Microsoft Office 2010 Training

Better conditional formatting

Conditional formatting allows you to analyze Excel data with just a few clicks. New icon sets and formatting options for data bars are available to add to conditional formatting in your documents.  We will show you how.

Improved charts

We will show you how Sparklines works. Sparklines are tiny charts that fit within a cell. They are useful for showing a snapshot of your data in a small amount of space.

Expanded charting limits: Now the number of data points in a data series is only limited by available memory.

Double-click to format charts: In Excel 2010, you can instantly access formatting options by double-clicking a chart element.

Macro recording for chart elements: You can use the macro recorder to record formatting changes to charts and other objects.

Improved PivotTables

PivotTables are easier to use and are more responsive in Excel 2010. Multi-threading to speed up performance; the ability to fill down labels; and new search features are some of the enhancements in Excel 2010.

Slicers are a visual way to filter the data in PivotTables. When a slicer is inserted, you use buttons to filter the data and display what you need. Slicers also make it easy to see which filters are applied.

Improved functions

Excel 2010 includes a set of more accurate functions for statistics. Some existing functions have also been renamed so they better describe what they do.

Improved filtering

A new search filter helps you to find what you need in large worksheets quickly. Search filters can be used in tables, PivotTables, and PivotCharts. AutoFilter buttons also remain visible as you scroll down in a table.

Equations in text boxes

Excel 2010’s built-in Equation Tools make it easier to write and edit equations by keeping them inside text boxes on a worksheet.

Ribbon

Traditional menus and toolbars have been replaced in Outlook 2010 by the Ribbon, a single mechanism that makes all the commands needed to perform a task readily available.  We will walk you through the new Ribbon and tabs.

File tab / Backstage view

We will show you how to access Backstage view and find common commands (Open, Print, Save) as well as more advanced ones (Automatic Replies, Mailbox Cleanup, Rules and Alerts).

Quick Steps

Quick Steps allow you to perform multiple tasks with a single click. We will show you how to customize the default Quick Steps or create your own.

Conversation View

Conversation View groups related messages together and displays them under a single thread in your Inbox.  We will show you how Conversation View works.

Meeting Reply

The Meeting Reply command allows you to reply to an e-mail by scheduling a meeting. We will show you how to use the Meeting Reply command to schedule a meeting and add all the message recipients to a new meeting request in one click.

Outlook Social Connector

The Outlook Social Connector keeps you informed about the activities and status of your personal and professional contacts. The Outlook Social Connector connects to third-party social networking sites and updates Outlook based on those sites. (optional demo)

Search tab

We will show you how to use The Search tab.  It appears on the Ribbon every time you perform a Search, providing instant access to various search-related options.

Zoom Slider

We will show you how Zoom Slider allows you to control how much information you see in the Reading Pane of your mailbox and on your Calendar.

Mailbox Cleanup

Mailbox Cleanup makes it easier to access advanced tools to manage your mailbox, empty deleted items, and archive older items. It also includes a visual representation of how much space is left in your mailbox.

People Pane

The People Pane appears at the bottom of the Reading Pane and displays information about the person(s) associated with the selected item. Social media information (if applicable) is displayed for each person, as well as any related files, appointments, or notes.

Ribbon customization

Now you can add/remove tabs, create your own groups, and rearrange commands on the Ribbon.

Quick Contacts

We will show you how to locate contacts quickly in Outlook 2010 using the Quick Contacts feature.

Schedule view

View the calendars of everyone in your team simultaneously using Schedule view.

Calendar groups

We will teach you how to keep track of team member schedules by creating a Calendar group. A Calendar group can include multiple people and resources such as conference rooms.

Meeting Suggestions

Outlook 2007 introduced the Meeting Suggestions feature, but it’s become more prominent in Outlook 2010. Now, scheduling suggestions will appear in a meeting request whenever you invite someone else to a meeting.

Updated Navigation Pane

The items in the Navigation Pane have been reorganized in Outlook 2010. The most important folders (Inbox, Drafts, Sent Items, Deleted Items) now appear at the top of the list, with all other folders alphabetized beneath it.

To-Do Bar updates

The appearance of the To-Do bar has been improved in Outlook 2010. The To-Do bar now provides better access to all-day appointments and events. There are also updated visual indicators for conflicts and unanswered meeting requests and day separators. Finally, it is easier to resize the To-Do bar in Outlook 2010.

Better Proofing Tools

If you change one of several spelling checker options in one Office program, that option is now updated in all the programs. Also, the Outlook 2010 spell checker can now recognize some contextual spelling errors—for example, the use of “their” vs. “there”.

Word E-mail Editor

The Microsoft Word program is now Outlook’s only e-mail text editor. You can no longer turn it off and use a native Outlook editor.

Include Screenshots

Outlook 2010 makes it easier than ever to include a screenshot of your computer screen in an e-mail. You can take a screenshot of your whole screen, or you can clip the screen and include the screen clip in an e-mail