Target Audience
Any body who is interested to obtain advance MSExcel knowledge. 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 Advance Workshop
These topics provide participants with the skills and knowledge needed to leverage Excel's advanced features and functionalities for complex data analysis, modeling, and automation, empowering them to become proficient Excel users capable of handling sophisticated tasks and projects. Topics Covered
1. Advanced Formulas and Functions: - Learning advanced functions such as INDEX/MATCH, SUMIFS, COUNTIFS, and nested functions. - Exploring array formulas for complex calculations and data analysis. - Understanding the use of logical functions like IF, AND, OR, and nested IF statements. - Using date and time functions effectively for time-sensitive calculations and analysis. 2. Data Analysis and Visualisation: - Techniques for data consolidation, cleansing, and transformation using tools like Power Query. - Creating dynamic dashboards and interactive reports with PivotTables and PivotCharts. - Utilizing Excel's built-in analysis tools like Goal Seek, Solver, and Scenario Manager. - Exploring advanced charting options and customizations to present data effectively. 3. Automation and Macros: - Introduction to Visual Basic for Applications (VBA) for automating repetitive tasks and workflows. - Recording and editing macros to perform specific actions and tasks in Excel. - Writing custom VBA code to enhance Excel functionality and automate complex processes. - Implementing error handling and debugging techniques for VBA macros. 4. Data Modelling and Analysis: - Building data models and relationships using Excel's Power Pivot feature. - Performing advanced data analysis using DAX (Data Analysis Expressions) formulas in Power Pivot. - Creating calculated columns, measures, and KPIs for in-depth data analysis. - Utilising What-If analysis tools like Data Tables and Scenario Manager for forecasting and decision-making. |