Excel 2016 - Easy data analysis with pivot tables

Course Detail Icon

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

Agenda Icon December 8, 2020 at 11:30 AM GMT+01:00
Pictogramme flèche

GOOD TIPS

User Avatar
Equipe PÉDAGOGIQUE
1
The replay is available in the course page here : https://mooc.office365-training.com/en/training-courses/have… ;)
User Avatar
Magnus FÄLTH
1
The webinar was great, any chance to get hold of the replay? thanks, Magnus :-)
User Avatar
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>
User Avatar
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
User Avatar
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

User Case Icon

Run and generate reports for an entire team

2:32
14

TUTORIALS / APPLICATIONS

Exel - Data Analysis

2 lessons
7 videos

21:01
123

LEARNING PATHS RELATED TO THIS COURSE

Learning Path Icon
Fee-based

Excel

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

3h00
1484
DISCOVER
Learning Path Icon
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
654
DISCOVER
ALL LEARNING PATHS

OTHER TRAINEES ALSO LIKED

Course Icon
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
749
Course Icon
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
1259
ALL COURSES