Free Microsoft Office Training and Tutorial Resources




    



January 7, 2009

Word 17 Word Tutorial Videos

Here are 17 well done Word Tutorial Videos at free-training-tutorial.com. These easy follow step-by-step Word training videos provide simple and easy instructions for using Word. They will help you with formatting and selecting text, editing text, working with paragraphs, spell checking, and learning keyboard shortcuts.


Formatting Text
 - Selecting text by using mouse clicks
 - Selecting text with the keyboard keys
 - Selecting non-continuous text areas

Handling Paragraphs
 - Correcting the default line spacing as was in older versions
 - Setting the line spacing
 - Setting the spacing between paragraphs
 - Setting paragraph indentation
 - Setting paragraph's first line indentation

Spelling
 - Correcting spelling mistakes with Word's suggestions
 - Adding a new word to the built-in dictionary

Selecting Text
 - Selecting text by using mouse clicks
 - Selecting text with the keyboard keys
 - Selecting non-continuous text areas

Editing Text
 - Undo - Cancelling your last actions
 - Moving text by using the context menu
 - Moving text by dragging it with the mouse
 - Copying text by using the context menu
 - Copying text by dragging it with the mouse

Keyboard Shortcuts
Here are Word keyboard shortcuts for selecting, formatting, cutting, copying, pasting, and aligning texts and paragraphs in Word.

Popularity: 1% [?]

Share and Enjoy: These icons link to social bookmarking sites where readers can share and discover new web pages.
  • Digg
  • del.icio.us
  • blogmarks
  • Furl
  • Reddit
  • Shadows
  • StumbleUpon
  • YahooMyWeb
Related Posts:
  • Free Training Videos for Microsoft Office Applications
  • Software Engineering for Web Applications Course
  • 8 Word Video Tutorials
  • Free Microsoft Word Video Training
  • 60 Free Word 2007 Tutorial Videos

  • Tags for this post>>
    January 6, 2009

    Excel Tutorial Videos

    Here are several good Excel Tutorial Videos at free-training-tutorial.com that will help you master using important Excel features, such as editing cells, rows, and columns; using the sum, average, countif, and VLOOKUP functions; using Excel formulas; creating charts and graphs; and working with filters and pivot tables. They give you step-by-step and easy-to-follow directions for managing and presenting your data with Excel. Each of the links below contain several Excel video training tutorials.


    Excel Basics:
     - Formatting Cells
     - Worksheets
     - Edit Cells
     - Rows and Columns
     - Find and Replace
     - The Fill Handle

    Excel Calculations:
     - Sum, Average, Countif Functions
     - Quick Functions
     - The IF Statement
     - VLOOKUP Function
     - Excel Formulas

    Special Excel Features:
     - Charts and Graphs
     - Sort Data
     - Filter Data
     - Conditional Formatting
     - Pivot Table  
     - First Aid

    Popularity: 3% [?]

    Share and Enjoy: These icons link to social bookmarking sites where readers can share and discover new web pages.
    • Digg
    • del.icio.us
    • blogmarks
    • Furl
    • Reddit
    • Shadows
    • StumbleUpon
    • YahooMyWeb
    Related Posts:
  • Free Training Videos for Microsoft Office Applications
  • Software Engineering for Web Applications Course
  • Free Microsoft Excel Video Training
  • 78 Free Excel 2007 Tutorial Videos
  • Excel Video Tutorials

  • Tags for this post>>
    November 22, 2008

    Technical Excel 2003 Tutorials

    Here are some good technical Excel 2003 Tutorials and Articles from Microsoft. These will help you learn the technical side of Excel, including how to use XML functionality with Exel, Map Data, use Windows Forms, create a Report Templare, and write macros using Visual Basic for Applications (VBA). Also, here is Chapter 20: Creating Advanced User Forms, from the book "Microsoft Office Excel 2003 Programming Inside Out".


     - Add XML Functionality in Microsoft Office Excel 2003 from Microsoft Visual Basic .NET
     - Creating Charts in Microsoft Office Excel 2003 Using Visual Basic for Applications Code
     - Creating XML Mappings in Excel 2003
     - Different Ways of Using Web Queries in Microsoft Office Excel 2003
     - How Excel 2003 Infers XSDs When Importing XML Data
     - Microsoft Office Excel 2003 Preview
     - Part 1: Automating the XML Data Mapping Process in Excel 2003
     - Part 2: Mapping XML from SQL Server to a Single Cell in Excel 2003
     - Part 3: Replicating Excel 2003 Formulas to SQL Server
     - Populating an Excel 2003 Worksheet with Multiple Related Records from a Windows Form
     - Super-Easy Guide to the Microsoft Office Excel 2003 Object Model
     - Understanding Security for Add-ins and VBA Macros in Excel 2003
     - Using the Excel 2003 XML Tools Add-in Version 1.1
     - Using the Excel XML Toolbox for Microsoft Office Excel 2003
     - Using Visual Basic and ASP with XML to Generate Excel 2003 Workbooks
     - XML and Microsoft Office Excel 2003: Creating an Expense Report Template

    Popularity: 100% [?]

    Share and Enjoy: These icons link to social bookmarking sites where readers can share and discover new web pages.
    • Digg
    • del.icio.us
    • blogmarks
    • Furl
    • Reddit
    • Shadows
    • StumbleUpon
    • YahooMyWeb
    Related Posts:
  • Excel Ebooks
  • 27 Free Microsoft Office Training eBooks
  • Free Online Microsoft Office Books
  • 8 Free Ebooks for Microsoft Word, Excel, Access, Office 2003
  • Free Microsoft Excel Ebook

  • Tags for this post>>
    October 28, 2008

    4 Word 2003 Training Manuals

    Here are 4 Word 2003 Training Manuals, hosted by Villanova University. These will teach you how to use Word to create and work with Paragraphs, Tabs, Tables, Cells, Graphics, Pictures, and Mail Merge. Also available is this short document explaining how to Fix a Word Mail Merge issue that occurs when Excel loses its formatting when data is merged (1 page, 12kb, pdf).


    Word 2003 Formatting Training Manual

    This shows you how to: Format and Align Paragraphs, and Use, Clear and Delete Tabs. (17 pages, 78kb, pdf)

    Lesson 1 - Using Paragraph Formatting:
    Formatting Paragraphs
    Aligning Paragraphs
    Using Click and Type to Align Text
    Modifying Paragraph Spacing
    Revealing Formatting
    Modifying Line Spacing
    Copying Paragraph Formats

    Lesson 2 - Indenting Paragraphs:
    Changing the Left Indent
    Indenting the First Line
    Creating a Hanging Indent
    Creating a Right Indent

    Lesson 3 - Setting Tabs:
    Using Tab Stops
    Setting Tab Stops
    Deleting and Moving Tab Stops
    Clearing All Tabs
    Creating a Leader Tab


    Word 2003 Tables Training Manual
    Learn how to: Create, Use and Modify Tables and Cells, and Work with Table Headings, Borders, and Shading.  (24 pages, 112kb, pdf)

    Lesson 1 - Working with Tables:
    Creating a Table
    Navigating a Table
    Entering Text Into a Table
    Inserting a Blank Line
    Using Table Autoformat
    Hiding and Showing Gridlines
    Using the Draw Table Button
    Converting Existing Text Into a Table

    Lesson 2 - Editing a Table:
    Selecting Table Components
    Selecting the Entire Table
    Inserting Rows and Columns Into a Table
    Merging Cells
    Rotating Text in a Table
    Changing Column Width and Row Height
    Aligning Table Text
    Distributing Rows and Columns Evenly
    Splitting Cells
    Deleting Columns and Rows
    Setting Table Properties
    Converting a Table Into Text
    Creating a Table Heading

    Lesson 3 - Applying Borders and Shading:
    Using Borders and Shading
    Adding Borders and Shading to Text
    Adding a Border to a Page
    Adding a Border to a Table
    Removing a Border from a Table
    Adding and Removing Shading


    Word 2003 Graphics Training Manual
    This teaches you how to: Insert Graphics, and Work with Graphics and Images, 3-D Effects, Layering Text and Objects, WordArt, and Watermarks. (20 pages, 217kb, pdf)

    Lesson 1 - Working with Drawing Objects:
    Creating a Drawing Object
    Selecting Filled and Unfilled Object
    Moving an Object
    Using the Drawing Canvas
    Drawing Without the Drawing Canvas
    Drawing a Line
    Changing and Removing the Fill Color
    Formatting Lines
    Resizing an Object
    Adding a 3-D Effect
    Layering Text and Objects
    Deleting an Object

    Lesson 2 - Inserting Graphics:
    Inserting a Picture
    Formatting Pictures
    Creating WordArt Objects
    Formatting WordArt Objects
    Using Advanced Layout Options
    Creating Watermarks


    Word 2003 Mail Merge Training Manual
    Covers Setting up and Using Mail Merge, Data Source, Entering Records, Merge Fields, Merging and Previewing the Data, Sorting the Data, and Merging Labels, Envelopes, and Directories.  (21 pages, 85kb, pdf)

    Lesson 1 - Using Mail Merge:
    Working with Mail Merge
    Starting the Mail Merge Wizard
    Identifying the Main Document
    Creating a Data Source
    Adding Fields to a Data Source
    Removing Fields From a Data Source
    Rearranging Fields in a Data Source
    Saving a Data Source
    Entering Records Into a Data Source
    Using an Existing Data Source
    Setting View Options For Merging
    Inserting Merge Fields Into a Document
    Previewing Merged Data
    Merging to a New Document
    Sorting Records to Be Merged
    Merging to the Printer

    Lesson 2 - Merging Mailing Labels, Envelopes & Directories:
    Using Mailing Labels & Envelopes
    Creating Mailing Labels/Envelopes
    Selecting Label/ Envelope Options
    Attaching a Data Source
    Inserting Label/Envelope Merge Fields
    Merging Labels to a New Document
    Creating a Directory

    Popularity: 97% [?]

    Share and Enjoy: These icons link to social bookmarking sites where readers can share and discover new web pages.
    • Digg
    • del.icio.us
    • blogmarks
    • Furl
    • Reddit
    • Shadows
    • StumbleUpon
    • YahooMyWeb
    Related Posts:
  • 12 Free Office XP Training Manuals
  • 12 Free Office 2000 Training Manuals
  • Free Training Manuals for Word, Excel, and Powerpoint
  • 2 Office 2003 Tutorials: Fundamentals and Drawing Tools
  • Word 2000 Tutorial from Comm. College of RI

  • Tags for this post>> |
    October 24, 2008

    2 Outlook 2007 Training Manuals

    Outlook 2007 is Microsoft's latest email application with which you can send and receive e-mail messages, schedule appointments, and organize your contacts and addresses. You can also store and be reminded of your tasks. Outlook's Calendar feature is one of the most-used tools in Microsoft Outlook. The Calendar lets you schedule meetings and keep track of appointments or events.

    Here are two Outlook 2007 Training Manuals, along with an FAQ for Outlook Web Access, hosted by Villanova University. These materials will help you learn the Outlook's important features for performing tasks related to email, contact, and the calendar. Outlook features taught include: OutlookItems, Message Window, the Ribbon, the Office Button and Quick Access Toolbar, the Navigation Pane, the To-Do Bar , Composing and Addressing Email, Signature, Attaching Files, Recalling Messages, Drafts, Out of Office Assistant, Opening/Saving Attachments, Sorting Messages, Managing Views, Search, Folders, Rules, Contacts, Distribution Lists, Using the Calendar, Scheduling Appointments, Working with Calendar Items, Meeting Requests, Reminders, Sharing Calendars, and Calendar Options.


    Outlook 2007 Email and Contacts Training Manual
    (50 pages, 2.5mb, pdf)

    The Fundamentals:
    What’s New in Outlook 
    Understanding the Outlook Program Screen
    Understanding Items
    Understanding the Message Window
    Understanding the Ribbon
    Using the Office Button and Quick Access Toolbar
    Using the Navigation Pane
    Using the To-Do Bar 
    Using Menus and Toolbars
    Using Keyboard Commands
    Using Help

    Composing & Addressing E-mail:
    Composing/ Addressing Email
    Creating/Inserting a Signature
    Attaching Files to a Message
    Attaching Items to a Message
    Inserting Calendars into a Message
    Specifying Message Options
    Recalling a Message
    Saving Unfinished Messages (Drafts)
    Using the Out of Office Assistant

    Receiving and Sorting E-mail:
    Reading E-mail
    Opening/Saving Attachments
    Flagging a Message for Follow-up
    Using Color Categories
    Sorting Messages
    Changing Views

    Organizing and Finding Information:
    Using Instant Search
    Refining a Search
    Creating and Using Folders
    Managing Folders
    Creating a Rule
    Creating a Rule with the Rules Wizard

    Working with Contacts:
    Adding a Contact
    Adding an E-mail Sender to Your Contacts
    Editing and Deleting Contacts
    Changing Contact Views
    Working with Distribution Lists


    Outlook 2007 Calendar Training Manual

    (26 pages, 1.6mb, pdf)

    Using the Calendar:
    Viewing/Navigating the Calendar
    Scheduling Appointments/Events
    Editing and Rescheduling Appointments & Events
    Working with Recurring Appointments
    Color-coding Calendar Items
    Viewing Calendar Items
    Arranging Calendar Items
    Working with Meeting Requests
    Setting Reminders
    Sharing Calendars
    Configuring Calendar Options
    Printing the Calendar


    FAQ for Outlook Web Access (OWA)
    (11 pages, 223kb, pdf)
    Outlook Web Access (OWA or WebMail) Frequently Asked Questions

    Popularity: 85% [?]

    Share and Enjoy: These icons link to social bookmarking sites where readers can share and discover new web pages.
    • Digg
    • del.icio.us
    • blogmarks
    • Furl
    • Reddit
    • Shadows
    • StumbleUpon
    • YahooMyWeb
    Related Posts:
  • 12 Free Office 2000 Training Manuals
  • 12 Free Office XP Training Manuals
  • Free Outlook 2007 Course from Dell
  • Office 2007 Training Handouts and Slides
  • Free Outlook 2007 Training

  • Next Page »