Buy Now Free

Excel for Beginners: Advanced Functions
  • Level Beginner
  • Duration 4 hours
  • Course by Coursera
  • Offered by

About

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.

Modules

Your Learning Journey

    • 1 Readings
    • 1 Plugin
    • 1 Lab
    • 1 Assignment
Show info about module content

1 Assignment

  • Assess Your Knowledge

1 Labs

  • Excel for Beginners: Advanced Functions

1 Readings

  • Project Overview

Auto Summary

Unlock advanced Excel functions in just 1 hour with this beginner-friendly course by Coursera. Focused on personal development, learners will explore conditional functions like countif, sumif, and averageif, as well as reference functions such as vlookup, xlookup, and index & match. Utilize Excel on the Web, with concepts also applicable to LibreOffice Calc and Google Sheets. Ideal for those new to spreadsheets, this project-based learning experience is free and requires a Microsoft account.

Edward Falzon
Instructor

Edward Falzon