Excel III Common Functions
Scheduled Dates
Course Name | Date | Time | Open Seats In-Person | Open Seats Online | Price | |
---|---|---|---|---|---|---|
Excel III Common Functions | 6/17/2023 (Sat) | 9AM - 12PM | 4 | 4 | $95.00 | Register |
Excel III Common Functions | 7/19/2023 (Wed) | 9AM - 12PM | 5 | 4 | $95.00 | Register |
Excel III Common Functions | 7/20/2023 (Thu) | 9AM - 12PM | 5 | 4 | $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.
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