RELATED COURSES
Critical Thinking
Data Visualization with Python
Microsoft Power Automate
Microsoft Power BI Boot Camp
SQL
Details
The main purpose of the course is to give students the ability to apply Excel data analysis. The course goes beyond the capabilities of tables and charts and uses Pivot Charts, the Excel Data Model and Power Pivot.
After completing this course, students will be able to:
- Perform data analysis fundamentals.
- Visualize data with Excel.
- Analyze data with formulas and functions.
- Analyze data with PivotTables
- Present visual insights with dashboards in Excel.
- Create geospatial visualizations with Excel.
- Perform statistical analysis.
- Get and transform data.
- Model and analyze data with Power Pivot.
- Present insights with reports.
Delivery Methods
Leading Training is focusing on providing virtual training courses for the foreseeable future and will only consider in-person and classroom training on request, with a required minimum group size of four delegates. We remain committed to offering training that is fast, focused and effective.
| Delivery Method | Duration | Price (excl. VAT) | ||
|---|---|---|---|---|
| Live Virtual Training | 3 days | GBP 1,455.00 | Get a Quote |
Discounts Available
Save up to 10% by booking and paying 10 business days before the course.
Brochure:
Audience
This course is intended for students who are experienced with Microsoft Excel and who wish to add Business intelligence techniques and visualization. The course will take students beyond the capabilities of tables and charts using Pivot Charts and Excel Data Model.
Pre-Requisites
Before attending this course, students must have:
- Basic knowledge of the Microsoft Windows operating system and its core functionality.
- Skills using Excel worksheets, particularly in creating formulas and functions.
Course Outline / Curriculum
Data Analysis Fundamentals
- Introduction to Data Science
- Create and Modify Tables
- Sort and Filter Data
Visualizing Data with Excel
- Visualize Data with Charts
- Modify and Format Charts
- Apply Best Practices in Chart Design
Analyzing Data with Formulas and Functions
- Analyze Data with Formulas and Named Ranges
- Analyze Data with Functions
- Implement Data Validation, Forms, and Controls
- Create Conditional Visualizations with Lookup Functions
Analyzing Data with PivotTables
- Create a PivotTable
- Analyze PivotTable Data
Presenting Visual Insights with Dashboards in Excel
- Visualize Data with PivotCharts
- Filter Data Using Slicers and Timelines
- Create a Dashboard in Excel
Creating Geospatial Visualizations with Excel
- Create Map Charts in Excel
- Customize Map Charts in Excel
Performing Statistical Analysis
- Visualize Trendlines and Sparklines with Excel
- Analyze Data with the Data Analysis ToolPak
Getting and Transforming Data
- Connect to Data with Queries
- Clean and Combine Data
- Shape and Transform Data
Modeling and Analyzing Data with Power Pivot
- Install Power Pivot in Excel
- Create Data Models with Power Pivot
- Create Power Pivots
- Perform Advanced Data Analysis and Visualization
Presenting Insights with Reports
- Plan a Report
- Create a Report
Schedule Dates and Booking
There are currently no scheduled dates.
Please note that this course needs a minimum of 4 delegates to schedule a course. You can choose to be added to the waiting list by clicking the button below and we will contact you when we have enough delegates interested. Should we not get enough delegates, we will refund or credit your paid booking.
Should you need this course urgently, the following options are available:
- Pay for 4 delegates (whether you have them or not) and we will schedule the course as soon as possible.