Back to Using Basic Formulas and Functions in Microsoft Excel
Coursera

Using Basic Formulas and Functions in Microsoft Excel

Have you started using spreadsheets like Excel and want to learn how to write formulas and functions to perform simple data analysis? In this project, you will learn about the general format for writing formulas and functions in Excel to perform analysis on the sales data from a sample company. In this analysis, you will calculate total sums of profits, you will learn how to use functions to analyze the popularity of the items sold and you will also learn how to calculate averages and percentages of monthly profits. Throughout the project, you will work through some examples that will show you how to apply the formulas and functions you have learned.

Status: Spreadsheet Software
Status: Business Mathematics
BeginnerGuided Project2 hours

Featured reviews

JO

5.0Reviewed Jan 4, 2023

this was really spectacular. It helped me pass my interview tests on Excel and landed me a job. I recommend this for everyone who really needs intermediate knowledge on Excel.

MK

5.0Reviewed May 23, 2024

The professor made this guided project so much easier to grasp the gist of data analysis and basic functions and calculations in excel

JR

5.0Reviewed Nov 22, 2022

Fantastic. Easy to follow, pre-made data ready to use for examples and practice. I will definitely look into other guided courses by this instructor. Best I've taken so far.

NZ

5.0Reviewed Oct 11, 2022

I​ learnt new skills on Excel, tools I did not know how to use on my own. Clear instructions, learning opportunities were given. Overall, a very pleasant learning experience.

SF

5.0Reviewed Apr 8, 2024

It's a quick and objective course for beginners or people like me who need a quick refresher. And at the end of the course you receive a certificate.

AS

5.0Reviewed Mar 16, 2024

I wish I knew before this course. Extremely satisfied with the technique and method of tutoring. Thanks Coursera and the instructor

CM

5.0Reviewed Nov 13, 2022

Very good course. Breaks down complicated ideas in a way that is easy to understand. Would recommend to anyone who wants to refresh their skills or learn how to use Excel for the first time.

VP

5.0Reviewed May 26, 2024

Such great start to learn about Microsoft Excel. This course indeed on beginner level. The instruction is clear. The audio and the instructor's English was great!

AS

5.0Reviewed Jul 26, 2023

It was great for a beginner like me. I got the hang of it with some practice and guidance. I'm excited to keep learning and improving.

UR

5.0Reviewed Jul 11, 2025

Explaination are smooth and easy to understand im just a beginner now i can understand the basic formulas functions of excal thanks.

TN

5.0Reviewed Sep 8, 2025

She speaks very clear and easily to understand. This is a basic course so I think all people can learn as well. Thank you so much!

T

5.0Reviewed May 20, 2022

T​his Guided project was Wonderful. The project was so helpful for understanding all basic formulas and functions used in Microsoft excel for calculation and analysis purpose.