KeyStone OnDemand increases office productivity by providing training videos, articles, and courses for virtually all the Microsoft and IT applications used by your organization, in an ondemand format. Now workers can get the training and answers they need, while the Helpdesk can focus on more important business goals.

In Excel 2007, there’s a great NEW feature – Sorting and Filtering Data by Color! In previous versions of Excel, we’ve had access to three features in particular that help analyze data:

• Sorting
• Filtering
• Conditionally Formatting

Each of these is a great feature all by itself in helping you to see visually data trends and hot spots. But, with the newly enhanced sorting and filtering in Excel 2007, now you can see trends and hot spots based on formatting, such as:

• Cell color
• Font color

And, because the conditional formatting feature has been greatly enhanced, Excel 2007 completely opens up the sorting and filtering views. You could spend an entire day just exploring these improvements.

Continue Reading...

Sure, you can sort your text, if it’s in a table; but can you sort your paragraph text? Believe it or not, the two procedures are nearly identical. Take the following list, for example:

Watermelon
Bananas
Grapefruit
Apples
Oranges
Grapes
Pineapple

This list is clearly not listed in alphabetical order. To let Word sort this list (so you don’t have to), first highlight the list and then, click the Sort command located in the Paragraph group on the Home tab.

For a simple list like our example, just click OK. Your list takes on the newly sorted appearance shown below:

Apples
Bananas
Grapefruit
Grapes
Oranges
Pineapple
Watermelon

p.s. – If you’re using Office 2003, you can find the same Sort dialog box under the Table menu (Table: Sort).

Subscribe to the KeyStone OnDemand blog to be the first to learn about future Microsoft Word Training tips.

By far the BEST (okay, one of the best) shortcuts in Excel is the one related to AutoSum. AutoSum is the most common formula used in Excel to automatically calculate a range of numbers. And, it has a handy, related AutoSum command on the Ribbon. But, there’s an even faster shortcut for AutoSum —> ALT+ =.

Deanna

PS – In my opinion, the BEST shortcut in Excel is F11. What does F11 do? If you don’t know, open Excel, highlight a range of numbers and press F11. …very cool!

Subscribe to the KeyStone OnDemand blog to be the first to learn about future Microsoft Excel Training tips.

In every class I’ve taught for the past ten years, someone ALWAYS asks me for a list of keyboard shortcuts. You would have thought I would have taken the hint long ago, but I’ve finally found the time to create a full list of keyboard shortcuts for each of the main Office programs including Word, Excel, PowerPoint and Outlook. What’s more, these shortcuts are not version specific, meaning they’ll work in 2003 and 2007.

On each of the keyboard shortcut sheets that I’ve created, there is one section called, “That Office Girl’s Favorites…” The shortcut keys listed under this section are the ones I use nearly daily and those are the shortcuts I’m posting here for Microsoft Word.

Repeat F4
Save CTRL+S
Page Break CTRL+ENTER
Center Align CTRL+E
Double Space CTRL+2
Go To F5
Font Dialog Box CTRL+D
Undo CTRL+Z
Select a Column ALT+DRAG
Thesaurus SHIFT+F7
Tab in a Table CTRL+TAB
Previous Location SHIFT+F5

Just be sure to spend all of the time you’ll be saving after implementing these shortcuts wisely!

Subscribe to the KeyStone OnDemand blog to be the first to learn about future Microsoft Word Training tips.