Excel for Professionals (Level 2)
Work better, faster and become a professional Excel user
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.
ARE YOU MORE THAN 7 WANTING TO TAKE THE SAME COURSE?
We offer private lessons. Contact us for more information.
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
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.
Workshop 3
In Workshop 3, 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
-
Une équipe compétente, efficace et dynamique qui appuie sa formation avec des outils pertinents pour faciliter l'apprentissage aux plus débutants d'entre nous. Les vidéos de révision sont bien produits et renforcent la compréhension … More de la matière.
Et que dire de leur coordonnatrice, Stéphanie, une précieuse collaboratrice !!! -
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.
-
J'ai suivi la formation Outlook avec Benoît Parent qui a été d'une grande qualité. J'ai révolutionné le traitement de mes emails et la planification de mes tâches. Je remercie Improov pour la construction de ses formations … More qui sont claires, d'un bon format et concentrées sur la pratique pour mettre en oeuvre rapidement des améliorations de son quotidien. A bientôt sur d'autres sujets
Excel for Professionals (Level 2)
$497.00
- 1 year of support with a team of experts
- 1 year of access to the sharing community
- Three 90-minute workshops
- 59 support videos totalling over 4 hours in length
