Advanced Excel Mastery
03 - 07 March 2024
Sandton
Johannesburg South Africa
Cost per Delegate
R17,999.00
Course Overview
This course is designed for Excel users who have a good understanding of basic Excel functions and are looking to advance their skills to perform more complex data analysis and reporting tasks efficiently. Participants will learn advanced Excel functions, data analysis techniques, and visualization methods through hands-on exercises and real-world examples.
The course will also cover automation techniques using macros and VBA to help participants streamline their workflows and save time on repetitive tasks. By the end of the course, participants will be equipped with the skills and knowledge to tackle complex data challenges and create impactful reports and dashboards using Excel.
Course Objectives
• Master advanced Excel functions and formulas for complex data manipulation and analysis.
• Develop proficiency in data analysis techniques such as PivotTables, Power Query, and data validation.
• Create visually appealing and interactive dashboards to present insights effectively.
• Automate repetitive tasks and streamline workflows using macros and VBA.
• Learn best practices for collaboration, data sharing, and protecting sensitive information in Excel.
Who should Attend?
• Business analysts
• Financial analysts
• Data analysts
• Excel power users
• Professionals seeking to enhance their Excel skills for improved productivity and efficiency in data handling and analysis.
Course Outline
Module 1: Advanced Functions and Formulas
• Nested functions
• Advanced logical functions (IFERROR, IFNA, etc.)
• Lookup functions (VLOOKUP, HLOOKUP, INDEX-MATCH)
• Array formulas
Module 2: Data Analysis Techniques
• PivotTables and PivotCharts
• Power Query for data transformation
• Data validation and cleaning techniques
• Advanced filtering and sorting
Module 3: Visualizations and Dashboard Creation
• Advanced charting techniques (sparklines, combo charts, etc.)
• Creating dynamic dashboards
• Conditional formatting for data visualization
• Interactive controls (checkboxes, dropdown lists) for dashboards
Module 4: Automation and Macros
• Introduction to Excel VBA
• Recording and editing macros
• Automating repetitive tasks
• Error handling and debugging
Module 5: Collaboration and Data Sharing
• Sharing workbooks and managing changes
• Protecting worksheets and workbooks
• Data consolidation techniques
• Importing and exporting data from/to other applications
End of the Workshop
For Training arrangements call us on the detail below
TANZANIA: +255 749 50 26 78
SOUTH AFRICA: +27 694 31 79 73
KENYA: +255 749 50 26 78
DUBAI: +27 694 31 79 73
