Excel Essentials Part 1
On-Track is excited to offer LIVE virtual training classes to our beloved students. Enjoy all the benefits a live expert instructor from the comfort of your own home or office computer.
Please contact us at learn@on-track.com to receive additional information about our virtual classes and training platform.
Duration: Half Day (3.5 hours)
COURSE OUTLINE
- Understanding the Excel Environment
- Understanding Workbooks and Worksheets
- Creating a New Workbook
- Working with the Interface (Ribbon, Quick Access Toolbar, Status Bar
- Managing the Worksheet
- Navigating in a Worksheet
- Using the Scroll Bars and Boxes
- Inserting, Renaming, and Deleting Worksheets
- Selecting Cells and Ranges
- Selecting a Cell, Range, Rows, and Columns
- Selecting Nonadjacent Cells and Ranges
- Selecting an Entire Worksheet
- REALLY Understanding How to Enter Data
- Text Editing Mode vs Navigation Mode
- Data (Content) vs Formats
- Entering Text
- Entering Numbers
- Entering Dates
- Entering Percentages
- Understanding how to Format Data
- Applying Font Formats
- Applying Number Formats
- Understanding how to Delete Data
- Deleting Data (aka Content)
- Deleting Formats
- Deleting Data AND Formats
- Understanding how to Edit Data
- Editing Data in a Cell
- Editing Data through the Formula Bar
- Replacing Data
- Understanding how to Duplicate or Move Data
- Duplicating (Copying and Pasting) Data
- Moving (Cutting and Pasting) Data
- Changing the Worksheet Structure
- Resizing and Auto-Fitting Columns and Rows
- Deleting Rows and Columns
- Inserting Rows and Columns
- Inserting and Deleting Cells
- Workbook Management
- Saving a Workbook
- Closing a Workbook
- Opening a Workbook
- Exiting Excel