Webcast Series

We hope that you will find the Microsoft Office training webcasts useful and that they will help make your work more productive. To participate in most of these webcasts, you'll need to have copies of the practice files so that you can work on them while following the tasks in the webcasts.

To download a copy of the practice file that goes with each webcast, click on the practice file link next to that webcast, choose Save, then save the file to your desktop (or the My Documents folder, or another easily accessible location), so that you can find the document and open it after the download is complete. After this is done, follow the instructions located here to watch the webcast and work on the document at the same time:

Setting up Your PC for Webcasts

NOTE: Some webcasts have more than one practice file associated with them. In these cases, after you click on the link and save the file to your local PC, you will need to right-click the zipped folder and choose “Extract” from the shortcut menu, then click Next until the wizard finishes. The unzipped files will now be available in the same location as the zipped file, and you can delete the zipped file.

NOTE: The material on and related to our webcasts (video, practice files, and lesson notes) are copyrighted and may not be reproduced in any form without the explicit written permission of NESDEC.

Microsoft Word 2003

Tabs & Indents

Word 2003 - Tabs & Indents

  • Setting Tabs
  • Setting Indents
Tools For Working With Long Documents

Word 2003 - Tools For Working With Long Documents

  • Creating a Cross-Reference
  • Inserting a Bookmark
  • Adding Footnotes & Endnotes
  • Building a Table of Contents
  • Compiling an Index
Mail Merge

Word 2003 - Mail Merge

  • Setting Up a Main Document
  • Setting Up a Data Source
  • Adding Records To Data Source
  • Inserting Merge Fields
  • Previewing The Merge
  • Completing The Merge
  • Merging Addresses Onto Labels
Templates & Onscreen Forms

Word 2003 - Templates & Onscreen Forms

  • Using Installed Templates
  • Creating Your Own Templates
  • Creating Onscreen Forms
Page Layout Tools

Word 2003 - Page Layout Tools

  • Setting Margins
  • Inserting Page Breaks
  • Creating Headers & Footers
  • Column Formatting
  • Using Print Preview
Paragraph Formatting

Word 2003 - Paragraph Formatting

  • Horizontal Alignment
  • Vertical Line Spacing
  • Bulleted & Numbered Lists
  • Sorting Paragraphs
Importing & Exporting Information

Word 2003 - Importing and Exporting Information

  • Pasting an Excel Spreadsheet Into Word
  • Pasting and Linking an Excel Spreadsheet in a Word Document
  • Embedding an Excel Spreadsheet Inside a Word Document
  • Linking and Embedding at the Same Time

Microsoft PowerPoint 2003

Charting

PowerPoint 2003 - Charting

  • Creating Charts
  • Entering Data
  • Moving & Sizing a Chart
  • Formatting a Chart
  • Changing The Chart Type
  • Using Charts From Excel
Creating a Presentation

PowerPoint 2003 - Creating a Presentation

  • Creating a Presentation
  • Using The AutoContent Wizard
  • Using a Design Template
  • From Scratch
  • Entering Text On Slides
  • Formatting Text
Moving & Copying Text, Slides, and Graphics

PowerPoint 2003 - Moving & Copying Text, Slides, and Graphics

  • Moving Text Using Cut & Paste
  • Copying Text Using Copy & Paste
  • Moving Text Using Drag & Drop
  • Copying Text Using Drag & Drop
  • Moving & Copying in Outline View
  • Moving Slides in Slide Sorter View
  • Moving & Copying Graphics
Organizational Charts

PowerPoint 2003 - Organizational Charts

  • Creating Org Chart
  • Sizing Org Chart
  • Adding & Deleting Levels
  • Formatting an Org Chart
Slide Show Tools

PowerPoint 2003 - Slide Show Tools

  • Adding Slide Transitions
  • Creating Custom Animation
  • Tools for Use During Slide Shows
  • Setting up Slide Shows
Importing and Exporting Information

PowerPoint 2003: Importing and Exporting Information

  • Importing Word Text Onto a PowerPoint Slides
  • Charting Excel Data On a PowerPoint Slide
  • Importing an Excel Chart Onto a PowerPoint Slide
  • Exporting PowerPoint Text Into Word
  • Copying Slides From Another PowerPoint Presentation Into The Current One
Working With Masters

PowerPoint 2003 - Working With Masters

  • Adding Graphics To Masters
  • Formatting Text In Masters
  • Adding Headers and Footers

Microsoft Excel 2003

Introduction

Excel 2003 - Introduction

  • The Excel Screen
  • Moving Around in a Worksheet
  • Selecting Parts of a Worksheet
  • Entering Data
  • Editing Data
  • Working With Sheets
Moving & Copying

Excel 2003 - Moving & Copying

  • Copying Using Copy & Paste
  • Copying Using Drag & Drop
  • Moving Using Cut & Paste
  • Moving Using Drag & Drop
  • Using The Fill Handle to Copy
  • Using The Format Painter
Collaboration Tools

Excel 2003 - Collaboration Tools

  • Inserting Comments
  • Hiding Columns
  • Password-Protecting Workbooks
  • Locking Cells
  • Linking Two Cells
  • Creating Hyperlinks
  • Saving Workbook as a Web Page
Filtering Data

Excel 2003 - Filtering Data

  • Setting Up An AutoFilter
  • Filtering On One Column
  • Filtering On Multiple Columns
  • Creating Custom Filters
Formulas

Excel 2003 - Formulas

  • Understanding Formulas
  • Creating a Formula
  • Using Functions in Formulas
  • Copying & Moving Formulas
Intermediate Formulas & Functions

Excel 2003 - Intermediate Formulas & Functions

  • Using Dates in Calculations
  • Doing an IF Function
  • Using Statistical Functions
  • Displaying Formula Contents in Cells
Charting

Excel 2003 - Charting

  • Creating a Chart
  • Deleting a Chart
  • Moving & Sizing a Chart
  • Editing a Chart
  • Formatting a Chart
Pivot Tables

Excel 2003 - Pivot Tables

  • Creating a Pivot Table
  • Drilling Down
  • Refreshing a Pivot Table
  • Pivoting a Table
  • Copying a Pivot Table
Using & Creating Templates

Excel 2003 - Using & Creating Templates

  • Using Installed Templates
  • Creating & Saving Your Own Templates
Macros

Excel 2003 - Macros

  • Recording a Macro
  • Using a Macro
  • Editing a Macro
  • Deleting a Macro

Windows XP

Introduction

Windows XP - Introduction

  • Understanding The Desktop
  • Viewing Object Properties
  • Customizing The Desktop
  • Creating Shortcuts
File Management

Windows XP - File Management

  • Creating Files
  • Saving Files
  • Moving & Copying Files
  • Renaming Files
  • Deleting Files
 
NESDEC Home Page