Excel 2019 Beginner for Professionals EX-034

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 : 150.00 $
Preferential Rate : 127.50 $
Note :
Upcoming Dates :
qty
Laval
9 Dec 2020 - 9:00 to 16:00

Montreal
20 Jan 2021 - 9:00 to 16:00

Virtual Class
20 Jan 2021 - 9:00 to 16:00

Montreal
19 Feb 2021 - 9:00 to 16:00

Virtual Class
19 Feb 2021 - 9:00 to 16:00

Montreal
26 Mar 2021 - 9:00 to 16:00

Virtual Class
26 Mar 2021 - 9:00 to 16:00

Brossard
7 Apr 2021 - 9:00 to 16:00

Montreal
26 Apr 2021 - 9:00 to 16:00

Virtual Class
26 Apr 2021 - 9:00 to 16:00

Laval
11 May 2021 - 9:00 to 16:00

Virtual Class
8 Jun 2021 - 9:00 to 16:00

Virtual Class
9 Jul 2021 - 9:00 to 16:00