Excel Level 1

Excel 2019 Level 1 – Introduction

Excel 2019 Level 1 – Introduction. Versions 2013, 2016, 2019, Office 365, & Online are also available. This Microsoft Excel Level 1 course covers Microsoft Office Specialist Program exam objectives to help you prepare for the Excel 2019 Level 1.

Course Outline

Lesson 1 – Excel Basics

• Creating an Excel Workbook
• Examining the Excel Environment
• Opening an Existing Workbook
• Navigating a Worksheet
• Creating a New Workbook
• Saving a New Workbook
• Moving Between Workbooks
• Setting Excel Options
• Switching Between Views
• Using Tell Me to Obtain Help
• Closing a Workbook and Exiting Excel

Lesson 2 – Working with Data

• Entering Text and Numbers
• Entering Simple Formulas
• Choosing Formula Cell References
• Using AutoSum
• Changing & Deleting Data
• Using Undo/Redo
• How to use Find and Replace
• Using the Go to Command
• Spell Checking Your Worksheet
• Inserting Symbols
• Using Smart Lookup

Lesson 3 – Editing a Worksheet

• Working with Ranges
• Copying and Pasting Data
• Using the Office Clipboard
• Cutting and Pasting Data
• Copying and Moving Cells Using Drag-And-Drop
• Changing Column Width
• Changing Row Height
• Inserting and Removing Rows and Columns
• Copying Data and Formulas with Autofill
• Filling in Cells Using Flash Fill

Lesson 4 – Formatting a Worksheet

• Formatting Text
• Using the Format Cells Dialog Box
• Formatting Values
• Using the Format Painter Button
• Alignment and Text Wrapping
• Merging Cells and Centering Text
• Adding Cell Borders
• Applying Colors and Shading to Cells
• Applying Cell Styles
• Hiding and Unhiding Rows and Columns
• Freezing and Unfreezing Rows and Columns
• Inserting and Removing Page Breaks

Lesson 5 – Page Setup and Printing

• Adjusting Margins
• Setting Page Orientation
• Setting Paper Size
• Defining a Print Area
• Printing Worksheet Titles
• Forcing a Worksheet to Fit
• Inserting Headers and Footers
• Printing a Worksheet

Lesson 6 – Formulas and Functions

• Relative References
• Absolute References
• Mixed References
• Copying Formulas
• Min, Max, Count and Average Functions
• the Insert Function Button

Lesson 7 – Modifying Workbooks

• Adding and Deleting Worksheets
• Copying Worksheets
• Renaming Worksheets
• Repositioning Worksheets
• Grouping Worksheets
• Changing Worksheet Tab Colors
• Using -D Formulas & References