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

June 11, 2019 at 9:00 AM GMT+02:00

GOOD TIPS

Noémie BOURGUIGNON
1
This week, check out our new course: The New Features in Outlook 2019.

We will show you new functionalities such as:
- Simplified Ribbon
- Show Focuses Inbox
- Suggested Contacts
- Reading Aloud

Discover our Outlook 2019 tutorials.

See you on the MOOC Office 365 online course on May 28 and 29, 2019.
Register now for this new course!
➡️ https://mooc.office365-training.com/en/blog/new-course-outlo…
Noémie BOURGUIGNON
0
This week, we introduce our new Managers course: Office 365 Executive Tips.

Our expert trainer will show you how:
- Organize meetings easily
- Manage your team’s activity
- Analyze activity
- Communicate and share information with your team

Dive into this course to hone your managerial skills ➡️ https://mooc.office365-training.com/en/blog/course-managers-…
Noémie BOURGUIGNON
0
This week, in our article, we will show you the different types of resources on the MOOC Office 365:
• Tutorials
• Use case scenarios
• Live training sessions
• Webinars
• Webcasts
• Courses
• Learning paths

Check out our blog post ⏬
https://mooc.office365-training.com/en/blog/resources-mooc-o…
Noémie BOURGUIGNON
0
This week, we propose you to discover the new features of Office 2019.
Register now, the first 2 sessions are free!
Our expert trainer will show you how these new features improve daily tasks, increase efficiency and further his training through the MOOC Office 365 platform.
For more information, check out our blog post ⬇️
Noémie BOURGUIGNON
2
Check out now the webinar replay about driving Teams adoption.
Thanks to 90 registered for your interest!
You asked us questions, we answer you in this article ⬇️
YAMMER COMMUNITY

WATCH WEBCAST

Discover the webcast related to this course,
A webcast is a webconference recording

USE CASE SCENARIOS

Sharing a file from a smartphone

2:28
208

TUTORIALS / THE APPLICATIONS

Excel

18 lessons
93 Videos

4:44:28
5911

LEARNING PATHS RELATED TO THIS COURSE

Business

Excel

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

3h00
1324
DISCOVER
Business

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
927
DISCOVER
ALL LEARNING PATHS

OTHER TRAINEES ALSO LIKED

Business

Excel 2016 - Quickly enhance your results

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

45:00
1040
Business

Excel 2016 - Discover spreadsheets

What is Excel? Discover the user interface and basic features of Excel: Create tables; generate calculations and manage data.

45:00
1657
ALL COURSES