Excel Common Functions

Welcome to the Excel Common Functions class!

In this course, we will explore the power of commonly used functions in Microsoft Excel, enabling you to perform complex calculations, manipulate text, and work with dates and times efficiently. We will dive into essential functions such as the SUM function, which allows you to quickly calculate the total of a range of numbers. You will learn how to utilize Count functions to count cells based on specific criteria, helping you extract valuable insights from your data. Additionally, we will explore Text functions, equipping you with the skills to manipulate and format text strings effectively. We will also delve into Average functions, enabling you to calculate the mean value of a range of numbers accurately. Furthermore, you will discover the capabilities of Excel's date and time functions, facilitating easy calculations and formatting of date and time values. By the end of this class, you will possess a solid understanding of these commonly used functions, empowering you to streamline your data analysis, increase efficiency, and unlock new possibilities in Excel. Get ready to take your Excel skills to the next level as we unravel the power of these fundamental functions.

Scheduled Dates

We don't currently have this class on the schedule, but we can add it for you! Please choose an available day and time or call us at (909) 981-6331 for more information.

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