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

September 30, 2019 at 2:30 PM 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

TUTORIALS / APPLICATIONS

Excel

18 lessons
107 videos

4:54:36
1308