17 January, 2012

Office Downloads and updates

Word 2010 Help and How-to | Word 2010 Videos | Word 2010 Training

Training Switching from Word 2003 or earlier to Word 2010? Take this course to get familiar with the changes and see how to do key everyday tasks.

Article 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...

Training 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...

Training 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...

Training Learn how to use the new Navigation Pane and Search features in Word 2010.

Training In Microsoft Office 2010, when files open, Message Bars can alert you to useful information and potential problems with your files. Security Message Bars...

Training Learn to apply graphical formatting to text, enhance images with picture tools, insert clippings and screenshots in documents, and use SmartArt graphics.

Article Get free, downloadable versions of many Office 2010 training courses. They’re in PowerPoint 2010 format, so you can customize them for group training or...

Training Create and format headers and footers in Word 2010. Work with page numbers, text, and images in headers and footers.

Training 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.

Training Learn what steps you can take to make your Word 2010 documents more accessible to everyone.

Training 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...

Training Learn keyboard shortcuts in Word 2010.

Outlook 2010 Help and How-To | Outlook 2010 Training | Outlook 2010 Videos

Training Switch from Outlook 2003 to Outlook 2010. This course explains how to do familiar tasks, such as send e-mail messages and use the calendar.

Training Ever wish you had a smarter, handier way to arrange your Outlook Inbox? Now, learn how Date (Conversations) can simplify and clarify your view — and how...

Article whether you used an earlier version of Outlook or have never used Outlook before; explore these resources to begin learning Outlook 2010.

Link Learn how to save time in Outlook 2010 by using Quick Steps, a new feature that allows you to perform multiple actions at once.

Article Get free, downloadable versions of many Office 2010 training courses. They’re in PowerPoint 2010 format, so you can customize them for group training or...

Training Learn how to use the Outlook 2010 calendar to create appointments and meetings, set recurrence, tasks and reminders, and create all-day events

Training Learn how to use e-mail signatures. This course shows you how to create signatures, use handwritten signatures, pictures, and complex layouts.

Training Learn how to create electronic business cards. This course shows you how to edit and format them, and use downloadable card templates.

Training Learn how to subscribe to RSS Feeds and view those Feeds in Outlook 2010

Training Learn how to send out-of-office replies to people who send email messages to your Outlook 2010 Exchange Server account, and how to create rules to help...

Training Overview Help manage your Inbox, calendar , and to-do list b y using conditional formatting. A conditional format is simply a rule that changes the...

Training Learn how to use templates with email, calendar items, tasks, and contacts in Outlook 2010. Templates can save you a lot of time and help reduce errors.

Training Overview Learn how to manage your Outlook 2010 mailbox by setting and changing views, settings that control how Outlook displays your data. This course...

Training Overview Learn how to manage your Outlook 2010 mailbox with Instant Search and Search Folders. Instant Search helps you find anything in your mailbox...

Training Create folders in an Outlook mailbox, and in an Outlook data file. You'll also learn how to move items into and out of folders, and manage folders.

Training Learn with Harry as his mentor shows how to use Outlook to increase productivity with email and time management best practices.

Training Learn Outlook 2010 keyboard shortcuts for your email inbox. Learn CTRL key shortcuts that let you move messages, create new email messages, search email...

Training Learn Outlook 2010 keyboard shortcuts for your calendar. The shortcuts in this course will primarily use the CTRL key, and they’ll help you create meetings...

Training Learn how to use ALT key shortcuts that let you access almost any command in Outlook 2010. These keyboard shortcuts are also called access keys, and they...

Excel 2010 Help and How-to | Excel 2010 Training | Excel 2010 Videos

Make the switch to Excel 2010

Training Are you switching to Excel 2010 from a previous version? This course is for you.

Getting started with Excel 2010

Article 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...

Get to know Excel 2010: Create your first spreadsheet

Training 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

Training 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

Training Learn to use formulas to do math, update formula results automatically, and use predefined formulas (functions) to calculate things like monthly payments.

Download Office 2010 training

Article Get free, downloadable versions of many Office 2010 training courses. They’re in PowerPoint 2010 format, so you can customize them for group training or...

VLOOKUP: What it is, and when to use it

Training 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

Training 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

Training Overview 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

Training 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

Training Overview 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...

How to create a basic chart in Excel 2010

Training 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

Training Overview 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...

Figure out dates by using formulas in Excel 2010

Training 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...

Plan payments and savings in Excel 2010

Training Learn how to use financial functions in Excel formulas to figure out payments and savings

Excel 2010 keyboard shortcuts I: CTRL key shortcuts

Training 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

Training 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...

Saving a site as a template

You can save a site as a template at any time using the template option (Save site as template) on the Site Settings page in SharePoint. SharePoint Designer 2010 make it easy by providing a Save as Template option in the ribbon, which takes you to this page in SharePoint. Once you save the template, a solution file is created and stored in the Solution Gallery where you can download or activate the solution.

To save your site as a template using SharePoint Designer 2010, perform the following steps:

1. Open your site in SharePoint Designer 2010.
2. On the Site tab, in the Manage group, click Save as Template


 3.This takes you to the Save as Template page in SharePoint.

4. Specify a name to use for the template file in the File name field.
5. Specify a name and description for the template in the Template name and Template description fields.
6. To include the content of the site in the site template, check the Include Content box.
Note: Including the content of the site can increase the size of the template significantly. Keep in mind that the default size limit for a site template is 50 MB but may be less in your organization.

7. Click OK to save the template.
8. If all of the components on the site are valid, the template is built, and you see a message that says Operation Completed Successfully.
9. To download or activate the solution from the solution gallery, click the user solution gallery link and follow the steps in the procedure below.
10. Or, to return to your site, click OK.