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

Scheduled Dates

Course NameDateTimeOpen Seats In-PersonOpen Seats OnlinePrice
Excel IX Advanced Formulas10/6/2021 (Wed)1PM - 4PM54$80.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.



Building Large Functions

  • Text And Formatting Functions
  • Textjoin
  • Text Function
  • Trim/Clean Functions
  • Create Email Address With Name And Domain

Lookups And Scenario Functions

  • Find/Exact Functions
  • Len Function
  • Match Function
  • Index Function
  • Two-Way Lookup With Index And Match

INDIRECT

  • How To Make Dependent Dropdown Lists In Excel (Data Validation)
  • Prevent Duplicate Entries (Data Validation)
  • Using A Formula For Data Validation

Goal Seek

  • Running Count Of Occurrence In List

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)