Discover what you can learn.

With video courses for work, study and leisure.

Available everywhere
Learn on PC, tablet or smartphone.

Pace

Own pace,
replay as often as you want.

Quick learning success,
instructional videos, exercises and quizzes get you closer to your goal.

Microsoft Excel: Functions (EN)

By 365 Careers

In this course you will learn about the usage of Functions in Microsoft Excel 2016.

This includes:

Key functions like COUNT, SUM and AVERAGE
Transferring Data efficiently
The Pivot Tables

Content

Keyboard Shortcuts	04:15
Key Functions in Excel: COUNT, COUNTA, COUNTIF	04:06
Key Functions in Excel: SUM, SUMIF, SUMIFS	04:24
Key Functions in Excel: AVERAGE and AVERAGEIF	01:59
Working with Text in Excel: LEFT, RIGHT, MID, UPPER	02:40
Find the Highest and the Lowest Values in a Range	00:52
Include ROUND in Financial Models	01:01
Transferring Data Efficiently VLOOKUP and HLOOKUP	07:47
Use INDEX and MATCH as a Substitute of VLOOKUP	07:27
IFERROR to Deal Easily with Error Messages	01:43
Excel's Dynamic and Interactive Tables Pivot Tables	02:17
Create Flexible Financial Models: CHOOSE	02:24
Goal Seek	02:17
Include Sensitivity Analysis Through Data	04:10

Details

Included lectures: 14
Duration: 0:47 h
Available documents: 51

These courses may be of interest to you

Medicine Flat Rate

Several lecturers

(10007)

~~€1,275.17 per month~~ €49.99 per month

You save 96 %

Microsoft Excel 2016 (EN)

365 Careers

(1)

~~€27.73 per month~~ €14.99 per month

You save 46 %

Authors of course Microsoft Excel: Functions (EN)

365 Careers

365 Careers specializes in online courses in Finance, Management, Data Science and other fields. The company's courses produced have been taken by more than 400,000 students across 210 countries.

Customer reviews

(1)
5,0 of 5 stars

5 Stars		5
4 Stars		0
3 Stars		0
2 Stars		0
1 Star		0