M20779: Analyzing Data with Excel

Book Now - 1 Delivery Method Available:
Classroom Virtual Classroom Private Group - Virtual Self-Paced OnlineOverview
This course is intended for both novice and experienced programmers who have a minimum of three months programming experience and have basic Windows navigation skills.
This course is intended for anyone responsible for analyzing data with Excel. The course will likely be attended by SQL Server report creators who are interested in alternative methods of presenting data.
Objectives
After completing this course, students will be able to:
- Explore and extend a classic Excel dashboard.
- Explore and extend an Excel data model.
- Pre-format and import a .CSV file.
- Import data from a SQL Server database
- Import data from a report.
- Create measures using advanced DAX functions.
- Create data visualizations in Excel.
- Create a Power BI dashboard with Excel.
Additional Information
Please note: for Attend from Anywhere customers an additional screen is required. The additional screen must have a minimum screen size of 19 inch and minimum resolution of 1280x1024, with the vertical resolution (1024) being the most critical.
Training Partners
We work with the following best of breed training partners using our bulk buying power to bring you a wider range of dates, locations and prices.
Modules
Prerequisites
Before attending this course, students must have:
- Basic knowledge of the Microsoft Windows operating system and its core functionality.
- Good Knowledge of Excel spreadsheets, functions, and charts.
- Working knowledge of relational databases.
Prerequisite Certifications
Scheduled Dates
Please select from the dates below to make an enquiry or booking.
Pricing
Different pricing structures are available including special offers. These include early bird, late availability, multi-place, corporate volume and self-funding rates. Please arrange a discussion with a training advisor to discover your most cost effective option.
Code | Location | Duration | Price | Sep | Oct | Nov | Dec | Jan | Feb |
---|---|---|---|---|---|---|---|---|---|
Later scheduled dates may be available for this course. |