Quickly improve and clean up your data with Excel

Master the essential functions of Excel with this training. Learn how to optimize your data, spreadsheets and reports efficiently.
Microsoft Partner

Upcoming sessions

No date suits you?

Notify me when a session is added.

  • Duration: 0.5 days
  • Regular price: $285
  • Preferential price: $255

Course outline

Increasingly more accessible and easy-to-use, Excel functions and formulas are essential for cleaning up, cross-tabulating, and analyzing data. With these features, you can correct text, format your data (e.g., uppercase, proper names), generate statistics, find and cross-reference information from different lists, and much more.
Optimizing your data and spreadsheets helps you generate better reports and boost your efficiency. Mastering these indispensable Excel features is crucial. This easy-to-understand training makes sure you succeed.

Audience

Intermediate users or those who have completed the “Excel Essentials” training.

Duration

3.5 hours of theoretical presentation and demonstrations.
Versions taught

Excel 2013 | 2016

Objectives

Thanks to this training, you will be able to
  • recognize functions and formulas;
  • choose and use the right function;
  • combine functions.
Contents
Understanding the features
  • the difference between functions and formulas
  • formula elements
  • function structures
Using names in formulas
  • proper use of the Name Manager dialog box
  • use the New Name dialog box
  • use the Name box
  • replace references by names
Knowing the functions
  • Lookup and matrix: VLOOKUP
  • Text: CONCATENATE, UPPER, LOWER, LAST, LEFT, RIGHT, LEN
  • Logic: IF, AND, OR
  • Statistics: SUM, SUMIF
  • Database: DB* (family)
Combining features: tips and tricks

Surround yourself with the best

Pierre-Edouard Brondel
Pierre-Edouard Brondel
Trainer and Desktop Application Consultant
Renowned as an educational expert in the IT and office technology field who has accumulated more than 25 years of experience, Pierre-Édouard is first and foremost passionate about human capital.
Ghislain Parent
Ghislain Parent
Trainer and Professional Efficiency Consultant
With more than 25 years of experience, Ghislain thrives on the challenge of improving your work team’s efficiency.
Marc Maisonneuve
Marc Maisonneuve
Trainer and Professional Efficiency Consultant
Frédéric Paradis
Frédéric Paradis
Certified Trainer and Cloud Architect
As a certified Microsoft trainer, Frédéric describes himself as a Cloud magician who easily navigates the mythical space between technology and reality.
Be aware of trends, innovations and best practices, every month.
Confidentiality
Training center accredited by Emploi-Québec, Accreditation : 0051460
GST : 141582528 – QST : 1019557738
© 2020 AFI
AFI Expertise

The AFI experience brought to you by Edgenda

At AFI, our focus is to offer you relevant training and impactful learning experiences in line with your transformation approach. Do you need support for your approach? Check out Edgenda’s services: Edgenda.com