EX-018 Excel 2007, Beginner for professionals EX-018

Course Overview

Create a simple spreadsheet from the conception to printing using the available tools.

Prerequisites

Microsoft Windows Beginner

Syllabus

Basic Concepts :

  • What is a spreadsheet;
  • Excel’s properties Starting Excel;
  • The Excel environment;
  • Opening a workbook;
  • The different pointer shapes;
  • Moving around a spreadsheet;
  • The different data types;
  • Data input;
  • Editing the content of a cell;
  • Erasing one or many cells;
  • Saving.

Environment :

  • Managing windows;
  • Using icons;
  • Using drop-down menus;
  • Using context-sensitive menus;
  • Viewing a document before printing;
  • Using zoom;
  • Using the Help features.

Editing Techniques :

  • Selecting cells;
  • Undoing and redoing previous actions.

Basic Calculations :

  • Using the AutoSum function;
  • Copying formulas and functions;
  • Creating formulas.

Formulas :

  • Using other functions;
  • Changing number formats.

Managing the worksheet :

  • Inserting columns and rows;
  • Deleting columns and rows;
  • Changing column width;
  • Changing row height.

Formatting Worksheets :

  • Modifying the alignment;
  • Formatting characters;
  • Using automatic formatting.

Page Setup :

  • Modifying Page Setup options;
  • Printing.
Duration : 1 Day
Regular Rate : 145.00 $
Preferential Rate : 110.00 $
Note :
Upcoming Dates :
price
qty
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 $
Quebec, 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 $