Mastering Microsoft Excel

Por um escritor misterioso

Last updated 31 dezembro 2024

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 Continue Reading