Excel: Advanced Functions and Formulas
Make magic by combining functions and formulas
3 workshops
OF TRANING
Live online
VIRTUAL CLASS
$497.00
$497.00
MORE THAN 7 HOURS OF CONTENT
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.
.
ARE YOU MORE THAN 7 WANTING TO TAKE THE SAME COURSE?
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
PROGRAM OF THE TRAINING
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: Advanced Functions and Formulas
$497.00
- Support on workshop materials for the duration of the course
- Three 120-minute workshops
