Excel Essentials
Welcome to the Excel Essentials class!
This course is designed to equip you with the fundamental skills necessary to navigate and utilize Excel's basic features. Whether you're new to spreadsheets or looking to refresh your knowledge, this class will provide you with a solid foundation in Excel. We'll explore key topics such as navigating through cells, entering data accurately, printing worksheets effectively, and harnessing the power of formulas to perform calculations. Get ready to embark on a journey that will empower you to work with confidence and efficiency in Microsoft Excel.
Scheduled Dates
We don't currently have this class on the schedule, but we can add it for you! Please choose an available day and time or call us at (909) 981-6331 for more information.
Need a Different Date?
Do the current classes not work for your schedule, or are no classes currently available? No problem! Visit our Schedule a Class page and choose an available day and time or call us at (909) 981-6331 for more information.
This class is designed to help students work as EFFICIENTLY as possible! Whether you’re a ‘self-taught’ computer guru or a complete ‘newbie’ this class will have something for you!
Topics Include:
Entering Data
- Multiple Cells, Same Data
- Multi-line cell
- Cell Message
- Entering data fast
- Copy data between Excel documents
- Create, edit and delete a Custom Lists
- Text to Columns
- Flash Fill
- Combine Text (Fill Justify)
- Shrink to Fit for Headers
Printing Worksheets
- Change viewing options
- Locking Headings for Data Entry
- Creating and Printing LARGE sheets
- Custom headers and footers
- Page breaks
- Print headings
- Change Print Order
Using Formulas
- Edit formulas and fix common errors
- Absolute Cell References
- Filling formulas
- PEMDAS
Paste Special-Values Only
- LOWER
- UPPER
- PROPER
Skills Covered:
- Quick navigation with keyboard or mouse
- Entering data fast
- Making changes to spreadsheet data
- Utilizing Cancel/Undo/Redo
- Fastest methods for selecting data
- Clearing Cells Correctly
- Inserting / deleting cells, rows, and columns
- Using Spell Check
- Best Methods to move or copy data
- Aligning data in cells
- Quickly resize Columns and Row sizes
- Hiding and unhiding columns and rows
- Save vs Save As
- Opening, closing and deleting files
- Creating a new workbook
- Writing Formulas
- Edit formulas and fix common errors
- Filling formulas
- How the Auto Sum feature works
- Use absolute references in formulas
- Save Time with Number Formats
- Change viewing options
- Locking Headings for Data Entry
- Creating and Printing LARGE sheets
- Using Print Preview
- Custom headers and footers
- Page breaks
- Print headings
- Change Print Order