Free Microsoft Office Training and Tutorials Blog




    



Microsoft Access Tutorials

Here are some Microsoft Access tutorials are hosted by the Univeristy of British Columbia.


Microsoft Access Tutorials:
http://mis.commerce.ubc.ca/courses/comm391/tutorials.html


Calculating Fields in Access:
http://mis.commerce.ubc.ca/courses/comm391/calcfields.html

Filters and Queries (S.Hui):
http://mis.commerce.ubc.ca/courses/comm391/tutorials/access1/access1.htm

Excel to Access Tutorial:
http://mis.commerce.ubc.ca/courses/comm391/tutorials/presentation/excel_to_access.htm

MS Access Whitepaper:
http://mis.commerce.ubc.ca/courses/comm391/tutorials/download/dbback.pdf

Notes on Relationships:

http://mis.commerce.ubc.ca/courses/comm391/tutorials/download/relations.html

Excel 2003 Tutorials and Free Video Training

Teacherclick.com is designed to offer to the educational community completely free and high-quality software tutorials and online courses. Here are their Excel tutorials, including several excellent video training tutorial modules that are well designed and documented. This is an exceptional site considering it is completely free.

Excel 2003 Tutorials:

1. Introduction. Excel Elements
2. Starting to work with Excel
3. Operations with files
4. Formulas and Functions
5. Manipulating cells
6. Cell formats
7. Structure changes
8. Insert and eliminate elements
9. Spelling correction
10. Printing

Free Excel Video Training Tutorials

1. Basic Excel2003 environment
2. Introduce and modify text
3. Save a workbook
3. Close a workbook
3. Create a new workbook
3. Open a workbook
4. Insert functions
5. Selecting rows, cells, and columns
5. Copy cells
5. Copy cells with the mouse
5. Special paste

5. Move cells
5. Delete cells
6. Change the font
6. Align the contents of cells
6. Borders
6. Colouring cells
6. Cell formatting
7. Row height
7. Hide rows
7. Column width
7. Hide columns
7. Change the name of a sheet

8. Insert rows
8. Insert columns
8. Insert sheets
8. Copy and move a worksheet
8. Eliminate elements
9. Autocorrect spelling
9. Spelling correction
10. Page setup
10. Print


"How to Use" Outlook Tutorials from Outlook-tips.net

This How To section of Outlook-Tips.net offers many step-by-step tutorials that show you how to use many of the features in Outlook. They also explain the reasoning behind some of Outlook's features.

"How to Use" Outlook Tutorials from Outlook-tips.net


How to Tutorials and Articles for Office 2003

Here are 25 articles from Microsoft for learning about Microsoft Office 2003. Some of these are tutorials will help you use Office 2003  more effectively and efficiently.  And some are explanations of things such as how to order a replacement CD, support policy, and a history of Office 2003 updates. Also, here are some good Troubleshooting Articles for Office 2003.

How to Tutorials and Articles for Office 2003

How to use a setup log file to troubleshoot setup problems in Office 2003
Explains how to use the Office 2003 installation log files to troubleshoot Office setup issues.
How to install Office 2003 on a computer that is configured to dually boot Windows 2000 and Windows XP
Explains how to install Office 2003 on a computer that is configured to dually boot Windows 2000 and Windows XP.
How to turn off the speech recognition and the handwriting recognition features in Office 2003
Explains how to turn off speech recognition and handwriting recognition after you install Office 2003
.
How to change the company name and user name in Office 2003
Explains how to change the name of the company in Office 2003 after setup by modifying the Windows registry. Explains how to change the user name information
.
How to order a replacement CD for Microsoft Office
Lists the phone numbers for U.S. and Canadian customers when you have lost, broken, or misplaced your original Publisher installation CD and want to order the replacement media from Microsoft. Explains how to view the status of your order.
Support policy for modifying an Office XP, Office 2003, or Office 2000 installation
Describes the supported methods for modifying an installation of the Office XP, Office 2003, or Office 2000 suite of products. This information is included in the documentation in the Office Resource Kit.
Users must belong to the Administrators group or to the Debugger Users group to use the Script Editor component in Office 2003
Describes the changes that have been made in Machine Debug Manager (MDM.EXE) version 7.0.9466.0, to enhance the security of your computer.
List of Office products that have received the Windows logo
Lists the Office products that have been awarded the Windows 2003 logo, the Windows XP logo, and the Windows 2000 logo. Explains the extent of Office product compatibility testing with these operating systems.
How to understand the repair feature in Office 2003 and in Office XP
Explains how the repair feature works in Office 2003.
How to make sure that your Office document has a valid digital signature in Office 2003
Explains how to make sure that a digitally signed Office document has a valid digital signature and how to make sure that it was not tampered with since the original was digitally signed
How to change the server location for Office 2000 source files
Describes how to modify the Windows registry so that the Windows Installer uses a different server location. You must create an administrative installation on the server for which you want to change the Office Setup location.
The folders and their contents are deleted when you delete shortcut folders from the Picture Shortcuts task pane in Picture Manager 2003
Describes the behavior where you receive an error message with the correct drive information when you delete shortcut folders from the Picture Shortcuts task pane in Picture Manager 2003.
History of Office 2003 updates
Describes the history of Office 2003 updates including Office 2003 Service Pack 1.
Supported installation methods for deploying Office 2003
Discusses the supported installation methods for deploying Office 2003.
How to disable Microsoft Office Online featured links in Office 2003
Describes methods that you can use to disable Office Online featured links in Office 2003.
Frequently asked questions about Student Essentials for Microsoft Office 2003 Editions
Answers some of the frequently asked questions about Student Essentials for Microsoft Office 2003 Editions
.
You cannot remove service packs for Office 2003 products
Describes how you can remove Office 2003 service packs from your computer and revert to your original Office 2003 installation.
List of some programming resources for Visual Basic programming in Office 2003
Provides a list of resources that are available to help you learn VB programming in Office 2003. It includes online help, object broswer, MS Press books, KB articles, newsgroups, and other Web resources.
Information about the ability to uninstall Office updates
Provides information about how to remove Microsoft Office updates. The ability to remove Office updates was added to certain Office updates that are dated July 12, 2005 and later.
Description of Office features that are intended to enable collaboration and that are not intended to increase security
Describes features in Office products that enable specific collaboration scenarios and features that are designed to help make your documents and files more secure.
How to install Office 2003 or Office XP on a computer that is running Windows Terminal Server
This article explains details concerning how Office 2003 and Office XP should be installed on a computer that is running Terminal Services.
How to view error signatures if an Office program experiences a serious error and quits
Explains how to view the error signatures when an Office program experiences a serious error and quits
.
How to tell the difference between field names in an Outlook 2003 contact list and in a Word 2003 mail merge
Discusses the differences between the field names that appear in an Outlook 2003 contact list and a Word 2003 mail merge. Provides a list of all the relevant field names in both programs.
How to create a Custom Maintenance Wizard file for updating installation options after you deploy a custom installation of Office
This article describes how to use the Custom Maintenance Wizard to change the configuration of an existing Office installation on your computer.
INFO: ActivePrinter Property in Word Sets System Default Printer
When you use the ActivePrinter property in Word to set the current printer, you also set the printer you select to be the default printer for the system.

The PowerPoint FAQ - Part 2

Here is the secone half of the links for the best how to and tutorial site on the web for Microsoft Powerpoint. I posted the first half yesterday. It offers Help, Tips, Techniques, and Tutorials about how to use Powerpoint. Here you'll find PowerPoint Help, Hints and How-tos; PowerPoint Answers, Add-Ins and Assists; PowerPoint Tips, Tricks and links to other PowerPoint add-ins, This site is where you want to look if you're seeking PPT resources and PPT sites..

The PowerPoint FAQ - Best Powerpoint Help and Tutorial Site


Programming PowerPoint

MacFAQs

Stupid PPT-TRIX

Troubleshooting


PROGRAMMING POWERPOINT

These code samples come from various authors and are here for purposes of illustration. We can't (and don't) guarantee that they'll work on all systems, or that they are free of harmful side effects. It's your responsibility to verify the appropriateness and safety of any code you find here.

We don't offer tech support for the code here. If you have any problems or questions, please post a detailed description on the PowerPoint newsgroup. Whether the author chooses to respond is entirely up to them.

VBA code only works in PowerPoint 97 or later. It doesn't work at all in the free PowerPoint Viewer.

For VBeginners

Creating and Installing Add-ins, Toolbars, Buttons

Show Me

Exporting stuff

Adding stuff

Deleting stuff

Changing stuff

Printing

Batch Tricks

Animations and Transitions

Working with Excel

Automating one app from another

Working with MSGraph charts

Other

Known VBA/Programming-related Bugs


MAC FAQS

Troubleshoot Problems, Interpret Error Messages

Downloads, Contact Microsoft

How-Tos

Other Mac PowerPoint Resources


STUPID PPT-TRIX


TROUBLESHOOTING

Troubleshooting Tips and Procedures

PowerPoint Crashes Without Error Message

Specific Error Messages

Graphics Problems

Display, Screen Show & Multimedia Problems

Corrupted or unopenable PPT files

Printing & File Saving Problems

Link & Copy/Paste Problems

File Import / Export Problems

Problems with PowerPoint on the Web

Text or Font Problems

Cross-Version / Cross-Platform Problems

Missing Features

Misc. Nuisances

All the FAQ and nothing but the FAQ


Page :  1 2 3 4