Mastering Microsoft Excel

Course Duration: Full Year

Category: Career & Technical Education, Electives, High School

Assessment: Pre-Test, Lesson Practice, Unit Exams, Mid-Term Exam, Final Exam

Language: English

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 StartedThis 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 TablesThis 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 DataIn 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 AppearanceThis 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 FiltersIn 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 DataThis 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 SourcesIn 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 SetsThis 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 PivotTablesThe 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 GraphicsIn 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 - PrintingThe 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 MacrosThis 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 ProgramsIn 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 ColleaguesIn 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.

.