List of online resources to help home study learners improve their knowledge of Microsoft Word 2007. Includes official Microsoft Office links and videos.

 

Microsoft Online Training

Get up to speed with Word 2007
Have you heard the word? It's time to get up to speed with Microsoft Office Word 2007. Learn the best ways to use the new Ribbon, get a handle on finding popular commands, and understand what the new file format does for you.
http://office.microsoft.com/en-us/word-help/up-to-speed-with-word-2007-RZ010066490.aspx?CTT=5&origin=HA010215566

 

Save time with templates Get a jump-start on your documents by using templates
This course shows you how to use templates in Microsoft Office Word 2007 to speed up document creation.
http://office.microsoft.com/en-us/word-help/save-time-with-templates-RZ010223218.aspx?CTT=5&origin=HA010215566

 

Format your document with styles
Learn what styles are in Word 2007, and use them to format your documents with ease — not to mention finesse and consistency. Use the new Quick Styles gallery, and see how to modify styles.
http://office.microsoft.com/en-us/word-help/format-your-document-with-styles-RZ010356279.aspx?CTT=5&origin=HA010215566

 

Tables: Table Tricks
In this lesson, you'll learn a bit more about formatting, along with some other tips that will help you work with Word tables.
http://office.microsoft.com/en-us/word-help/tables-ii-table-tricks-RZ010371267.aspx?CTT=5&origin=HA010215566

 

Revise documents with Track Changes and Comments in Word 2007
Make revisions to documents that others can see, and add comments in the document by using Track Changes and Comments in Word 2007.
http://office.microsoft.com/en-us/word-help/revise-documents-with-track-changes-and-comments-in-word-2007-RZ010235968.aspx?CTT=5&origin=HA010215566

 

Mail Merge: Use mail merge for mass mailings
Learn how to use mail merge in Word 2007 to produce letters and envelopes for mass mailings.
http://office.microsoft.com/en-us/word-help/mail-merge-i-use-mail-merge-for-mass-mailings-RZ010277841.aspx?CTT=5&origin=HA010215566

 

Mail Merge: Use the Ribbon and perform a complex mail merge
Go beyond the basics of mail merges and create personalized form letters or e-mail messages, numbered coupons, and more.
http://office.microsoft.com/en-us/word-help/mail-merge-ii-use-the-ribbon-and-perform-a-complex-mail-merge-RZ010279824.aspx?CTT=5&origin=HA010215566

 

Keyboard shortcuts in the 2007 Office system
Many of the programs in the 2007 Microsoft Office system have a brand-new look. Most menus and toolbars have gone away, and along with the new look come new and easier ways to use the keyboard.
http://office.microsoft.com/en-us/word-help/keyboard-shortcuts-in-the-2007-office-system-RZ010156267.aspx?CTT=5&origin=HA010215566

 

 

List of online resources to help home study learners improve their knowledge of Microsoft Word 2010. Includes official Microsoft Office links and videos.

 

Microsoft Online Training

Office 2010 Security: Protecting your files
In Microsoft Office 2010, when files open, Message Bars can alert you to useful information and potential problems with your files. Security Message Bars provide the opportunity to consider the potential security risks that may be in your file, and then the ability to open or read the file while reducing the risks that can occur.
http://office.microsoft.com/en-us/word-help/office-2010-security-protecting-your-files-RZ101665538.aspx?CTT=5&origin=HA104039042

 

Word 2010 keyboard shortcuts
Learn Word 2010 keyboard shortcuts. Find out how to access almost any button using the ALT key. And, learn handy shortcuts that use the CTRL key.
http://office.microsoft.com/en-us/word-help/word-2010-keyboard-shortcuts-RZ102673168.aspx?CTT=5&origin=HA104039042

 

Create and customize a table of contents
Create a table of contents (TOC) in Word 2010. Prepare document headings so that Word will generate the TOC automatically, and customize the look and settings for the TOC.
http://office.microsoft.com/en-us/word-help/create-and-customize-a-table-of-contents-RZ102634105.aspx?CTT=5&origin=HA104039042

 

 

List of online resources to help home study learners improve their knowledge of Microsoft Excel 2007. Includes official Microsoft Office links and videos.

 

Microsoft Online Training

Get up to speed with Excel 2007
Get a hands-on introduction to the new look of Microsoft Office Excel 2007, and see how to do what you're used to doing in Excel as you get up to speed.
http://office.microsoft.com/en-us/excel-help/up-to-speed-with-excel-2007-RZ010062103.aspx

 

Get to know Excel 2007
Enter formulas Get to know Microsoft Office Excel 2007 by learning how to enter formulas into worksheets and perform simple calculations. Then, ditch your calculator.
http://office.microsoft.com/en-us/excel-help/get-to-know-excel-2007-enter-formulas-RZ010074593.aspx

 

Learn how to figure out dates using formulas in Excel 2007
Use formulas in your Microsoft Excel spreadsheet to figure out dates.
http://office.microsoft.com/en-us/excel-help/learn-how-to-figure-out-dates-using-formulas-in-excel-2007-RZ010278632.aspx

 

PivotTable: Get started with PivotTable reports in Excel 2007
Make sense out of data. Learn about Microsoft Office Excel 2007 PivotTable reports, a fast and powerful way to analyze data and answer questions you have about it.
http://office.microsoft.com/en-us/excel-help/pivottable-i-get-started-with-pivottable-reports-in-excel-2007-RZ010205886.aspx

 

Keyboard shortcuts in the 2007 Office system
Many of the programs in the 2007 Microsoft Office system have a brand-new look. Most menus and toolbars have gone away, and along with the new look come new and easier ways to use the keyboard.
http://office.microsoft.com/en-us/excel-help/keyboard-shortcuts-in-the-2007-office-system-RZ010156267.aspx

 

 

List of online resources to help home study learners improve their knowledge of Microsoft Word 2013. Includes official Microsoft Office links and videos.

 

Microsoft Online Training

Track changes
When you want to see who’s changing what in your document (or when you want someone else to see what you changed in their document), turn on Track Changes.
http://office.microsoft.com/en-us/word-help/video-track-changes-VA104072630.aspx?CTT=5&origin=HA104030981

 

Work with word counts in your document
View the word count and other information in your document. Learn how to insert and update the word count in to the body of your document.
http://office.microsoft.com/en-us/word-help/video-work-with-word-counts-in-your-document-VA104091396.aspx?CTT=5&origin=HA104030981

 

Don't change fonts, use Quick Styles
You might format a document while you type, or change fonts for things like headings. Here’s a better way to get your document looking smart: Quick Styles.
http://office.microsoft.com/en-us/word-help/video-don-t-change-fonts-use-quick-styles-VA104245899.aspx?CTT=5&origin=HA104030981

 

 

List of online resources to help home study learners improve their knowledge of Microsoft Excel 2010. Includes official Microsoft Office links and videos.

 

Microsoft Online Training

Plan payments and savings in Excel 2010
Learn how to figure out payments and savings by using formulas in Excel.
http://office.microsoft.com/en-us/excel-help/plan-payments-and-savings-in-excel-2010-RZ102630204.aspx?CTT=5&origin=HA104039038

 

The IF function: what it is, and how to use it
The IF function checks to see if a condition you specify is true or false. If true, one thing happens; if false, something else happens. For example, if you use the IF function to see if amounts spent are under or over budget, the result for True could be “Within budget,” while the result for False could be “Over budget.”
http://office.microsoft.com/en-us/excel-help/the-if-function-what-it-is-and-how-to-use-it-RZ102425926.aspx?CTT=5&origin=HA104039038

 

Understand data at a glance with conditional formatting
Sometimes it’s hard to read and interpret data by scanning rows and rows of information. But you can use conditional formatting to make certain data stand out, helping you to analyze data, and to identify patterns and trends.
http://office.microsoft.com/en-us/excel-help/understand-data-at-a-glance-with-conditional-formatting-RZ102060984.aspx?CTT=5&origin=HA104039038

 

VLOOKUP: What it is, and when to use it
Learn how to use VLOOKUP to look up a value you want to find in an Excel list or table. Using VLOOKUP is similar to looking up a person’s name in a telephone book to get a telephone number. VLOOKUP looks at a value in one column, and finds its corresponding value on the same row in another column.
http://office.microsoft.com/en-us/excel-help/vlookup-what-it-is-and-when-to-use-it-RZ101862716.aspx?CTT=5&origin=HA104039038

Save time by creating and running macros in Excel 2010
Do you find yourself doing the same actions over and over again in your spreadsheets? Did you know you can create macros so that Excel can do that repetitive work for you? Macros are sets of instructions based on actions that you record while you work in your spreadsheet. After you record a macro, you can use it again as the need arises.
http://office.microsoft.com/en-us/excel-help/save-time-by-creating-and-running-macros-in-excel-2010-RZ102337714.aspx?CTT=5&origin=HA104039038