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

Scheduled Dates

Course NameDateTimeOpen Seats In-PersonOpen Seats OnlinePrice
Excel II Large Data2/8/2023 (Wed)1PM - 4PM44$95.00 Register

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.



Topics Include:

Using Table Features

  • Creating a Table
  • Formatting a Table
  • Sorting a Table
  • Filtering a Table
  • Use number match/comparison criteria
  • Working with the Total Row
  • Using Tables in Formulas

Managing Data

  • Creating in cell Drop Down boxes with Data Validation
  • Using the Pick From List to enter data
  • Userform
  • Creating a Calculated Column
  • Remove Duplicates
  • Cleaning raw data

Large Data Templates

California Computer Schools, Inc.

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

Contact Us

View Cart (0)