Microsoft Office training courses, online training, downloadable training, shortcuts, how to’s and more

The other day I put up my Microsoft Office 2010 “How To” Skills Builder Video Series post here on the blog, which includes several collections of “How-to” video series for Microsoft Office 2010. In there, I mentioned that I would be providing additional Microsoft Office training information for you shortly, and here it is. 

At Microsoft, we have a ton of Office training resources available to you, ranging from online training, to videos, to downloadable training and more. Here is a collection of several of these resources for you to help you get the most from your Microsoft Office software, whether you are a new user or a daily Office aficionado. In this post I have included:

• Resources on switching to Microsoft Office 2010
• Online training for Microsoft Office 2010 by program
• Sample trainings with details and links for Microsoft Word 2010, Excel 2010, and PowerPoint 2010
• Links to download Microsoft Office 2010 training for offline use
• Office webinars
• Partner resources
• Top 10 reasons

Making the switch to Microsoft Office 2010: If you are a user of a previous version of Microsoft Office and are moving to Office 2010, we have a collection of training courses designed to help make your move to Microsoft Office 2010 as easy as possible. Here are the core trainings in this series for you:

• Make the switch to Word 2010
• Make the switch to Excel 2010
• Make the switch to PowerPoint 2010
• Make the switch to Outlook 2010
• Make the switch to SharePoint 2010
• Make the switch to Access 2010
• Make the switch to OneNote 2010
• Make the switch to Visio 2010

Office 2010 online training: Here are links to collections of Microsoft Office 2010 online training by product and just below this list is a sampling of these courses for Word 2010, Excel 2010, and PowerPoint 2010, in addition to links to download this training for offline use:

Using Microsoft Office 2010 (How-to’s): Now that you are on Microsoft Office 2010, we have a collection of training available to you to show you how to do many things inside Microsoft Office 2010. Here is a quick sample:

Word 2010

• Getting started with Word 2010: If you know Word 2007, used an earlier version of Word, or have never used Word before, explore these resources to begin learning how to use the latest
• How to create your first Word document I: Are you new to Word? Learn to do the following in Word 2010: type where you want to on a page, fix spelling errors, make a list, change page margins, add...
• How to create your first Word document II: Part two of a series. If you're new to Word, learn to move around in the document, use formatting marks, move text by using Cut and Paste, and change line...
• Word 2010 tips and tricks: You’ve created tons of Word documents. But perhaps you need some timesaving techniques to help you work faster, and more effectively. This short course...
• Word 2010 keyboard shortcuts: Learn keyboard shortcuts in Word 2010.
• How to use the Navigation Pane to search and move around in your document: Learn how to use the new Navigation Pane and Search features in Word 2010.
• 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...
• How to create visually compelling documents in Word 2010: Learn to apply graphical formatting to text, enhance images with picture tools, insert clippings and screenshots in documents, and use SmartArt graphics.
• How to get control of page numbers, headers, and footers: Create and format headers and footers in Word 2010. Work with page numbers, text, and images in headers and footers.
• How to create and customize a table of contents: Create a table of contents (TOC) in Word 2010. Prepare document headings so Word will generate the TOC automatically, and learn to customize the TOC.
• How to create accessible Word documents: Learn what steps you can take to make your Word 2010 documents more accessible to everyone.

Excel 2010

• Getting started with Excel 2010: If you know Excel 2007, used an earlier version of Excel, or have never used Excel before, explore these resources to begin learning how to use the latest...
• Excel 2010 keyboard shortcuts I: CTRL key shortcuts: Learn Excel 2010 keyboard shortcuts. Learn CTRL key shortcuts that let you do everything from selecting and editing cells, to inserting cells, rows, and columns.
• Excel 2010 keyboard shortcuts II: ALT key shortcuts: Learn how to use ALT key shortcuts that let you access almost any command in Excel 2010. These keyboard shortcuts are also called access keys, and they...
• Get to know Excel 2010: Create your first spreadsheet: New to Excel? Learn how to create a spreadsheet, do basic math, create and format column titles, freeze the top row, and set some printing options.
• 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...
• Get to know Excel 2010: Create formulas: Learn to use formulas to do math, update formula results automatically, and use predefined formulas (functions) to calculate things like monthly payments.
• VLOOKUP: What it is, and when to use it: You may have heard of the VLOOKUP function, and you may have heard reasons why you should use it. But what does it do, exactly? In this training course...
• Understand data at a glance with conditional formatting: Have you heard about conditional formatting? Get hands-on practice using conditional formatting to make data stand out.
• Sparklines: Use tiny charts to show data trends: As you look at rows and rows of data, sometimes it’s hard to immediately make sense of it. Add tiny charts called sparklines next to data to...
• Use Excel tables to manage information: Learn how to use Excel tables to sort and filter data, get special table formatting, and see table formulas auto fill.
• 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.
• How to create a basic chart in Excel 2010: Learn how to create a chart and how to make changes to a chart after you create it.
• Save time by creating and running macros in Excel 2010: In this training, you'll learn how to record, run, and edit a macro, and how to save a macro to your personal macro workbook so you can reuse it later.
• How to figure out dates by using formulas in Excel 2010: Figure out dates by using formulas in Excel 2010 Overview Use formulas to figure out dates such as how many workdays until vacation, or calculate the...
• How to plan payments and savings in Excel 2010: Learn how to use financial functions in Excel formulas to figure out payments and savings

PowerPoint 2010

• Getting started with PowerPoint 2010: If you know PowerPoint 2007, used an earlier version of PowerPoint, or have never used PowerPoint before, explore these resources to begin learning how...
• Create your first PowerPoint 2010 presentation: Learn to create a PowerPoint 2010 presentation and prepare to share it and deliver your message to an audience.
• PowerPoint 2010 keyboard shortcuts: Learn how to do things more quickly, using your keyboard in PowerPoint 2010.
• PowerPoint 2010 tips and tricks: You’ve created tons of PowerPoint presentations. But perhaps you need some shortcuts to help you work faster, and more effectively. This short course will...
• 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...
• How to put your photos into PowerPoint: Put photos into PowerPoint 2010. Insert one, or make a photo album. Plus learn how to size, crop, rotate, and apply effects to photos.
• How to insert video into your presentation: Insert video into PowerPoint 2010. Learn how to link video, embed video, and set playback options.
• How to broadcast a presentation: Learn how to broadcast a presentation using PowerPoint 2010. Find out what's required, how to broadcast internally and publicly, and what problems that can occur.
• Charts and diagrams I: SmartArt graphics: In this PowerPoint 2010 training course, you'll learn to work with SmartArt graphics, so you can create things like process diagrams or organization charts.
• Charts and diagrams II: Data charts: In this training course, you'll learn to create line, column, and other data charts in PowerPoint 2010.
• Animations and transitions: Add animations and transitions using PowerPoint 2010. Animate slides, text, bullets, pictures, charts, and shapes. Learn how to add animations to all slides...
• Going further with animations: Control animation timing, animation speed, and animation duration in PowerPoint 2010. Add animation delays, change the animation order, and even add a sound...

Want to use these Microsoft Office training resources offline? Ok, here’s the link to download the Microsoft Office 2010 trainings for offline use. Also, did you know that we hold free Microsoft Office webinars every Tuesday that you can join us for to get more information and insights? If not, be sure to check out the upcoming schedule of webinars (which includes links to view past sessions if you missed them) and start joining us each Tuesday.

As a Microsoft partner, be sure to utilize the Microsoft Office 2010 resources we have for you on the Microsoft Partner Network portal:

• Microsoft Office 2010 Partner Training Resources
• Microsoft Office 2010 Partner Sales & Marketing Resources

Here are some “Top 10 Reason” docs to also help you out:

• Top 10 reasons to try Access 2010
• Top 10 reasons to try Office 2010
• Top 10 reasons to try Visio 2010
• Top 10 reasons to try Lync 2010
• Top 10 reasons to try Outlook 2010
• Top 10 reasons to try Office Professional 2010

Did you find this information helpful? If so, you may want to make sure you are utilizing all of the areas I share information online, such as:

My Twitter account My Linkedin account My blog My Facebook page

Get the Microsoft Partner Info Mobile App and get access to the latest from all of those plus: product teams, MPN teams, Microsoft News and hundreds more resources here at Microsoft right on your phone:

Thanks again for being a reader of my blog!

Thank you and have a wonderful day,

Eric Ligman – Follow me on TWITTER, LinkedIn, and RSS and see “What I’m thinking”
Director, Worldwide Partner Experience
Microsoft Corporation
This posting is provided "AS IS" with no warranties, and confers no rights

Bookmark on: MSDN , TechNet, and Expression

Technorati Tags: Microsoft,Office,Office 2010,Word,Excel,PowerPoint,Access,Visio,SharePoint,Word 2010,Excel 2010,PowerPoint 2010,Access 2010,Visio 2010,SharePoint 2010,training,resources,videos,download,how to,MPN,Microsoft Partner Network,Eric Ligman

del.icio.us Tags: Microsoft,Office,Office 2010,Word,Excel,PowerPoint,Access,Visio,SharePoint,Word 2010,Excel 2010,PowerPoint 2010,Access 2010,Visio 2010,SharePoint 2010,training,resources,videos,download,how to,MPN,Microsoft Partner Network,Eric Ligman