"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.
Everyday Excel, Part 1
Everyday Excel, Part 1
This course is part of Everyday Excel Specialization
Instructor: Charlie Nuttelman
Access provided by PALC Dev
297,542 already enrolled
Gain insight into a topic and learn the fundamentals.
3,669 reviews
Beginner level
Recommended experience
Flexible schedule
3 weeks at 10 hours a week
Learn at your own pace
95%
Most learners liked this course
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
- Microsoft Excel
- Data Visualization Software
- Data Entry
- Pivot Tables And Charts
- Data Import/Export
- Problem Solving
- Spreadsheet Software
- Data Cleansing
- Data Validation
- Data Management
- Excel Formulas
- Skills section collapsed. Showing 10 of 11 skills.
Details to know
Shareable certificate
Add to your LinkedIn profile
Assessments
6 assignments
Taught in English
See how employees at top companies are mastering in-demand skills
Build your subject-matter expertise
This course is part of the Everyday Excel Specialization
When you enroll in this course, you'll also be enrolled in this Specialization.
- Learn new concepts from industry experts
- Gain a foundational understanding of a subject or tool
- Develop job-relevant skills with hands-on projects
- Earn a shareable career certificate
There are 6 modules in this course
In Week 1 you will learn the fundamentals of working in Excel. You’ll begin by navigating Excel, opening and saving files, and understanding how workbooks and worksheets are structured. You’ll then explore how cells, rows, and columns work together, how to move efficiently around a worksheet, and how to enter and edit data. You’ll also learn how to format cells, apply conditional formatting, and use common number formats such as text, dates, and currency. Finally, concepts like relative and absolute cell references will be emphasized, as well as naming cells and ranges to make your work more efficient and accurate.
What's included
22 videos2 readings1 assignment2 programming assignments
In Week 2, you will focus on implementing Excel formulas. You’ll learn about the order of operations, how to build mathematical formulas, and how to troubleshoot issues when results aren’t what you expect. You will be introduced to a popular selection of Excel’s built-in functions, including those used for summing, counting, averaging, rounding numbers, calculating remainders, generating random numbers, and performing logical tests.
What's included
18 videos1 assignment2 programming assignments
In Week 3 you will learn how to work with more structured and dynamic data in Excel. You will learn how to create Excel Tables and dynamic named ranges, apply data validation rules, and use advanced conditional formatting techniques.
What's included
13 videos1 assignment2 programming assignments
In Week 4 you will continue building your Excel function skills. You’ll learn how to use more advanced logical functions, including techniques for testing conditions and determining whether values appear in lists. You’ll also explore tools for working with text, including the advantages and limitations of Flash Fill and how to use text functions to clean and reshape data. In addition, you will be introduced to date and time functions and basic financial functions, enabling more complex calculations and data transformations.
What's included
12 videos1 assignment2 programming assignments
In Week 5 you will focus on managing and preparing data for analysis and reporting. You will learn techniques for cleaning data, applying filters, sorting data using multiple criteria, and identifying and removing duplicates. You will also practice consolidating data from multiple worksheets or sources and organize it in a way that supports analysis and reporting.
What's included
12 videos1 assignment2 programming assignments
In Week 6 you will learn how to visualize and share data using Excel. You’ll learn how to create different types of charts, including dynamic charts and Pivot Charts, and enhance visualizations with tools like Slicers and Sparklines. You will also learn how to share Excel content in Word and PowerPoint, print worksheets and charts, and export Excel files as PDF documents.
What's included
17 videos1 assignment
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
Instructor ratings
(1,606 ratings)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."
Learner reviews
- 5 stars
83.29%
- 4 stars
11.77%
- 3 stars
1.68%
- 2 stars
0.59%
- 1 star
2.64%
Showing 3 of 3669
I
Reviewed on May 18, 2020
Very much basic course and the instructor described Everything very nicely..Its a must for the beginne.. Had to work hard to go through the course and finally came out to be successful
SW
Reviewed on Nov 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.
BT
Reviewed on Apr 3, 2024
I learned much more than I thought I would. Weeks 3-5 were very helpful to my knowledge and skills as well as practical skills I am now using on a daily basis at work. Highly recommend this course.
Explore more from Computer Science
University of Colorado Boulder
University of Colorado Boulder