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

November 21, 2019 at 11:00 AM GMT+01:00

GOOD TIPS

Noémie BOURGUIGNON
0
Our Office 365 trainer: Dina will host the next week’s webinar!

Ask yourself the following: Why share? With whom? And how often?

We will give you answers to key issues and a guide to help you determine the right tool to use 🧰
In addition, our usage guide is available on the MOOC Office 365 platform.

Sign up now ➡️ http://eqy.link/CNV5asbNcc
Noémie BOURGUIGNON
0
This week: Discover your admin portal’s new features.
The MOOC Office 365 platform is constantly evolving. This article presents the back office latest updates.

Read all about it! ➡️ http://eqy.link/Hdy4LnTOsg
Community MANAGER
0
Microsoft has announced the phasing out of Skype for Business 😰...this is an unprecedented situation...fortunately, Microsoft TEAMS takes over from here!

Are you already using Microsoft TEAMS? How is the appropriation of this new tool going? 😎
Noémie BOURGUIGNON
0
Following the SalesTim webinar on the adoption and the governance of Microsoft teams, find the replay and the FAQ!
A special thanks to all participants for your interest! ⬇️
Noémie BOURGUIGNON
1
This week, we're taking you into the world of collaboration!
During this new course, our expert trainer will share tips with you on how to collaborate easily with Excel and SharePoint.

This course will be divided into 4 parts:
- Work with Excel heavy client and online
- Export structured Excel tables to SharePoint
- Export SharePoint lists to Excel
- Display an Excel dashboard in a SharePoint page

The first sessions are available:
- Friday, October 11, 2019
- Monday, October 14, 2019
Register now ➡️ http://eqy.link/dcdhgkU0RK
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
66

TUTORIALS / APPLICATIONS

Excel

19 lessons
108 videos

4:55:35
1392

LEARNING PATHS RELATED TO THIS COURSE

Fee-based

Excel

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

3h00
426
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
176
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
264
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
590
ALL COURSES