Excel Essentials

Do you want to get the most out of Excel? This training course will show you how to convert data into a dashing dashboard, and how to share it with Office 365.

277 min 5 lessons 48 activities

available in

Rating

9.0

From Data to Dashboard From Data to Dashboard

Learning objectives

Exploring all the possible uses of Excel.
Learning about the basic functions of Excel.
Discovering the perks of Excel in combination with Office 365.

64 min - 11 activities

Magazine
Quick Scan
Explained
How do I use the user interface?
How do I open a workbook?
How do I add a worksheet?
How do I edit cells?
How do I edit rows and columns?
How do I format a file?
How do I format cells?
Go!

Functions and Formulas Functions and Formulas

Learning objectives

Learning how formulas are built.
Applying formulas to your data.

56 min - 11 activities

Magazine
Explained
How do I use operators?
How do I use MIN, MAX, AVERAGE?
How do I use XLOOKUP?
How do I use XMATCH?
How do I use the IF function?
How do I use COUNT and COUNTIF?
How do I use SUM, SUMIF and SUMIFS?
Go!
Top 25 Most Used Functions

Data With a Twist Data With a Twist

Learning objectives

Discovering the various types of tables and charts.
Turning data into pivot tables and charts.
Identifying the most suitable charts for your goal.

54 min - 9 activities

Magazine
CASE STUDY
How do I create a pivot table?
How do I create a line chart?
How do I create a map chart?
How do I create a column chart?
How do I create a pie chart?
How do I create a bar chart?
Go!

Dashing Dashboard Dashing Dashboard

Learning objectives

Discovering the possibilities of a dashboard.
Combining your data into one dashboard.
Adding slicers to your dashboard.

51 min - 8 activities

Magazine
Explained
How do I add a background?
How do I combine charts?
How do I add titles?
How do I add slicers?
How do I share the dashboard?
Go!

From Password to Paper From Password to Paper

Learning objectives

Printing your Excel files correctly.
Protecting your files.
Discovering how to efficiently work together on a file in Office 365.

42 min - 8 activities

Magazine
How do I hide the content?
How do I protect a file?
How do I protect a workbook?
How do I protect a worksheet?
How do I print the dashboard?
Go!
Reference Guide

Test Test

Learning objectives

Practical uses of Excel
Tables and charts
Office 365

10 min - 1 activities

Excel Essentials

Learning objectives

Donut worry about cookies