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.9

stars

1,532 ratings

Charlie Nuttelman

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

SpreadsheetMicrosoft ExcelProblem SolvingProjectcomputingData ManagementReal WorldReal-world projects

About this Specialization

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.

Flexible Schedule

Set and maintain flexible deadlines.

Beginner Level

While helpful, no previous background nor experience with Excel is an absolute necessity to undertake this specialization.

Approximately 4 months to complete

Suggested pace of 4 hours/week

English

Subtitles: English, Arabic, French, Portuguese (European), Chinese (Simplified), Italian, Vietnamese, Korean, German, Russian, Turkish, Spanish

Shareable Certificate

Earn a Certificate upon completion

100% online courses

Start instantly and learn at your own schedule.

Flexible Schedule

Set and maintain flexible deadlines.

Beginner Level

While helpful, no previous background nor experience with Excel is an absolute necessity to undertake this specialization.

Approximately 4 months to complete

Suggested pace of 4 hours/week

English

Subtitles: English, Arabic, French, Portuguese (European), Chinese (Simplified), Italian, Vietnamese, Korean, German, Russian, Turkish, Spanish

There are 3 Courses in this Specialization

Course1

Course 1

Everyday Excel, Part 1

4.8

stars

1,368 ratings

•

494 reviews

"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.9

stars

161 ratings

•

64 reviews

"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)

"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

212,641 Learners

6 Courses

Offered by

University of Colorado Boulder

CU-Boulder is a dynamic community of scholars and learners on one of the most spectacular college campuses in the country. As one of 34 U.S. public institutions in the prestigious Association of American Universities (AAU), we have a proud tradition of academic excellence, with five Nobel laureates and more than 50 members of prestigious academic academies.

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, Coursera provides financial aid to learners who cannot afford the fee. Apply for it by clicking on the Financial Aid link beneath the "Enroll" button on the left. You'll be prompted to complete an application and will be notified if you are approved. You'll need to complete this step for each course in the Specialization, including the Capstone Project. Learn more.
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.