In this course you will learn all the tips, tricks, shortcuts, functions and formulas you need to be an Excel power user.
Learn dynamic formulas with IF, VLOOKUP, INDEX, MATCH functions, and many more.
Course Content-
Module 1
- Introduction: Excel Formulas
- Excel Formula Syntax
- Writing Efficient Formulas with Fixed & Relative References.
- Basic excel formulas
- Common Excel Error Types
- Navigating Excel Worksheets with Ctrl Shortcuts
- Saving Time with Function Shortcuts
- Accessing Tools with Alt Key Tips
- Creating Drop-Down Menus with Data Validation
- Conditional formatting
Module 2
- Lookup and Reference Functions: VLOOKUP, HLOOKUP, INDEX, ADDRESS, MATCH, TRANSPOSE
- Logical Function: IF / ELSE, AND, OR, NOT, TRUE, NESTED IF/ELSE etc.
Module 3
- Text Functions: LEFT, RIGHT, TEXT, TRIM, MID, LOWER, UPPER, PROPER, REPLACE, REPT, FIND, SEARCH, SUBSTITUTE, TRIM, TRUNC, CONVERT, CONCATENATE, DOLLAR EXACT, CONCATENATE
- Date Function DATE,DATED IF,DATE VALUE,DAY,DAYS 360,EDATE,EMONTH,HOUR,MINUTE,MONTH;NETWORKDAY S,NOW,TIME, TIME VALUE,SECOND,TODAY,WEEK DAY,WORK DAY,YEAR,YEAR FRAC
Module 4
- Math and Trigonometry Functions: RAND, ROUND, CEILING, FLOOR, INT, LCM, MOD, EVEN, SUMIF, UMIFS, ABS, CEILING, COUNTIF, EVEN,FACT,FLOOR,GCD,INT,LCM,MOD,MROUND,ODD,PI,PRODUC T,POWER,QUTIENT,RAND,ROMAN,ROUND,ROUND DOWN,ROUND UP,SIGN ,SUBTOTAL.
- Formatting Excel sheets.
Duration- 4 Hours
Fees- 600+ tax