Excel for Beginners: Advanced Functions

Offered By
In this Guided Project, you will:
No download needed
Split-screen video
Desktop only

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.

Skills you will develop

  • Spreadsheet

  • Microsoft Excel

Learn step-by-step

In a video that plays in a split-screen with your work area, your instructor will walk you through these steps:

How Guided Projects work

Your workspace is a cloud desktop right in your browser, no download required

In a split-screen video, your instructor guides you step-by-step

Frequently Asked Questions