Target Audience

Employees in any grade who want to master the Intermediate Microsoft Excel usage.
Programme Standards

- Maximum 6 attendees
- 30 days of one to one support
- Handouts
- Programme director/s with at least a Masters Degree in the subject
- Convenient morning timings or in-house at any time for a minimum of two bookings
- Can be configured to address a number of professions and industry sectors

Price

EUR248 ex VAT per participant.
Excel Intermediate Workshop​

These topics provide participants with a solid foundation in intermediate Excel skills, empowering them to analyze data more effectively, create dynamic reports, and automate repetitive tasks. Additionally, it prepares them for more advanced Excel functionalities and data analysis techniques.
Topics Covered

1.  Advanced Formulas and Functions: 
   - Building upon basic functions, participants can learn about more advanced functions such as IFERROR, INDEX, MATCH, SUMIFS, COUNTIFS, and VLOOKUP.
   - Understanding how to nest functions and use logical operators to create complex formulas.
   - Exploring array formulas and their applications for performing calculations across multiple cells or ranges.

2.  Data Analysis and Visualization:
   - Introduction to Excel's built-in data analysis tools, including PivotTables and PivotCharts, for summarizing and analyzing large datasets.
   - Creating dynamic reports and dashboards to present insights visually using conditional formatting, data bars, sparklines, and slicers.
   - Utilising data validation to ensure data accuracy and consistency, including creating drop-down lists and custom validation rules.

3.  Data Cleaning and Manipulation:
   - Techniques for cleaning and preparing data for analysis, such as text-to-columns, remove duplicates, and text functions like LEFT, RIGHT, MID, and CONCATENATE.
   - Introduction to Excel's Power Query tool for importing, transforming, and combining data from multiple sources.
   - Working with structured data tables and using filters, sorting, and advanced filtering techniques to extract specific information.

4.  Advanced Data Analysis Techniques: 
   - Performing What-If analysis using Excel's Scenario Manager and Goal Seek to explore different scenarios and achieve desired outcomes.
   - Introduction to Excel's Solver tool for optimizing complex problems by adjusting input variables based on constraints and objectives.
   - Understanding basic statistical functions in Excel and their applications, such as AVERAGE, STDEV, and FREQUENCY.