9:00 AM – 4:00 PM CST
9:00 AM – 4:00 PM CST
9:00 AM – 4:00 PM CST
9:00 AM – 4:00 PM CST
9:00 AM – 4:00 PM CST
9:00 AM – 4:00 PM CST
9:00 AM – 4:00 PM CST
9:00 AM – 4:00 PM CST
9:00 AM – 4:00 PM CST
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?
Call Now