Excel 2019 Level 1 – Introduction. Versions 2013, 2016, 2019, Office 365, & Online are available.

Course 100003

Excel 2019 Level 1 – Introduction. Versions 2013, 2016, 2019, Office 365, & Online are available.


To customize this class, call 800-453-5961 or click here to contact us

Excel 2019 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

 

Do not hesitate to Contact Us or Live Chat if you have questions or concerns about Excel 2019 Level 1 – Introduction.

Additional information

dates

05/03/2021 (Live Virtual) $350, 06/07/2021 (Live Virtual) $350, 07/12/2021 (Live Virtual) $350, 08/09/2021 (Live Virtual) $350, 09/06/2021 (Live Virtual) $350, 10/04/2021 (Live Virtual) $350, 11/08/2021 (Live Virtual) $350, 12/13/2021 (Live Virtual) $350

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!

Request Group Quote

Register - Choose Date


$350.00

Clear
Number of Seats: