Part 1: MS Excel Advanced

Data manipulation   Automatic outlining Group and ungroup Filtering data Advanced filtering Sorting data Inserting Subtotals Creating an Advanced Filter Single input data tables Double input data tables   Formulas and functions   Complex If statements Using nested functions Using named regions Using lookup functions Using database functions The DSUM Function The DAVERAGE Function The DCOUNT Function The DGET Function The DMIN Function The DMAX Function		Tools   Creating scenarios Scenario summary reports Protecting scenarios Using Goal Seek Using the Solver Working with views What-if analysis   Overview of PivotTables The PivotTable Wizard Formatting PivotTables Rearranging PivotTables Sorting data Grouping data Using AutoShow Overview of PivotCharts The PivotChart Wizard   Macros   Recording a Macro Running a Macro Macro buttons   Collaboration   Working with Shared Workbooks Reviewing Workbooks Sending Workbooks Tracking changes Resolving conflicts Merging Workbooks

Part 2: MS Excel VBA Programming

Basics   Excel VBA overview Understanding macro steps Modifying macro steps Storing values in variables Adding comments to your code Stepping through macros Getting help on macros Objects, properties and methods About Excel objects Range object   The Selection property The Range property Targetting cells Counting the cells in a selection Using the Offset statement Retrieving the value of a cell Retrieving a formula from a cell Setting the value of cells

Using Visual Basic   Language structure Using variables Declaring variables Data types Making decisions If statements Looping structures   Interactivity   Assigning a macro to a menu Assigning a macro to a toolbar Assigning macros to other objects Built-in dialogue boxes Using form controls

Part 3: MS Word Advanced

Long/complex documents   Using the Document Map Working in outline view Creating master documents Creating subdocuments The outlining toolbar Controlling headers and footers Sectioning documents   Table of contents, index, etc   Creating a table of contents Creating a table of figures Creating indexes Adding footnotes Using bookmarks Using cross-references Using captions   Style sheets and themes   Creating a style Paragraph and character styles Table and list styles Applying styles Moving styles between documents Reveal formatting Keeping track of formatting Applying a theme Setting a default thems Removing a theme   Drawings and diagrams   Using the drawing toolbar The drawing canvas Adding text to drawings Creating diagrams Creating organisation charts Aligning and distributing objects Inserting WordArt Using autoshapes Creating flow charts   Templates   How templates work The Normal template Global templates Creating a template Attaching a template Modifying a template Document security   Password protection overview Password to open Password to modify Read-only recommended Automatic backup Versioning a document Editing document versions Customization   Customizing toolbars Creating a new toolbar Customizing menus Deleting menu items Rename a menu Rename a menu item Customizing keyboard shortcuts Restoring default settings   Macros   Overview of macros Recording a new macro Inserting extra steps Deleting steps Attaching a macro to a button Customizing a button

Part 4: MS Word VBA Programming

Basics   Overview of Word VBA Generating code by recording The Word Object Model The Visual Basic Editor The Project Explorer Creating sub procedures Importance of comments Printing your code Manipulating text   Insert After/Before Selecting text Using the Text property Retrieving text from a selection Formatting a selection Toggling formatting Finding and replacing text Objects, properties, methods   About objects and collections Returning an object Working with methods Working with properties Programming structures   Variables and constants Declaring and typing variables Using conditional structures Using looping structures

Ranges   The Range object Ranges and navigation The Characters collection The Words collection The Sentences collection The Paragraphs collection The Font object The ParagraphFormat object   Dialog boxes   Built-in dialog boxes Dialog box settings Capturing return values Dialog box events   Controls   Overview of ActiveX controls Creating userforms Adding controls to a userform Setting properties Creating event procedures Displaying a userform Dismissing a userform

Part 5: PowerPoint Advanced

Managing presentations   Using summary slides Inserting slides from other presentations Find and Replace Hiding a slide Showing a hidden slide during a presentation Charts   About Microsoft Graph About chart placeholders Creating a new chart Editing the datasheet Importing Excel data Overview of chart types Formatting charts Adding titles and labels Tables   Inserting a new table Drawing a new table Adding rows and columns Formatting a table Selecting table elements Merging and splitting cells Rotating text in tables Templates and Color Schemes   Saving a presentation as a template Adding templates to the AutoContent Wizard Modifying colour schemes Deleting colour schemes Importing colour shcemes

Animation   Overview of animation Preset vs custom animation Animating text Creating a custom motion path Editing a motion path Reversing a motion path Setting animation timings Previewing animations   Multimedia   Inserting video clips Setting video options Resizing video clips Inserting animated GIFs Adding sound to a presentation Recording sound onto a slide Playing a CD during a presentation Importing Flash movies   Timings and transitions   Applying transitions to slides Varying transitions between slides Setting timings manually Setting timings by rehearsing Activating and de-activating timings during a slide show   Customized presentations   Creating a custom show Adding and removing slides Previewing a custom show Presenting a custom show Adding hyperlinks Linking to a custom show

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