Excel 2013/2016/2019/2021/365 Beginner for Professionals EX-026

Course Overview

Mastering the basics features of Excel to create a simple spreadsheet from the design phase to the printing process.

Prerequisites

A good knowledge of Microsoft Windows.

Syllabus

Basic Concepts:

  • What is a spreadsheet;
  • Starting Microsoft Excel;
  • The Excel environment.

Data Entry:

  • The different data types;
  • Setting the display, the content and the format of a cell;
  • Data entry;
  • Editing data.

Workbook Management:

  • Creating a new workbook;
  • Opening a workbook;
  • Saving a workbook;
  • Saving and sharing files online;
  • Freezing titles;
  • Viewing multiple workbooks;
  • A workbook, a window.

Editing Techniques:

  • Selecting cells;
  • Moving or copying cells;
  • Using the Auto Fill feature.

Basic Calculations:

  • Creating a formula;
  • Using mathematical operators;
  • Identifying the order of calculation;
  • Copying the result of a formula;
  • Modifying the reference type.

Functions:

  • Creating a formula using functions;
  • Using the SUM function;
  • Adding a range of data using the instant data analysis tools;
  • Using Statistical functions;
  • Changing the format of cells.

Spreadsheet Management:

  • Changing the width of a column;
  • Changing the height of a row;
  • Inserting or deleting cells;
  • Inserting or deleting rows or columns;
  • Hiding rows or columns.

Formatting Data:

  • Modifying the alignment;
  • Formatting characters;
  • Adding borders;
  • Applying shades to cells;
  • Using conditional formatting;
  • Copying and pasting formatting.

Page Layout and Printing:

  • Using the Print Preview feature;
  • Modifying the page layout options;
  • Using the Page Layout view;
  • Editing page breaks;
  • Defining the print area;
  • Printing a spreadsheet.
Duration : 1 Day
Regular Rate : 175.00 $
Preferential Rate : 148.75 $
Note :

Upcoming Dates

qty

Montreal

25 Mar 2024 - 9:00 to 16:00

Virtual Class

25 Mar 2024 - 9:00 to 16:00

Confirmed

Virtual Class

26 Apr 2024 - 9:00 to 16:00

Laval

10 May 2024 - 9:00 to 16:00

Virtual Class

10 May 2024 - 9:00 to 16:00

Virtual Class

3 Jun 2024 - 9:00 to 16:00

Montreal

28 Jun 2024 - 9:00 to 16:00

Virtual Class

3 Jul 2024 - 9:00 to 16:00

Virtual Class

12 Aug 2024 - 9:00 to 16:00

Montreal

6 Sep 2024 - 9:00 to 16:00

Virtual Class

6 Sep 2024 - 9:00 to 16:00

Laval

11 Oct 2024 - 9:00 to 16:00

Virtual Class

11 Oct 2024 - 9:00 to 16:00

Virtual Class

11 Nov 2024 - 9:00 to 16:00

Virtual Class

22 Nov 2024 - 9:00 to 16:00

Virtual Class

2 Dec 2024 - 9:00 to 16:00

Qualifying educational activities