Intermediate Excel powered by AI
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.
Technical requirements: We will supply laptops with the necessary licenses. However, if you choose to attend online, you must have Microsoft 365 and Copilot for Microsoft 365 installed.
Course Structure
This course is split over 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
Should Attend
This course is the next step for individuals who have followed the Core concepts of analytics with Excel course.
Prerequisites
Applicants should have completed the core concepts of analytics course.
Assessment
There is no final assessment. Participants will be guided during the course. At the end of the course, attendees will receive a Certificate of Attendance..
Key-Features
NA
Course Structure
This course is split over 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
Should Attend
This course is the next step for individuals who have followed the Core concepts of analytics with Excel course.
Prerequisites
Applicants should have completed the core concepts of analytics course.
Assessment
There is no final assessment. Participants will be guided during the course. At the end of the course, attendees will receive a Certificate of Attendance..
Key-Features
NA
Register Your Interest: