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

Scheduled Dates

Course NameDateTimeOpen Seats In-PersonOpen Seats OnlinePrice
Excel VIII Advanced Formulas7/1/2023 (Sat)1PM - 4PM44$95.00 Register
Excel VIII Advanced Formulas8/24/2023 (Thu)9AM - 12PM54$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.



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 123 East 9th Street
Suite 300
Upland, CA 91786
Phone: 909.981.6331 Hours: Monday – Friday: 9:00 AM – 4:00 PM (PST)

Contact Us

View Cart (0)