We may earn an affiliate commission when you visit our partners.

Excel for Beginners

Advanced Functions

Edward Falzon

This 1-hour, project-based course introduces learners to more-advanced spreadsheet functions. We’ll be using Excel on the Web in this project, which is the free spreadsheet program offered by Microsoft. However, all of the concepts that you will learn in this project will be applicable to other spreadsheet programs, such as LibreOffice Calc and Google Sheets.

We will cover the following concepts in a hands-on manner:

- Advanced conditional functions: countif, sumif, averageif

- Easy searching and matching of data with reference functions: vlookup, xlookup, index & match

We will cover the following concepts in a hands-on manner:

- Advanced conditional functions: countif, sumif, averageif

- Easy searching and matching of data with reference functions: vlookup, xlookup, index & match

Please Note: If you don't have a free Microsoft account, you will need to create one to be able to complete the content.

Enroll now

Or subscribe to Coursera Plus

And get unlimited access to Coursera

Here's a deal for you

Save money when you learn with a deal that may be relevant to this course.

All coupon codes, vouchers, and discounts are applied automatically unless otherwise noted.

Valid until August 30

Google AI App Builder

Learn how to use Gemini API and API Studio with a three-course series from Google DeepMind

What's inside

Syllabus

Traffic lights

Read about what's good

what should give you pause

and possible dealbreakers

Teaches advanced spreadsheet functions and techniques that are common across various programs

Suitable for beginners and intermediate learners who want to enhance their spreadsheet skills

Provides hands-on exercises and uses Excel on the Web, a free program

Save this course

Create your own learning path. Save this course to your list so you can find it easily later.

Save

Reviews summary

Practical excel advanced functions course

According to learners, this course is a highly practical and concise introduction to advanced Excel functions like `VLOOKUP`, `XLOOKUP`, and `INDEX & MATCH`. Students frequently highlight the instructor's clear explanations and the effective project-based format as significant strengths, making complex concepts easy to grasp. While the course is efficient and well-structured, ideal for busy professionals or those seeking a quick skill brush-up, some reviewers noted that the pace can be fast and it may assume some prior basic Excel knowledge despite the "Beginners" title, potentially making it less suitable for true Excel novices. Overall, it provides a solid foundation for applying these functions in real-world scenarios.

Short duration makes it ideal for quick learning and busy schedules.

"The short duration (1 hour) is a double-edged sword: great for a quick overview, but not enough for deep mastery."

"Perfect for busy professionals. The fact it's web-based Excel also helped me get started quickly..."

"It's a short course, but packed with value. Perfect for a quick refresher or learning new tricks."

"Very efficient and well-structured. It's a quick way to get familiar with complex functions."

Provides solid instruction on crucial advanced Excel functions.

"The instructor explains VLOOKUP and XLOOKUP so clearly..."

"COUNTIF and SUMIF were well explained."

"I finally understand INDEX MATCH after struggling with it for ages."

"VLOOKUP and XLOOKUP were presented very well."

Teaches functions directly applicable to work and daily tasks.

"This course was exactly what I needed to brush up on my Excel skills for work."

"Highly recommend for anyone looking to apply these functions in a practical setting."

"As a hobbyist tracking my budget, these functions are super useful."

"As a data analyst, I found the explanations for INDEX MATCH particularly insightful."

Hands-on, project-based format enhances practical application.

"The project-based approach is great for hands-on learning."

"The practical demo really helped solidify my understanding."

"I really appreciated the hands-on project and the instructor's clear instructions."

"I liked the project-based format for quickly getting familiar with complex functions."

Instructor provides highly clear and effective explanations.

"The instructor explains VLOOKUP and XLOOKUP so clearly, even though I've used them before, I learned new nuances."

"Excellent concise course. I finally understand INDEX MATCH after struggling with it for ages."

"Fantastic intro to advanced Excel. I really appreciated the hands-on project and the instructor's clear instructions."

"The instructor's voice is clear and the examples are relevant."

Could benefit from more diverse real-world examples and practice.

"I wish it covered more real-world examples beyond the simple dataset used."

"The project was good, but more practice problems would be beneficial."

Pace may be too fast and assumes prior Excel knowledge for true beginners.

"The course is okay, but it assumes a bit too much prior Excel knowledge for someone truly at a 'beginner' level..."

"I struggled to keep up at times. It's more 'intermediate advanced functions' than 'beginners'."

"I was looking for a course to teach me advanced Excel from scratch, but this assumes you know basics. The 'beginners' in the title is misleading."

"The course was okay, but the pace was too fast for me. I felt like it was rushing through concepts..."

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 Excel for Beginners: Advanced Functions with these activities:

Review syntax & language fundamentals

Show steps

Review spreadsheet basics will help in more advanced spreadsheet functions

Browse courses on Spreadsheets

Show steps

Identify the basic functions in a spreadsheet software
Practice using these functions in a spreadsheet

Complete hands-on examples of the functions

Show steps

Practice is essential to master the functions and their applications in different scenarios.

Browse courses on Functions

Show steps

Follow the provided examples in the course
Create your own examples to test your understanding

Find tutorials & resources on the functions

Show steps

Additional resources provide diverse perspectives and reinforce the concepts.

Browse courses on Functions

Show steps

Search for tutorials related to spreadsheet functions
Review the tutorials to supplement your understanding

Five other activities

Expand to see all activities and additional details

Show all eight activities

Discuss the functions with peers

Show steps

Peer discussions offer fresh perspectives and strengthen understanding.

Browse courses on Functions

Show steps

Find a study group or online forum
Engage in discussions about the functions

Create a cheat-sheet summarizing the functions

Show steps

Creating a personal reference aids in memorization and quick recall.

Browse courses on Functions

Show steps

List down the functions covered in the course
Summarize each function's purpose and syntax

Participate in spreadsheet challenges

Show steps

Challenges test your skills and encourage practical application.

Browse courses on Functions

Show steps

Find online spreadsheet challenges or competitions
Practice and develop strategies to solve the challenges
Participate in the challenges to test your abilities

Build a project using the functions

Show steps

Practical application solidifies knowledge and enhances problem-solving abilities.

Browse courses on Functions

Show steps

Identify a problem or task that can benefit from spreadsheet functions
Design and build a spreadsheet model using the functions
Test and refine the model to ensure its accuracy and efficiency

Help other students with the functions

Show steps

Mentoring reinforces knowledge and deepens understanding through explanation.

Browse courses on Functions

Show steps

Identify opportunities to assist other students with the functions
Provide guidance and support to help them grasp the concepts

Career center

Learners who complete Excel for Beginners: Advanced Functions will develop knowledge and skills that may be useful to these careers:

Data Analyst

Data Analysts scour data to extract valuable insights, use statistical and mathematical methods, and create reports that lead to effective business decisions. Taking this course on advanced Excel functions may be useful for improving your ability to prepare and analyze data. Functions like COUNTIF, SUMIF, and AVERAGEIF can be helpful for summarizing and filtering data, while VLOOKUP, XLOOKUP, INDEX, and MATCH can be used to find and retrieve specific data points.

See salaries and explore the career path for Data Analyst

Financial Analyst

Financial Analysts help companies make better financial decisions. They analyze financial data, create financial models, and make recommendations on investments. This course on advanced Excel functions may be useful for improving your ability to work with financial data. Understanding how to use functions like COUNTIF, SUMIF, and AVERAGEIF can help you analyze financial data more efficiently, while VLOOKUP and XLOOKUP can be used to retrieve specific financial data points.

See salaries and explore the career path for Financial Analyst

Business Analyst

Business Analysts help organizations improve their performance by analyzing business processes and identifying inefficiencies. They create reports and make recommendations that lead to improved decision-making. This course on advanced Excel functions may be useful for improving your ability to prepare and analyze data. Functions like COUNTIF, SUMIF, and AVERAGEIF can be helpful for summarizing and filtering data, while VLOOKUP, XLOOKUP, INDEX, and MATCH can be used to find and retrieve specific data points.

See salaries and explore the career path for Business Analyst

Operations Analyst

Operations Analysts help organizations improve their operational efficiency by analyzing processes and identifying inefficiencies. They create reports and make recommendations that lead to improved decision-making. This course on advanced Excel functions may be useful for improving your ability to prepare and analyze data. Functions like COUNTIF, SUMIF, and AVERAGEIF can be helpful for summarizing and filtering data, while VLOOKUP, XLOOKUP, INDEX, and MATCH can be used to find and retrieve specific data points.

See salaries and explore the career path for Operations Analyst

Management Consultant

Management Consultants help organizations improve their performance by analyzing business processes and identifying inefficiencies. They create reports and make recommendations that lead to improved decision-making. This course on advanced Excel functions may be useful for improving your ability to prepare and analyze data. Functions like COUNTIF, SUMIF, and AVERAGEIF can be helpful for summarizing and filtering data, while VLOOKUP, XLOOKUP, INDEX, and MATCH can be used to find and retrieve specific data points.

See salaries and explore the career path for Management Consultant

Auditor

Auditors examine financial records to ensure accuracy and compliance with regulations. They prepare reports and make recommendations that lead to improved financial performance. This course on advanced Excel functions may be useful for improving your ability to work with financial data. Understanding how to use functions like COUNTIF, SUMIF, and AVERAGEIF can help you analyze financial data more efficiently, while VLOOKUP and XLOOKUP can be used to retrieve specific financial data points.

See salaries and explore the career path for Auditor

Tax Accountant

Tax Accountants prepare tax returns and advise clients on tax laws and regulations. They ensure that clients are in compliance with tax laws and that they are paying the correct amount of taxes. This course on advanced Excel functions may be useful for improving your ability to work with financial data. Understanding how to use functions like COUNTIF, SUMIF, and AVERAGEIF can help you analyze financial data more efficiently, while VLOOKUP and XLOOKUP can be used to retrieve specific financial data points.

See salaries and explore the career path for Tax Accountant

Budget Analyst

Budget Analysts help organizations plan and manage their budgets. They create budgets, track expenses, and make recommendations that lead to improved financial performance. This course on advanced Excel functions may be useful for improving your ability to work with financial data. Understanding how to use functions like COUNTIF, SUMIF, and AVERAGEIF can help you analyze financial data more efficiently, while VLOOKUP and XLOOKUP can be used to retrieve specific financial data points.

See salaries and explore the career path for Budget Analyst

Financial Planner

Financial Planners help individuals and families plan for their financial future. They create financial plans, advise clients on investments, and make recommendations that lead to improved financial well-being. This course on advanced Excel functions may be useful for improving your ability to work with financial data. Understanding how to use functions like COUNTIF, SUMIF, and AVERAGEIF can help you analyze financial data more efficiently, while VLOOKUP and XLOOKUP can be used to retrieve specific financial data points.

See salaries and explore the career path for Financial Planner

Investment Analyst

Investment Analysts evaluate investment opportunities and make recommendations to clients. They conduct research, analyze financial data, and create reports that help clients make informed investment decisions. This course on advanced Excel functions may be useful for improving your ability to work with financial data. Understanding how to use functions like COUNTIF, SUMIF, and AVERAGEIF can help you analyze financial data more efficiently, while VLOOKUP and XLOOKUP can be used to retrieve specific financial data points.

See salaries and explore the career path for Investment Analyst

Risk Analyst

Risk Analysts identify, assess, and manage risks for organizations. They create risk management plans, conduct risk assessments, and make recommendations that lead to improved risk management. This course on advanced Excel functions may be useful for improving your ability to work with data. Functions like COUNTIF, SUMIF, and AVERAGEIF can be helpful for summarizing and filtering data, while VLOOKUP, XLOOKUP, INDEX, and MATCH can be used to find and retrieve specific data points.

See salaries and explore the career path for Risk Analyst

Data Scientist

Data Scientists use data to solve business problems. They collect, clean, and analyze data to identify trends and patterns. This course on advanced Excel functions may be useful for improving your ability to work with data. Functions like COUNTIF, SUMIF, and AVERAGEIF can be helpful for summarizing and filtering data, while VLOOKUP, XLOOKUP, INDEX, and MATCH can be used to find and retrieve specific data points.

See salaries and explore the career path for Data Scientist

Statistician

Statisticians collect, analyze, and interpret data to provide insights and make predictions. They use statistical methods to identify trends and patterns in data. This course on advanced Excel functions may be useful for improving your ability to work with data. Functions like COUNTIF, SUMIF, and AVERAGEIF can be helpful for summarizing and filtering data, while VLOOKUP, XLOOKUP, INDEX, and MATCH can be used to find and retrieve specific data points.

See salaries and explore the career path for Statistician

Quantitative Analyst

Quantitative Analysts use mathematical and statistical methods to analyze financial data. They develop financial models and make recommendations that help investors make informed investment decisions. This course on advanced Excel functions may be useful for improving your ability to work with financial data. Understanding how to use functions like COUNTIF, SUMIF, and AVERAGEIF can help you analyze financial data more efficiently, while VLOOKUP and XLOOKUP can be used to retrieve specific financial data points.

See salaries and explore the career path for Quantitative Analyst

Operations Research Analyst

Operations Research Analysts use mathematical and statistical methods to analyze and improve business operations. They create models and simulations to identify inefficiencies and make recommendations that lead to improved performance. This course on advanced Excel functions may be useful for improving your ability to work with data. Functions like COUNTIF, SUMIF, and AVERAGEIF can be helpful for summarizing and filtering data, while VLOOKUP, XLOOKUP, INDEX, and MATCH can be used to find and retrieve specific data points.

See salaries and explore the career path for Operations Research Analyst

Reading list

We've selected ten books that we think will supplement your learning. Use these to develop background knowledge, enrich your coursework, and gain a deeper understanding of the topics covered in Excel for Beginners: Advanced Functions.

101 Best Excel Tips & Tricks

Save

Comprehensive guide to advanced Excel techniques. It covers a wide range of topics, from data analysis to visualization and VBA programming.

101 Best Excel Tips & Tricks (101 Excel Series)

Paperback

100 Excel Simulations

Save

Provides a comprehensive overview of Excel's data analysis and modeling capabilities. It covers topics such as data import and cleaning, data analysis, and forecasting.

100 Excel VBA Simulations: Using Excel VBA to Model...

Paperback

Excel Scientific and Engineering Cookbook

Save

Provides a comprehensive overview of Excel's features and functions for scientists and engineers. It covers topics such as data analysis, visualization, and modeling.

Excel Scientific and Engineering Cookbook: Adding...

Paperback

Excel Scientific and Engineering Cookbook: Adding...

Kindle Edition

Excel Dashboards & Reports For Dummies

Save

Provides a comprehensive overview of Excel's features and functions for business analysis. It covers topics such as data analysis, visualization, and reporting.

Excel Dashboards & Reports For Dummies (For Dummies...

Paperback

Excel Dashboards & Reports for Dummies

Paperback

Excel Dashboards & Reports for Dummies

Paperback

Excel Dashboards & Reports For Dummies

Kindle Edition

Excel VBA Programming For Dummies

Save

Comprehensive guide to VBA programming in Excel. It covers a wide range of topics, from basic concepts to advanced techniques.

Excel VBA Programming For Dummies 5th Edition (For...

Paperback

Financial Modeling, fifth edition

Save

Provides a comprehensive overview of Excel's financial modeling capabilities. It covers topics such as financial statement analysis, forecasting, and valuation.

Financial Modeling, fifth edition

Hardcover

$$$$

Financial Modeling, fifth edition

Kindle Edition

$$$

Making Schools Work

Save

Provides a comprehensive overview of Excel's features and functions for educators. It covers topics such as creating and managing grade books, tracking student progress, and communicating with parents.

Making Schools Work: New Evidence on Accountability...

Kindle Edition

Fuster and Hurst's The Heart, 15th Edition

Save

Provides a comprehensive overview of the basics of Excel. It covers topics such as creating and managing spreadsheets, entering and editing data, and using formulas and functions.

Fuster and Hurst's The Heart, 15th Edition

Hardcover

$$$$

Fuster and Hurst's The Heart, 15th Edition

Kindle Edition

$$$$

Exam 77-420 Microsoft Excel 2013

Save

Comprehensive reference guide to Excel. It provides detailed information on all of Excel's features and functions.

Exam 77-420 Microsoft Excel 2013

Paperback

Check price

Exam 77-420 Microsoft Excel 2013

Kindle Edition

Check price

Excel Workbook For Dummies

Save

Comprehensive overview of the basics of Excel. It covers topics such as creating and managing spreadsheets, entering and editing data, and using formulas and functions.

Excel Workbook For Dummies

Paperback

Excel Workbook For Dummies

Kindle Edition

Help others find this course page by sharing it with your friends and followers: