Loading page details...
Instructor-Led Training
Mastering Microsoft® Excel® for Office 365® Level 200
You know a lot about Microsoft Excel, but now everyone is talking to you about data analysis. You’re aware there are tools for such things, but you don’t really have a background in this, and you don’t know where to start.
If this sounds familiar to you, or you struggle with expanding your skills knowing that data analysis is the newest “hot skill” needed in every organization, this course is for you. In one day, you’ll learn the vast number of powerful analytic tools and techniques nested in Excel ready for you to harness and use to illuminate the data you’ve worked so hard to collect.
Course Outcomes
- Become familiar with Power Query and how to “tidy” data to make sure it’s tabular, simple and consistent
- Summarize your tabular data effectively by enabling and using AI to perform descriptive and predictive analytics
- Understand consolidating data, combination charts, 3-D maps, Gantt charts and gauge charts
- Practice and learn non-VBA form controls and Excel add-ons, including the Data Analysis ToolPak and the Solver
- Build dynamic interactive workbooks with number formats, conditional formatting and form controls
- Combine 3 important Excel technologies — charts, array formulas and form controls — to build a dashboard
Course Agenda
Instructor-Led Training
Module 1: Get and Transform Data With Power Query
Module 2: Descriptive and Predictive Data Analysis With AI
Module 3: Configuring Data Visualizations With Basic Charts
Module 4: Custom Visualizations With Multiple Series
Module 5: Building Dynamic Interactive Workbooks With Number Formats, Conditional Formatting and Form Controls
Module 6: Putting It All Together: Building a Dynamic Interactive Excel Dashboard
Request group training
Complete the form below to request tailored, private training for your team. We’ll be in touch to discuss your group’s specific goals.
More Courses in
Related Courses