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 IV Common Functions

Scheduled Dates

Course NameDateTimeOpen Seats In-PersonOpen Seats OnlinePrice
Excel IV Common Functions10/9/2021 (Sat)1PM - 4PM44$80.00 Register
Excel IV Common Functions10/20/2021 (Wed)9AM - 12PM54$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.



Topics Include:

SUM Functions

  • SUM / SUMIF / SUMIFS

COUNT Functions

  • COUNT / COUNTA / COUNTBLANK / COUNTIF / COUNTIFS

AVERAGE Functions

  • AVERAGE / AVERAGEIF / AVERAGEIFS

Other Functions

  • MIN / MAX / ROUND

Text in Functions

  • LOWER / UPPER / PROPER
  • Joining text with functions

Calculating with Date and Times

  • MONTH / DAY / YEAR / TODAY
  • HOUR / MINUTE / SECOND / NOW
  • Calculating with a 12 hour clock
  • Forcing formatting

PMT Function

  • Function Wizard

Defining and Creating Names

Display Cells

 

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)