Excel 2010 Beginner Regular EX-022

Course Overview

Understand the basic notions of simple database management.

Prerequisites

Windows

Syllabus

Basic Concepts :

  • What is a spreadsheet;
  • Starting Excel;
  • Exploring the Excel user interface;
  • Customizing the ribbon;
  • Customizing the Quick Access toolbar;
  • Importing/Exporting customizations;
  • The Backstage;
  • Excel properties;
  • Using the mouse;
  • Using the keyboard;
  • Getting help.

Data Input :

  • The different data types;
  • Defining the display, the content and the format of a cell;
  • Entering data in a cell;
  • Editing the content of a cell;
  • Undo, redo or repeat an action;
  • Changing the zoom level.

Managing Workbooks :

  • Creating a workbook;
  • Opening a workbook;
  • Saving a workbook;
  • Freezing titles;
  • Displaying many workbooks;
  • Sending a workbook by e-mail;
  • Closing a workbook;
  • Closing Excel.

Editing Techniques :

  • Selecting cells;
  • Moving or copying data;
  • Creating series;
  • Search and replace text.

Basic Calculations :

  • Creating formulas;
  • Using mathematical operators;
  • Understanding the order of calculation;
  • Copying the result of a formula;
  • Changing the way to address cells;
  • Finding errors in formulas.

Functions :

  • Working with functions;
  • Using the AutoSum function;
  • Using statistical functions;
  • Using date/time functions;
  • Using the IF function;
  • Changing the format of a cell.

Managing the worksheet :

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

Formatting Data :

  • Modifying the alignment;
  • Formatting characters;
  • Adding borders;
  • Adding shades;
  • Using styles;
  • Using conditional formatting;
  • Using the format painter.

Page Setup and Printing :

  • Print preview;
  • Modifying page setup options;
  • Controlling page breaks;
  • Setting the print area;
  • Printing.
Duration : 2 Days
Regular Rate : 290.00 $
Preferential Rate : 220.00 $
Note :
Upcoming Dates :
price
qty
Montreal, 5 to 6 Nov. 2018 - 9:00 to 16:00
290.00 $
Brossard, 5 to 6 Nov. 2018 - 9:00 to 16:00
290.00 $
Laval, 5 to 6 Nov. 2018 - 9:00 to 16:00
290.00 $
Montreal, 17 to 18 Dec. 2018 - 9:00 to 16:00
290.00 $
Brossard, 17 to 18 Dec. 2018 - 9:00 to 16:00
290.00 $
Laval, 17 to 18 Dec. 2018 - 9:00 to 16:00
290.00 $
Montreal, 28 to 29 Jan. 2019 - 9:00 to 16:00
290.00 $
Brossard, 28 to 29 Jan. 2019 - 9:00 to 16:00
290.00 $
Laval, 28 to 29 Jan. 2019 - 9:00 to 16:00
290.00 $
Montreal, 5 to 6 Mar. 2019 - 9:00 to 16:00
290.00 $
Brossard, 5 to 6 Mar. 2019 - 9:00 to 16:00
290.00 $
Laval, 5 to 6 Mar. 2019 - 9:00 to 16:00
290.00 $
Montreal, 17 to 18 Apr. 2019 - 9:00 to 16:00
290.00 $
Brossard, 17 to 18 Apr. 2019 - 9:00 to 16:00
290.00 $
Laval, 17 to 18 Apr. 2019 - 9:00 to 16:00
290.00 $
Montreal, 15 to 16 May. 2019 - 9:00 to 16:00
290.00 $
Brossard, 15 to 16 May. 2019 - 9:00 to 16:00
290.00 $
Laval, 15 to 16 May. 2019 - 9:00 to 16:00
290.00 $
Montreal, 11 to 12 Jun. 2019 - 9:00 to 16:00
290.00 $
Brossard, 11 to 12 Jun. 2019 - 9:00 to 16:00
290.00 $
Laval, 11 to 12 Jun. 2019 - 9:00 to 16:00
290.00 $
Montreal, 16 to 17 Jul. 2019 - 9:00 to 16:00
290.00 $
Brossard, 16 to 17 Jul. 2019 - 9:00 to 16:00
290.00 $
Laval, 16 to 17 Jul. 2019 - 9:00 to 16:00
290.00 $
Montreal, 20 to 21 Aug. 2019 - 9:00 to 16:00
290.00 $
Brossard, 20 to 21 Aug. 2019 - 9:00 to 16:00
290.00 $
Laval, 20 to 21 Aug. 2019 - 9:00 to 16:00
290.00 $