Excel 2016 - Easy data analysis with pivot tables

Agile data analysis in Excel 2016, using automatic formatting and pivot tables.

Teaching Format:

  • Remote e-learning training session
  • Interact live with your trainer throughout the e-learning session. Ask questions and discuss points as they arise

Training aims:

  • Understand pivot tables
  • Use a pivot table for basic data analysis

Training content:

  • Source of pivot table data
  • The four areas for grouped data
  • Filter data
  • Edit summary functions
  • Edit headings and display order
  • Format a pivot table
  • Benefit from Slicers

NEXT SESSION

January 28, 2020 at 9:00 AM GMT+01:00

GOOD TIPS

Noémie BOURGUIGNON
0
The MOOC Office 365 team wishes you a very Happy New Year 2020! 🎉
We hope you have had a great holiday season and are prepared to advance your skills with focused training on new Office 365 features.
2019 was a year packed with new features, in this article we look back on the main.
➡️ http://eqy.link/AfrHClosEg
Noémie BOURGUIGNON
0
Microsoft uses its customers’ feedback to continue to improve its application: Teams.
This week, we present the functional iterations of Teams.
Check out our article to learn more ➡ http://eqy.link/mp2mGhRuMV
Noémie BOURGUIGNON
0
A new 100% video course is available on MOOC Office 365!

Learn more about artificial intelligence from Microsoft's tools.
Also check out Microsoft Power Apps in this article.

To find out more, this is ➡ ️http://eqy.link/28KORkf6GL
Noémie BOURGUIGNON
0
Have you ever trained with Dina?
Learn more about our international educational consultant!

Check out her portrait here ➡️ http://eqy.link/Hm29MZ_B0g
Noémie BOURGUIGNON
2
Let's go back to our webinar this November: How to Determine the Right Tool to Use?

Dina, our international trainer, answers your questions about the tools and their use according to your need.

To find out more, click here ➡️ http://eqy.link/20RxO6jLOZ
YAMMER COMMUNITY

WATCH WEBCAST

Check out the webcast related to this course!
Webcasts are recorded web conferences.

USE CASE SCENARIOS

Sharing a file from a smartphone

2:28
73

TUTORIALS / APPLICATIONS

Excel

19 lessons
108 videos

4:55:35
1437

LEARNING PATHS RELATED TO THIS COURSE

Fee-based

Excel

From simple table to in-depth data analysis, discover a range of key features.

3h00
549
DISCOVER
Fee-based

Marketing Manager

Office 365 provides you with the right tools for efficient team working, and quick and easy communication. Discover how Yammer, Skype for Business and OneDrive can help you.

4h00
265
DISCOVER
ALL LEARNING PATHS

OTHER TRAINEES ALSO LIKED

Fee-based

Excel 2016 - Quickly enhance your results

Quickly enhance your spreadsheets with excel 2016, adding charts and graphs and learning more new features.

45:00
335
Fee-based

Excel 2016 - Introduction to Spreadsheets

What is Excel? Discover Excel user interface and basic features by creating tables, using simple formulas and managing data.

45:00
660
ALL COURSES