Using Basic Formulas and Functions in Microsoft Excel
5.0 /5- Offered byCoursera
- Public/Government Institute
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 |
Mode of learning | Online |
Difficulty level | Beginner |
Official Website | Go to Website  |
Credential | Certificate |
Using Basic Formulas and Functions in Microsoft Excel
Table of contents
- Overview
- Highlights
- Course Details
- Curriculum
- Entry Requirements
- + 1 more item
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
Eligibility criteria
- Education: Graduate
Conditional Offer
- Not mentioned
Other courses offered by Coursera
– / –
3 months
Beginner
View Other 6709 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
2 Ratings- 4-51
Using Basic Formulas and Functions in Microsoft Excel
at Coursera
Student Forum
Anything you would want to ask experts?
Using Basic Formulas and Functions in Microsoft Excel at Coursera News & Updates
Using Basic Formulas and Functions in Microsoft Excel
at Coursera
Latest
Popular
