Microsoft Word, Excel, Access
XP & 2003 Tutorial Training on 3 DVDs
  
Regular Price $158.95
Sale Price $49.57
Available on DVD-Rom or CD-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
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 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 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.57
| |
Minimum System Requirements |
| |
Pentium class CPU operating at 266MHz |
| |
128 MB of RAM (256 MB for Win NT 4.0 or 2000) |
| |
CD-ROM drive, at least 12x recommended. |
| |
Windows 98, ME, NT 4.0, 2000 or XP |
| |
SVGA monitor at least 16 bit color & 1024x768 resolution |
| |
Sound card with speakers or headphones |
| |
The Faster your system, the better the demos will run |
|
|
After Effects Training
