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.
Which Microsoft Excel Course should I take?
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.