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 Formulas II

Do you have to do a lot of ‘cleaning’ your data before you even START working on results? Let Excel do the tedious ‘heavy lifting’ for you! Use Excel formulas to extract / manipulate your data automatically!

Scheduled Dates

Course NameDateTimeOpen SeatsPrice
Excel Formulas II12/4/20199:00AM - 4:30PM9$99.00 Register
Excel Formulas II1/9/20209:00AM - 4:30PM9$99.00 Register
Excel Formulas II2/3/20209:00AM - 4:30PM9$99.00 Register
Excel Formulas II2/17/20209:00AM - 4:30PM9$99.00 Register
Excel Formulas II2/28/20209:00AM - 4:30PM9$99.00 Register
Excel Formulas II4/15/20209:00AM - 4:30PM9$99.00 Register

Skills Covered:

  • INDEX MATCH
    • Two-way lookup
    • Join tables
  • INDIRECT
    • Dynamic worksheet reference
    • Dynamic reference Table name
    • Lookup with variable sheet name
  • FIND
    • Extract word containing specific text
    • Clean and reformat telephone numbers
    • Get first/last name from name
  • Comparisons
  • Count matches between two columns
  • Range contains a value not in another range
  • Conditional formatting with formulas
  • Find duplicate values in two columns
  • Highlight dates that are weekends
  • Data validation with formulas
  • Create Dependent Dropdown boxes!
  • Data validation unique values only
  • Validate input with check mark
  • Text functions
  • Get first name from name
  • Join date and text

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)