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 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 NameDateTimeOpen Seats In-PersonOpen Seats OnlinePrice
Excel Common Functions2/26/2024 (Mon)1PM - 4PM44$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

 

California Computer Schools, Inc.

Location 123 East 9th Street
Suite 300
Upland, CA 91786
Phone: 909.981.6331 Hours: Monday – Friday: 9:00 AM – 4:00 PM (PST)

Contact Us

View Cart (0)