Excel: Advanced Functions and Formulas - Improov

Excel: Advanced Functions and Formulas

Make magic by combining functions and formulas


3 workshops


Live online




Contact us


Out of stock

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.


We offer private lessons. Contact us for more information.

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


Advanced and embedded functions
Reference and logic functions
Functions, formulas and matrix calculations
Workshop with an Instructor
Workshop with an Instructor
Workshop with an Instructor
120 minutes
120 minutes
120 minutes

Testimonials from the Improov community

5.0 254 reviews

  • Avatar Isabelle Reid ★★★★ il y a un mois
    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 !!!
  • Avatar Anne Bergeron ★★★★★ il y a 3 mois
    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 Adrien Meziane ★★★★★ il y a un mois
    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

Out of stock

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!