Excel Basics

Discover Excel with this workshop. Learn how to create a workbook, enter data, manipulate columns and rows, and create a graph.
Microsoft Partner

Upcoming sessions

Show all sessions
Guaranteed to run
  • Duration: 2 days
  • Regular price: $290
  • Preferential price: $250

Course outline

Please note that the most represented version in the group will be installed in computer workstations. However, the training addresses the differences between versions.

Duration : 2 days

© 2021 AFI


Windows - User or equivalent


  • Acquire essential knowledge to create simple tables with Excel
  • Use basic formulas to execute simple calculations
  • Illustrate results using a simple chart

Teaching method

Presentations - Demos - Guided and individual exercises


Chapter 1 - Recognise interface elements

  • Identify components of the environment
  • Identify the parts of Excel
  • Access commands
  • Get help
  • The File tab and the Backstage view mode
  • Start screen, templates, navigation, cloud
Chapter 2 - Open and manipulate a workbook
  • Open a workbook
  • Adapt the on-screen display as needed
  • Navigating a spreadsheet
  • Select cells
  • Freeze titles
Chapter 3 - Create a workbook and enter data
  • Create and save a workbook
  • Recognize the types of data
  • Enter data into a spreadsheet
  • Use the fill handle to create a series of data
  • Save a workbook
  • Close a workbook and exit Excel
  • Cancel or restore the last operations
  • The cloud and templates, choice of sharing, instant fill
Chapter 4 - Manipulate columns, rows or cells
  • Modify the size of columns and rows
  • Insert columns and rows
  • Remove columns and rows
  • Hide columns and rows
Chapter 5 - Create formulas
  • Identify formula features
  • Enter a formula
  • Add cells using the Sum button
  • Use the function assistant
  • Copy formulas
  • Use relative, absolute, or mixed references
Chapter 6 - Manipulate data
  • Copy and move data
  • Search or replace data
Chapter 7 - Apply formatting to cells
  • Apply formats
  • Set the font
  • Align, merge cells, and apply indents
  • Set numeric formats
  • Apply borders and fill colour
  • Manipulate formats
  • Quick analysis and conditional formatting
Chapter 8 - Create a chart
  • Create a chart
  • Manipulate a chart
  • Add a title to a chart
  • Print a chart
  • Use filters and slicers
Chapter 9 - Format and print workbook data
  • Set display mode
  • Set layout
  • Insert page breaks
  • Set a print area
  • View page breaks and print areas
  • Use Print Titles to repeat headers
  • Use scaling and printing options
  • Print spreadsheets

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.
Marc Maisonneuve
Marc Maisonneuve
Trainer and Professional Efficiency Consultant
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.
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.
Training center accredited by Emploi-Québec, Accreditation : 0051460
GST : 141582528 – QST : 1019557738
© 2021 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