Class Central is learner-supported. When you buy through links on our site, we may earn an affiliate commission.

Coursera Project Network

Excel for Beginners: Advanced Functions

Coursera Project Network via Coursera

Overview

Prepare for a new career with $100 off Coursera Plus
Gear up for jobs in high-demand fields: data analytics, digital marketing, and 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.

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.

Taught by

Edward Falzon

Reviews

3.8 rating at Coursera based on 15 ratings

Start your review of Excel for Beginners: Advanced Functions

Never Stop Learning.

Get personalized course recommendations, track subjects and courses with reminders, and more.

Someone learning on their laptop while sitting on the floor.