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

Tired of having to think? Let Excel do the work for you! FORMULAS AND FUNCTIONS can do a lot of work for you! Give ‘em a try…they’re not THAT hard!

Scheduled Dates

Course NameDateTimeOpen SeatsPrice
Excel Formulas11/25/20199:00AM - 4:00PM4$99.00 Register
Excel Formulas12/17/20199:00AM - 4:00PM7$99.00 Register
Excel Formulas12/28/20199:00AM - 4:00PM8$99.00 Register
Excel Formulas1/3/20209:00AM - 4:00PM7$99.00 Register
Excel Formulas2/14/20209:00AM - 4:00PM9$99.00 Register
Excel Formulas3/3/20209:00AM - 4:00PM9$99.00 Register
Excel Formulas4/1/20209:00AM - 4:00PM9$99.00 Register
Excel Formulas4/30/20209:00AM - 4:00PM9$99.00 Register

Skills Covered:

  • Best Practices for writing Formulas
  • Conditional formulas (IF statement)
  • Write a formula with nested IF statements
  • Using IF AND and IF OR statements
  • Using formulas to calculate date/time
  • = NOW =YEAR =MONTH =DAY

  • How to use = VLOOKUP
  • Formulas for computing a Straight Note
  • Using = PMT to calculate a loan payment
  • Round numbers using = ROUND
  • Display values: =MIN =MAX and =INT
  • Using the = COUNT function
  • Convert text =LOWER =UPPER =PROPER
  • Join text using = CONCATENATE
  • Using the Function Wizard
  • SUM IF
  • SUM PRODUCT
  • Goal Seek

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)