Master Microsoft Excel
Excel is typically used to organize data and perform financial analysis. It is used across all business functions and at companies from small to large.
Our comprehensive Excel training program covers everything from basic data entry to advanced financial modeling and automation. Whether you're a complete beginner or looking to enhance your existing skills, we have the perfect course for you.
Excel Basic
1 Day CoursePerfect for beginners and those who want to build a solid foundation in Excel.
- Data entry and basic formatting
- Simple formulas and functions (SUM, AVERAGE, COUNT)
- Creating and formatting basic charts
- Working with worksheets and workbooks
- Basic data management techniques
- Printing and page setup
Excel Intermediate
1 Day CourseBuild on your basic skills and learn powerful intermediate features.
- Advanced formulas (VLOOKUP, IF, COUNTIF, SUMIF)
- Data validation and conditional formatting
- Working with multiple worksheets
- Introduction to PivotTables
- Advanced charting techniques
- Data sorting and filtering
Excel Advanced
2 Day CourseMaster advanced Excel features for data analysis and automation.
- Complex formulas and nested functions
- Advanced PivotTables and PivotCharts
- What-If Analysis (Goal Seek, Scenario Manager)
- Data consolidation and linking
- Advanced data analysis tools
- Introduction to Macros
- Financial modeling techniques
Excel for Creating Dashboards
2 Days (or 1 Day after Advanced)Learn to create stunning, interactive dashboards for data visualization.
- Dashboard design principles
- Advanced PivotTable techniques
- Dynamic charts and graphs
- Using slicers and timelines
- Conditional formatting for dashboards
- Creating interactive reports
- Best practices for data presentation