Excel: Advanced Functions and Formulas - Improov

Excel: Advanced Functions and Formulas

Make magic by combining functions and formulas

l

3 workshops

OF TRANING

Live online

VIRTUAL CLASS

Contact us

TO RESERVE

Learn the functions used by the experts and combine them to solve an impressive number of problems

 

The Excel Advanced Level on Formulas and Functions is for people who want to automate just about any calculation and problem using Excel functions. You will learn a multitude of new functions and how to combine them to solve problems that most Excel users would not think they could solve with them. The participant completing this advanced level will have all the tools to work magic with Excel’s formulas and functions, as well as continuing to learn on their own. Programming functions and formulas at this level is a pleasure to discover and allows for efficiency gains, unparalleled quality analysis and the ability to automate just about any calculation.

At this level, you will learn the usefulness of functions such as INDIRECT, INDEX, ADDRESS and many others. You will learn how to combine them in various ways and even make what is called in Excel jargon, “mega-formulas”. You will understand and learn how Excel’s array calculation can be used to calculate just about anything, in any way. Unlike the vast majority of users, you will understand the convenience of the brand-new array calculation engine that Excel has been using since 2019.

This level is offered in 3 online workshops of 2 hours, with an expert instructor. It requires a commitment from the participants because of the intensity of its content, both during and between workshops. In order to stay on track, they will need to ensure that they have fully integrated the first two workshops before moving on to the third. Even though this level is demanding, the benefits it will provide are worth it and any advanced Excel user will find it worthwhile.
.

Places are going fast

Reserve your spot, change your daily life now.

What you will learn

  • Best practices and good work habits in Excel
  • Handling arithmetic formulas and basic functions
  • Fundamental concepts such as how dates work
  • Several essential tools such as sorts and filters
  • Producing reliable, reusable and quality files
  • Becoming more efficient and comfortable with Excel

PROGRAM OF THE TRAINING

Format
Workshop 1
With expert trainer
The foundations of Excel
10 accompanying videos
Functions and formulas
9 accompanying videos
Data management
9 accompanying videos
Layout and protection
10 accompanying videos
Workshop 2
With expert trainer
Duration
Workshop 1
90 minutes
The foundations of Excel
60 minutes
Functions and formulas
70 minutes
Data management
60 minutes
Layout and protection
60 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 learn how to work efficiently with the software as well as various tips, shortcuts and best practices to work efficiently while creating a professional Excel template.

Module 1: the foundations of Excel
  • Introduction to Module 1
  • 1.01 – Launching
  • 1.02 – Interface and vocabulary
  • 1.03 – Ribbon
  • 1.04 – Data entry and format
  • 1.05 – Select, insert and delete
  • 1.06 – Cells formating
  • 1.07 – Status bar
  • 1.08 – Saving
Module 2: functions and formulas
  • Introduction to Module 2
  • 2.01 – References
  • 2.02 – Formulas
  • 2.03 – SUM() function
  • 2.04 – AVERAGE() function
  • 2.05 – MIN() and MAX() functions
  • 2.06 – ROUND() function
  • 2.07 – Introduction to COUNT() functions
  • 2.08 – Error messages
  • 2.09 – Practice exercises
Module 3: data management
  • Introduction to Module 3
  • 3.01 – Notes and comments
  • 3.02 – Copying and incrementing
  • 3.03 – Absolute and relative references
  • 3.04 – Copy and paste
  • 3.05 – Find and replace
  • 3.06 – Sorting
  • 3.07 – Filters
  • 3.08 – Grouping
Module 4: layout and protection
  • Introduction to Module 4
  • 4.01a – Page layout part 1
  • 4.01b – Page layout part 2
  • 4.02 – Display options
  • 4.03a – Workbook protection
  • 4.03b – Worksheet protection
  • 4.04 – Worksheets management
  • 4.05 – Options
  • Level 1 Conclusion
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 feel comfortable with Excel and understand how to automate tasks through this reliable, professional and reusable template project.

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!