Everyday Excel, Part 1

Everyday Excel, Part 1

This course is part of Everyday Excel Specialization

Instructor: Charlie Nuttelman

Access provided by Pak Portal 25

298,989 already enrolled

6 modules

Gain insight into a topic and learn the fundamentals.

3,675 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

6 modules

Gain insight into a topic and learn the fundamentals.

3,675 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

Tools you'll learn

Microsoft Excel

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

Learn more about Coursera for Business

logos of Petrobras, TATA, Danone, Capgemini, P&G and L'Oreal

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

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

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 videos3 readings1 assignment2 programming assignments

22 videos Total 142 minutes

Instructor Introduction and Welcome! 2 minutes
Course Introduction 5 minutes
Basic Features of Excel 11 minutes
Saving and Opening Files 2 minutes
Sheets, Cells, Rows and Columns: Part 1 8 minutes
Sheets, Cells, Rows and Columns: Part 2 10 minutes
Moving Around the Worksheet 8 minutes
Editing the Worksheet 6 minutes
Cell Formatting 6 minutes
Intro to Conditional Formatting 5 minutes
Formats for Numbers, Currency, Dates, and Times 12 minutes
The Format Painter 3 minutes
Auto Fill and Fill Series 10 minutes
Cell Addressing Modes 11 minutes
Cell Ranges 2 minutes
Qualified References 3 minutes
Naming Cells and Cell Ranges 12 minutes
Excel is Smart! 4 minutes
Setting Preferences and Customizing Excel 9 minutes
OPTIONAL Example: Gantt Chart 8 minutes
Example: Multiplication Table 4 minutes
Module 2 Preview 2 minutes

3 readings Total 13 minutes

Course Updates and Accessibility Support 1 minute
Microsoft 365 is Required for This Course 2 minutes
The Power of Microsoft Excel 10 minutes

1 assignment Total 20 minutes

Module 1 Quiz 20 minutes

2 programming assignments Total 120 minutes

Conditional Formatting 60 minutes
Mixed Cell References 60 minutes

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, and performing logical tests.

What's included

18 videos1 assignment2 programming assignments

18 videos Total 155 minutes

Excel Syntax and Order of Operations 11 minutes
Troubleshooting Excel Formulas 8 minutes
Introduction to Functions in Excel (Part 1) 10 minutes
Introduction to Functions in Excel (Part 2) 6 minutes
Counting Basics 12 minutes
Totals, Averages, Highs, and Lows 10 minutes
Rounding and Remainders 14 minutes
Examples: Rounding and Remainders 8 minutes
Nesting: Using Functions Inside Other Functions 5 minutes
IF and IFS 11 minutes
AND and OR 7 minutes
Logical Equivalents to the AND and OR Functions 8 minutes
The XLOOKUP function 12 minutes
The INDEX Function 7 minutes
MATCH and XMATCH 12 minutes
The OFFSET Function 7 minutes
Example: Leap Year 7 minutes
Module 3 Preview 1 minute

1 assignment Total 20 minutes

Module 2 Quiz 20 minutes

2 programming assignments Total 120 minutes

Conditional Logic and Data Summaries 60 minutes
Lookup and Reference Functions 60 minutes

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

13 videos Total 112 minutes

Making Named Ranges Dynamic 12 minutes
Excel Tables 13 minutes
Structured References 12 minutes
Data Validation 14 minutes
Example: Data Validation to Prevent Duplicates 6 minutes
Drop-Down Lists (Data Validation) 6 minutes
Example: Employee Time Sheets 9 minutes
Conditional Formatting Using a Formula 11 minutes
Example: Conditional Formatting for Financial Reconciliation 8 minutes
Checkboxes in Excel 5 minutes
Example: Key Performance Indicators 8 minutes
Example: Orders 6 minutes
Module 4 Preview 2 minutes

1 assignment Total 20 minutes

Module 3 Quiz 20 minutes

2 programming assignments Total 120 minutes

Data Validation 60 minutes
Checkboxes and Conditional Formatting 60 minutes

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

12 videos Total 126 minutes

Advanced Logical Functions 13 minutes
Determining if an Item is on a List 4 minutes
Example: Credit Card Lookup 11 minutes
Example: Room Reservation Sign-Up 11 minutes
Flash Fill: Advantages and Disadvantages 7 minutes
Text Functions in Excel (Part 1) 14 minutes
Text Functions in Excel (Part 2) 11 minutes
Example: Using the SEARCH Function 9 minutes
The TEXT Function 15 minutes
Introduction to Excel's Financial Function 12 minutes
Date and Time Functions 16 minutes
Module 5 Preview 1 minute

1 assignment Total 20 minutes

Module 4 Quiz 20 minutes

2 programming assignments Total 120 minutes

Conditional Aggregation 60 minutes
Text Functions and Lookups 60 minutes

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

12 videos Total 79 minutes

The Find and Select Tool 10 minutes
Applying a Filter 4 minutes
Removing Blanks 7 minutes
Example: Applying a Filter 6 minutes
Cleaning Your Data 9 minutes
Identifying Duplicates 12 minutes
Removing Duplicates 4 minutes
Consolidating Data 5 minutes
Sorting Data 10 minutes
Sorting by a List 5 minutes
Example: Sorting to Remove Duplicates 4 minutes
Example: Sorting by Columns 3 minutes

1 assignment Total 20 minutes

Module 5 Quiz 20 minutes

2 programming assignments Total 120 minutes

Consolidating and Sorting Data 60 minutes
Filtering and Custom Sorting Tasks 60 minutes

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

17 videos Total 148 minutes

Line Graphs 11 minutes
Scatter Plots 8 minutes
Column and Pie Charts 10 minutes
Target Charts 8 minutes
Progress Charts 14 minutes
Sparklines 6 minutes
For Fun: Importing Geographic Information 6 minutes
Example: Phone Number Map 8 minutes
Dynamic Charts 14 minutes
Slicers 10 minutes
Using Slicers for Dynamic Charts 6 minutes
Introduction to Pivot Tables and Pivot Charts 12 minutes
Example: Slicer for Multiple Series 10 minutes
Example: Using a Timeline with a Pivot Chart 9 minutes
Sharing Worksheets and Charts in Word and PowerPoint 9 minutes
Printing Excel Worksheets and Workbooks 5 minutes
Example: Sales Invoice as PDF file 4 minutes

1 assignment Total 30 minutes

Module 6 Quiz 30 minutes

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,609 ratings)

Charlie Nuttelman

University of Colorado Boulder

10 Courses 478,005 learners

Offered by

University of Colorado Boulder

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.31%
4 stars
11.75%
3 stars
1.68%
2 stars
0.59%
1 star
2.63%

Showing 3 of 3675

Reviewed on Jul 14, 2022

This course has made me change the way i use MS Excel. It is broad and indepth but easy to follow along. the modules are well organised and advacement to more complex aspects was gradual. thank you

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

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.

View more reviews