Pro Member Tutorials Archives - Page 52 of 116

How to Manually Edit Attendees’ Responses to a Meeting Request (Outlook 2010 & 2007)

If an attendee to a meeting request has responded verbally, or their response did not update in your calendar, you can manually edit the Meeting Request Response. This process is shown in Outlook 2010, but will work the same in Outlook 2007.

This post is only available to members.

How to Use ‘Concatenate’ to Combine Data in Multiple Columns into One Column (Excel 2010/2007/2003)

December 24, 2012
Helios Visions
Microsoft Office Productivity, Pro Member Tutorials

There are times when you may have data in multiple columns that needs to be combined into one. You can use the ‘Concatenate’ function to easily accomplish this task. In this example we will take two columns that contain a first name and last name and combine them into a column that contains the last name a comma and the first name. You can combine the contents of two or more cells. This process will work the same in Excel 2003, Excel 2007 and Excel 2010.

This post is only available to members.

How to Easily Identify Merged Cells in a Worksheet (Excel 2010/2007/2003)

December 24, 2012
Helios Visions
Microsoft Office Productivity, Pro Member Tutorials

Merged cells can play havoc with the normal functioning of some of Excel’s tools. There may be times that you need to identify merged cells in a worksheet before performing certain functions. Using the “Find” feature, you can quickly identify any merged cells. This process will work the same in Excel 2003, Excel 2007 and Excel 2010.

This post is only available to members.

How to Forward Multiple e-mail Messages at Once (Outlook 2010/2007/2003)

You may need to forward multiple e-mail messages at once for many reasons. This is easily accomplished in Outlook 2003, Outlook 2007 and Outlook 2010. Outlook will group the messages into one message for consolidation and this will allow you to forward them all at once.

This post is only available to members.

How to Resend a Previously Sent e-mail Message (Outlook 2007)

There may be times when you need to resend an e-mail message. Instead of going into the “Sent” items folder and selecting “Forward”, you can actually use Outlook to resend the message (eliminating the FW: in the subject line).

This post is only available to members.