Microsoft Excel is one of today's most powerful and versatile business tools. With the basic Excel training you'll learn how to use charts, graphs, fonts, borders, shading and more â?? and produce spread sheets that communicate better.
Course Content
- Functions V Lookup ,H Lookup, Index, Match (including approximate match) Off Set, Sub Total
- Dynamic Charts using control box, Bridge Chart
- If Statements: Count if, Average if, Sum if
- Formula based Conditional Formatting
- What if: Scenario Management, Goal Seek, Data Tables
- Advanced Filters: Advance cases of Pivots with look-ups.
- Recording a Macro (using Absolute / Relative References)
View this Course
Certified
You have 
