Excel - Analyze with advanced functions

It is not always suitable to use PivotTables to analyze data. Discover another approach by using instead functions and conditional formatting to analyze tables. 

Means and methods:

  • The session is carried out remotely with a virtual classroom tool
  • Live interaction with a trainer enabling participants to ask questions

Training Objectives:

  • Use functions to retrieve data from your tables
  • Discover advanced conditional formatting uses 

Training content:

  • Functions if, COUNTIF, VLOOKUP,...
  • Calculations with dates
  • The matrix calculation
  • Use a formula to apply conditional formatting

NEXT SESSION

December 2, 2019 at 9: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

TUTORIALS / APPLICATIONS

Excel

19 lessons
108 videos

4:55:35
1392