909.981.6331
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 II Pro

Scheduled Dates

This class is scheduled on an as-needed basis. Please choose an available day and time or call us at (909) 981-6331 for more information.

Topics Include:

  • Entering data fast
  • Fastest methods for selecting data
  • Quickly resize Columns and Row sizes
  • Creating a Series
  • Applying Cell Styles
  • Copy data between Excel documents

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

  • Best Practices for writing Formulas
  • Edit formulas and fix common errors
  • Filling formulas
  • PEMDAS

Other Ways to Use Formulas

  • Paste Special - Values Only
  • Defining and creating names
  • Display cells
  • MIN
  • MAX
  • AVERAGE
  • ROUND
  • LOWER
  • UPPER
  • PROPER
  • Using and formatting Comments
  • Multiple Cells, Same Data
  • Multi-line cell
  • Cell Message
  • One Click to Get More Status

California Computer Schools, Inc.

Location 3290 East Guasti Road
Suite 110
Ontario, CA 91761
Phone: 909.981.6331 Hours: Monday – Friday: 9:00 AM – 4:00 PM (PST)

Contact Us

View Cart (0)