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
Microsoft Excel
Status: Gross Profit
Gross Profit
Beginner·Guided Project·2 hours
Featured reviews
5.0
·Reviewed Sep 26, 2023
I am extremely grateful for the chance to work on this Course project as it will undoubtedly help me advance in my career. Thank you for entrusting me with this opportunity!
5.0
·Reviewed 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.
4.0
·Reviewed 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!
5.0
·Reviewed Mar 16, 2024
I wish I knew before this course. Extremely satisfied with the technique and method of tutoring. Thanks Coursera and the instructor
5.0
·Reviewed May 20, 2022
This 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.
5.0
·Reviewed 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
5.0
·Reviewed 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.
4.0
·Reviewed 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.
5.0
·Reviewed 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
5.0
·Reviewed 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.
5.0
·Reviewed Oct 13, 2023
Coursera is the best! Unlike the experiences I have had in other learning platforms, the instructor was explicit, and the sample file for self-evaluation was really helpful
5.0
·Reviewed 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!
All reviews
Showing: 20 of 442
All Learners
All Stars
Most Helpful
M
Madonna
1.0
·Reviewed Dec 2, 2023
Was not able to complete as Opening OneDrive had all files on my personal computer not the file I needed.
C
Caryn
1.0
·Reviewed Nov 17, 2022
Unable to get to and use the sample data and this is really poorly designed.
P
Patrick
1.0
·Reviewed Apr 20, 2024
The excel file needed is nowhere to be found. Terrible course!
M
Melissa
1.0
·Reviewed May 20, 2024
Unable to find the file to begin with
E
Elizabeth
1.0
·Reviewed Jan 27, 2023
This course does not work correctly.
K
Klaus
1.0
·Reviewed Jun 11, 2024
I wasn't able to access the document the instructor stated would be necessary to work with. But I was still able to memorize the info she talked about, and as a result I managed to pass the guided project. Still though, I wouldn't recommend this course.
C
Christyn
1.0
·Reviewed Jun 4, 2024
Unclear on where to find the data file.
R
Ronald
1.0
·Reviewed Sep 12, 2023
You did 5 stars worth of work, but left the student with 0 stars worth of cloud space practice time.
A
Arnold
1.0
·Reviewed Jun 1, 2024
Cannot access excel sheet with data after following instruction videos.
T
Tina
1.0
·Reviewed Sep 15, 2022
Was not able to even to create a 365 account. Unenrolled.
E
Esha
3.0
·Reviewed Oct 8, 2023
My main issue is not being able to read and see the content. In the instructional video, when a formula is being demonstrated it is at times out of frame and all you hear is the explanation, making it difficult to follow along. I couldn't increase the size of the sample document or the window itself, I really tried to stick with it but it left me struggling to see and then frustrated. Please fix this or do a new one.
M
Mikaela
5.0
·Reviewed Oct 11, 2021
Great BEGINNER project, also, very helpful for refreshing basic skills if you don't use them often.
S
SIRIGIRI
5.0
·Reviewed Apr 22, 2022
I have understand very clearly the classes which was given by the instuctor .The instructor was explaining it very clearly .So choose coursera for your future purpose.Its very useful for job purpose.Thank you
C
Crystal
5.0
·Reviewed Nov 14, 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.
T
Tejas
5.0
·Reviewed May 21, 2022
This 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.
A
Amber
3.0
·Reviewed Jun 23, 2022
The cloud Excel program was awful. Lagging and glitched. It took so long for the program to catch up with my cursor movement I ended up just finishing the project on my own Excel computer program.
S
Stephon
1.0
·Reviewed Jan 7, 2025
The file she mentions is non-accessible. I saw reviews dating back to two years ago with the same exact issues. Very irritating that this problem is still happening.
L
Lia
1.0
·Reviewed Jan 17, 2023
The screen share is very difficult to use. I'm trying to figure out how to cancel the class.
A
Aarti
5.0
·Reviewed Sep 27, 2024
overall, this course was well worth the time and effort. it not only provide valuable knowledge but also inspired me to continue exploring the depth, I'd recommend it to anyone looking to advance in this field.
N
najiha
5.0
·Reviewed Oct 12, 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.