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

July 30, 2019 at 4:00 PM GMT+02:00

GOOD TIPS

Noémie BOURGUIGNON
1
This week, check out our new course: The New Features in Outlook 2019.

We will show you new functionalities such as:
- Simplified Ribbon
- Show Focuses Inbox
- Suggested Contacts
- Reading Aloud

Discover our Outlook 2019 tutorials.

See you on the MOOC Office 365 online course on May 28 and 29, 2019.
Register now for this new course!
➡️ https://mooc.office365-training.com/en/blog/new-course-outlo…
Noémie BOURGUIGNON
0
This week, we introduce our new Managers course: Office 365 Executive Tips.

Our expert trainer will show you how:
- Organize meetings easily
- Manage your team’s activity
- Analyze activity
- Communicate and share information with your team

Dive into this course to hone your managerial skills ➡️ https://mooc.office365-training.com/en/blog/course-managers-…
Noémie BOURGUIGNON
0
This week, in our article, we will show you the different types of resources on the MOOC Office 365:
• Tutorials
• Use case scenarios
• Live training sessions
• Webinars
• Webcasts
• Courses
• Learning paths

Check out our blog post ⏬
https://mooc.office365-training.com/en/blog/resources-mooc-o…
Noémie BOURGUIGNON
0
This week, we propose you to discover the new features of Office 2019.
Register now, the first 2 sessions are free!
Our expert trainer will show you how these new features improve daily tasks, increase efficiency and further his training through the MOOC Office 365 platform.
For more information, check out our blog post ⬇️
Noémie BOURGUIGNON
2
Check out now the webinar replay about driving Teams adoption.
Thanks to 90 registered for your interest!
You asked us questions, we answer you in this article ⬇️
YAMMER COMMUNITY

TUTORIALS / APPLICATIONS

Excel

18 lessons
105 videos

4:53:30
5949