Intermediate Excel with Copilot elements
Course Description
Candidates will unlock the potential of Excel with our NEW Intermediate Excel for Professionals Course. This course is designed to take your Excel skills to the next level, covering advanced techniques and tools that will enhance your data analysis and visualisation capabilities. Moreover, specific aspects of the syllabus will be executed using copilot in excel, further enhancing efficiency.
The course is divided into four modules, as follows:
- Advanced Visualisation Techniques
- Data Cleaning and Preparation
- Advanced Formulas and Functions
- Power Query and Power Pivot
Having practiced all of these new skills extensively to handle complex data tasks during the course you will be able to hit the ground running on your return to the office and should be able to complete your Excel work far more proficiently and with ease.
Course Structure
This course is split over the following 4 modules:
Advanced Visualisation Techniques
- Custom Data Visualisations
- Advanced Charting Features (Power Charts)
Data Cleaning and Preparation
- Removing Duplicates
- Text Functions to standardise text data
- Date and Time Fixes
- Power Query to automate data cleaning tasks
- Implementing a Data Quality FRamework
Advanced Formulas and Functions
- Mastering Lookup Functions
- Using Array Formulas
- Applying Statistical Functions
- Applying Text Functions
- Error Handling
Power Query and Power Pivot
- Data Import and Transformation using Power Query
- Creating and managing data models in Power Pivot
- DAX Functions for Data Analysis
- Building Interactive Reports and Dashboards with Power Pivot and Power Query
- Applications in Real-World Scenarios to drive Business Intelligence
Register Your Interest: