Training Overview
This two-day intermediate Microsoft Excel training course is designed for employees to get a deeper understanding of Excel, learn advanced functions, and make their workflow more efficient. By the end of the program, attendees will be able to maximize MS Excel to generate business reports, data consolidation, use V Lookup, manipulate pivot tables, and more. The training will be facilitated by hands-on professional facilitators who have decades of experience in using and teaching the program.
TOPICS COVERED:
- Logical functions
- Conditional functions
- Financial functions (SUMIF, SUMIFS, COUNTIF, COUNTIFS, AVERAGEIF, AVERAGEIFS)
- Text functions
- Date and time functions
- Error functions (ISNA, ISERROR)
- Using lookup functions
- Creating and using names
- Managing names
- Validating cell entries
- Advanced filtering
- Conditional formatting
- Outlining and consolidating data
- Creating subtotals
- PivotTables and PivotCharts
- Working with PivotTables
- Modifying PivotTable data
- Formatting PivotTables
- Using PivotCharts
- Exporting and importing text files
- Exporting and importing MS Access files
- Goal Seek
- Scenarios
- Data Tables
- Running and recording a macro
- Working with VBA code
