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
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
 | skillpath.com/EX200 |
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.
Module 1: Get and Transform Data With Power Query
To understand the more advanced topics in Excel, you need to be familiar with what works best in Excel: clean data.
- Explain Get & Transform
- Use the transformative features of Power Query
- Use the generative features of Power Query
Module 2: Descriptive and Predictive Data Analysis With AI
In this lesson, you’ll realize the importance of summarizing your tabular data effectively with either recommended PivotTable Reports or recommended charts.
- Enable and use AI
- Perform descriptive analytics
- Use Analyze Data
- Perform predictive analytics
Module 3: Configuring Data Visualizations With Basic Charts
In this lesson, you’ll begin by looking at the elements of chart making — from scratch — so you can build a solid foundation and gain better judgment of how to create effective charts.
- Choose the best chart for your data
- Work with a single series of data
- Modify the invisible and invisible distractions from your graphs
Module 4: Custom Visualizations With Multiple Series
In this lesson, you’ll expand your visual Excel expertise to tackle more complex datasets comprised of multiple series.
- Configure combination charts
- Develop gauge charts and Gantt charts
- Build small multiples
Module 5: Building Dynamic Interactive Workbooks With Number Formats, Conditional Formatting and Form Controls
After this lesson, you’ll be capable of formatting your data to enable others to understand its meaning more quickly — with so much more than just bold, italics or underlining.
- Configure micro-visualizations with custom formats
- Dynamically format cells with formula-based conditional formatting
- Build interactive form controls for your workbook
Module 6: Putting It All Together: Building a Dynamic Interactive Excel Dashboard
In this session, you’ll use your experience with charts, array formulas and form controls to build a dashboard that updates as the underlying data changes.
- Get the data for your dashboard
- Build the components of a dynamic Excel dashboard
- Assemble your dynamic, interactive dashboard