Improve and Quickly Clean Up Data with Excel

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

This training is available in a private or personalized format. It can be provided in one of our training centres or at your offices. Call one of our consultants of submit a request online.

Call now at 1 877 624.2344

  • Duration: 0.5 days
  • Regular price: On request

Course outline

Schedule : 8H30 to 12H00

Our scheduled sessions are offered in French. Private sessions are available to you in English, contact us for more info.

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

Sylvain Richer
Sylvain Richer
Trainer and Desktop Application Consultant
Passionate about knowledge transfer and unparalleled in his ability to make complex information easy to understand, Sylvain is a professional efficiency trainer whose expertise is requested again and again.
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.
Valère Drainville
Valère Drainville
Trainer adn Expert Leader on Office 365 collaboration and efficiency
As the Expert Leader on Office 365 collaboration and efficiency, Valère Drainville specializes in helping you successfully implement and adopt Microsoft tools.
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