Everyday Excel, Part 1

Ends in 3 days! Save 40% on your access to 10,000+ programs and make a real impact in your career. Save now.

Everyday Excel, Part 1

This course is part of Everyday Excel Specialization

Instructor: Charlie Nuttelman

306,215 already enrolled

Included with Learn more

Ask Coursera

6 modules

Gain insight into a topic and learn the fundamentals.

Beginner level

Recommended experience

3 weeks to complete

at 10 hours a week

Flexible schedule

Learn at your own pace

6 modules

Gain insight into a topic and learn the fundamentals.

Beginner level

Recommended experience

3 weeks to complete

at 10 hours a week

Flexible schedule

Learn at your own pace

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

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 Module 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 videosTotal 142 minutes

Instructor Introduction and Welcome!2 minutes
Course Introduction5 minutes
Basic Features of Excel11 minutes
Saving and Opening Files2 minutes
Sheets, Cells, Rows and Columns: Part 18 minutes
Sheets, Cells, Rows and Columns: Part 210 minutes
Moving Around the Worksheet8 minutes
Editing the Worksheet6 minutes
Cell Formatting6 minutes
Intro to Conditional Formatting5 minutes
Formats for Numbers, Currency, Dates, and Times12 minutes
The Format Painter3 minutes
Auto Fill and Fill Series10 minutes
Cell Addressing Modes11 minutes
Cell Ranges2 minutes
Qualified References3 minutes
Naming Cells and Cell Ranges12 minutes
Excel is Smart!4 minutes
Setting Preferences and Customizing Excel9 minutes
OPTIONAL Example: Gantt Chart8 minutes
Example: Multiplication Table4 minutes
Module 2 Preview2 minutes

3 readingsTotal 13 minutes

Course Updates and Accessibility Support1 minute
Microsoft 365 is Required for This Course2 minutes
The Power of Microsoft Excel10 minutes

1 assignmentTotal 20 minutes

Module 1 Quiz20 minutes

2 programming assignmentsTotal 120 minutes

Conditional Formatting60 minutes
Mixed Cell References60 minutes

In Module 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 videosTotal 155 minutes

Excel Syntax and Order of Operations11 minutes
Troubleshooting Excel Formulas8 minutes
Introduction to Functions in Excel (Part 1)10 minutes
Introduction to Functions in Excel (Part 2)6 minutes
Counting Basics12 minutes
Totals, Averages, Highs, and Lows10 minutes
Rounding and Remainders14 minutes
Examples: Rounding and Remainders8 minutes
Nesting: Using Functions Inside Other Functions5 minutes
IF and IFS11 minutes
AND and OR7 minutes
Logical Equivalents to the AND and OR Functions8 minutes
The XLOOKUP function12 minutes
The INDEX Function7 minutes
MATCH and XMATCH12 minutes
The OFFSET Function7 minutes
Example: Leap Year7 minutes
Module 3 Preview1 minute

1 assignmentTotal 20 minutes

Module 2 Quiz20 minutes

2 programming assignmentsTotal 120 minutes

Conditional Logic and Data Summaries60 minutes
Lookup and Reference Functions60 minutes

In Module 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 videosTotal 112 minutes

Making Named Ranges Dynamic12 minutes
Excel Tables13 minutes
Structured References12 minutes
Data Validation14 minutes
Example: Data Validation to Prevent Duplicates6 minutes
Drop-Down Lists (Data Validation)6 minutes
Example: Employee Time Sheets9 minutes
Conditional Formatting Using a Formula11 minutes
Example: Conditional Formatting for Financial Reconciliation8 minutes
Checkboxes in Excel5 minutes
Example: Key Performance Indicators8 minutes
Example: Orders6 minutes
Module 4 Preview2 minutes

1 assignmentTotal 20 minutes

Module 3 Quiz20 minutes

2 programming assignmentsTotal 120 minutes

Data Validation60 minutes
Checkboxes and Conditional Formatting60 minutes

In Module 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 videosTotal 126 minutes

Advanced Logical Functions13 minutes
Determining if an Item is on a List4 minutes
Example: Credit Card Lookup11 minutes
Example: Room Reservation Sign-Up11 minutes
Flash Fill: Advantages and Disadvantages7 minutes
Text Functions in Excel (Part 1)14 minutes
Text Functions in Excel (Part 2)11 minutes
Example: Using the SEARCH Function9 minutes
The TEXT Function15 minutes
Introduction to Excel's Financial Functions12 minutes
Date and Time Functions16 minutes
Module 5 Preview1 minute

1 assignmentTotal 20 minutes

Module 4 Quiz20 minutes

2 programming assignmentsTotal 120 minutes

Conditional Aggregation60 minutes
Text Functions and Lookups60 minutes

In Module 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 videosTotal 79 minutes

The Find and Select Tool10 minutes
Applying a Filter4 minutes
Removing Blanks7 minutes
Example: Applying a Filter6 minutes
Cleaning Your Data9 minutes
Identifying Duplicates12 minutes
Removing Duplicates4 minutes
Consolidating Data5 minutes
Sorting Data10 minutes
Sorting by a List5 minutes
Example: Sorting to Remove Duplicates4 minutes
Example: Sorting by Columns3 minutes

1 assignmentTotal 20 minutes

Module 5 Quiz20 minutes

2 programming assignmentsTotal 120 minutes

Consolidating and Sorting Data60 minutes
Filtering and Custom Sorting Tasks60 minutes

In Module 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 videosTotal 148 minutes

Line Graphs11 minutes
Scatter Plots8 minutes
Column and Pie Charts10 minutes
Target Charts8 minutes
Progress Charts14 minutes
Sparklines6 minutes
For Fun: Importing Geographic Information6 minutes
Example: Phone Number Map8 minutes
Dynamic Charts14 minutes
Slicers10 minutes
Using Slicers for Dynamic Charts 6 minutes
Introduction to Pivot Tables and Pivot Charts12 minutes
Example: Slicer for Multiple Series10 minutes
Example: Using a Timeline with a Pivot Chart9 minutes
Sharing Worksheets and Charts in Word and PowerPoint9 minutes
Printing Excel Worksheets and Workbooks5 minutes
Example: Sales Invoice as PDF File4 minutes

1 assignmentTotal 30 minutes

Module 6 Quiz30 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

Charlie Nuttelman

University of Colorado Boulder

10 Courses488,343 learners

Offered by

University of Colorado Boulder

Explore more from Design and Product

Status: Free Trial
University of Colorado Boulder
Everyday Excel, Part 2
Course
Status: Free Trial
University of Colorado Boulder
Everyday Excel
Specialization
Status: Free Trial
Knowledge Accelerators
Excel Basics for Beginners: Workbooks, Formatting, Charts and Core Skills
Course
Status: Free Trial
Packt
Excel 365 Fundamentals – Getting Started and Core Skills
Course

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

Frequently asked questions

To access the course materials, assignments and to earn a Certificate, you will need to purchase the Certificate experience when you enroll in a course. 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.

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.

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.