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:
- Custom Data Visualisations
- Advanced Charting Features (Power Charts)
Advanced Visualisation Techniques
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
Any person interested in enhancing their Excel skills is eligible for this course.
Prerequisites
A foundation in basic Excel techniques is advised.
Assessment
There is no final assessment. Students will be guided during the course. At the end of the course, attendees will receive a Certificate of Attendance.
Key-Features
Learning Outcomes
Advanced Visualisation Techniques. By the end of this module, participants will be able to:
- Create custom data visualizations that go beyond standard charts and graphs.
- Explore advanced charting features to make your data stand out.
Data Cleaning and Preparation. By the end of this module, participants will be able to:
Advanced Formulas and Functions. By the end of this module, participants will be able to:
- Gain expertise in mastering lookup functions like XLOOKUP and VLOOKUP.
- Utilize array formulas for complex calculations.
- Apply statistical functions to analyze data effectively.
- Leverage advanced text functions for data manipulation.
- Handle errors in formulas with confidence.
Power Query and Power Pivot. By the end of this module, participants will be able to:
- Learn to import and transform data from various sources using Power Query.
- Create and manage data models in Power Pivot.
- Master Data Analysis Expressions (DAX) for advanced data calculations.
- Build interactive reports and dashboards with Power Pivot and Power Query
Course Structure
This course is split over the following 4 modules:
- Custom Data Visualisations
- Advanced Charting Features (Power Charts)
Advanced Visualisation Techniques
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
Any person interested in enhancing their Excel skills is eligible for this course.
Prerequisites
A foundation in basic Excel techniques is advised.
Assessment
There is no final assessment. Students will be guided during the course. At the end of the course, attendees will receive a Certificate of Attendance.
Key-Features
Learning Outcomes
Advanced Visualisation Techniques. By the end of this module, participants will be able to:
- Create custom data visualizations that go beyond standard charts and graphs.
- Explore advanced charting features to make your data stand out.
Data Cleaning and Preparation. By the end of this module, participants will be able to:
Advanced Formulas and Functions. By the end of this module, participants will be able to:
- Gain expertise in mastering lookup functions like XLOOKUP and VLOOKUP.
- Utilize array formulas for complex calculations.
- Apply statistical functions to analyze data effectively.
- Leverage advanced text functions for data manipulation.
- Handle errors in formulas with confidence.
Power Query and Power Pivot. By the end of this module, participants will be able to:
- Learn to import and transform data from various sources using Power Query.
- Create and manage data models in Power Pivot.
- Master Data Analysis Expressions (DAX) for advanced data calculations.
- Build interactive reports and dashboards with Power Pivot and Power Query
Register Your Interest: