Excel Level 1

Course: 9004

This Microsoft Excel Level 1 course covers Microsoft Office Specialist Program exam objectives to help you prepare for the Excel Associate.

Download PDF
  • Duration: 1 day
  • Price: $325.00
Get This Course $325.00
February 6

9:00 AM – 4:00 PM CST

March 6

9:00 AM – 4:00 PM CST

April 3

9:00 AM – 4:00 PM CST

May 1

9:00 AM – 4:00 PM CST

June 5

9:00 AM – 4:00 PM CST

August 7

9:00 AM – 4:00 PM CST

September 4

9:00 AM – 4:00 PM CST

October 2

9:00 AM – 4:00 PM CST

December 4

9:00 AM – 4:00 PM CST

Scroll to view additional course dates

Reserve Your Seat

  • Virtual instructor Led Training
  • Complete Hands-on Labs
  • Softcopy of Courseware
  • Learning Labs
  • Virtual instructor Led Training
  • Complete Hands-on Labs
  • Softcopy of Courseware
  • Learning Labs
  • You can use your Purchase Card and checkout
  • The GSA Contract Number: 47QTCA20D000D
  • Call 800-453-5961 for details
  • Customize your class
  • Delivery Onsite or Online for your organization
  • Choice of Dates when and where you want
  • Guidance in choosing and customizing your class

Question About this Course?

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

Question About this Course?

Need help picking the right course?

Contact Us

Call Now

Call Now800-453-5961