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

June 22, 2020 at 11:30 AM GMT+02:00

GOOD TIPS

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

TUTORIALS / APPLICATIONS

Excel

19 lessons
108 videos

4:55:35
1814