This course is part of the Everyday Excel Specialization

4.7
stars
3,028 ratings

Charlie Nuttelman

214,843 already enrolled

Offered By

Everyday Excel SpecializationUniversity of Colorado Boulder

About this Course

220,712 recent views

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

Flexible deadlines

Reset deadlines in accordance to your schedule.

Shareable Certificate

Earn a Certificate upon completion

100% online

Start instantly and learn at your own schedule.

Course 1 of 3 in the

Everyday Excel Specialization

Beginner Level

A knowledge of algebra will help for some of this course.

Approx. 23 hours to complete

English

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

Try Coursera for Business

What you will 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 will gain

Data Management
Spreadsheet
Microsoft Excel
Problem Solving
Real World

Flexible deadlines

Reset deadlines in accordance to your schedule.

Shareable Certificate

Earn a Certificate upon completion

100% online

Start instantly and learn at your own schedule.

Course 1 of 3 in the

Everyday Excel Specialization

Beginner Level

A knowledge of algebra will help for some of this course.

Approx. 23 hours to complete

English

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

Try Coursera for Business

Instructor

Instructor rating

4.84/5 (1,381 Ratings)

Charlie Nuttelman

Senior Instructor

Chemical and Biological Engineering

348,954 Learners

6 Courses

Offered by

University of Colorado Boulder

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

Learn more about Coursera for Business

Syllabus - What you will learn from this course

Content Rating95%(21,247 ratings)

Week1

Week 1

6 hours to complete

Navigating Excel

In Week 1, you will learn basic worksheet navigation, how to open and save Excel files, and all about worksheets and workbooks. You will learn the difference between cells, columns, and rows in Excel, as well as cell references. You will learn how to move around the worksheet effectively using shortcut key combinations, and you will learn how to edit the worksheet. You will also learn how to format cells, conditionally format cells, and how to change between number, text, date, currency, and other cell formatting options. There will be particular emphasis on relative vs. absolute cell addressing modes and you will learn how to name cells and cell ranges. You will be introduced to basic macro recording using VBA and you will learn how to set personal preferences in Excel. Week 1 will conclude with a required quiz and an on-computer, in-application assignment. When you successfully complete Assignment 1, you will be given a "completion code", which you can input into the Assignment 1 submission quiz to earn credit for the assignment. The Week 2 material will be released when you have successfully passed Quiz 1 and Assignment 1. Good luck!

6 hours to complete

21 videos (Total 118 min), 14 readings, 3 quizzes

21 videos

Welcome to Everyday Excel!1mWhat will I learn in the course?6mHow to Switch Sessions of the Course46sWeek 1 preview5mBasic features of Excel8mSaving and opening files1mSheets, cells, rows and columns: Part 15mSheets, cells, rows and columns: Part 27mMoving around the worksheet7mEditing the worksheet4mCell formatting and conditional formatting8mAuto Fill and Fill Series8mOPTIONAL Example: Gantt Chart7mFormats for numbers, dates, and times8mCell addressing modes8mNaming cells and cell ranges6mIntroduction to VBA macros7mExcel is smart! (Quick Analysis tool and Ideas tool)3mSetting preferences in Excel5mCustomizing Excel to English formats1mAssignment 1 preview and instructions2m

14 readings

Subscribe to "Everyday Excel VBA" YouTube Channel!2mThe power of Microsoft Excel10mThe importance of a Course Certificate and the future of higher education5mAuditing the course vs. purchasing a Course Certificate5mWhat version of Excel do you need for this course?10mFor Mac users5mIf an Assignment is not showing up for you10mHow to get help2mOpening macro-enabled workbooks10mIf the GRADE button is not showing up1mWeek 1 Excel files10mExcel shortcuts on a Mac2mAssignment 12hWeek 2 Excel files10m

3 practice exercises

Unlock quiz for Week 1 files2mQuiz 120mAssignment 1 submission

Week2

Week 2

4 hours to complete

Expression Entry and Common Excel Functions

In Week 2 you will learn about how to properly write Excel syntax. You will learn the order of operations, how to input mathematical formulas into Excel, and how to troubleshoot when things don't go as expected. You will be introduced to just a few of the thousands of built in functions in Excel. The functions that you will learn about in this module relate to summing, counting, averaging, how to round numbers and calculate remainders, random number generation, and combinations and permutations. Week 2 concludes with a quiz and an on-computer, in-application assignment. Upon successful completion of these items, the Week 3 material will be unlocked. Good luck and have fun!

4 hours to complete

12 videos (Total 70 min), 2 readings, 2 quizzes

12 videos

Week 2 preview2mExcel syntax and order of operations8mTroubleshooting Excel formulas6mIntroduction to functions in Excel8mCounting, summing, and averaging in Excel, Part 17mCounting, summing, and averaging in Excel, Part 25mRounding and remainders9mExamples: Rounding and remainders7mRandom numbers, combinations, and permutations6mThe CHOOSE function2mOPTIONAL: The CONVERT function (for engineers and scientists)2mAssignment 2 preview and instructions3m

2 readings

Assignment 22hWeek 3 Excel files10m

2 practice exercises

Quiz 220mAssignment 2 submission30m

Week3

Week 3

4 hours to complete

More Excel functions

In Week 3, you will learn more advanced functions in Excel. These include logical functions (IF, AND, OR) and advanced logical functions (SUMIF, COUNTIF, AVERAGEIF). You will learn how to effectively use Auto Fill and Fill Series but then I explain how to use text functions, which overcome some of the limitations of the Auto Fill feature. You will be introduced to Excel's financial functions (many more financial functions will be covered in Part 2 of the course), and you will learn how to use array formulas in Excel. Finally, I show how you can create your own user-defined function in VBA. Week 3 concludes with a quiz and on-computer, in-application assignment. When completed successfully, the Week 4 material will be released. Good luck!

4 hours to complete

12 videos (Total 76 min), 2 readings, 2 quizzes

12 videos

Week 3 preview2mMaking named ranges dynamic6mPreviewing compatibility with earlier versions4mIF, AND, and OR8mAdvanced logical functions in Excel10mFlash Fill: Advantages and disadvantages4mText functions in Excel, Part 18mText functions in Excel, Part 27mExcel's financial functions8mIntroduction to array formulas7mIntroduction to VBA user-defined functions4mAssignment 3 preview and instructions2m

2 readings

Assignment 32hWeek 4 Excel files10m

2 practice exercises

Quiz 320mAssignment 3 submission30m

Week4

Week 4

4 hours to complete

Managing Data

Week 4 really gets at the heart of why Excel is so great for managing data. You will learn how to apply a filter, how to create an Excel Table, and how to validate data (for example, by only allowing items in a drop-down list). You will learn how to sort data, how to clean up data prior to using, how to remove duplicates in your data, and how to consolidate data from multiple sources. Finally you will learn how to use one-way lookup functions in Excel (VLOOKUP and the INDEX/MATCH combination). Quiz 4 and the on-computer, in-application Assignment 4 will test your understanding of the material in Week 4. Once you've completed these assessments, the Week 5 material will be unlocked. Good luck and have fun!

4 hours to complete

15 videos (Total 73 min), 2 readings, 2 quizzes

15 videos

Week 4 preview1mApplying a filter6mUsing the FILTER function (Office 365)3mCreating an Excel Table6mData validation and drop-down lists9mSorting data in Excel7mThe SORT and SORTBY functions (Office 365)2mExample: Sorting by columns2mCleaning your data7mRemoving duplicates6mConsolidating data4mOne-way lookup functions, Part 14mOne-way lookup functions, Part 25mThe XLOOKUP function2mAssignment 4 preview and instructions2m

2 readings

Assignment 42hWeek 5 Excel files10m

2 practice exercises

Quiz 420mAssignment 4 submission30m

Reviews

4.7

976 reviews

5 stars
83.32%
4 stars
11.83%
3 stars
1.87%
2 stars
0.59%
1 star
2.36%

TOP REVIEWS FROM EVERYDAY EXCEL, PART 1

by JBJun 14, 2020

Pretty good course. There are some hiccups in some of the videos, as well as some of the "hints". I find it leads you down the wrong path sometimes, but other than that pretty good course.

by RSApr 17, 2021

Really good course for absolute beginners. It helps a lot to learn and practice on my own with the assignments. And the course instructor is also nice to us. Thanks for this course. Wating for Part 2.

by SWNov 16, 2022

I had such a great time learning Excel with Charlie! I have learned so much more about excel and I can use that for my job in Logistic Management Analyst! Thanks for this amazing course.

by GFApr 7, 2021

Great course!. It covers very basis tools to more complex features like vlookups function. I have learned new things and definitely very useful for the workday task. Looking forward for the Part 2.

View all reviews

About the Everyday Excel 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.

Frequently Asked Questions

When will I have access to the lectures and assignments?
Access to lectures and assignments depends on your type of enrollment. If you take a course in audit mode, you will be able to see most course materials for free. To access graded assignments and to earn a Certificate, you will need to purchase the Certificate experience, during or after your audit. If you don't see the audit option:
The course may not offer an audit option. You can try a Free Trial instead, or apply for Financial Aid.
The course may offer 'Full Course, No Certificate' instead. This option lets you see all course materials, submit required assessments, and get a final grade. This also means that you will not be able to purchase a Certificate experience.
What will I get if I subscribe to this Specialization?
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. Your electronic Certificate will be added to your Accomplishments page - from there, you can print your Certificate or add it to your LinkedIn profile. If you only want to read and view the course content, you can audit the course for free.
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.

More questions? Visit the Learner Help Center.

Build employee skills, drive business results

Discover Coursera for Business

Everyday Excel, Part 1

About this Course

What you will learn

Skills you will gain