Ch 2: Excel Formulas & Functions

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
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.