Excel

Excel

Word

Word

Access

Access

PowerPoint

PowerPoint

Outlook

Outlook

Publisher

Publisher

Quickbooks

Quickbooks

Windows & Computers

Windows & Computers

Internet & Cloud

Internet & Cloud

Specialty

Specialty

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

California Computer Schools, Inc.

Location 123 East 9th Street
Suite 300
Upland, CA 91786
Phone: 909.981.6331 Hours: Monday – Friday: 9:00 AM – 4:00 PM (PST)

Contact Us

View Cart (0)