Free Microsoft Office Training and Tutorial Resources

Blog Roll:
Free Microsoft Office Training & Tutorials
Free Adobe & Macromedia Training & Tutorials
Free Web Development Training & Tutorials
Intelligentedu.com Blogs
- Free Technical Computer Training
- Free Computer Books & Ebooks

Top Links:
Free Training By Email
Free Computer Training from EdComp
Free Computer and I.T. Training

March 8, 2011

2 Excel 2003 Tutorials

Here are 2 Excel 2003 Tutorials, from by Hillsborough Community College, that will help you learn many of Excel’s basic features, along with how to enter and use formulas and charts. These tutorials include some nicely done screen shots that help in demonstrating the features presented.

Excel 2003 Training Tutorial I
(30 pages, 786kb, pdf)
Upon completion of this Excel training module, you will know and be able to:
1. Use the Menu bar, Standard and Formatting Toolbars;
2. Know the parts of an Excel worksheet;
3. Know how to open and save a workbook;
4. Use the Page Setup Dialog box;
5. Insert a row, column, or worksheet;
6. Format a cell;
7. Change the font type, style, size and color of a cell or range of cells;
8. Create a border around a range of cells;
9. Use basic Excel formulas;
10. Know how to use the Chart Wizard to create a chart

Excel 2003 Training Tutorial II
(17 pages, 241kb, pdf)
Contents:
- Overview
- Setting up the Spreadsheet
- Inputting Data
- AutoSum
- Average Formula
- Multiplication Formula
- Minimum Formula
- Maximum Formula
- Types of Charts
- Creating a Chart

Popularity: 1% [?]

Technical Excel 2003 Tutorials

Excel Features and Create an Excel Macro

Free Microsoft Excel Ebook

Micrsoft Office 2003 and 2002 Tutorials

Tags for this post>> Excel 2003

Filed under: Free Microsoft Office Training and Tutorial Resources — computer_teacher @ 10:20 pm

Comments (0)

3 Access 2003 Tutorials

Here are 3 Access 2003 Tutorials, from by Hillsborough Community College, that take you through the following features and tools in Accecss: creating tables and ussing design view to enter data; setting data types; using a primary key; inserting and deleting rows in a table; creating and running queries; creating and using forms; importing data from and exporting data to Excel; and using Aggregate Functions.

Access 2003 Training Tutorial I
(23 pages, 598kb, pdf)
Upon completion of this Access training module, you will know and be able to:
1. Understand the three types of relationships: one-to-many, many-to-many and one-to-one;
2. Create a new database;
3. Create tables for data entry in design view;
4. Use, understand, and set data types: Text, Memo, Number, Currency, Date/Time, AutoNumber, Yes/No, Lookup wizard.
5. Create and delete a primary key;
6. Insert and delete a row.

Access 2003 Training Tutorial II
(29 pages, 1.1mb, pdf)
Upon completion of this Access training module, you will know and be able to:
1. Create a query;
2. Sort fields in a query;
3. Show fields in a query;
4. Run a query using wildcards;
5. Run a query for fields not in result;
6. Run a query for a number value;
7. Run a query using the comparison criteria “And”;
8. Run a query using the comparison criteria “Or”;
9. Create a form using the Wizard tool;
10. Understand the basics of the Toolbox: Controls;
11. Insert a graphic/image;
12. Insert and image;
13. Insert an unbound object frame;
14. Resize and image/graphic.

Access 2003 Training Tutorial III
(23 pages, 969kb, pdf)
Upon completion of this Access training module, you will know and be able to:
1. Import a table from Excel;
2. Import data from a delimited text file;
3. Export an Access file to Excel;
4. Understand the purpose of Aggregate Functions;
5. Create and run a query using count;
6. Create and run a query using average;
7. Create and run a query using the parameter between.

Popularity: 1% [?]

Micrsoft Office 2003 and 2002 Tutorials

8 Free Ebooks for Microsoft Word, Excel, Access, Office 2003

Access 2003 Reference Guide

Access Ebooks

Tags for this post>> Access 2003

Filed under: Free Microsoft Office Training and Tutorial Resources — computer_teacher @ 10:19 pm

Comments (0)

March 7, 2011

3 Word 2003 Training Tutorials

Here are 3 Word 2003 Tutorials, hosted by Hillsborough Community College. These tutorials teach and demonstrate many of Word’s important features, and include screen shots to help you master them and become a better Word user.

Word 2003 Training Tutorial I
(27 pages, 670kb, pdf)
Upon completion of this Word training module, you will know and be able to:
1. use the menu bar and various toolbars to create Word documents;
2. open an existing document or new document;
3. use page set-up features including setting margins and paper;
4. save a new or existing document;
5. manipulate text including cut/paste and copy/paste;
6. use the Views featue to view an existing document in various formats;
7. format text including font type, size, color and effects;
8. use other text features including zoom, spell check, grammar check, thesaurus and word count;
9. use pring features including print preview.

Word 2003 Training Tutorial II
(29 pages, 750kb, pdf)
Upon completion of this Word training module, you will know and be able to:
1. create a mail merge letter;
2. insert the HCC logo;
3. re-size the HCC logo;
4. use an Excel Database to create a mail merge;
5. use an Access Database to create a mail merge;
6. view two parts of the same document;
7. compare two documents side-by-side;
8. use section breaks.

Word 2003 Training Tutorial III
(21 pages, 694kb, pdf)
Upon completion of this Word training module, you will know and be able to:
1. use various text features, including find/replace text, wrap text, auto text, and word art;
2. use page format features, including formatting paragraphs, headers and footers, columns, page break, and section break;
3. use graphics features, including inserting clipart, inserting pictures, and editing graphics using the picture toolbar;
4. use the Tables feature, including creating a new table and using the calculations function;
5. use auto shapes;
6. use document features, including track changes and comments.

Popularity: 1% [?]

Related Posts:

6 Word 2003 Tutorials

Intermediate and Advanced Word 2003 Training Tutorials

15 Word 2003 Tutorials

In Word, How Do I…

28 Word Tutorials from Towson University

Tags for this post>> Word 2003

Filed under: Free Microsoft Office Training and Tutorial Resources — computer_teacher @ 12:16 pm

Comments (0)

2 Outlook 2003 Tutorials

Here are 2 Outlook 2003 Tutorials, hosted by Hillsborough Community College. These tutorials include comprehensive instructions to all of Outlook’s main features, along with screen shots to help you become more versatile using this popular email and calendaring application.

Outlook 2003 Training Tutorial I
(23 pages, 875kb, pdf)
Upon completion of this Outlook training module, you will know and be able to:
1. Enable and disable the Standard and Advanced Toolbar;
2. Customize Outlook Today;
3. Send fl agged messages;
4. Set a stationery to your outgoing messages;
5. Create and add a personal signature to outgoing messages;
6. Send attachments;
7. Recall an e-mail;
8. Add contacts;
9. Create a contact distribution list;
10. Send e-mail to contacts;
11. Access Public Folders;
12. Organize e-mail with folders;
13. Turn on and off AutoArchive;
14. Retrieve Archived fi les;
15. Log into Outlook Remotely.

Outlook 2003 Training Tutorial II
(32 pages, 1.2mb, pdf)
Outlook Tutorial Contents:
- Calendar
   – Schedule Appointments
   - Adjust Appointment Time
   - Group Schedules
   - Schedule Group Meeting -
   - Recurring Appointment
   - Incoming Message for Meeting
   - Invitee Proposed New Meeting
   - Meeting Cancellation
   - Meeting Updates
   - Invite Attendees Not In Group
- Tasks
   - Add Fields
   - Add Additional Tasks
   - Reminder Feature
   - Navigation
   - Organize By Category
   - Organize Task Folders
   - Delegates
   - Assign Tasks
   - Final Report
- Notes
   - Create New Note
   - Print Note
   - Forward Note
   - Turn Note Into Task
   - Change Note Appearance
- Journal
   - Journal Fields