Excel - Creating a simple and professional document

Microsoft Partner

Upcoming sessions

Show all sessions
Guaranteed to run
  • Duration: 1 day
  • Regular price: $360
  • Preferential price: $306

Course outline

Duration : 1 day

© AFI Expertise inc.

Prerequisites

Windows - User or equivalent

Objectives

  • Acquire essential knowledge to create simple tables with Excel

Teaching method

Presentations - Demos – Guided and individual exercises

Contents

Chapter 1 - Identify interface elements

  • Recognise 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 Exce
  • 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 - Manipulate data

  • Copy and move data
  • Search or replace data

Chapter 6 - 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 7 - 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

Khalil Ben Fadhel
Khalil Ben Fadhel
Trainer, Data Science - AI
Khalil is an artificial intelligence expert working at Leap Conseil. Thanks to its extensive expertise in the managing and conducting artificial intelligence projects, Khalil has co-worked with several public and private sector organizations to carry out innovative projects.
Fazil Chouakri
Fazil Chouakri
VP Technology, Coach and Trainer
Fazil is a coach and trainer with solid experience in the field, which allows him to combine the practical and the theoretical to meet his students’ needs.
Philippe Paradis
Philippe Paradis
Certified Trainer and IT Consultant
Obsessed with the quality of services he provides and the solutions he develops, Philippe always makes sure he delivers more than what people expect, all while ensuring a pleasant learning experience.
Michel Laporte
Michel Laporte
Trainer and IT consultant
Michel possesses the ability to translate needs into IT solutions. His mission is to help his clients surf the ceaselessly accelerating technology wave.
Be aware of trends, innovations and best practices, every month.
Confidentiality
Training center accredited by Emploi-Québec, Accreditation : 0051460
GST : 141582528 – QST : 1019557738
© 2022 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