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 V Managing Sheets & Summaries

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:

Working with Workbooks

  • Viewing, Renaming, and Color-coding Worksheets
  • Grouping Spreadsheets
  • Moving or Copying sheets

Working with Multiple Worksheets and Workbooks

  • Creating Linked Formulas
  • Using 3-D References
  • Viewing Multiple Worksheets
  • Viewing Worksheets in Different Workbooks
  • Creating Linked Formulas between Workbooks

Macros

  • Recording and running
  • Creating a macro button
  • Adding custom menu to a toolbar
  • Assign a macro to a custom menu
  • IFERROR Function

=VLOOKUP

  • When To Use Exact Match
  • 6 Tips For Writing Better Vlookups
  • Creating A Dynamic Data Range
  • Making Vlookup Formulas Go Wild
  • Comparing 2 Lists With A Vlookup
  • Range Lookup In Excel [Formulas]
  • COUNT
  • COUNTA
  • COUNTBLANK

SUMIF

  • Sumifs Function
  • Using the =COUNTIF function
  • Countifs Function
  • Averageifs

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)