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

October 14, 2019 at 10:00 AM GMT+02:00

GOOD TIPS

Noémie BOURGUIGNON
0
This month, our webinar is dedicated to the adoption and governance of Microsoft Teams with SalesTim.
Discover this tool to be better organized and therefore save time.

See you tomorrow at 4:30 PM! A few places are still available, register now!

➡️ http://eqy.link/g1LP1xZ22p
Noémie BOURGUIGNON
0
This week discover our brand new 100% video course: Teams Call Features.
The purpose of this course is to introduce you to the various features and call options in Teams as well as the new uses of Cloud telephony and finally, to get familiar with the configuration menus.
Find out more about this course by reading our blog article!
➡️ http://eqy.link/g-u_VAsYeO
Community MANAGER
0
As we return from the summer holidays, we take stock of the difference between MOOC Office 365 and Microsoft licenses. Indeed, with Microsoft licenses you cannot log in to MOOC Office 365.

Everything is explained in our article ➡️http://bit.ly/2LjsWSA
Noémie BOURGUIGNON
0
We interviewed our expert trainer on Office 365 tools: Fanny.
Did you ever have the opportunity to train with Fanny?
For more information about your favorite trainer, check out our article 😊
➡️ http://bit.ly/31iOaFk
Noémie BOURGUIGNON
1
This week, discover our new video format: The tutorial series about Microsoft Teams.
Discover the first season: Skype VS Teams Uses Coaching.

Watch now! ➡️ http://bit.ly/2YCTd5I
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
64

TUTORIALS / APPLICATIONS

Excel

18 lessons
107 videos

4:54:36
1308

LEARNING PATHS RELATED TO THIS COURSE

Fee-based

Excel

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

3h00
323
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
127
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
217
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
529
ALL COURSES