Excel for Professionals - Improov

Excel for Professionals

Work better, faster and become a professional Excel user

l

2 workshops

OF TRAINING

59 videos

TO ACCOMPANY

Contact Us

TO RESERVE

Become an expert in the various tools and functions of Excel. Increase your efficiency and enjoyment tenfold.

 

This second level of our Excel program covers all the different topics of the application with an increased level of difficulty. The learning of more advanced features will allow the resolution of complex problems in record time. Participants completing this Excel program will be equipped with a complete toolbox and will see their efficiency improve. They will enjoy using the application much more. They will become professional and motivated Excel users, ready to face most of the problems encountered in the workplace.

Excel for Professionals is divided into five main thematic modules which aim to help the participants become versatile and efficient users. More complex functions, such as SUMIFS and VLOOKUP, are covered from all angles to help the participants master them perfectly. This level also opens the doors to pivot tables, a powerful analysis tool. The last module is reserved for a brand-new category of functions for Office 365 users: dynamic array functions.

This course is offered as a hybrid program with over 5 hours of videos and 3 hours of workshops with an expert instructor. The videos focus on practice, using carefully selected exercise files. They allow participants to learn at their own pace. The workshops are unique, structured and motivating. They allow participants to integrate their knowledge into one stimulating project, guided by an expert who can also answer questions.

Our free 20-minute assessment lets us see exactly at which level the future participant is, and also in which modules the participant’s weaknesses lie. For groups, we provide an evaluation report that highlights strengths and weaknesses in the various themes of our Excel development plan, allowing you to choose the most appropriate plan of instruction.

Place are going fast

Reserve your spot, change your daily life now.

What you will learn

  • Being efficient and versatile when faced with multiple complex problems
  • Producing analyzes in record time with pivot tables
  • Several intermediate functions such as SUMIFS, VLOOKUP, COUNTIF, IF, and more
  • In-depth, indispensable concepts such as data formats and dates
  • The brand-new dynamic array functions of Office 365

PROGRAM OF THE TRAINING

Format
Workshop 1
With instructor
Tools for professionals
14 accompanying videos
Essential concepts
9 accompanying videos
Essential functions
17 accompanying videos
Pivot tables and graphs
12 accompanying videos
Dynamic array functions (office 365)
7 accompanying videos
Workshop 2
With instructor
Duration
Workshop 1
90 minutes
Tools for professionals
90 minutes
Essential concepts
120 minutes
Essential functions
90 minutes
Pivot tables and graphs
90 minutes
Dynamic array functions (office 365)
90 minutes
Workshop 2
90 minutes

Niveau 1

Workshop 1

In Workshop 1, you will build a full-fledged Excel project around a concrete situation. Workshop 1 is not a series of exercises, but rather a large Excel project that will continue through the end of Workshop 2. In 90 minutes, you will get a taste of the features shown in the videos and be exposed to efficient and professional ways of working. You will solve problems while learning how to create a reusable Excel template.

Module 1: Tools for Professionals
  • Introduction to Level 2
  • Introduction to Module 1
  • 1.01 – Shortcuts
  • 1.02 – Flashfill
  • 1.03 – Remove duplicates
  • 1.04 – Worksheet groups
  • 1.05 -3D SUM
  • 1.06 – Data validation
  • 1.07 – Advanced filters – Part 1
  • 1.08 – Advanced filters – Part 2
  • 1.09 – Conditional formatting – Part 1
  • 1.10 – Conditional formatting – Part 2
  • 1.11 – Conditional formatting – formulas
  • 1.12 – Conditional formatting – rules and priority
Module 2: Essential Concepts
  • Introduction to Module 2
  • 2.01 – Mixed references – Part 1
  • 2.02 – References and data organization
  • 2.03 – Data types and formats
  • 2.04 – Text to columns – Part 1
  • 2.05 – Text to columns – Part 2
  • 2.06 – Dates – Part 1
  • 2.07 – Dates – Part 2
  • 2.08 – Dates – Part 3
  • 2.09 – Names
Module 3: Essential Functions
  • Introduction to Module 3
  • 3.01 – SUBTOTAL()
  • 3.02 – COUNTIF() – Part 1
  • 3.03 – COUNTIF() – Part 2
  • 3.04 – COUNTIFS()
  • 3.05 – SUMIFS() – Part 1
  • 3.06 – SUMIFS() – Part 2
  • 3.07 – SUMIFS() – Part 3
  • 3.08 – VLOOKUP() – Part 1
  • 3.09 – VLOOKUP() – Part 2
  • 3.10 – VLOOKUP() – Part 3
  • 3.11 – VLOOKUP() – Part 4, Approximate match
  • 3.12 – VLOOUP() – Part 5
  • 3.13 – VLOOKUP() – Part 6, with two criteria
  • 3.14 – IF() – Part 1
  • 3.15 – IF() – Part 2
  • 3.16 – IF() – Part 3
Module 4: Pivot Tables and Charts
  • Introduction to Module 4
  • 4.01 – Introduction to tables
  • 4.02 – Pivot tables – Part 1
  • 4.03 – Pivot tables – Part 2
  • 4.04 – Pivot tables – Part 3
  • 4.05 – Pivot tables – Part 4
  • 4.06 – Pivot tables – Part 5
  • 4.07 – Charts theory
  • 4.08 – Pie chart
  • 4.09 – Column chart
  • 4.10 – Pivot chart
  • 4.11 – Sparklines
Module 5: Dynamic Array Functions
  • 5.01 – Introduction to dynamic arrays
  • 5.02 – UNIQUE()
  • 5.03 – SORT()
  • 5.04 – SORTBY()
  • 5.05 – RANDARRAY()
  • 5.06 – TRANSPOSE()
  • 5.07 – FILTER()
Workshop 2

In Workshop 2, you will continue the project started in Workshop 1. The level of difficulty of the concepts and tools used will be increased. You will apply some of the elements covered in the videos in a different way to improve your comfort level. You will also learn some new features and ways of working that are more difficult to communicate through the accompanying videos. Finally, at the end of this workshop, you will feel that you are in control of the application.

Hybrid classes: a concept adapted to today’s reality that is changing the world of corporate training

LIVE WORKSHOPS WITH AN INSTRUCTOR

Direct access to your instructor to answer all your questions and teach you key concepts.

  • Expert, motivating and friendly instructors
  • Dynamic and stimulating workshops, focused on practical exercises with real-life situations
  • Direct access to your instructor to answer all your questions
  • Workshops of 60 to 120 minutes that can easily be adapted to various schedules

HIGH QUALITY ACCOMPANYING VIDEOS

Access to the complete program via online capsules with exercises to complete at your own pace.

  • Access to a complete online video program with practical exercises
  • Logical and structured path to optimal learning
  • Allow participants to learn at their own pace via an easy-to-use platform
  • Professional production studio allowing us to partner with organizations to customize the content and look of the videos

FULL ONE-YEAR SUPPORT

Enjoy a full year of support and access to our expert instructors!

  • A full year of access to our expert instructors
  • Access to an online community and to questions already asked on the forums
  • Personalized and impeccable customer service

Testimonials from the Improov community

5.0 226 reviews

  • Avatar Valérie St Val ★★★★★ il y a 4 mois
    J’ai beaucoup apprécié la formation Teams comme un pro donnée par Benoit Parent. Il a su utiliser des exemples concrets, clairs et simples pour transmettre les informations. Cela répond parfaitement à mes besoins. Formation de très bonne … More qualité et un formateur hors pair!
  • Avatar Jimena Vergara ★★★★★ il y a 4 mois
    Super intéressant, complet, clair et précis. Les connaissances acquises lors de la formation vont grandement faciliter notre travail! On évitera bien des frustrations et qui sait des tendinites avec les raccourcis de clavier ! Merci beaucoup … More François!
  • Avatar Steeve Queenton ★★★★★ il y a 2 mois
    J'ai adoré la formation sur la gestion du temps offerte par François. En plus de faire réfléchir, la formation m'a permis de mettre en pratique des trucs et stratégies efficaces. Moins de gruges-temps, plus d'organisation … More - plus d'efficacité.
    Merci beaucoup!

You would like to form a group?

Want tips and tricks on how to improve your professional efficiency?

Sign up to receive information that will help you optimize your time and master your everyday technological tools.

You have Successfully Subscribed!