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.

4.7

stars

1,416 ratings

Charlie Nuttelman

47,118 already enrolled

Offered By

Everyday Excel SpecializationUniversity of Colorado Boulder

What you will 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.
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).

Skills you will gain

About this Specialization

27,482 recent views

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.

Applied Learning Project

In Part 3 (Projects), learners choose three "warm-up" projects (chosen from five potential projects), three intermediate projects (chosen from six potential projects), and three main projects (chosen from five potential projects). Thus, learners have liberty to tailor their experience through choice of projects. Screencasts are provided that show hints and previews for each project.

Shareable Certificate

Earn a Certificate upon completion

100% online courses

Start instantly and learn at your own schedule.

Coursera Labs

Includes hands on learning projects.

Learn more about Coursera Labs

Flexible Schedule

Set and maintain flexible deadlines.

Beginner Level

Approximately 4 months to complete

Suggested pace of 4 hours/week

English

Could your company benefit from training employees on in-demand skills?

Try Coursera for Business

Shareable Certificate

Earn a Certificate upon completion

100% online courses

Start instantly and learn at your own schedule.

Coursera Labs

Includes hands on learning projects.

Learn more about Coursera Labs

Flexible Schedule

Set and maintain flexible deadlines.

Beginner Level

Approximately 4 months to complete

Suggested pace of 4 hours/week

English

Could your company benefit from training employees on in-demand skills?

Try Coursera for Business

See how employees at top companies are mastering in-demand skills

Learn more about Coursera for Business

How the Specialization Works

Take Courses

A Coursera Specialization is a series of courses that helps you master a skill. To begin, enroll in the Specialization directly, or review its courses and choose the one you'd like to start with. When you subscribe to a course that is part of a Specialization, you’re automatically subscribed to the full Specialization. It’s okay to complete just one course — you can pause your learning or end your subscription at any time. Visit your learner dashboard to track your course enrollments and your progress.

Hands-on Project

Every Specialization includes a hands-on project. You'll need to successfully finish the project(s) to complete the Specialization and earn your certificate. If the Specialization includes a separate course for the hands-on project, you'll need to finish each of the other courses before you can start it.

Earn a Certificate

When you finish every course and complete the hands-on project, you'll earn a Certificate that you can share with prospective employers and your professional network.

There are 3 Courses in this Specialization

Course1

Course 1

Everyday Excel, Part 1

4.7

stars

3,039 ratings

"Everyday Excel, Part 1" is aimed at learners who are seeking to learn Excel from the ground up. No experience with Excel is necessary. While this course is meant for beginners of Excel, advanced users will undoubtedly pick up new skills and tools.

This course is the first part of a three-part series and Specialization that focuses on teaching introductory through very advanced techniques and tools in Excel. In this course (Part 1), you will: 1) learn how to effectively navigate around the Excel environment; 2) edit and format Excel worksheets; 3) implement basic to advanced Excel functions (including financial, logical, and text functions); 4) learn how to manage data sets (filter, remove duplicates, consolidate data, sort data, and validate data); and 5) learn how to effectively visualize data through scatterplots, column charts, and pie charts. New to Excel? That is entirely fine! This course is meant to be fun, thought-provoking, and appeal to a wide audience. No prior knowledge in programming nor advanced math skills are necessary. The course is organized into 5 Weeks (modules). To pass each module, you'll need to pass a mastery quiz and complete a problem solving assignment. This course is unique in that the weekly assignments are completed in-application (i.e., on your own computer in Excel), providing you with valuable hands-on training.

Course2

Course 2

Everyday Excel, Part 2

4.8

stars

483 ratings

"Everyday Excel, Part 2" is a continuation of the popular "Everyday Excel, Part 1". Building on concepts learned in the first course, you will continue to expand your knowledge of applications in Excel. This course is aimed at intermediate users, but even advanced users will pick up new skills and tools in Excel. By the end of this course, you will have the skills and tools to take on the project-based "Everyday Excel, Part 3 (Projects)".

This course is the second part of a three-part series and Specialization that focuses on teaching introductory through very advanced techniques and tools in Excel. In this course (Part 2), you will: 1) learn advanced data management techniques; 2) learn how to implement financial calculations in Excel; 3) use advanced tools in Excel (Data Tables, Goal Seek, and Solver) to perform and solve "what-if" analyses; 4) learn how to create mathematical predictive regression models using the Regression tool in Excel. This course is meant to be fun and thought-provoking. I hope for you to at least several times in the course say to yourself, "Wow, I hadn't thought of that before!" Given the wide range in experience and abilities of learners, the goal of the course is to appeal to a wide audience. The course is organized into 5 Weeks (modules). To pass each module, you'll need to pass a mastery quiz and complete a problem solving assignment. This course is unique in that the weekly assignments are completed in-application (i.e., on your own computer in Excel), providing you with valuable hands-on training.

Course3

Course 3

Everyday Excel, Part 3 (Projects)

4.7

stars

229 ratings

"Everyday Excel, Part 3 (Projects)" is a continuation of "Everyday Excel, Parts 1 and 2". It is a capstone, projects-based course in which you will apply what you've learned previously to more complex, somewhat open-ended projects (open-ended with respect to the fact that they can be solved in multiple ways).

Each learner must complete 3"warm-up" projects (chosen from 3), 3 intermediate projects (chosen from 6), and 3 main (more difficult) projects (chosen from 5). The projects have been created to span a wide range of interests and topic areas and are anticipated to appeal to diverse learner backgrounds. It is hoped that this project-based courses will dramatically reinforce the application of Excel tools, techniques, and functions to real-world projects.

Instructor

Charlie Nuttelman

Senior Instructor

Chemical and Biological Engineering

350,837 Learners

6 Courses

Offered by

University of Colorado Boulder

Frequently Asked Questions

What is the refund policy?
If you subscribed, you get a 7-day free trial during which you can cancel at no penalty. After that, we don’t give refunds, but you can cancel your subscription at any time. See our full refund policy.
Can I just enroll in a single course?
Yes! To get started, click the course card that interests you and enroll. You can enroll and complete the course to earn a shareable certificate, or you can audit it to view the course materials for free. When you subscribe to a course that is part of a Specialization, you’re automatically subscribed to the full Specialization. Visit your learner dashboard to track your progress.
Is financial aid available?
Yes. In select learning programs, you can apply for financial aid or a scholarship if you can’t afford the enrollment fee. If fin aid or scholarship is available for your learning program selection, you’ll find a link to apply on the description page.
Can I take the course for free?
When you enroll in the course, you get access to all of the courses in the Specialization, and you earn a certificate when you complete the work. If you only want to read and view the course content, you can audit the course for free. If you cannot afford the fee, you can apply for financial aid.
Is this course really 100% online? Do I need to attend any classes in person?
This course is completely online, so there’s no need to show up to a classroom in person. You can access your lectures, readings and assignments anytime and anywhere via the web or your mobile device.
How long does it take to complete the Specialization?
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.
What background knowledge is necessary?
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.
Do I need to take the courses in a specific order?
Yes, it is recommended that you take the courses in order: Part 1, Part 2, followed by Part 3.
Will I earn university credit for completing the Specialization?
It depends upon university, but most likely not (at least until things change with course credit, etc., which is in the near future!).
What will I be able to do upon completing the Specialization?
Upon completing this specialization, you'll be able to perform a wide variety of techniques in Excel and utilize many functions and tools that are built into Excel. You'll be able to manage large data sets and sort, filter, and search through the data for items of interest. Many learners have received job promotions and/or new careers as a result of completing courses in the specialization.

More questions? Visit the Learner Help Center.

Build employee skills, drive business results

Discover Coursera for Business

Everyday Excel Specialization

What you will learn

Skills you will gain

About this Specialization

Applied Learning Project