Advanced Excel powered by AI
Course Description
This course covers a wide range of advanced Excel functionalities and techniques, designed to enhance your data management, analysis and automation skills. Learn the best ways to use Microsoft Excel for data analysis, reporting and modelling for decision making using real-world business scenarios. More importantly, specific aspects of the syllabus will be executed using copilot in excel, further enhancing efficiency.
The course is composed of 5 modules, as per below:
- Advanced Functions
- Working with Data and Real-Time Collaboration
- Advanced Data Analysis and Presentation
- Power Query
- Integration with other tools
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 the following 5 modules:
-
Advanced Functions
- Name Manager, Naming Ranges and Using them in Formulas
- Formula Auditing
- SUMIF, SUMIFS, AVERAGEIF, AVERAGEIFS
- Advanced Relative & Absolute Cell References
- Restricting Cell Entries to Certain Data Types
- Data Validation Tools
- Real-Time Collaboration Features
- Using Sparklines
- Advanced PivotTables
- Grouping Data to analyse data by Year/Quarter/Month
- Summarise/calculations embedded in Pivot Tables
- Introduce, create, and manage Slicers
- Create and manage multiple PivotCharts
- Manipulating options in existing PivotCharts
- Multiple PivotTables linked to the same slicer
- Building a BI Dashboard
- Advanced Charting Techniques
- Get Data
- Transform Data
- Load Data
- Create relationships between tables
- Integration with Power BI
- Using Excel with Power Automate
- Data Import and Export
Working with Data and Real-Time Collaboration
Advanced Data Analysis and Presentation
Power Query
Integration with other tools
Should Attend
This course is the next step for individuals who have followed the Core concepts of analytics with Excel course. If you haven’t attended this course, having an Intermediate Excel proficiency is advised.
Prerequisites
Applicants should have completed Excel Intermediate Level.
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 the following 5 modules:
-
Advanced Functions
- Name Manager, Naming Ranges and Using them in Formulas
- Formula Auditing
- SUMIF, SUMIFS, AVERAGEIF, AVERAGEIFS
- Advanced Relative & Absolute Cell References
- Restricting Cell Entries to Certain Data Types
- Data Validation Tools
- Real-Time Collaboration Features
- Using Sparklines
- Advanced PivotTables
- Grouping Data to analyse data by Year/Quarter/Month
- Summarise/calculations embedded in Pivot Tables
- Introduce, create, and manage Slicers
- Create and manage multiple PivotCharts
- Manipulating options in existing PivotCharts
- Multiple PivotTables linked to the same slicer
- Building a BI Dashboard
- Advanced Charting Techniques
- Get Data
- Transform Data
- Load Data
- Create relationships between tables
- Integration with Power BI
- Using Excel with Power Automate
- Data Import and Export
Working with Data and Real-Time Collaboration
Advanced Data Analysis and Presentation
Power Query
Integration with other tools
Should Attend
This course is the next step for individuals who have followed the Core concepts of analytics with Excel course. If you haven’t attended this course, having an Intermediate Excel proficiency is advised.
Prerequisites
Applicants should have completed Excel Intermediate Level.
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: