Skip to content

Classes End User Application

EXL-01 Microsoft Taught by us

Microsoft Excel Level 1

  • 1 days
  • 7 upcoming dates
  • 1 guaranteed to run

Upcoming dates

All times shown in the class's own timezone. 1 of 7 are guaranteed to run, meaning they go ahead regardless of enrollment. Dates we teach ourselves run once 1 people are booked, so a pair of seats confirms one.

Dates Starts Where Status Seat Book
Tue, Oct 13 9:00 AM to 4:00 PM PDT Taught by us Live virtual RUNS WITH 1+ $295
Tue, Oct 27 9:00 AM to 4:00 PM PDT Taught by us Live virtual RUNS WITH 1+ $295
Mon, Nov 2 9:00 AM to 4:00 PM PST Taught by us Live virtual GUARANTEED $295
Mon, Nov 9 9:00 AM to 4:00 PM PST Taught by us Live virtual RUNS WITH 1+ $295
Mon, Nov 23 9:00 AM to 4:00 PM PST Taught by us Live virtual RUNS WITH 1+ $295
Mon, Dec 14 9:00 AM to 4:00 PM PST Taught by us Live virtual RUNS WITH 1+ $295
Tue, Dec 29 9:00 AM to 4:00 PM PST Taught by us Live virtual RUNS WITH 1+ $295

About this class

We have 7 scheduled dates of Microsoft Excel Level 1, from Tue, Oct 13 through Tue, Dec 29. 1 of them is guaranteed to run regardless of enrollment. We teach this one ourselves, with our own instructors and courseware. Seats are $295 each over 1 day, courseware included. Book online with a card, or send a purchase order and we will invoice on net 30 terms.

In this one-day, instructor-led course, students will take a glimpse behind the curtain and learn hidden details about how excel works. What is contiguous and non-contiguous selection? What is a list range? What is the check symbol for? When should I use Tab? Enter? Shift? CTRL? What is Select Mode and Edit Mode? What is Autofill? Autofit? What about these terms: Function? Expression? Values? These questions and more will be answered as we learn the foundation of data storage, data calculations, and data formatting using the Excel program. Features and functions in Office 365 and Office 2019 / 2016 are nearly identical. For this reason, users for all three versions (365, 2019 and 2016) attend the same class. The instructor will explain the few visual differences in the versions to you; just let the instructor know what version you are using.

What you'll be able to do

  • Get around in Excel
  • Create an Excel workbook
  • Edit a worksheet
  • Calculate data
  • Format cells
  • Create page setup and printing options
  • Work with multiple worksheets

Course outline

Module 1 Getting Around in Excel

  • Opening Excel
  • Exploring the Excel Window
  • Exploring the Excel Environment
  • Using the Excel Tell Me Feature
  • Opening and Viewing a Workbook
  • Navigating a Workbook

Module 2 Creating an Excel Workbook

  • Closing a Workbook
  • Starting a New Workbook
  • Entering Data
  • Saving and Naming a Workbook
  • Using AutoFill

Module 3 Editing a Worksheet

  • Selecting Cells, Rows and Columns
  • Editing and Deleting Data in Cells
  • Using Undo and Redo
  • Moving and Copying Data in Cells
  • Adding and Deleting Rows and Columns
  • Using Find and Replace
  • Using Spellcheck and Smart Lookup

Module 4 Calculating Data

  • Using Basic Formulas
  • Copying and Pasting Formulas
  • Multiplying Cells
  • Adding More than Two Cells
  • Dividing Cells
  • Calculating with Functions
  • Using Absolute and Relative References

Module 5 Formatting Cells

  • Modifying Fonts
  • Adding Borders and Colors to Cells
  • Using the Format Painter
  • Formatting Numbers
  • Adjusting Cell Alignment
  • Using Cell Styles
  • Adjusting Row Height and Column Width

Module 6 Creating Page Setup and Printing Options

  • Setting Page Breaks
  • Setting Page Orientation
  • Setting Margins
  • Inserting Headers and Footers
  • Setting Printing Options
  • Freezing and Unfreezing Panes
  • Splitting a Worksheet

Module 7 Working With Multiple Sheets

  • Formatting Worksheet Tabs
  • Inserting and Deleting Worksheets
  • Moving and Copying Worksheets
  • Hiding a Worksheet
  • Arranging Worksheets

Before you attend

Students should be familiar with using personal computers and have used a mouse and keyboard. You should be comfortable in the Windows environment and be able to use Windows to manage information on your computer. Specifically, you should be able to launch and close programs; navigate to information stored on the computer; and manage files and folders.

How reserving works. Your card is authorized, not charged. We confirm the seat with the training center, usually within one business day, and take payment only once it is held. If the class turns out to be full we release the authorization and you are not charged.

Request a quote

Tell us how many people and roughly when. We'll come back with dates, seat price, and a total by the end of the next business day.

Class Microsoft Excel Level 1

No obligation, and we don't add you to a mailing list.