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

$297.00

7 HOURS OF CONTENT

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

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

Testimonials from the Improov community

5.0 240 reviews

  • Avatar Anne Bergeron ★★★★★ il y a moins d'une semaine
    J’ai réalisé une formation avec Improov. Le contenu m’a été très utile pour accroître le volet efficacité et gestion du temps. Une formation très intéressante et bien présentée.
  • Avatar Geneviève Jodoin ★★★★★ il y a 2 mois
    Superbe expérience d'apprentissage. Nous avons eu beaucoup de plaisir lors de nos séances. Un service de haute qualité. Je recommande sans hésitation.
  • Avatar Nathalie Caron ★★★★★ il y a 2 mois
    Bonne formation, permet d'apprendre de nouvelles astuces. Il faut bien entendu adapter tout ceci à nos méthodes de travail et de gestion du temps.

Are you more than 5 people who want to follow the same training together?

We offer private trainings. Contact us to know more.

Improov logo formation cours training

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!