This Specialization is for learners wishing to learn Microsoft Excel from beginner level to expert level. The first two courses will teach learners the basics of Excel through the use of dozens of educational screencasts and a series of quizzes and in-application assignments. Finally, in Part 3 (Projects), learners will complete several "real world", somewhat open ended yet guided projects. In the Projects course, special emphasis is placed on dynamic array functions, which are new in Office 365 and have revolutionized the way that worksheet calculations are performed.
Everyday Excel Specialization
Discover new skills with $120 off courses from industry experts. Save now.
Everyday Excel Specialization
Learn Excel From Scratch to Expert. Starting from zero knowledge of Excel, you'll learn basic spreadsheet skills and apply them in to several exciting projects in the capstone "Projects" course.
Instructor: Charlie Nuttelman
79,254 already enrolled
Included with 
Get in-depth knowledge of a subject
(1,905 reviews)
Beginner level
Recommended experience
1 month at 10 hours a week
Flexible schedule
Earn a career credential
Share your expertise with employers
Get in-depth knowledge of a subject
(1,905 reviews)
Beginner level
Recommended experience
1 month at 10 hours a week
Flexible schedule
Earn a career credential
Share your expertise with employers
What you'll learn
In this specialization, you'll learn a variety of Excel tools, techniques, and functions, which you'll apply to real-world, "open-ended" projects.
Overview
Skills you'll gain
Tools you'll learn
What’s included
Shareable certificate
Add to your LinkedIn profile
Taught in English
40 practice exercises
Advance your subject-matter expertise
- Learn in-demand skills from university and industry experts
- Master a subject or tool with hands-on projects
- Develop a deep understanding of key concepts
- Earn a career certificate from University of Colorado Boulder
Specialization - 3 course series
What you'll learn
Navigating Excel, editing the worksheet (including inserting/deleting cells, columns, and rows), and cell formatting.
Expression entry and common Excel formulas (including logical functions, text functions, and financial functions).
Data management (sorting, filtering, consolidating, removing duplicates, data validation, and one-way lookups).
Data visualization (scatter plots, column charts, pie charts, Slicers, Sparklines, and Pivot Tables).
Skills you'll gain
Category: Microsoft Excel
Category: Excel Formulas
Category: Excel Macros
Category: Data Management
Category: Data Validation
Category: Microsoft PowerPoint
Category: Data Visualization
Category: Data Import/Export
Category: Problem Solving
Category: Microsoft Word
What you'll learn
Advanced data management techniques
How to implement financial calculations in Excel
How to use advanced tools in Excel (Data Tables, Goal Seek, and Solver) to perform and solve "what-if" analyses
How to create mathematical predictive regression models using the Regression tool in Excel
Skills you'll gain
Category: Microsoft Excel
Category: Excel Formulas
Category: Data Management
Category: Depreciation
Category: Regression Analysis
Category: Financial Analysis
Category: Cash Flows
Category: Process Optimization
Category: Financial Forecasting
Category: Statistical Modeling
Category: Complex Problem Solving
Category: Predictive Modeling
Category: Financial Modeling
Category: Problem Solving
Category: Business Mathematics
Category: Data Analysis
What you'll learn
In this course, you'll apply Excel functions and tools to solving broad, somewhat open-ended problems through a wide variety of "guided" projects.
Skills you'll gain
Category: Microsoft Excel
Category: Excel Formulas
Category: Complex Problem Solving
Category: Data Management
Category: Mathematical Modeling
Category: Data Validation
Category: Analysis
Earn a career certificate
Add this credential to your LinkedIn profile, resume, or CV. Share it on social media and in your performance review.
Instructor
Offered by
Why people choose Coursera for their career
Felipe M.
Learner since 2018
"To be able to take courses at my own pace and rhythm has been an amazing experience. I can learn whenever it fits my schedule and mood."
Jennifer J.
Learner since 2020
"I directly applied the concepts and skills I learned from my courses to an exciting new project at work."
Larry W.
Learner since 2021
"When I need courses on topics that my university doesn't offer, Coursera is one of the best places to go."
Chaitanya A.
"Learning isn't just about being better at your job: it's so much more than that. Coursera allows me to learn without limits."
Open new doors with Coursera Plus
Unlimited access to 10,000+ world-class courses, hands-on projects, and job-ready certificate programs - all included in your subscription
Advance your career with an online degree
Earn a degree from world-class universities - 100% online
Join over 3,400 global companies that choose Coursera for Business
Upskill your employees to excel in the digital economy
Frequently asked questions
The time required for this specialization will vary dramatically depending upon the amount of time that learners can devote to it each week. If you can spend 3-5 hours per week on the courses, you should be able to complete the specialization in about 10-12 weeks. The time required to complete the specialization is much less if you're able to spend a significant amount of time each week on the courses.
It is beneficial to have a basic understanding of computers and navigating around computers, but other than that you will learn Excel from "scratch to expert". A basic knowledge of math is helpful, but not a lot of time is spent on mathematical formulas.
Yes, it is recommended that you take the courses in order: Part 1, Part 2, followed by Part 3.
More questions
Financial aid available,