Part 1: MS Excel Introduction

Basics   Standard toolbar overview Formatting toolbar overview Data entry Block selection Copying data Moving data Inserting cells, rows and columns Deleting cells, rows and columns Resizing rows and columns Using the AutoFit facility Undoing and redoing operations Spell checking Printing a spreadsheet   Formatting   Setting alignment Using cell shading Adding borders to cells Using Autoformat Number and date Formats Creating styles Applying styles Modifying Styles Using conditional formatting

Formulas   Formulas How formulas work About cell references About Excel ranges Overview of functions Using the AutoSum facility Using the formula palette Using conditionals Statistical functions Financial functions Creating external references Charts   Creating a chart Setting chart options Editing chart elements Editing chart data Adding logos and graphics Printing charts   Productivity   Creating reports Setting print options Creating custom lists AutoCorrect Password protecting documents Protecting worksheets Using hyperlinks Save As Web Page Web Page Preview

Part 2: MS Word Introduction

Creating a document   Creating a new document Using Wizards Using Templates Saving documents Copying an existing document Entering text Obtaining help Asking help questions The Office Assistant Context Sensitive help Setting up a document   Setting margins Selecting a paper size Setting the page orientation Previewing a document Printing a document Modifying a document   Selecting text Selectng lines of text Selecting a range of text Inserting text Replacing text About the Clipboard Using Cut, Copy and Paste Drag and drop editing Basic formatting Using Click and Type Automatically inserting the date Useful keyboard shortcuts Formatting text   Character formatting Paragraph formatting Aligning text Changing line spacing Inserting space between paragraphs Inserting special characters Useful keyboard shortcuts Using the Format Painter

Checking and auto-enter   Using the Spell-Checker Grammar checking Using the Thesaurus The Word Count feature Using AutoCorrect Using AutoText Adding AutoText entries Find and Replace   Tabs, indents and lists   Creating tabs Tab alignment types Using leader characters Indenting paragraphs Types of indentation Creating a numbered list Creating a bulleted list Customising numbering Customising bullets   Tables   Inserting a table Selecting table elements Formatting cells Using AutoFormatting Inserting rows and columns Deleting rows and columns Convert Text to Table   Mail merge   Creating a main document Specifying a data source Creating a data document Inserting merge fields Previewing merged documents Personalising individual items Creating form letters Creating mailing labels   Inserting elements   Inserting page breaks Inserting section breaks Working with multiple columns Headers and footers Page numbering Inserting graphics Inserting clip art

Part 3: MS PowerPoint Introduction

First steps   What can PowerPoint produce Creating a blank presentation From Design Template From AutoContent Wizard Adding basic slide content Saving a presentation   PowerPoint views   Normal view Outline view The Slide tab Slide view The Slide pane The Notes pane Slide Sorter view The Slide Show   Editing slides   Creating new slides Overview of slide types Duplicating slides Reordering slides Using Copy and Paste Deleting slides Hiding and showing slides   Working with text   Creating new slides Overview of slide types Duplicating slides Reordering slides Using Copy and Paste Deleting slides Checking your spelling   Graphics   Importing bitmapped images Importing vector images Editing vector images Using Recolor images Inserting clip art Outlining   Adding content in outline mode Changing the level of an item Useful keyboard shortcuts Collapsing and expanding text Importing text into an outline Exporting an outline The slide master   What is the Slide Master? What is the Title Master? Formatting placeholders Setting the slide background Using a background image   Notes and handouts   Notes page view The Notes Master Handout options Previewing handouts The Handout Master   Output   Running a slide show Creating a looping presentation The Pack and Go Wizard The PowerPoint Viewer Printing presentations

REGISTRATION FORM

REGISTRATION STEPS:

1. Fill out our Registration form.
   
   
2. One of our staff members will contact you at the telephone number you included on your registration form to confirm your registration.

4 methods of payment

The payment is made:

• by a credit card (VISA, MASTERCARD and AMERICAN EXPRESS)
  
  
• from your PayPal account through the system PayPal
  
  
  
  
• by cheque or money order for the residence of Canada and USA.
  
  The cheques and money orders for New Image College of Design and Technology send to the address:
  
  1001 Finch Av. West. Suite 200-A
  Toronto. Ontario
  M3J 2C7 Canada



• Through the bank transfer on the account of College in Toronto (for the residence of CIS, Western and Eastern Europe)

  The account for payment:
  
  New Image College of Design and Technology
  1001 Finch Av. West. Suite 200-A
  Toronto. Ontario. M3J 2C7
  Canada.
  
  TD Canada Trust Bank
  254 Lakeshore Rd. West
  Mississauga ON. L5H 1G6
  SWIFT CODE: TDOMCATTTOR
  ABA #026009593
  Transit # 05352
  Institution # 004
  Account # 83897301091