Excel Advanced
Course Info
Microsoft Excel is the most important computer software used in the workplace today. Professionals use Excel to perform everyday functional tasks in the workplace. Ask Finance people - they spend more time on Excel than on Accounting software!
An increasing number of companies rely on Excel for decision support.
- The Foundations of Data in Excel - Date, Text, Number.
- The Foundations of Calculations in Excel - Relative, Fixed, and Mixed Reference.
- Data in “Excel Tables” and not in “Excel Range”.
- The New era of PivotTables.
- Advance Data Analysis.
- Slicers (not Filter button) for Data, Reports, and Interactive Dashboards.
- The daily grind of Excel warriors - Functions and Formulas (Lookup, Logical, Text, and Date functions).
- Creating Interactive Dashboards.
Course syllabus