Excel 2010 Beginner for professionals EX-025

Course Overview

Understand the basic features of Excel and create a simple spreadsheet from the conception to printing.

Prerequisites

A good knowledge of Microsoft Windows.

Syllabus

Basic Concepts :

  • What is a spreadsheet;
  • Starting Microsoft Excel;
  • Exploring the Excel user interface.

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.

Managing Workbooks :

  • Creating a workbook;
  • Opening a workbook;
  • Saving a workbook;
  • Freezing titles;
  • Displaying many workbooks;
  • Closing a workbook;
  • Closing Excel.

Editing Techniques :

  • Selecting cells;
  • Moving or copying data.

Basic Calculations :

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

Functions :

  • Working with functions;
  • Using the AutoSum function;
  • Using statistical functions;
  • 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 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 : 1 Day
Regular Rate : 145.00 $
Preferential Rate : 110.00 $
Note :
Upcoming Dates :
price
qty
Montreal, 18 Oct 2018 - 9:00 to 16:00
145.00 $
Brossard, 18 Oct 2018 - 9:00 to 16:00
145.00 $
Laval, 18 Oct 2018 - 9:00 to 16:00
145.00 $
Brossard, 13 Nov 2018 - 9:00 to 16:00
145.00 $
Laval, 13 Nov 2018 - 9:00 to 16:00
145.00 $
Montreal, 13 Dec 2018 - 9:00 to 16:00
145.00 $
Brossard, 13 Dec 2018 - 9:00 to 16:00
145.00 $
Laval, 13 Dec 2018 - 9:00 to 16:00
145.00 $
Montreal, 21 Jan 2019 - 9:00 to 16:00
145.00 $
Brossard, 21 Jan 2019 - 9:00 to 16:00
145.00 $
Laval, 21 Jan 2019 - 9:00 to 16:00
145.00 $
Montreal, 20 Feb 2019 - 9:00 to 16:00
145.00 $
Brossard, 20 Feb 2019 - 9:00 to 16:00
145.00 $
Laval, 20 Feb 2019 - 9:00 to 16:00
145.00 $
Montreal, 26 Mar 2019 - 9:00 to 16:00
145.00 $
Brossard, 26 Mar 2019 - 9:00 to 16:00
145.00 $
Laval, 26 Mar 2019 - 9:00 to 16:00
145.00 $
Montreal, 26 Apr 2019 - 9:00 to 16:00
145.00 $
Brossard, 26 Apr 2019 - 9:00 to 16:00
145.00 $
Laval, 26 Apr 2019 - 9:00 to 16:00
145.00 $
Montreal, 4 Jun 2019 - 9:00 to 16:00
145.00 $
Brossard, 4 Jun 2019 - 9:00 to 16:00
145.00 $
Laval, 4 Jun 2019 - 9:00 to 16:00
145.00 $
Montreal, 9 Jul 2019 - 9:00 to 16:00
145.00 $
Brossard, 9 Jul 2019 - 9:00 to 16:00
145.00 $
Laval, 9 Jul 2019 - 9:00 to 16:00
145.00 $
Montreal, 27 Aug 2019 - 9:00 to 16:00
145.00 $
Brossard, 27 Aug 2019 - 9:00 to 16:00
145.00 $
Laval, 27 Aug 2019 - 9:00 to 16:00
145.00 $