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 VII Advanced Formulas

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:

Text And Formatting Functions

  • Textjoin
  • Text Function
  • Join Date And Text
  • Join text using =CONCATENATE
  • Left/Right/Mid Functions
  • Create Email Address With Name And Domain
  • Trim/Clean Functions

Lookups And Scenario Functions

  • Find/Exact Functions
  • Len Function
  • Match Function
  • Index Function
  • Goal Seek
  • Using the Function Wizard
  • Two-Way Lookup With Index And Match
  • Running Count Of Occurrence In List
    Formula To Find Duplicate Values In A Data Range
  • Using A Formula For Data Validation
    Sum If Cell Contains Text In Another Cell
  • How To Make Dependent Dropdown Lists In Excel (Data Validation)
  • Prevent Duplicate Entries (Data Validation)
  • How To Set Up Dependent Dropdown Lists

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)