What is the VLOOKUP function used for?

VLOOKUP helps you find a value in a table. For example, =VLOOKUP("Apple", A1:B5, 2, FALSE) looks for "Apple" in the first column and returns the corresponding value from the second column.

How do you round a number in Excel?

Use the ROUND function. For example, =ROUND(A1, 2) will round the number in cell A1 to two decimal places.

How do you find the average of numbers in Excel?

Use the AVERAGE function. For example, =AVERAGE(A1:A5) calculates the average of the values from A1 to A5.

How do you combine text from two cells in Excel?

Use the & symbol. For example, =A1 & " " & B1 combines the text from cells A1 and B1 with a space between them.

What is an array formula in Excel?

An array formula allows you to perform multiple calculations at once. For example, =SUM(A1:A5*B1:B5) multiplies corresponding values in two ranges and then sums the results.

Can I preview a course before enrolling?

Yes, you can preview the first video and view the syllabus before you enroll. You must purchase the course to access content not included in the preview.

When will I have access to the lectures and assignments?

If you decide to enroll in the course before the session start date, you will have access to all of the lecture videos and readings for the course. You’ll be able to submit assignments once the session starts.

What will I get when I enroll?

Once you enroll and your session begins, you will have access to all videos and other resources, including reading items and the course discussion forum. You’ll be able to view and submit practice assessments, and complete required graded assignments to earn a grade and a Course Certificate.

When will I receive my Course Certificate?

If you complete the course successfully, your electronic Course Certificate will be added to your Accomplishments page - from there, you can print your Course Certificate or add it to your LinkedIn profile.

Why can’t I audit this course?

This course is currently available only to learners who have paid or received financial aid, when available.

Is financial aid available?

Yes. In select learning programs, you can apply for financial aid or a scholarship if you can’t afford the enrollment fee. If fin aid or scholarship is available for your learning program selection, you’ll find a link to apply on the description page.

Excel Functions and Formulas

Unlock access to 10,000+ courses with Coursera Plus

Start 7-Day free trial

Excel Functions and Formulas

Instructor: Packt - Course Instructors

Included with

Learn more

9 modules

Gain insight into a topic and learn the fundamentals.

Intermediate level

Recommended experience

5 hours to complete

Flexible schedule

Learn at your own pace

9 modules

Gain insight into a topic and learn the fundamentals.

Intermediate level

Recommended experience

5 hours to complete

Flexible schedule

Learn at your own pace

What you'll learn

Master Excel’s core functions and formulas to improve data analysis and manipulation
Understand how to efficiently manage and format data using Excel's logical and text functions
Create complex reports with lookup and reference tools like VLOOKUP
Simplify large datasets with advanced array formulas for real-world applications

Skills you'll gain

Details to know

Shareable certificate

Add to your LinkedIn profile

See how employees at top companies are mastering in-demand skills

Learn more about Coursera for Business

logos of Petrobras, TATA, Danone, Capgemini, P&G and L'Oreal

There are 9 modules in this course

This course features Coursera Coach!

A smarter way to learn with interactive, real-time conversations that help you test your knowledge, challenge assumptions, and deepen your understanding as you progress through the course. Unlock the full potential of Excel with this comprehensive course on Excel functions and formulas. Whether you're a beginner or intermediate user, you'll gain the skills to efficiently manage data, perform complex calculations, and automate tasks to enhance your productivity. Through step-by-step guidance, you'll learn everything from basic formulas to advanced array functions, giving you a deep understanding of Excel's power and versatility. This course also covers key Excel features like cell references, logical functions, text manipulation, and data analysis techniques, ensuring that you can confidently use Excel in any professional setting. The course begins with foundational concepts like cell references and copying formulas, leading into practical topics such as managing large datasets with count, sum, and date-time functions. You'll then explore logical functions for decision-making, followed by powerful lookup and reference tools like VLOOKUP. The latter part of the course delves into rounding, statistical functions, and text manipulation to handle more complex data operations. You’ll also learn how to master array formulas to simplify large-scale data calculations. Designed for anyone looking to enhance their Excel skills, this course is perfect for professionals working with data, students, or anyone aiming to use Excel more efficiently. No prior Excel knowledge is required, but a basic understanding of spreadsheets will be helpful. This course is suitable for beginners, but it will also provide valuable insights for intermediate users looking to take their skills to the next level. By the end of the course, you will be able to confidently use Excel to manage complex data, perform advanced calculations, create dynamic reports, and automate repetitive tasks, enhancing both your efficiency and productivity.

In this module, we will dive into the foundational aspects of Excel’s cell references. You will learn how to set cell references correctly, master the art of copying formulas, and use absolute references to ensure formulas work across different cells. By the end of this section, you'll be able to work with large datasets efficiently, saving time and reducing errors.

What's included

7 videos1 reading

In this module, we will explore powerful counting and summing functions in Excel. You’ll learn to quickly calculate sums and counts based on various criteria and handle more complex analysis with functions like SUMPRODUCT. By the end, you will be proficient in handling large datasets and deriving meaningful insights from them.

What's included

10 videos1 assignment

10 videosTotal 32 minutes

Count & Sum Functions4 minutes
Countif Function4 minutes
Running Totals2 minutes
Sumif Function5 minutes
Count Characters3 minutes
SUM Function2 minutes
Count Blank and Nonblank Cells2 minutes
Not Equal To2 minutes
Count Cells with Text2 minutes
Sumproduct2 minutes

1 assignmentTotal 15 minutes

Functions & Formulas - Count and Sum - Assessment15 minutes

In this module, we will focus on how to manage date and time data in Excel. You’ll learn to enter and manipulate dates, use date-related functions, and format them appropriately for your needs. This section will also teach you how to find critical time-based information like the last day of the month.

What's included

4 videos1 assignment

In this module, we will explore how to use Excel’s logical functions to automate decision-making and data evaluation. You’ll learn to build complex formulas using IF, OR, and SWITCH to analyze data based on multiple conditions. By the end of this section, you'll be able to craft logical expressions that streamline data analysis and problem-solving in Excel.

What's included

8 videos1 assignment

In this module, we will delve into Excel’s lookup and reference functions to help you efficiently search and retrieve data. You will gain a thorough understanding of VLOOKUP and other lookup techniques, enabling you to extract critical information from large datasets with ease.

What's included

2 videos1 assignment

In this module, we will explore the essential rounding functions in Excel. You will learn to round numbers to the desired decimal places and remove unnecessary decimals, helping you present data more clearly and professionally. By the end of this section, you will be able to work with numbers in a way that best suits your analytical needs.

What's included

2 videos

In this module, we will explore the statistical functions available in Excel. You will learn to apply functions like AVERAGE, RANK, and STDEV to analyze and interpret your data. By mastering these functions, you’ll be equipped to make data-driven decisions and draw meaningful conclusions from your datasets.

What's included

2 videos1 assignment

In this module, we will cover essential text manipulation techniques in Excel. You will learn how to extract, combine, and clean text data using functions like TEXT, CONCATENATE, and SEARCH. By the end of this section, you’ll be able to handle large text-based datasets with ease.

What's included

12 videos1 assignment

In this module, we will dive into the world of array formulas, a powerful tool for handling complex calculations in Excel. You will learn how to apply these formulas to calculate data in large datasets, identify unique values, and solve intricate problems like summing every nth row. By mastering array formulas, you'll be able to tackle more advanced Excel tasks with ease.

What's included

10 videos3 assignments

10 videosTotal 19 minutes

Array Formulas1 minute
Count Errors1 minute
Count Unique Values3 minutes
Count with Or Criteria1 minute
Sum Every Nth Row1 minute
Sum Largest Numbers1 minute
Sum Range with Errors1 minute
Sum with Or Criteria2 minutes
Most Frequently Occurring Word1 minute
System of Linear Equations1 minute

3 assignmentsTotal 90 minutes

Functions & Formulas - Array Formulas - Assessment15 minutes
Full Course Assessment60 minutes
Full Course Practice Assessment15 minutes

Instructor

Packt - Course Instructors

Packt

1,218 Courses295,149 learners

Offered by

Packt

Why people choose Coursera for their career

Felipe M.

Learner since 2018

"To be able to take courses at my own pace and rhythm has been an amazing experience. I can learn whenever it fits my schedule and mood."

Jennifer J.

Learner since 2020

"I directly applied the concepts and skills I learned from my courses to an exciting new project at work."

Larry W.

Learner since 2021

"When I need courses on topics that my university doesn't offer, Coursera is one of the best places to go."

Chaitanya A.

"Learning isn't just about being better at your job: it's so much more than that. Coursera allows me to learn without limits."

Open new doors with Coursera Plus

Unlimited access to 10,000+ world-class courses, hands-on projects, and job-ready certificate programs - all included in your subscription

Learn more

Advance your career with an online degree

Earn a degree from world-class universities - 100% online

Explore degrees

Join over 3,400 global companies that choose Coursera for Business

Upskill your employees to excel in the digital economy

Learn more

Frequently asked questions

Use the SUM function. For example, to sum the numbers in cells A1 to A5, type =SUM(A1:A5).

Use the TODAY() function. Type =TODAY() in any cell, and it will show the current date.

The IF function checks if a condition is true or false and returns different results based on that. For example, =IF(A1>10, "Yes", "No") checks if A1 is greater than 10.