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

March 5, 2020 at 9:00 AM GMT+01:00

GOOD TIPS

Noémie BOURGUIGNON
0
Did you attend our latest webinar: Microsoft TEAMS’ Private Channels, hosted by our international Office365 expert: Dina?
Thank you for your interest!
Here are the answers to your questions, including the replay.
Check out our article ➡ ️http://eqy.link/bm2VPzwNeu
Noémie BOURGUIGNON
0
Do you use Microsoft OneNote in your daily tasks?
Check out the new features of OneNote and some videos of the MOOC Office 365 in this article.

Check out our article to learn more ➡️ http://eqy.link/r-cSfYoenv
Noémie BOURGUIGNON
0
Our international Office 365 trainer: Dina will be hosting a webinar on Microsoft TEAMS’ private channels.

See you on Thursday, February 6, 2020 at 2:30 p.m.!

Sign up now! ➡️ http://eqy.link/oQzeB7BXm
Noémie BOURGUIGNON
0
Do you use public transportation to get to work?
Do you want to save time while commuting? 🚆

Thanks to working on-the-go, you can keep working while commuting using any mobile devices.

For more information, click here ➡️ http://eqy.link/wFAwgJNWU
Noémie BOURGUIGNON
0
The MOOC Office 365 team wishes you a very Happy New Year 2020! 🎉
We hope you have had a great holiday season and are prepared to advance your skills with focused training on new Office 365 features.
2019 was a year packed with new features, in this article we look back on the main.
➡️ http://eqy.link/AfrHClosEg
YAMMER COMMUNITY

TUTORIALS / APPLICATIONS

Excel

19 lessons
108 videos

4:55:35
1493