This website uses cookies to ensure you get the best experience on our websites. Learn more

Skip navigation
Business professional using Excel to analyze data
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

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.

Related Courses

loading icon