Excel-Geeta: As it is

       Calculate commission of agents as per sales target achieved:              Definitions: 1.       Commission : The commission is amount in money that sales representative get it for selling something or products of company. 2.       Sales Rep : Sales representative is a person whose job is to sell product or service for company in particular area 3.       Commission Rate : This is fixed payment or percentage associated with certain amount of sale. Rate is in Percentage. Ex. 10% commission on selling Water Purifier               Description:             Please watch Video (Multiple Table Lookup) for this belo                      ...

  Calculate Person's Age in Excel:                     Actually, You can calculate person's age orally, But, If you were working with huge data and you want to calculate age belongs to person's Birth Date in that huge data. Then, it will easy and versatile to use formula for calculations.                There are 2 methods as below; 1. Formula mix-up 'INT & YEARFRAC 2. DATEDIF Formula METHOD 1:                 First you should know Birth Date of Person. Formula consist of INT ( ) , Integer function takes 1 argument and we put here another formula YEARFRAC ( ) . YEARFRAC takes 3 arguments, YEARFRAC (start_date, End_date, [basis]) .                 Here, we take Start date as "Current Date" and End date as "Birth Date". and basis is ...

Hello,   Readers and Excel Lovers .  Welcome to   " Excel-Geeta: as it is ". This page contains an useful information about Excel and Advanced Excel also. Here is a gift for you, "Excel-Geeta's 99 Keyway Table" . This table helps you to keep all useful shortcuts in Microsoft Excel tool with you.           I kept all 99 shortcuts in this table categorized as based on Family as below; 1. Family Enter 2. Family Tab 3. Family Spacebar 4. Family Arrow 5. Family ABCD 6. Family 1to9 7. Family Function  8. Family Special (Highlighted in yellow color) This all placed with same pattern hence it is easy to understand and helps to quick grasping.            So, You have to keep practice and play with keys with your Excel work.                                   ...