Microsoft Excel Courses

Course detail

Learn about Microsoft Excel and how it applies to business reporting. Discovering Excel will teach you how to develop spreadsheets, use formulas and formatting as well as how to create charts and navigate throughout Microsoft Excel. Gain a comprehensive knowledge of how Excel can work for you.

Course detail:

The course is divided into three sessions covering specific topics in Excel. 

Session 1: Data Lists and Macros

This is a specialised training programme focusing on:

• Tell Me Text Box
• Smart Lookup
• Sorting, Subtotalling and Filtering Data
• Data Validation
• What-If Data Analysis
• Forecast Sheet
• Macros

Session 2: Workshop: Formulas & Functions 

This is a specialised training programme focusing on:

• Data Consolidation
• Conditional Formatting Worksheet Protection
• Managing and Preparing Data
• Using Cell References
• Lookup, Text and Logical Functions
• Statistical and Mathematical Functions
• Date and Time Functions

Session 3: Workshop: PivotTables and PivotCharts

This is a specialised training programme focusing on:

• PivotTable Basics 
• PivotTable Options
• Formatting a PivotTable 
• Calculated Items and Fields
• Sort & Filter a PivotTable 
• Consolidated PivotTable
• PivotCharts and Sparklines

Course detail

Excel on Steroids Plus: Data Analysis, Visualisation and Dashboards will teach you how to model your data so you can create interactive dashboard reports that will make analysing your data much easier, and will give you clearer insights so you can make smart business decisions.