MS Excel Essentials-Formulas & Functions

About Course

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.

Modules

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.

Learning Outcomes

• Participants will learn ms- excel from scratch.
•  3 months full access to this course and study material to practice it to perfection.

Who Should Attend

Anyone who wants to learn MS-Excel

Certificate

Digital Certificate  will be issued after completion of the course