In Week 2, you will focus on implementing Excel formulas. You’ll learn about the order of operations, how to build mathematical formulas, and how to troubleshoot issues when results aren’t what you expect. You will be introduced to a popular selection of Excel’s built-in functions, including those used for summing, counting, averaging, rounding numbers, calculating remainders, generating random numbers, and performing logical tests.

In Week 3 you will learn how to work with more structured and dynamic data in Excel. You will learn how to create Excel Tables and dynamic named ranges, apply data validation rules, and use advanced conditional formatting techniques.

In Week 4 you will continue building your Excel function skills. You’ll learn how to use more advanced logical functions, including techniques for testing conditions and determining whether values appear in lists. You’ll also explore tools for working with text, including the advantages and limitations of Flash Fill and how to use text functions to clean and reshape data. In addition, you will be introduced to date and time functions and basic financial functions, enabling more complex calculations and data transformations.

In Week 5 you will focus on managing and preparing data for analysis and reporting. You will learn techniques for cleaning data, applying filters, sorting data using multiple criteria, and identifying and removing duplicates. You will also practice consolidating data from multiple worksheets or sources and organize it in a way that supports analysis and reporting.

In Week 6 you will learn how to visualize and share data using Excel. You’ll learn how to create different types of charts, including dynamic charts and Pivot Charts, and enhance visualizations with tools like Slicers and Sparklines. You will also learn how to share Excel content in Word and PowerPoint, print worksheets and charts, and export Excel files as PDF documents.