Excel 2007, Regular Beginner EX-019

Course Overview

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


Prerequisites

Microsoft Excel 2007 Beginner

Syllabus

Day 1

Basic Concepts :

  • What is a spreadsheet;
  • Excel’s properties Starting Excel;
  • The Excel environment;
  • Opening a workbook;
  • The different pointer shapes;
  • Understanding the Keyboard;
  • Moving around a spreadsheet;
  • The different data types;
  • The display, content, and format of a cell;
  • Data input;
  • Editing the content of a cell;
  • Erasing one or many cells;
  • Saving a workbook;
  • Setting AutoSave;
  • Sending a file by e-mail;
  • E-mailing a selected range.

Environment :

  • Managing workbooks;
  • Using drop-down menus;
  • Customizing the toolbar;
  • Using context-sensitive menus;
  • Viewing a document before printing;
  • Using zoom;
  • Using Smart Tags;
  • Using the Help features.

Editing Techniques :

  • Selecting cells;
  • Copying and moving data;
  • Filling a range with data series;
  • Undoing and redoing previous actions;
  • Finding and replacing;
  • Freezing titles.

Basic Calculations :

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

Day 2

Formulas :

  • Cell addressing;
  • Creating formulas using other functions;
  • Editing a formula;
  • Changing number formats;
  • Using the IF function;
  • Using the Date and Time functions;
  • Using the Round Function.

Spreadsheet Management :

  • Inserting columns and rows;
  • Deleting columns and rows;
  • Changing column width;
  • Changing row height;
  • Hiding columns or rows;
  • Displaying columns or rows;
  • Naming cells.

Formatting Worksheets :

  • Modifying the alignment;
  • Formatting characters;
  • Adding borders;
  • Adding patterns;
  • Using automatic formatting;
  • Conditional formatting.

Page Setup :

  • Modifying Page Setup options;
  • Inserting an image into the header and footer;
  • Working with manual page break;

Printing. Appendix:

  • Toolbars;
  • Keyboard shortcuts.

Share

[ssba]


Duration : 2 days
Regular Rate : $290
Preferential Rate : $220
Notes :


Upcoming Dates

[ESPRESSO_TICKET_SELECTOR event_id=13409]

Duration : 2 Days
Regular Rate : 290.00 $
Preferential Rate : 220.00 $
Note :
Upcoming Dates :
price
qty
Montreal, 11 to 12 Oct. 2018 - 9:00 to 16:00
290.00 $
Brossard, 11 to 12 Oct. 2018 - 9:00 to 16:00
290.00 $
Laval, 11 to 12 Oct. 2018 - 9:00 to 16:00
290.00 $
Montreal, 5 to 6 Nov. 2018 - 9:00 to 4: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 Jan 2019 - 9:00 to 16:00
290.00 $
Brossard, 28 Jan 2019 - 9:00 to 16:00
290.00 $
Laval, 28 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, 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 $
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 $