We may earn an affiliate commission when you visit our partners.
Excel for Beginners
Advanced Functions
Edward Falzon
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.
Read more
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.
Read more
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
Please Note: If you don't have a free Microsoft account, you will need to create one to be able to complete the content.
Register for this course and see more details by visiting:
OpenCourser.com/course/h3o0lr/excel
What's inside
Syllabus
Project Overview
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.
Good to know
Good to know
Know what's good ,
what to watch for , 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
Save Excel for Beginners: Advanced Functions to your list so you can find it easily later:
Save
Save
Activities
Coming soon
We're preparing activities for
Excel for Beginners: Advanced Functions.
These are activities you can do either before, during, or after a course.
Career center
Learners who complete Excel for Beginners: Advanced Functions will develop knowledge and skills
that may be useful to these careers:
Management Consultant
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.
Data Scientist
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.
Business 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.
Operations Research 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.
Statistician
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.
Data Analyst
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.
Financial 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.
Operations 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.
Risk 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.
Quantitative Analyst
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.
Financial Planner
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.
Auditor
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.
Tax Accountant
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.
Budget Analyst
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.
Investment Analyst
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.
For more career information including salaries, visit:
OpenCourser.com/course/h3o0lr/excel
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.
Comprehensive guide to advanced Excel techniques. It covers a wide range of topics, from data analysis to visualization and VBA programming.
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.
Provides a comprehensive overview of Excel's features and functions for scientists and engineers. It covers topics such as data analysis, visualization, and modeling.
Provides a comprehensive overview of Excel's features and functions for business analysis. It covers topics such as data analysis, visualization, and reporting.
Comprehensive guide to VBA programming in Excel. It covers a wide range of topics, from basic concepts to advanced techniques.
Provides a comprehensive overview of Excel's financial modeling capabilities. It covers topics such as financial statement analysis, forecasting, and valuation.
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.
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.
Comprehensive reference guide to Excel. It provides detailed information on all of Excel's features and functions.
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.
For more information about how these books relate to this course, visit:
OpenCourser.com/course/h3o0lr/excel
Share
Similar courses
Here are nine courses similar to
Excel for Beginners: Advanced Functions.
Excel for Beginners: Beginner Functions
OpenCourser.com/course/iyezgs/excel
Excel for Beginners: Beginner Functions
Most relevant
Spreadsheets for Beginners using Google Sheets
OpenCourser.com/course/jt524v/spreadsheets
Spreadsheets for Beginners using Google Sheets
Most relevant
Excel for Beginners: Introduction to Spreadsheets
OpenCourser.com/course/lwalz6/excel
Excel for Beginners: Introduction to Spreadsheets
Most relevant
Excel for Beginners: Pivot Tables
OpenCourser.com/course/36ke3w/excel
Excel for Beginners: Pivot Tables
Most relevant
Excel for Beginners: Sorting, Filtering, Data-Validation
OpenCourser.com/course/bf9vsu/excel
Excel for Beginners: Sorting, Filtering, Data-Validation
Most relevant
Introduction to Microsoft Excel
OpenCourser.com/course/12vl4j/introduction
Introduction to Microsoft Excel
Most relevant
How to Use Lookup Reference Math and Text Functions in Excel
OpenCourser.com/course/ff7g9v/how
How to Use Lookup Reference Math and Text Functions in...
Most relevant
Create a Mortgage Calculator in Excel
OpenCourser.com/course/dpciz8/create
Create a Mortgage Calculator in Excel
Most relevant
How to use Custom and Conditional Formatting in Excel
OpenCourser.com/course/ncz565/how
How to use Custom and Conditional Formatting in Excel
Most relevant
Effort
2
Level
Introductory
Via
Coursera
Institution
Coursera Project Network
Instructor
Edward Falzon
Language
English
Good to know
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
Our mission
OpenCourser helps millions of learners each year. People visit us to learn workspace skills, ace their exams, and nurture their curiosity.
Our extensive catalog contains over 50,000 courses and twice as many books. Browse by search, by topic, or even by career interests. We'll match you to the right resources quickly.
Find this site helpful? Tell a friend about us.
Affiliate disclosure
We're supported by our community of learners. When you purchase or subscribe to courses and programs or purchase books, we may earn a commission from our partners.
Your purchases help us maintain our catalog and keep our servers humming without ads.
Thank you for supporting OpenCourser.
© 2016 - 2024 OpenCourser