Microsoft Excel Data Analysis Expert
1 day course
What you will learn:
- Use Power View to examine and analyse data
- Perform a variety of analytical tasks using Power Pivot
- Import and refine data with Get and Transform
- Analyse location-based data in Power Map
What you'll get:
Workbook
Refreshments
Capped class sizes
eCertificate
Post Course Support
What you will learn:
- Use Power View to examine and analyse data
- Perform a variety of analytical tasks using Power Pivot
- Import and refine data with Get and Transform
- Analyse location-based data in Power Map
What you'll get:
Courseware and Handouts
Capped class sizes
eCertificate
Post Course Support
Course prerequisites
Participants will need to have attended or be familiar with all the topics covered in the Microsoft Excel Advanced course, including working with named ranges, tables, and basic PivotTables.
In-Person Training
Participants are not required to bring their own laptops as our dedicated computer training labs are equipped with the programs and files you will need access to on your training day.
Online Training
Please ensure you have downloaded the latest version of the software Microsoft Excel Desktop for use within the session. We also require a working computer with a microphone and speaker installed, and an up-to-date web browser for this training. For the best experience we recommend downloading the latest Google Chrome browser.
It is also recommended that you have a second screen attached to your computer. This will allow you to watch the online training session and complete the course activities at the same time.
Topics covered in this training course
- Descriptive statistics
- Correlation
- Forecast sheet
- Goal Seek
- Solver
- Scenarios
- Create query from data
- Create web query & text query
- Power Query editor
- Adding columns
- Editing applied steps
- Transforming data
- Unpivoting data
- Merging queries
- Manually loading data
- Changing or updating source data
- Enabling Power Pivot
- Building a data model from external sources
- Creating relationships
- Create a PivotTable from the data model
- Appending data
- Formatting columns
- Creating calculated columns
- Creating calculated measures
- Date tables
- Creating a dashboard from the data model
- Slicers
- Set connections to refresh on open
- Overview of how it connects to the previous content
- Get data to create a report
- Navigate views
- Add visuals
- Distribute and publish a report to the Power BI Service
You might be interested in:
