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

August 10, 2020 at 2:00 PM GMT+02:00

GOOD TIPS

Equipe PÉDAGOGIQUE
1
The replay is available in the course page here : https://mooc.office365-training.com/en/training-courses/have… ;)
Magnus FÄLTH
1
The webinar was great, any chance to get hold of the replay? thanks, Magnus :-)
Noémie BOURGUIGNON
0
In this month of March, telework has become mandatory for all occupations allowing it.
Are you well prepared for this sudden change?

We offer a "survival kit" to guide you. Try out our completely free course consisting of the following 3 courses:
· #1: Setting up telework
· #2: Communicating with your team
· #3: Organizing meetings remotely

Many sessions are available, sign up now!
We also offer personalized support, to learn more, check out our blog post
➡️ https://bit.ly/3ajSTvs<https://t.co/Y9FVlIXHnq?amp=1>
Noémie BOURGUIGNON
1
This month, we decided to organize a webinar based on a key player in the end user adoption: the manager.
Meet Dina, our expert, on Tuesday, March 17th!
This article sets out the big thrusts of our new webinar.
Click here to learn more ➡️ http://bit.ly/2Q7H7vT
Noémie BOURGUIGNON
0
Our first 2020 course is available on the MOOC Office 365 platform!
Get to know Microsoft To Do, the app meant to manage your tasks efficiently.
With the mobile version, use this app on-the-go and efficiently organize your day by staying focused on priorities.

Our 100% video course will show you how to:
- Create tasks and import them from Outlook or Planner
- Create your lists and share them with your employees
- Add deadlines and reminders.

Read our article to find out more ➡️ http://eqy.link/03MhpJ7Pa
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
83

TUTORIALS / APPLICATIONS

Excel

19 lessons
108 videos

4:55:35
1871

LEARNING PATHS RELATED TO THIS COURSE

Fee-based

Excel

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

3h00
1082
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
486
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
575
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
1012
ALL COURSES