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

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
Do not hesitate to Contact Us or Live Chat if you have questions or concerns about Excel 2019 Level 1 – Introduction.
Need help picking the right course?
Give us a call!
408-684-5250 or
800-453-596 (Toll Free)
800-453-596 (Toll Free)
Train Your Team
Save money and get your team trained. With a group of 5 or more people, you have special options. Click the button below to request a special quote for your team now!
Register Now
Price:
Duration:
1 days