Microsoft® Excel® for Office 365 (Desktop or Online): Part 1

In this course, you will learn fundamental Excel skills. You will:

• Familiarize yourself with Excel's layout, its various parts, its commands, and its terminology.
• Outline Excel's abilities to quickly, efficiently, and accurately calculate data.
• Update worksheets without throwing away all of the valuable work you've already done.
• Format a worksheet and organize your data.
• Print workbooks.
• Manage the overall structure of your workbooks.

This course is intended for students who wish to gain the foundational understanding of Excel that is necessary to create and work with electronic spreadsheets.
 

To ensure your success, you should have end-user skills with any current version of Windows, including being able to start and close applications, navigate basic file structures, manage files and folders, and access websites using a web browser. To obtain this level of skills and knowledge, you can take the following Logical Operations course:
• Using Microsoft® Windows® 10 (Second Edition)

Lesson 1: Getting Started with Excel

• Topic A: Navigate the Excel User Interface
• Topic B: Use Excel Commands
• Topic C: Create and Save a Basic Workbook
• Topic D: Navigate in Excel for the Web
• Topic E: Enter Cell Data

Lesson 2: Performing Calculations

• Topic A: Create Worksheet Formulas
• Topic B: Insert Functions
• Topic C: Reuse Formulas and Functions

Lesson 3: Modifying a Worksheet

• Topic A: Adjust Cells, Columns, and Rows
• Topic B: Search for and Replace Data
• Topic C: Use Proofing and Research Tools

Lesson 4: Formatting a Worksheet

• Topic A: Apply Text Formats
• Topic B: Apply Number Formats
• Topic C: Align Cell Contents
• Topic D: Apply Colors, Borders, and Styles
• Topic E: Apply Basic Conditional Formatting

Lesson 5: Printing Workbooks

• Topic A: Preview and Print a Workbook
• Topic B: Set Up the Page Layout
• Topic C: Configure Headers and Footers

Lesson 6: Managing Workbooks

• Topic A: Manage Worksheets
• Topic B: Manage Workbook and Worksheet Views
• Topic C: Manage Workbook Properties

Appendix A: Mapping Course Content to Microsoft Excel (Microsoft 365 Apps and Office 2019): Exam MO-200 Appendix B: Mapping Course Content to Microsoft Excel Expert (Microsoft 365 Apps and Office 2019): Exam MO-201 Appendix C: Microsoft® Excel® Common Keyboard Shortcuts Appendix D: Adding Themes and Backgrounds to Worksheets Appendix E: Basic Excel Customization