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

© AFI Expertise inc.

Prerequisites

Windows - User or equivalent

Objectives

  • 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 - Facilitated and individual exercises

Contents

Chapter 1 - Identify interface elements

  • Identify components of the environment
  • Identify the particular elements of Excel
  • Access commands
  • Get help
  • The File tab and 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
  • Navigate in a sheet
  • 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 sheet
  • Use the fill handle to enter a series of data
  • Save a workbook
  • Close a workbook and exit Excel
  • Cancel or restore the last operations
  • The cloud and models, 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 segments
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
  • Print descriptive titles
  • 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.
Leif Martin Bédard
Leif Martin Bédard
Trainer and Desktop Application Consultant
Specialized in the Microsoft suite and with a background in accelerated learning, Leif is a trainer whose communication approach and adaptability are always fully appreciated
Mohamed Righi
Mohamed Righi
Trainer
Mohamed lets you go at your own pace to learn new ways of using IT tools in your work.
Marc Maisonneuve
Marc Maisonneuve
Trainer and Professional Efficiency Consultant
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