Mastering Microsoft Excel

Mastering Microsoft Excel

Course Features

Course Details


Course Overview

The Mastering Microsoft® Excel® course focuses of providing students with a solid foundation on the many features and applications of the Microsoft Excel spreadsheet program. Excel, being a vastly versatile and widely used tool in the modern workforce, is a skill integral to success for students planning for any business-related career. This course explores topics from basics of creating workbooks to advanced functions using macros, as well as how to work with other Microsoft Office programs. "Microsoft" and "Excel" are registered trademarks of Microsoft Corporation.

Sample Lesson - Organizing Data into Levels


This course was developed by the International Academy of Science. Learn More

Scope and Sequence

Unit 1 - Getting Started This introductory unit of Mastering Microsoft Excel conveys a basic foundation of the Excel interface and basic tasks including creating workbooks, modifying workbooks, and modifying worksheet columns, rows, and cells. Additionally, this unit helps students get to know the Excel menu, change how the Excel program window displays, and customize the Excel Program Window. Vocabulary and keyboard shortcuts are also introduced. Unit 2 - Working with Data & Excel Tables This unit covers entering and revising data, moving data within a workbook, finding and replacing data, correcting and expanding upon worksheet data, and defining Excel tables. Additional vocabulary and keyboard shortcuts are also introduced. Unit 3 - Performing Calculations on Data In the Performing Calculations on Data unit, students learn about naming groups of data, introduction to formulas, creating formulas to calculate values, summarizing data that meets specific conditions, as well as finding and correcting errors in calculations.  Additional vocabulary and keyboard shortcuts are also introduced. Unit 4 - Changing Workbook Appearance This unit delves into formatting cells, defining styles, applying workbook themes and Excel table styles, making numbers easier to read, changing the appearance of data based on value, and adding images to worksheets.  Additional vocabulary and keyboard shortcuts are also introduced. Unit 5 - Focusing on Specific Data by Using Filters In the Focusing on Specific Data by Using Filters unit students delve into limiting data that appears on your screen, manipulating worksheet data, using random functions, and defining valid sets of values for cell ranges.  Additional vocabulary and keyboard shortcuts are also introduced. Unit 6 - Reordering and Summarizing Data This unit focuses on sorting worksheet data, organizing data into levels, and looking up information in a worksheet. Additional vocabulary and keyboard shortcuts are also introduced. Unit 7 - Combining Data from Multiple Sources In the Combining Data from Multiple Sources unit students learn how to using workbooks as templates for other workbooks, link to data in other worksheets and workbooks, consolidate multiple data sets into a workbook, and group multiple sets of data. Additional vocabulary and keyboard shortcuts are also introduced. Unit 8 - Analyzing Alternative Data Sets This unit focuses on defining an alternative data set, defining multiple alternative data sets, using goal seek analysis to get a desired result, finding optimal solutions by using solver, and analyzing data by using descriptive statistics. Additional vocabulary and keyboard shortcuts are also introduced. Unit 9 - Creating Dynamic Worksheets by Using PivotTables The Creating Dynamic Worksheets by Using PivotTables unit focuses on analyzing data dynamically by using PivotTables, filtering, showing, and hiding PivotTable data, editing PivotTables, formatting PivotTables, creating PivotTables from external data, and advanced PivotTables.  Additional vocabulary and keyboard shortcuts are also introduced. Unit 10 - Creating Charts and Graphics In this unit, students learn about creating charts, customizing the appearance of charts, finding trends in data, and summarizing data by using Sparklines. Also covered in this unit are the concepts of creating dynamic charts by using PivotCharts, creating diagrams by using SmartArt, as well as creating shapes and mathematical equations. Additional vocabulary and keyboard shortcuts are also introduced. Unit 11 - Printing The Printing unit focuses on adding headers and footers to printed pages, preparing worksheets for printing, printing worksheets, printing parts of worksheets, as well as printing charts. Additional vocabulary and keyboard shortcuts are also introduced. Unit 12 - Automating Repetitive Tasks by Using Macros This unit delves into enabling and examining macros, creating and modifying macros, running macros when a button is clicked, running macros when a workbook is opened, and using relative references in macros.  Additional vocabulary and keyboard shortcuts are also introduced. Unit 13 - Working with Other Microsoft Office Programs In this unit, students learn how to include Office documents in workbooks, store workbooks inside other Office documents, create hyperlinks, and paste charts into other documents.  Additional vocabulary and keyboard shortcuts are also introduced. Unit 14 - Collaborating with Colleagues In the Collaborating with Colleagues unit, students learn about sharing workbooks, managing comments, tracking and managing colleagues' changes, protecting workbooks and worksheets, finalizing and authenticating workbooks, and saving workbooks for the web. Additional vocabulary and keyboard shortcuts are also introduced.