Excel - Functions and always functions - Training Courses | Afi U.
afiU logo
Explore our 2025-2026 catalogue View all courses
Training and Coaching

Cultivate a learning organization and develop talent.

Customer Experience

Optimize your processes for operational excellence.

Employee Experience

Engage, empower, and enhance employee well-being.

Artificial Intelligence

Master AI and automate your processes.

Leadership

Develop key skills to inspire and mobilize.

Digital Tools

Boost collaboration and productivity within your teams

Strategy and Performance

Align your goals for sustainable growth.

Digital Transformation

Leverage technology to innovate and accelerate your growth.

ContactFAQ

Excel - Functions and always functions

Master and distinguish different functions in Excel. Use reference names in formulas, use lookup and text functions, manage data lists functionsand round functions.
Microsoft Partner

Upcoming sessions

Guaranteed to run

No date suits you?

Notify me when a session is added.

  • Duration: 1 day
  • Regular price: $360
  • Preferential price: $306tip icon

Course outline

Duration : 1 day

© AFI par Edgenda inc.

Master and distinguish between different functions in Excel. This course will teach you how to use reference names, master lookup functions (VLOOKUP, HLOOKUP, XLOOKUP, MATCH), text functions, functions that work with data lists, rounding functions, and how to perform a formula audit.

Prerequisites

Have completed at least the Excel - Logical and date/time functions training or equivalent

Objectives

  • Master and distinguish different functions in Excel

Teaching method

Presentations - Demos - Facilitated and individual exercises

Contents

Chapter 1 - Use reference names in formulas

  • Create reference names.
  • Selecting a named reference.
  • Using the name manager
  • Using a reference name in a formula

Chapter 2 – Using lookup functionsUsing names in formulas

  • Vlookup
  • Hlookup
  • Xlookup

Chapter 3 -Text function

  • CONCATENATE
  • UPPER, LOWER
  • Proper
  • LEFT, RIGHT
  • LEN.
  • FInd

Chapter 4 -Data lists functions

  • SumIF, CountIF
  • SumIFS, CountIFS
  • DSum, DAverage, etc.
  • Subtotal

Chapter 5 – Round function

  • Roundup
  • Rounddown

Chapter 6 – Formula Audits

  • Perform a classic formula audit
  • Show relationships between formulas and cells through precedents and dependents
  • Keep an eye on key cells with the Watch Window

Surround yourself with the best

Francis Ferland-Stevenson
Francis Ferland-Stevenson
Trainer
Francis began as a trainer more than 5 years ago by testing office automation tools designed specifically to met the needs of his colleagues. His calm and his empathy makes him able to adapt his language according to the level of experience of the group. This makes his learnings clear and accessible to anyone. As a trainer, he is therefore attentive to the needs of his students to make sure they meet their objectives and face the challenges.
Nour Khalifa
Nour Khalifa
Trainer
With a solid background in management IT and holding a Bachelor’s degree in IT Management as well as a Master’s in Artificial Intelligence and Information Technologies, Nour Khalifa supports organizations in developing the digital skills of their teams. She leverages her technical and pedagogical expertise to design and deliver practical, engaging, and learner-centered training programs. Before joining Afi U., Nour held strategic roles such as database administrator, business analyst, and project manager, working in complex technological environments. This experience enables her to offer practical solutions and effectively connect theory to practice. Recognized for her rigor and ability to simplify technical concepts, Nour favors interactive approaches that encourage the adoption of digital tools and skills development. She firmly believes that mastering management technologies is a key driver for performance and professional fulfillment.
Pierre-Edouard Brondel
Pierre-Edouard Brondel
Trainer
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.
Marwa Attafi
Marwa Attafi
Trainer
Marwa Atafi has over ten years of experience in IT, including several strategic projects in business intelligence and decision support systems. Before arriving in Quebec, she taught a wide range of IT subjects and led complex projects, from needs assessment to the implementation of analytical solutions. She has in-depth expertise in Business Intelligence, covering all stages: requirements analysis, data modeling, design, and deployment of interactive dashboards. She is proficient with tools and technologies such as Power BI, Power Apps, Power Automate, SQL Server, ETL (SSIS), and advanced Excel, as well as results-oriented project management methods. Responsible, motivated, and passionate about her field, Marwa stands out for her technical skills and analytical mindset, making her a sought-after and strategic resource.