If you have the time (20-50 minutes), I’m certain Microsoft has the free Office training that’s perfect for you!
GENERAL OFFICE 2003
Help protect yourself: Security in Office Learn about security fundamentals in Microsoft Office programs and what you can do to help protect your computer and documents. Create an accessible Office document Find out what accessibility means and how people with disabilities experience your documents. Organize your clip art and other media The Clip Organizer tool arranges and catalogs clip art and other media files stored on your hard disk. See what you can do with the Research service Practice using this built-in research service. Digitally sign your own macros for stronger security Use the High macro security level and still run macros that you’ve written and signed without seeing security warnings. Customize your toolbars and menus Learn how to change existing toolbars and menus, including the shortcut menu, and how to create your own toolbars and menus. XML: What’s it all about? Learn the basics of XML, what it is and how it works, and how programs in the Office System help you use XML.EXCEL
Great Excel features Learn five great features that will help you to work faster and easier. Get to know Excel: Create your first workbook Learn how to create a workbook, how to enter and edit text and numbers, and how to add and delete columns and rows. Printing options in Excel See how to get the results you want when you print. Get to know Excel: Enter formulas Learn how to perform simple calculations and enter simple formulas into worksheets. Charts I: How to create a chart Learn how to create charts to transform data into pictures. Charts II: Choose the right chart type Selecting the most effective chart type will make your data clearer, stronger, and more informative. Charts III: Create a professional-looking chart Learn how to customize it, enhance its appearance, and change any of the information on the chart. Charts IV: Charts for the scientist Learn how to use the chart features to accomplish scientific tasks such as adding a trend line to data or using error bars. Import text files into Excel Learn how to import text files, and how to update the imported data if the external data changes. Import external data into Excel Learn to import data that is stored in a database by using the Data Connection Wizard. Filter external data before importing it into Excel Learn to filter and sort data that is stored in a database by using Microsoft Query. Get in the loop with Excel macros Macros are very powerful, and by the end of this course, you’ll understand why. Working with really big worksheets Keep column and row names in sight no matter where you are on a worksheet, navigate to the far end of the largest worksheet by using a keyboard shortcut, move and copy sheets, and filter and sort data by using the AutoFilter arrows. All about AutoFilter AutoFilter selects and shows you only the data you want to see. Help secure and protect data in Excel Learn what you can do to help keep data secure. Lists I: How to use lists in Excel 2003 There’s a new List command that makes it easy to sort and filter data and to total up values. Lists II: Publish Excel 2003 lists to a SharePoint site You can share list data with others by publishing the list to a Web site based on SharePoint Services. Use formulas to edit, correct, and proofread text Learn how to save time by using formulas instead of retyping to work with text. PivotTable I: What’s so great about PivotTable reports? Learn about the PivotTable feature, which organizes, summarizes, and analyzes your data to reveal its meanings. PivotTable II: Swing into action with PivotTable reports Learn even more about the ins and outs of working with PivotTable reports. PivotTable III: Show off your PivotTable skills Learn even more advanced ways to use PivotTable reports, including how to use formulas with report data. Using XML in Excel 2003 Learn how to use new tools to work with Extensible Markup Language (XML). Plan payments and savings by using financial formulas Learn how to use formulas to figure out payments, savings, and other financial numbers. Find functions and enter arguments Learn how to find functions by using the Insert Function dialog box. Get to know function arguments and the ways to learn more about them. Make time count by using formulas Learn how to calculate times by using formulas. Figure out dates by using formulas Learn how to figure out dates by using formulas. Excel statistical functions Learn about using statistical functions and formulas.WORD
Get to know Word: Create your first document Learn the basics of Microsoft Office Word, such as adding, deleting, and moving text around, adding basic formatting, and creating bulleted or numbered lists. Tables I: Create and format basic tables Learn how to add tables to your documents. Tables II: Use tables to simplify complex page layouts Learn key best practices for managing tables effectively. Decorate documents with backgrounds, borders, and text effects Discover how watermarks, backgrounds, borders, shading, and graphical text effects can enliven your document. Revise documents with Track Changes and comments See insertions and deletions in documents by using Track Changes, and use comments to discuss document text. Prepare for the holidays: Write and send a newsletter with Word Find out how to create/decorate a holiday letter to send to all your friends and family as well as mailing labels for a mass mailing. Protect Word documents Learn how you can help protect your documents, including limiting who can access them and restricting changes others can make Table of Contents I: Create a basic TOC Find out how to create and format a basic table of contents (TOC). Table of Contents II: Advanced TOCs, long documents, and other tables Explore advanced tables of contents, including using fields and having more than one TOC in a document. Add graphics and keep them where you want them Learn how to insert/position many types of graphics into your document. Create individual envelopes and labels Tips and tricks for creating small numbers of professional labels and envelopes. Create a document outline Find out how to create a working outline, and reorganize quickly what you’ve already written. Use mail merge for mass mailings and more Learn to use mail merge to produce envelopes and labels for mass mailings, and the basics to create personalized form letters or e-mail messages, numbered coupons, and more. Headers and footers, simple to elaborate Learn to add headers and footers, from basic ones that appear on every page to more elaborate ones that differ from page to page or document section to document section. Great Word features Learn five great features like the new reading layout view. Customize keyboard shortcuts in Word Learn customizing keyboard shortcuts, and discover how to set up and save your own shortcut keys. Decorate documents with backgrounds, borders, and text effects Discover how watermarks, backgrounds, borders, shading, and graphical text effects can enliven your document. Introduction to XML in Word See how Word and XML work together to help you reuse data in your Word documents and in other programs. Create footnotes and endnotes Learn to add footnotes and endnotes to documents, convert footnotes to endnotes and vice versa, move or copy notes, delete notes, and customize the number format for the note reference marks. Format your document with styles Learn also to apply existing and new styles, modify them, and copy them between documents or templates.
General OfficeOutlookPowerPointGeneral OfficeProjectVisioGeneral OfficeAccessFrontPageInfoPathOneNotePublisher
Click Here for FREE Microsoft Software I (Windows)