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
Course Name | Date | Time | Open Seats In-Person | Open Seats Online | Price | |
---|---|---|---|---|---|---|
Excel Common Functions | 10/26/2024 (Sat) | 9AM - 12PM | 5 | 4 | $125.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