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 Advanced

So you have a HUGE database in Excel, now what? Use PIVOT TABLES to summarize your data. Learn how to make your life easier by AUTOMATING redundant and time consuming tasks.

Scheduled Dates

Course NameDateTimeOpen SeatsPrice
Excel Advanced12/10/20199:00AM - 4:00PM7$99.00 Register
Excel Advanced12/14/20199:00AM - 4:00PM8$99.00 Register
Excel Advanced12/27/20199:00AM - 4:00PM8$99.00 Register
Excel Advanced1/31/20209:00AM - 4:00PM9$99.00 Register
Excel Advanced2/25/20209:00AM - 4:00PM9$99.00 Register
Excel Advanced3/21/20209:00AM - 4:00PM9$99.00 Register
Excel Advanced3/25/20209:00AM - 4:00PM9$99.00 Register
Excel Advanced4/23/20209:00AM - 4:00PM9$99.00 Register

Skills Covered:

  • What are records and fields?
  • Using the Pick List to enter data
  • Defining and creating names
  • Using the Go To feature
  • Filter information using
  • AutoFilter
  • Create a custom Auto Filter
  • Use number match/comparison criteria
  • Using Convert Text to Columns Wizard
  • Sorting spreadsheet data
  • Creating a Series
  • Create, edit and delete a Custom Lists
  • Using vertical/horizontal split windows
  • Arrange multiple documents on screen
  • Moving or Copying sheets
  • Insert and delete sheets
  • Grouping Spreadsheets
  • Saving Workspaces
  • Copy data between Excel documents
  • Link data from one file to another
  • Understand linking between documents
  • Creating a Template
  • Customizing the Ribbon
  • Macros
  • Recording and running
  • Creating a macro button
  • Adding custom menu to a toolbar
  • Assign a macro to a custom menu
  • Pivot Tables
  • Creating and using
  • Summarizing
  • Isolating data

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)