Name: Excel Top 10 Essential Functions
Overall Rating: 4.8 out of 5 (5 ratings)
Category: All Learners
Duration: 1.50 hour(s)
Individual Fee: $25.00

Excel functions can greatly enhance your ability to perform tasks in day-to-day activities in Excel. While there are hundreds of functions available, there are 10 functions that all Excel users should know. Join Cathy to learn these important functions.

Whether you are an office worker, or a small business owner using Excel to keep track of your finances or just the casual user, these Excel functions can be very important time savers and enhance your ability to create better performing spreadsheets.  


This Development Activity has not been scheduled.
College of Lake County
19351 West Washington Street
Building E, Suite E186
Grayslake, IL 60030
United States
Importance: Why this competency is important to our organization, mission, strategy, or goals.

You will learn not only HOW to use these functions, but WHY they do what they do. Knowing the “why” helps you to do more with Excel. Attendees should have basic knowledge of creating Excel calculations using the basic mathematical operators and know the difference between relative and absolute cell references. 

Know and Explain: Information you will know, be able to explain, or be able to find.
  • Learn many statistical functions including SUM, AVERAGE, MAX, MIN and COUNT
  • Use IF and its counterparts COUNTIF, SUMIF, and AVERAGEIF
  • Understand VLOOKUP
  • Calculate dates using TODAY, and NOW
  • Learn many functions to manipulate text once imported including LEFT, RIGHT, LEN, TRIM and CONCATENATE
Do and Show: Important tasks or skills you will be able to perform and demonstrate to others.

  • Learn many statistical functions including SUM, AVERAGE, MAX, MIN and COUNT
  • Use IF and its counterparts COUNTIF, SUMIF, and AVERAGEIF
  • Understand VLOOKUP
  • Calculate dates using TODAY, and NOW
  • Learn many functions to manipulate text once imported including LEFT, RIGHT, LEN, TRIM and CONCATENATE

SkillPrerequisiteExpected Outcome
Excel1 - BeginnerNot specified
Excel - Using Spreadsheets1 - BeginnerNot specified
Excel Advanced1 - BeginnerNot specified
Excel Intermediate1 - BeginnerNot specified
Class Costs
Class ValueNo Charge
Individual Fee$25.00
Private Class Fee$0.00
4.8 out of 5 (5 ratings)

Very good course for beginner level Thu, May 11, 2023
I learned so much in this 90 minute course. Before taking the course, I could pretty much just use the 'SUM' formula in Excel. After the course I am confident in using at least 5 other formulas, as well as better ways to manage the spreadsheets overall. We learned some great shortcuts as well. The teacher went at a pace that everyone could keep up with, and was happy to answer questions that came up during the course.
Excel Top 10 Essential Functions Thu, Jan 20, 2022
I just need to practice more with the formulas to build my confidence using it.
Excel Top 10 Functions Fri, Sep 17, 2021
Excellent information. Excellent interaction with participants.
[See all User Reviews…]