"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.
Offered By
Everyday Excel, Part 1
University of Colorado BoulderAbout this Course
548,949 recent views
Shareable Certificate
Earn a Certificate upon completion
100% online
Start instantly and learn at your own schedule.
Flexible deadlines
Reset deadlines in accordance to your schedule.
Beginner Level
A knowledge of algebra will help for some of this course.
Approx. 24 hours to complete
English
Subtitles: French, Portuguese (Brazilian), Vietnamese, Russian, English, Spanish
Skills you will gain
Data ManagementSpreadsheetMicrosoft ExcelProblem SolvingReal World
Shareable Certificate
Earn a Certificate upon completion
100% online
Start instantly and learn at your own schedule.
Flexible deadlines
Reset deadlines in accordance to your schedule.
Beginner Level
A knowledge of algebra will help for some of this course.
Approx. 24 hours to complete
English
Subtitles: French, Portuguese (Brazilian), Vietnamese, Russian, English, Spanish
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.
Syllabus - What you will learn from this course
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
19 videos (Total 116 min), 8 readings, 3 quizzes
19 videos
What will I learn in the course?6m
Week 1 preview5m
Basic features of Excel8m
Saving and opening files1m
Sheets, cells, rows and columns: Part 15m
Sheets, cells, rows and columns: Part 27m
Moving around the worksheet7m
Editing the worksheet4m
Cell formatting and conditional formatting8m
Auto Fill and Fill Series8m
OPTIONAL Example: Gantt Chart7m
Formats for numbers, dates, and times8m
Cell addressing modes8m
Naming cells and cell ranges6m
Introduction to VBA macros7m
Excel is smart! (Quick Analysis tool and Ideas tool)3m
Setting preferences in Excel5m
Assignment 1 preview and instructions2m
8 readings
The power of Microsoft Excel10m
I can't open the assignments nor starter .xlsx files - I thought the course was free?5m
The importance of a Course Certificate and the future of higher education5m
For Mac users5m
Week 1 Excel files10m
Quiz 1 solutions and explanations10m
Assignment 12h
Week 2 Excel files10m
3 practice exercises
Unlock quiz for Week 1 files2m
Quiz 130m
Assignment 1 submission
5 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!
5 hours to complete
12 videos (Total 70 min), 3 readings, 2 quizzes
12 videos
Excel syntax and order of operations8m
Troubleshooting Excel formulas6m
Introduction to functions in Excel8m
Counting, summing, and averaging in Excel, Part 17m
Counting, summing, and averaging in Excel, Part 25m
Rounding and remainders9m
Examples: Rounding and remainders7m
Random numbers, combinations, and permutations6m
The CHOOSE function2m
OPTIONAL: The CONVERT function (for engineers and scientists)2m
Assignment 2 preview and instructions2m
3 readings
Quiz 2 solutions and explanations10m
Assignment 22h
Week 3 Excel files10m
2 practice exercises
Quiz 230m
Assignment 2 submission30m
5 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!
5 hours to complete
12 videos (Total 77 min), 3 readings, 2 quizzes
12 videos
Making named ranges dynamic6m
Previewing compatibility with earlier versions4m
IF, AND, and OR8m
Advanced logical functions in Excel10m
Flash Fill: Advantages and disadvantages4m
Text functions in Excel, Part 18m
Text functions in Excel, Part 27m
Excel's financial functions8m
Introduction to array formulas7m
Introduction to VBA user-defined functions4m
Assignment 3 preview and instructions2m
3 readings
Quiz 3 solutions and explanations10m
Assignment 32h
Week 4 Excel files10m
2 practice exercises
Quiz 330m
Assignment 3 submission30m
5 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!
5 hours to complete
15 videos (Total 73 min), 3 readings, 2 quizzes
15 videos
Applying a filter6m
Using the FILTER function (Office 365)3m
Creating an Excel Table6m
Data validation and drop-down lists9m
Sorting data in Excel7m
The SORT and SORTBY functions (Office 365)2m
Example: Sorting by columns2m
Cleaning your data7m
Removing duplicates6m
Consolidating data4m
One-way lookup functions, Part 14m
One-way lookup functions, Part 25m
The XLOOKUP function2m
Assignment 4 preview and instructions2m
3 readings
Quiz 4 solutions and explanations10m
Assignment 42h
Week 5 Excel files10m
2 practice exercises
Quiz 430m
Assignment 4 submission30m
Reviews
TOP REVIEWS FROM EVERYDAY EXCEL, PART 1
by THSep 13, 2020
I found it difficult not being to speak or ask questions to a live person, but other than that I loved learning this new information and it will be super helpful in my new position! Thank you!!
by VMAug 8, 2020
This course is very good practice for the beginner level candidate. I have learn lot of new functions practically and that would definitely help in my professional life. Thanks for this course
by GNMay 31, 2020
It 's a very nice & useful course. All content is explain well. Nice assignments to think and learn how to use the some of the basics functions. I liked it, i will take the part 2 of course.
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.
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 purchase the Certificate?
When you purchase a Certificate you get access to all course materials, including graded assignments. Upon completing the course, 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, 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. Learn more.
Will I earn university credit for completing the Course?
This Course doesn't carry university credit, but some universities may choose to accept Course Certificates for credit. Check with your institution to learn more. Online Degrees and Mastertrack™ Certificates on Coursera provide the opportunity to earn university credit.
More questions? Visit the Learner Help Center.
