Ch 1: Course Overview

Chapter 1 introduces the TestOut Excel Pro course, starting with an introduction to Microsoft Office and Excel. It discusses the course objectives, and how to use the lab simulations for effective learning. It also introduces keyboard shortcuts as well as tips for Mac and Chromebook users.

Ch 2: Common Office Features

Chapter 2 explores common features across Microsoft office products such as the ribbon and the backstage view. It also covers how to customize the user's view and options. Students will learn to print files as well as navigate and search documents within Microsoft Office. This chapter concludes with practicing how to insert and format objects such as shapes and images.

Ch 3: Excel Basics

Chapter 3 teaches how to manage worksheets in excel workbooks, build spreadsheets using templates and themes, and import external data. It covers how to organize and enter data, use copy and paste and work with larger data sets. Students will learn how to change properties for protection, data validation, and document printing. This chapter concludes by discussing cell formatting options, including numbers, cells, styles, colors, and borders.

Ch 4: Formulas and Functions

Chapter 4 discusses the effectiveness of basic formulas and functions, instructing students to use AutoFill options, mathematical operator functions, text functions and concatenation. This chapter also explores advanced functions like relative and absolute references, named cells and ranges, logical functions, and the IF function. This chapter concludes by covering error messages within Excel.

Ch 5: Simple Data Analysis

Chapter 5 explores data analysis by introducing charts, their different types, and how to format charts to effectively present data. Tables are an effective way to organize data within Excel and students will learn how to use them effectively. This chapter explains how to customize tables, and format tables based on conditions using the conditional formatting tool.

Ch 6: MO-200 (Excel Associate) Practice Exams

Chapter 6 introduces the auto-graded live projects within Excel. Unlike other assignments, these live projects are done using an installed version of Microsoft Excel where students can practice what they have learned from the simulated labs. Students can download guided instruction from LabSim to execute the tasks within Microsoft Excel. Teachers and students will still be able to see the results from the assignments and access the submitted assignments. This chapter provides 3 live projects. Students will also prepare to take the MOS Excel Associate (MO-200) exam. This chapter teaches best practices in preparing for the MOS exam, such as studying over time, focusing on exam objectives and entering the test well-rested. It also reviews how to perform unfamiliar tasks by searching panes, dialog boxes and contextual tabs. Lastly this chapter introduces the TestOut MOS Practice exams, providing domain practice labs as well as practice exams, so that students can enter the actual exam with confidence.

Ch 7: Advanced Workbook Options and Settings

Chapter 7 is the first chapter exploring advanced topics to prepare students for the MOS Excel expert exam. Beginning with AutoSave and AutoRecover, this chapter covers crucial skills to not lose work, how to reference data in different workbooks, configure language settings and manage workbooks. This chapter concludes by instructing students how to prepare workbooks for collaboration by protecting different parts of a workbook, configuring formula calculation options, and managing comments.

Ch 8: Advanced Data Formatting

Chapter 8 introduces advanced features of autofill, flash fill, and advanced fill series options. It addresses the utility of customize fill options. Students will learn how to format and validate data by creating custom number formats, configure data validation, use outlines to create groups and subtotals, and remove duplicate records. This chapter concludes by discussing advanced conditional formatting and filtering. It covers Boolean operators and their logic, and how to create and adjust rules when using conditional formatting.

Ch 9: Advanced Formulas and Macros

Chapter 9 Explores several advanced features in Excel, such as logical operators, look up functions, date and time functions, data analysis, troubleshooting formulas and building macros. Students will learn about nested and mathematical functions, VLOOKUP and HLOOKUP functions, and MATCH and INDEX functions. They will also learn to summarize data, perform a what-if analysis, and interpret error messages to troubleshoot formulas. This chapter concludes by covering how to record and run simple macros, enable and disable macros, and how to copy macros.

Ch 10: Advanced Charts and Tables

Chapter 10 investigates the usefulness of charts and tables for interpreting and presenting data by exploring advanced chart types and formatting. Students will learn how to create and modify a PivotTable and calculate fields in a PivotTable. This chapter concludes by introducing PivotCharts and how to create, manipulate and drill down into PivotCharts.

Ch 11: MO-201 (Excel Expert) Practice Exams

Chapter 11 prepares students to take the MOS Excel Expert (MO-101) exam. It begins by teaching best practices in preparing for the MOS exam such as studying over time, focusing on exam objectives and entering the test well-rested. It also reviews how to perform unfamiliar tasks by searching panes, dialog boxes and contextual tabs. Lastly, this chapter introduces the TestOut MOS practice exams, providing domain practice labs as well as practice exams so that students can enter the actual exam with confidence.

Ch 12: TestOut Pro Certified: Microsoft Excel® Advanced Practice Exams

Chapter 12 reviews the TestOut Pro Certified: Microsoft Excel® Advanced certification exam objectives, lists objectives by course section, and tells how to take the Pro exam. This chapter also provides a practice exam and domain practice exams that help prepare students for the certification exam.

‍