homecomputer trainingProfessional DevelopmentOnline LearningPrivate Training

Just Tips on Training

Outlook 2007,2010: Ignore Conversations

Thursday, September 15th, 2011

Outlook’s Conversation View groups messages and their replies under a single heading so that you can easily follow the string of emails that have the same Subject. When emails are replied to again and again, the same message can appear in each Reply.
To delete repeated messages in the Conversation, you can use the Clean Up [...]

EXCEL 2007-2010: Filter Excel Tables from Table Headings

Thursday, September 15th, 2011

When your data has been entered into Excel, you can use the built-in Filter tool on the Data Tab to narrow down what you are viewing based on criteria you set:
Enter your data.

On the Data tab, click the Filter button.
(It’s a toggle button meaning: "one click on, one click off")

Click the arrow next to the [...]

PowerPoint 2010: Animate a Chart in a Presentation

Friday, August 12th, 2011

If you want to see each column in your chart appear separately during your presentation, just follow these steps.

Copy a column chart from Excel.
Paste it onto a blank PowerPoint slide.
Select the Chart.
Click the Animation Tab.
Select the Fade effect.
Click on the Effects Options drop-down menu.

 
 
 
 
 

Excel: Setting Constant Column Widths in a PivotTable

Friday, August 12th, 2011

When you update a PivotTable, Excel can often change some of the column width formatting you previously set. Here’s how you can protect the column widths you want for the PivotTable. After your PivotTable is created and columns formatted…

Select any cell in your PivotTable.
Display the Options tab from the PivotTable ribbon.
Click the Options tool at [...]

Word 2007 and 2010: Creating AutoText Entries

Friday, August 12th, 2011

Word 2007 and 2010: Creating AutoText Entries
The AutoText feature saves you time if you type and retype the same text. Often, to accomplish this, we open a document with the text, copy and then paste it into a new document. AutoText is a way to automate this repetitive data entry.

Enter the text you want to [...]

Getting the most from your training dollar and employees

Saturday, July 9th, 2011

What if we train our employees, and they leave? — Controller
What if we don’t, and they stay? — HR
In tough times, training is often the easiest thing to cut, but investing in your employees can have high dividends in the short and long term. Here are a few tips for getting the most from your [...]

PowerPoint Video: using action buttons to open different documents or presentations within your Slideshow

Saturday, July 9th, 2011

You can use the action button feature to create an interactive button that will launch other programs, documents or presentations from within your slideshow.

 
 
 
 
 

Word 2010: creating bookmarks and hyperlinks

Saturday, July 9th, 2011

If you are working on a large document, you can create bookmarks and then create hyperlinks to those locations from anywhere in your document.
CREATING A BOOKMARK

Click where you want to place your bookmark
Click on the Insert tab, and in the Links group, select Bookmark
In the Bookmark dialog box, type the bookmark name then click the [...]

Excel 2010: how do I create a drop-down list in Excel?

Saturday, July 9th, 2011

You can create a drop-down list in Excel, so that others can select from a list of options to populate a cell, using a feature called a Data Validation.

Select cells you want the drop-down list to appear in
On the Data tab, in the Data Tools group, click the Data Validation button, then select the Data [...]

PowerPoint 2010: creating your own color theme

Saturday, July 9th, 2011

If you want to ensure you have a consistent color theme throughout your presentation, you can select one of the Microsoft design/color themes, or you can create a custom color theme.

On the Design tab, in the Themes group, click the arrow to the right of the Colors button
Select Create New Theme Colors at the bottom [...]