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 IV Large Data

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 Data

  • Importing Data from a Text File
  • Exporting Data
  • Converting Text to Columns
  • Using Flash Fill
  • Using Text Functions

Using Table Features

  • Creating a Table
  • Formatting a Table
  • Sorting a Table
  • Filtering a Table
  • Use number match/comparison criteria
  • Filter information using AutoFilter
  • Creating a Slicer
  • Working with the Total Row
  • Creating a Calculated Column

Entering Data

  • Using Convert Text to Columns Wizard
  • Creating in cell Drop Down boxes with Data Validation
  • Using the Pick List to enter data
  • Flash Fill

Pivot Tables Basics

  • Creating A Pivot Table
  • Laying out a New Pivot table On the Worksheet
  • Managing Pivot Tables
  • Grouping Pivot Table Items
  • Displaying Pivot Table Details
  • Adding/Deleting Subtotals
  • Adding Sub-Details to an Item
  • Create, edit and delete a Custom Lists
  • Remove Duplicates
  • Userform

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)