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: Microsoft Excel
Status: Business Mathematics
BeginnerGuided Project2 hours

Featured reviews

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.

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.

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.

AN

4.0Reviewed Jun 8, 2023

The course is good, the material is well presented for easy follow up.However scrolling through the questions is bit problematic.Overall it is good.

CG

5.0Reviewed Jul 1, 2022

i have learned a lot things , new skills and more ways to get the job done in a short time t+hanks to this course now i am able to use excel very easy .

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.

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

AA

4.0Reviewed Mar 25, 2023

Very short - but I suppose that is a good thing. The online excel page split is really poorly implemented. I recommend getting rid of it outright. Otherwise a great beginner course!

PS

5.0Reviewed Jun 19, 2024

The way of explaining of the instructor is the best. And the instructor told us things from very basic. Beginner can learn from here very easily.

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.

CC

5.0Reviewed Nov 28, 2022

It was very informative and easy to digest. I genuinely learnt so much in a short period of time and I am ready to try out my new skills

All reviews

Showing: 20 of 430

Madonna Morris
1.0
Reviewed Dec 2, 2023
Caryn Morgan
1.0
Reviewed Nov 17, 2022
Patrick Holden
1.0
Reviewed Apr 20, 2024
Melissa Murillo
1.0
Reviewed May 20, 2024
Elizabeth Worosz
1.0
Reviewed Jan 27, 2023
Klaus Heinrich
1.0
Reviewed Jun 11, 2024
Christyn Jackson
1.0
Reviewed Jun 4, 2024
Ronald T. Sisk
1.0
Reviewed Sep 12, 2023
Arnold Jackson
1.0
Reviewed Jun 1, 2024
Tina McCoy
1.0
Reviewed Sep 15, 2022
Mikaela Hartwick
5.0
Reviewed Oct 11, 2021
Esha
3.0
Reviewed Oct 8, 2023
SIRIGIRI HEMALATHA
5.0
Reviewed Apr 22, 2022
Crystal Moore
5.0
Reviewed Nov 14, 2022
Tejas
5.0
Reviewed May 21, 2022
Amber Carter
3.0
Reviewed Jun 23, 2022
Stephon Carter
1.0
Reviewed Jan 7, 2025
Lia Carter
1.0
Reviewed Jan 17, 2023
Aarti mrunal pandit
5.0
Reviewed Sep 27, 2024
najiha zulkifli
5.0
Reviewed Oct 12, 2022