Excel for Beginners: Advanced Functions

Go to class

Write Review

Excel for Beginners: Advanced Functions provided by Coursera is a comprehensive online course. Excel for Beginners: Advanced Functions is taught by Edward Falzon. Upon completion of the course, you can receive an e-certificate from Coursera. The course is taught in Englishand is Paid Course. Visit the course page at Coursera for detailed price information.

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.

0, based on 0 Course votes at GetYourEducation

Start your review of Excel for Beginners: Advanced Functions

Add review ->

Language

English
Certificate
Paid Certificate Available
Date of Start
31st October, 2022
Level
Beginner
Price
Paid Course
Provider
Coursera
Taught By

Edward Falzon
Share this course

Excel for Beginners: Advanced Functions

3D Wooden Textiles for Beginners

Digital Brand Strategy: Elevate The User Experience

Flavorful Food Illustration with Watercolor

FPGA computing systems: Background knowledge and introductory materials

Freehand Sketching with Acrylic and Watercolor

Fundamentals of the Chinese character writing. Part 2