Ch 2: Excel Formulas & Functions

About This Chapter

The Excel Formulas & Functions chapter of this Advanced Excel Training: Help & Tutorials course is the simplest way to master Excel formulas and functions. This chapter uses simple and fun videos that are about five minutes long, plus lesson quizzes and a chapter exam to ensure you learn the essentials of formulas and functions in Excel.

Who's It For?

Anyone who needs help learning or mastering Excel formulas and functions material will benefit from the lessons in this chapter. There is no faster or easier way to learn about formulas and functions in Excel. Among those who would benefit are:

  • Students who have fallen behind in understanding Excel formulas and functions
  • Students who struggle with learning disabilities or learning differences, including autism and ADHD
  • Students who prefer multiple ways of learning Excel (visual or auditory)
  • Students who have missed class time and need to catch up
  • Students who need an efficient way to learn about Excel formulas and functions
  • Students who struggle to understand their teachers
  • Students who attend schools without extra Excel learning resources

How It Works:

  • Find videos in our course that cover what you need to learn or review.
  • Press play and watch the video lesson.
  • Refer to the video transcripts to reinforce your learning.
  • Test your understanding of each lesson with short quizzes.
  • Verify you're ready by completing the Excel Formulas & Functions chapter exam.

Why It Works:

  • Study Efficiently: Skip what you know, review what you don't.
  • Retain What You Learn: Engaging animations and real-life examples make topics easy to grasp.
  • Be Ready on Test Day: Use the Excel Formulas & Functions chapter exam to be prepared.
  • Get Extra Support: Ask our subject-matter experts any Excel program question. They're here to help!
  • Study With Flexibility: Watch videos on any web-ready device.

Students Will Review:

This chapter helps students review the concepts in a formulas and functions unit of a standard advanced Excel training course. Topics covered include:

  • Writing basic formulas in Excel
  • Finding groups of functions on Ribbon
  • Using sum and average functions
  • Copying formulas to other cells or cell ranges
  • Using the min and max functions
  • How to use the COUNT, IF, COUNTIF, AVERAGEIF and SUMIF functions
  • The UPPER and LOWER functions
  • Uses for the CONCATENATE and VLOOKUP functions

14 Lessons in Chapter 2: Excel Formulas & Functions
Test your knowledge with a 30-question chapter practice test
How to Use Formulas & Functions in Excel

1. How to Use Formulas & Functions in Excel

When you need Excel to do the math for you and run the calculations for totals and subtotals, formulas are your go-to feature. This lesson will introduce you to formulas, how they work and the different elements that make up a formula in Excel.

Using the SUM Function in Excel

2. Using the SUM Function in Excel

When you need to perform calculations to add, subtract, divide and multiply, the SUM function is perfect for helping to carry out those tasks. This lesson will introduce you to the SUM function and explain how to use SUM in your formulas.

Using the AVERAGE Function in Excel

3. Using the AVERAGE Function in Excel

Average is calculated by adding numbers together, then dividing the total by the number of numbers. This lesson will explain how to use the AVERAGE function in Excel.

Copying Formulas with the Excel Fill Handle

4. Copying Formulas with the Excel Fill Handle

One of the beautiful things about Excel is its ability to handle plenty of complex formulas. In this lesson, we learn how to make using those formulas a little bit easier by using the fill handle to avoid having to type them over and over again.

Cell References in Excel: Relative, Absolute & Mixed

5. Cell References in Excel: Relative, Absolute & Mixed

Cell references are often used when creating Excel worksheets and writing formulas. This lesson will discuss the different types of cell references, such as absolute and relative. We will also look at examples of each one.

Using the MIN and MAX Functions in Excel

6. Using the MIN and MAX Functions in Excel

Looking in a cell range of numbers to find the smallest number, or the largest, can be time consuming and inefficient. This lesson will introduce you to the MIN and MAX functions in Excel and demonstrate how to use them in formulas.

Using the COUNT Function in Excel

7. Using the COUNT Function in Excel

The COUNT function is one of the most common functions used in Excel. This lesson will introduce you to the function and explain how to use it in formulas.

Using the IF Function in Excel

8. Using the IF Function in Excel

After watching this video lesson, you will learn how you can use the IF function in Excel to help you analyze your data to get the results that you want. Learn how you can use the IF function and how to set it up.

How to Use the COUNTIF Function in Excel

9. How to Use the COUNTIF Function in Excel

When you need write a formula to total the number of cells in a range, where the values meet a very specific criteria, you want to use the COUNTIF function. You will learn in this lesson how to use COUNTIF in Excel.

How to Use the AVERAGEIF Function in Excel

10. How to Use the AVERAGEIF Function in Excel

If you need to take your AVERAGE function to the next step, adding the IF function will give you more power. This lesson will first review the basic AVERAGE function, then demonstrate using examples, how to include IF in your formulas.

How to Use the SUMIF Function in Excel

11. How to Use the SUMIF Function in Excel

When you need to sum numbers that meet a specific criteria in Excel, the SUMIF function is the ticket. This lesson will help you to understand the SUMIF function and how to use it in a formula.

Using the TRIM & CLEAN Functions to Fix Data in Excel

12. Using the TRIM & CLEAN Functions to Fix Data in Excel

Have you ever received an Excel file with information imported from another database? Did you find extra spaces? Non-printable characters? This lesson explains how to use the TRIM function and its partner, CLEAN.

Using the UPPER and LOWER Functions in Excel

13. Using the UPPER and LOWER Functions in Excel

If you need to change the text in a worksheet to uppercase, lowercase, or just return it to proper case, there is a function that you can use to write a formula and Excel will do the work. This lesson will discuss the upper, lower, and proper functions in Excel.

How to Use the CONCATENATE Function in Excel

14. How to Use the CONCATENATE Function in Excel

Ever want to combine two columns into one? This lesson will demonstrate how to use the Concatenate function in Excel. Using this function in a formula will allow you to merge multiple columns of data into one.

Chapter Practice Exam
Test your knowledge of this chapter with a 30 question practice chapter exam.
Not Taken
Practice Final Exam
Test your knowledge of the entire course with a 50 question practice final exam.
Not Taken

Earning College Credit

Did you know… We have over 200 college courses that prepare you to earn credit by exam that is accepted by over 1,500 colleges and universities. You can test out of the first two years of college and save thousands off your degree. Anyone can earn credit-by-exam regardless of age or education level.

To learn more, visit our Earning Credit Page

Transferring credit to the school of your choice

Not sure what college you want to attend yet? Study.com has thousands of articles about every imaginable degree, area of study and career path that can help you find the school that's right for you.

Other Chapters

Other chapters within the Advanced Excel Training: Help & Tutorials course

Support