Excel - Creating Charts - 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 - Creating Charts

Use different tools to bring out the data, use charts to represent your results, apply conditional formatting, create charts and sparklines, import external data.
Microsoft Partner

Upcoming sessions

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.

Use a variety of tools to highlight information and bring your data to life through visual representations. This training will teach you how to master conditional formatting, create effective and customized charts, create Sparklines, import external data, and manage custom views.

Prerequisites

Windows - User or equivalent

Have to work with graphics

Objectives

  • Use different tools to bring out the data
  • Use charts to represent your results

Teaching method

Presentations - Demos - Guided and individual exercises

Contents

Chapter 1 – Apply conditional formatting

  • Introduction to simple conditional formatting rules
  • Use predefined formatting
  • Create custom conditional formatting

Chapter 2 – Create charts

  • Create the right type of chart
  • Manipulate and customize a chart
  • Create special graphics (waterfalls, Funnel, …)
  • Save a chart as a template

Chapter 3 – Create Sparklines

  • Identify the items of a Sparkline
  • Create and modify a Sparkline
  • Personalize a Sparkline

Chapter 4 – Import external data

  • Convert a text file in Excel
  • Recognize the characteristics of text files
  • Distribute text in columns
  • Manipulate text data using preprogrammed functions

Chapter 5 – Create and manipulate custom views

  • Define the usefulness of custom views
  • Create a custom view
  • Use a custom view

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.