Using Basic Formulas and Functions in Microsoft Excel
5.0 /5
- Offered byCoursera
Using Basic Formulas and Functions in Microsoft Excel at Coursera Overview
Using Basic Formulas and Functions in Microsoft Excel
at Coursera
Implement formulas and functions to automate repetitive tasks, reducing manual effort and increasing productivity
Duration | 2 hours |
Start from | Start Now |
Mode of learning | Online |
Difficulty level | Beginner |
Official Website | Go to Website |
Credential | Certificate |
Using Basic Formulas and Functions in Microsoft Excel at Coursera Highlights
Using Basic Formulas and Functions in Microsoft Excel
at Coursera
- Earn a certificate from Coursera
- Learn from industry experts
- Guided project & hands-on learning
Using Basic Formulas and Functions in Microsoft Excel at Coursera Course details
Using Basic Formulas and Functions in Microsoft Excel
at Coursera
Who should do this course?
- For individuals who have never used Excel before and want to learn the basics of creating spreadsheets, entering data, and performing simple calculations
What are the course deliverables?
- Create an account in Microsoft Office 365 and upload a file to open with Excel
- Write formulas to perform simple calculations like addition, subtraction, multiplication and division
- Use the SUM and SUMIF functions to analyze data on the sales of a sample company as well as calculate averages and percentages
More about this course
- 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
Using Basic Formulas and Functions in Microsoft Excel at Coursera Curriculum
Using Basic Formulas and Functions in Microsoft Excel
at Coursera
Upload a document using the free online version of Microsoft Office 365
Write functions in Excel to perform simple calculations like addition, subtraction, multiplication, and division
Use the SUM function and multiplication formula in Excel to perform analysis on sales data for a co
Use the SUMIF function in Excel to perform analysis on the popularity of the items sold from the company sales data
Use formulas to calculate averages and percentages in Excel to perform analysis on the monthly profits from the company sales data
Using Basic Formulas and Functions in Microsoft Excel at Coursera Entry Requirements
Using Basic Formulas and Functions in Microsoft Excel
at Coursera
Using Basic Formulas and Functions in Microsoft Excel at Coursera Admission Process
Using Basic Formulas and Functions in Microsoft Excel
at Coursera
Important Dates
May 25, 2024
Course Commencement Date
Other courses offered by Coursera
– / –
3 months
Beginner
View Other 6715 Courses
Using Basic Formulas and Functions in Microsoft Excel at Coursera Students Ratings & Reviews
Using Basic Formulas and Functions in Microsoft Excel
at Coursera
5/5
1 Rating- 4-51
S
Suchita Jambu
Using Basic Formulas and Functions in Microsoft Excel
Offered by Coursera
5
Learning Experience: By completing all the excel related course , I got the refresher of everything at my own pace . Naukri Learning have variety of courses , an individual get to learn various things and can add skills to resume. Trainers communicate concepts in simpler way . After completing assessment, instant certificate is add on .
Faculty: By completing all the excel related course , I got the refresher of everything at my own pace . Coursera is helping millions of individuals to gain in depth knowledge various topics .
Course is updated .
Reviewed on 5 Dec 2022Read More
View 1 Review
Using Basic Formulas and Functions in Microsoft Excel
at Coursera
Student Forum
Anything you would want to ask experts?
Write here...