Everyday Excel, Part 1 from Coursera

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

What's inside

Syllabus

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!

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!

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!

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!

Plotting, Importing Data, and Converting to Other File Types

Week 5 is all about data visualization. You will learn the differences between and how to use scatter plots, column charts, and pie charts. You will be introduced to Pivot Tables, Slicers, and Sparklines, which all represent different and exciting ways to visualize your data. I will show you how to share data (embed vs. linking) with Word and PowerPoint as well as how to print your worksheets and how to convert them to .pdf documents. Like the other modules, Week 5 concludes with a quiz and an on-computer, in-application assignment. When you've completed those assessments, you will earn the Course Certificate! Good luck!

Good to know

Know what's good

, what to watch for

, and possible dealbreakers

Develops intermediate to advanced Excel skills that are sought after in many different industries

Strong fit for beginners who have no prior Excel knowledge

Hands-on Excel assignments allow learners to practice skills in context

Taught by expert in Excel skills, Charles Nuttelman

Part of a specialization that offers a comprehensive study of Excel

Reviews summary

Everyday excel: part 1 essentials

learners say they acquired a broad range of Excel skills including handling large amounts of data, using formulas, creating charts, and presenting information in readable ways.

The course was too good.

"The course was too good."

He explained the material very clearly.

"He explained the material very clearly."

The most important part is the Assignment. He will make you understand the concept and without understanding we can't do the assignment.

"The most important part is the Assignment. He will make you understand the concept and without understanding we can't do the assignment."

I was zero in Excel before starting this course, but now I feel like I am an Excel expert.

"I was zero in Excel before starting this course, but now I feel like I am an Excel expert."

Every screencast and especially the assignments thrilling because its application oriented....no guess work.

"Every screencast and specially the assignments thrilling because its application oriented....no guess work."

Activities

Be better prepared before your course. Deepen your understanding during and after it. Supplement your coursework and achieve mastery of the topics covered in Everyday Excel, Part 1 with these activities:

Review basic spreadsheet concepts and terminology

Show steps

Ensures a solid understanding of fundamental spreadsheet concepts and terminology, providing a strong foundation for advanced Excel techniques.

Browse courses on Spreadsheet Basics

Show steps

Recall the components of a spreadsheet, such as cells, rows, and columns
Review common spreadsheet terminology, including formulas, functions, and charts
Understand the basics of data entry and formatting in spreadsheets

Review Basic Math

Show steps

Brush up on basic math skills to prepare for the course's quantitative aspects.

Show steps

Review the order of operations, exponents, and fractions.
Practice solving simple equations and inequalities.
Review basic geometry concepts, such as area and volume.

Review prior spreadsheet experience and knowledge

Show steps

Refreshes your prior experience and knowledge in spreadsheets, ensuring a stronger foundation for learning advanced Excel techniques in this course.

Browse courses on Excel

Show steps

Recall the basics of creating and editing spreadsheets
Review different spreadsheet functions and formulas
Examine examples of data analysis and visualization in spreadsheets

Five other activities

Expand to see all activities and additional details

Show all eight activities

Organize and review course materials regularly

Show steps

Promotes effective learning by encouraging regular review and organization of course materials, enhancing retention and understanding.

Browse courses on Study Strategies

Show steps

Create a system for organizing notes, assignments, and other course materials
Review materials regularly to reinforce concepts and identify areas for improvement
Summarize key points and concepts from the materials

Explore Excel tutorials and online resources

Show steps

Provides additional support and guidance by directing you to valuable Excel tutorials and online resources, enhancing your learning experience.

Show steps

Search for Excel tutorials covering specific topics or skills
Explore online forums and communities for Excel users
Utilize interactive Excel simulations and exercises

Complete Excel practice problems

Show steps

Provides hands-on practice in applying Excel functions, manipulating data, and using formulas, solidifying your understanding of core Excel concepts.

Browse courses on Excel Functions

Show steps

Solve practice problems involving basic Excel functions
Manipulate data using Excel's built-in tools
Create and apply custom Excel formulas

Start using Excel regularly for personal or professional tasks

Show steps

Encourages consistent practice and application of Excel skills, reinforcing your learning and improving your proficiency.

Show steps

Identify tasks in your personal or professional life where Excel can be useful
Create spreadsheets to manage tasks, track data, or perform calculations
Experiment with different Excel features and functions to solve problems

Develop an Excel project to showcase your skills

Show steps

Challenges you to apply your Excel knowledge and skills to a practical project, fostering deeper understanding and problem-solving abilities.

Browse courses on Data Visualization

Show steps

Identify a real-world problem or scenario that can be solved using Excel
Design and develop an Excel solution to address the problem
Create visualizations and reports to present your findings

Career center

Learners who complete Everyday Excel, Part 1 will develop knowledge and skills that may be useful to these careers:

Data Analyst

Data Analysts interpret large datasets, such as those that may be stored on an Excel spreadsheet, to find patterns and create reports that help make better decisions. This course provides the technical foundation for using the spreadsheet software Excel to analyze data, including how to perform calculations, build visualizations, and manage and clean datasets.

See salaries and explore the career path for Data Analyst

Financial Analyst

Financial Analysts use Excel to perform financial modeling and analysis. This course can help equip aspiring Financial Analysts with the skills they need to succeed in this role, including how to use Excel functions for financial calculations, create charts and graphs to present financial data, and manage and analyze large datasets.

See salaries and explore the career path for Financial Analyst

Market Researcher

Market Researchers use Excel to collect, analyze, and interpret data about markets and customers. This course can help aspiring Market Researchers develop the skills they need to succeed in this role, including how to use Excel functions to perform statistical analysis, create charts and graphs to present data, and manage and analyze large datasets.

See salaries and explore the career path for Market Researcher

Operations Analyst

Operations Analysts use Excel to analyze business processes and identify areas for improvement. This course can help aspiring Operations Analysts develop the skills they need to succeed in this role, including how to use Excel functions to perform data analysis, create charts and graphs to present data, and manage and analyze large datasets.

See salaries and explore the career path for Operations Analyst

Auditor

Auditors use Excel to examine financial records and ensure that they are accurate and compliant with regulations. This course can help aspiring Auditors develop the skills they need to succeed in this role, including how to use Excel functions to perform financial analysis, create charts and graphs to present data, and manage and analyze large datasets.

See salaries and explore the career path for Auditor

Business Analyst

Business Analysts use Excel to analyze business processes and identify areas for improvement. This course can help aspiring Business Analysts develop the skills they need to succeed in this role, including how to use Excel functions to perform data analysis, create charts and graphs to present data, and manage and analyze large datasets.

See salaries and explore the career path for Business Analyst

Project Manager

Project Managers use Excel to plan, track, and manage projects. This course can help aspiring Project Managers develop the skills they need to succeed in this role, including how to use Excel functions to create project plans, track progress, and manage budgets.

See salaries and explore the career path for Project Manager

Consultant

Consultants use Excel to analyze data and make recommendations to clients. This course can help aspiring Consultants develop the skills they need to succeed in this role, including how to use Excel functions to perform data analysis, create charts and graphs to present data, and manage and analyze large datasets.

See salaries and explore the career path for Consultant

Data Scientist

Data Scientists use Excel to analyze data and build machine learning models. This course can help aspiring Data Scientists develop the skills they need to succeed in this role, including how to use Excel functions to perform data analysis, create charts and graphs to present data, and manage and analyze large datasets.

See salaries and explore the career path for Data Scientist

Software Engineer

Software Engineers use Excel to manage project data and track progress. This course can help aspiring Software Engineers develop the skills they need to succeed in this role, including how to use Excel functions to create project plans, track progress, and manage budgets.

See salaries and explore the career path for Software Engineer

Product Manager

Product Managers use Excel to track product development and manage budgets. This course can help aspiring Product Managers develop the skills they need to succeed in this role, including how to use Excel functions to create product roadmaps, track progress, and manage budgets.

See salaries and explore the career path for Product Manager

Marketing Manager

Marketing Managers use Excel to track campaign performance and manage budgets. This course can help aspiring Marketing Managers develop the skills they need to succeed in this role, including how to use Excel functions to create marketing plans, track progress, and manage budgets.

See salaries and explore the career path for Marketing Manager

Sales Manager

Sales Managers use Excel to track sales performance and manage budgets. This course can help aspiring Sales Managers develop the skills they need to succeed in this role, including how to use Excel functions to create sales plans, track progress, and manage budgets.

See salaries and explore the career path for Sales Manager

Customer Service Manager

Customer Service Managers use Excel to track customer interactions and manage budgets. This course can help aspiring Customer Service Managers develop the skills they need to succeed in this role, including how to use Excel functions to create customer service plans, track progress, and manage budgets.

See salaries and explore the career path for Customer Service Manager

Human Resources Manager

Human Resources Managers use Excel to track employee data and manage budgets. This course can help aspiring Human Resources Managers develop the skills they need to succeed in this role, including how to use Excel functions to create employee records, track employee performance, and manage budgets.

See salaries and explore the career path for Human Resources Manager