How To GurusQuality Training since 1995 
 

 

 

 

 

 

 


Microsoft Word, Excel, Access
XP - 2003 Tutorial Training on 3 DVDs

Microsoft Word, Excel, Access XP - 2003 Tutorial Training   Microsoft Word, Excel, Access XP - 2003 Tutorial Training   Microsoft Word, Excel, Access XP - 2003 Tutorial Training

Regular Price $158.95
Sale Price $49.87
Available on DVD-Rom

This Microsoft Office Tutorial Training set
is filled with over 20 hours of video tutorial training.
250 individual video lessons.
Covers every topic that you need to know.
Includes all working files and examples.

Comments by recent purchasers

Note: These are Computer DVDs and will not play on a TV style DVD player
Note: This training is for Windows
and does not come with the Adobe InDesign program
Our training videos can be viewed on a Mac.
Visit our Mac page for more info.

This new HTG title provides training for Microsoft Word/Excel/Access XP (Version 2002) and Microsoft Word/Excel/Access 2003. Each HTG training software title guides you quickly and easily through comprehensive, step-by-step video tutorials.

This training is for the Windows platform and will play on all current versions of Windows.

Boost your Microsoft Office skills to full speed quickly and easily with this latest course clearly demonstrated by top training guru, George Peirson.

Learn how to create professional level animations and video sequences. Our Computer based training shows you how!

This outstanding set covers not just the basics, but provides practical information, clear-cut demonstrations, and project applications you can use immediately.


Lessons are laid out in a logical, easy-to-follow format, guiding you step-by-step through the tools and processes you need. Beginning with an overview of the principles involved, each lesson moves on to a step-by-step demonstration of the tool or process, followed by a hands-on, practical application project that lets you experience how to use this new information in your everyday work.

By using this training, you will learn how to use Microsoft Office, discover how to maximize your learning, and truly master this powerful program to become an Microsoft Office Guru.

Click here to view a sample lesson
This video has been compressed for streaming over the web.

You do not need to have Microsoft Office installed on your computer to view this training. Although you will need your own copy of Microsoft Office installed to do the exercises.

Explore the world's most popular video effects program. Our in-depth, easy-to-follow courses lead you through common tasks using a clear, step-by-step approach. HTG Training takes the guesswork out of mastering this software.

Learn exactly what you need to know with our interactive multimedia courseware. Our training teaches fundamental and advanced techniques and lets you apply what you have learned today.

We are including all Materials with examples from all the projects and additional files, that let you work along with the tutorials and try out all of our demonstrations on your own machine using the same files we use in the demos.

Complete List of Video Lessons

Microsoft Word, Excel, Access XP - 2003 Tutorial Training
New Permissions Settings

Microsoft Word XP-2003

Microsoft Word Part 1

What is Microsoft Word?
Overview
  What's New 2002 - 1
  What's New 2002 - 2 
  What’s New 2002 – 3
  What’s New 2003 – 1
  What’s New 2003 - 2

Basic Word Tasks
  Creating a Document
  Working with Paragraphs 
  Headers & Footers
  Adding Text    
  Formatting Text 
  Using Pictures
  Save and Save As
  Printing the Document  

Microsoft Word Workspace
  The Workspace 
  2003 - Document Workspaces 
  The Word Toolbar  
  2003 – New Buttons   
  The Office Assistant 
  Adjusting Options

Microsoft Word Menus
  The File Menu 
  2003 File Menu changes
  The Edit Menu 
  The View Menu 
  2003 View Menu changes
  The Insert Menu
  The Format Menu
  The Tools Menu
  2003 Tools Menu changes
  The Table Menu
  The Window & Help Menus
  2003 Window Menu changes
  2003 Help Menu changes

 

Microsoft Word Part 2

Microsoft Word Editing & Proofing
  AutoCorrect & Complete
  Undoing Mistakes
  Searching
  Changing Pictures
  Tracking Changes
  2003 Tracking updates
  Checking Spelling
  Checking Grammar
  Using the Thesaurus

Formatting
  Working with Fonts
  Special Characters
  Alignment
  Lists
  Using Tabs
  Setting Indents
  Setting Line & Page Breaks
  The Task Pane
  Adding Decoration
  Sorting Text
  Numbering Pages
  Using Fields

Pictures & Clip Art
  Using Clip Art
  Using Pictures
  Drawing with Word
  Editing Images

Microsoft Word Part 3

Tables  
  Inserting a Table
  Navigating
  Editing a Table
  Formatting a Table
  Table Auto Format
  Table Cells
  Converting Text to Table
  Table Formulas

Microsoft Word Themes & Styles
  AutoFormat
  Word Themes
  The Style Gallery
  The Organizer

Microsoft Word Mail & Envelopes
  Using Data Source
  Mail Merge Wizard
  Labels & Envelopes
  Letter Wizard

Macros & Other Programs
  About Macros
  Recording Macros
  Running Macros
  Using Macros
  Inserting Objects
  HTML Pages
  Hyperlinks
  Saving as PDF

Microsoft Word, Excel, Access XP - 2003 Tutorial Training

Microsoft Excel XP - 2003

Microsoft Excel Part 1

Microsoft Excel Overview   
  How to use this Training
  Overview
  What's New in Office XP
  What's New in XP 1
  What's New in XP 2
  What's New in XP 3
  What’s New in 2003 1
  What’s New in 2003 2

The Microsoft Excel Workspace
  The Workspace
  The Office Assistant
  Customize
  Properties

Microsoft Excel Document Basics
  Open & New
  Data
  Formulas
  Charts
  Cel Formatting
  Pictures
  Saving
  Printing

Part 2

Microsoft Excel Menus
  File
  2003 File Menu
  Edit
  View
  2003 View Menu
  Insert
  Format
  Tools
  2003 Tools Menu
  Data
  2003 Data Menu
  Window & Help
  2003 Window Menu
  2003 Help Menu

Microsoft Excel Formulas & Functions
  Formulas
  References
  Insert Function Wizard
  Formula Auditing
  Functions
  Dates
  Text
  Information

Layout & Formatting
  Cells & Rows
  Moving & Copying
  Sheets
  Comments
  Cell Attributes
  Borders & Shading
  Numeric Formats
  Hiding & UnHiding

Microsoft Excel Part 3

Microsoft Excel Cell Referencing
  Relative & Absolute
  Mixed Referencing
  3D Referencing
  R1C1 Style

Microsoft Excel Printing
  Page Setup
  Header & Footer
  Print Preview
  Printing Controls

Microsoft Excel Worksheets & Workbooks
  Splitting & Freezing
  Troubleshooting
  Templates
  Smart Tags
  Workbooks
  Multi-Sheet Workbooks
  Comments
  Collaboration
  2003 Shared Workspace

Microsoft Excel Auditing & Advanced Functions
  Tracking Changes
  Cell Relationships
  Error Correction
  Circular References
  Conditional Formulas
  Calculation Operators
  Order Precedence
  Nested Functions

Microsoft Excel Common Formulas
  Look Up Values
  Multiplication Table
  Convert Measurements
  Text & Other Functions
  Date & Time Entry
  Formatting Dates
  Convert Times
  Insert Julian Dates

Microsoft Word, Excel, Access XP - 2003 Tutorial Training

Microsoft Access XP - 2003

Microsoft Access Part 1

Microsoft Access Overview
  How to use this training
  What is a database?
  Relational databases
  Opening a database
  Menus and toolbars
  Using Help in XP
  2003 - Using Help in 2003

Microsoft Access 2003 - What’s New in 2003
  2003 - What’s New Overview
  2003 - Improved Security
  2003 - Object Dependencies
  2003 - Auto Type Correction
  2003 - Error Checking
  2003 - SharePoint Services
  2003 - XML Support

Microsoft Access Tables & Records
  Open, Close
  Viewing & Scrolling
  Resizing
  Freezing & Unfreezing
  Searching
  Arranging Records
  Using Filters
  Using Forms

Microsoft Access Queries
  About Queries
  Creating a Query
  Retrieving Records
  Using design view
  Calculating Values
  Creating a new table
  Updating records
  Indexing


Microsoft Access Part 2

Microsoft Access New Database
  Planning
  Creating Tables
  Design View
  Data Types
  2003 - Backup Database

Microsoft Access Records & Data
  Entering Records
  Using AutoCorrect
  Using & Editing Text
  Spelling Check
  Getting Data
  Exporting Data
  Merging Data
  Using Data

Microsoft Access Reports & Forms
  Reports overview
  Design View
  Building a Report
  Previewing and Printing
  Access Forms
  Modifying a form
  Creating from Scratch
  More Controls

Microsoft Access Data Access & Improvements
  Data Access Wizards
  Modifying Page
  Creating in Design View
  Testing in HTML
  Text
  Lines & Borders
  Pictures
  Clip Art

Microsoft Access Part 3

Microsoft Access Databases & Tables
  The Working Environment
  What Data?
  Planning the Database
  Deciding on structure
  Building a Table
  Using Table Wizards
  Using Design View
  Modifying Tables
  2003 – Create Local Table

Microsoft Access Constructing Forms
  Building a Form
  Using Form Wizards
  Using Design View
  Modifying Forms
  2003 – Sort in Boxes

Microsoft Access Using Queries
  Building a Query
  Using Query Wizards
  Using Design View
  Modifying Queries
  Expression Builder
  Linking Objects
  Analyze the database
  Database Security

Microsoft Access Designing Reports
  Building a Report
  Using Report Wizards
  Using Design View
  Modifying Reports

This Microsoft Office Tutorial Training set
is filled with over 20 hours of video tutorial training.
250 individual video lessons.
Covers every topic that you need to know.
Includes all working files and examples.

Regular Price $158.95
Sale Price $49.87

Microsoft Word, Excel, Access XP - 2003 Tutorial Training

 

Home | Company |Policy | Sitemap | Testimonials | Free Tutorials

Making Money on the Web | Photoshop | Photoshop Elements | InDesign | After Effects | Premiere | Illustrator | Flash | Dreameaver
JavaScript | HTML | CSS | Fireworks | PageMaker | QuarkXPress | Microsoft Office | Internet Security


Follow howtogurus on Twitter

© 2017 How To Gurus, all rights reserved