K2 Office Tips Header
Volume 7, Number 5  
May 1
, 2012
ExceltopIn This Issue 
Excel Tips
Quickly Calculating the Average of a Range of Cells

Quick Link
 Technology Tips Video
WordtopIn This Issue 
Word Tip
OutlooktopIn This Issue
 Outlook Tip

PPTTopIn This Issue
PowerPoint Tip
Quick Links


Previous versions of Office Tips





Like us on Facebook




Follow us on Twitter



View our profile on LinkedIn 












We are now into May and I am back to work after a great holiday in April. We did a cruise from Athens to Barcelona and then took the Orient Express from Venice to London. It was wonderful break. But unfortunately all good things have to come to an end, so I am back on the road with a heavy teaching schedule for the next two and a half months.


I am pleased with the response to my latest eBook, entitled Excel Charts - Part 1. This ninety page book is chock full of tips that will help you create great charts in Excel. The response to this new release has been very positive. Each eBook sells for $34.95 and gets you 2 CPDs.


Next will be three eBooks on Microsoft Word. The first one will be ready by the end of May.


The link to my Web Store is http://www.mcssl.com/store/alanswebstore


New for 2012 are our Facebook and LinkedIn pages. I am now posting a weekly tip and additional relevant accounting technology links on these pages. You can follow me on Facebook at 

www.facebook.com/K2Canada and on LinkedIn at www.linkedin.com/in/k2canada. I am continuing to update readers on the status of Office 15, which will be the next version of Excel, Word, etc.


As usual I would welcome your comments at [email protected].



Alan Salmon

Excel Tips

Excel1Quickly Calculating the Average of a Range of Cells 

Summary: Quickly calculating the Average of a range of cells. Here is how to do this:


To quickly calculate the average of a range of cells follow these steps.
  1. Select all the data in the range of cells.
  2. Include a blank row below the table.
  3. Go the Home Tab and click on the drop-down arrow beside the AutoSum button.
  4. Select Average from the list.
Excel will calculate the Averages for each column of data and place the value at the bottom of the table.

Excel2AApplying One Column Width to Other Columns in a Workbook    

Summary: There are times when you want take the width of one column in a workbook and change other columns to that width. Here is how to do this: 


  1. Select the column with the correct width.
  2. Press Ctrl+C to copy.
  3. Select the columns you want to apply that width to.
  4. Go the Home tab and click in the Clipboard group on Paste, Paste Special, Columns Widths. 

The columns you selected will now have the same width as your first column.


Back to top


Excel3Changing the Orientation of Text in a Cell   
Summary:  There are times when you want to change the orientation of text in a cell. Here is how to do this.
  1. Select the cells whose orientation you want to change.
  2. Display the Format Cells dialogue box. In the Home tab of the Ribbon click on the small icon at the lower right hand corner of the Number group.
  3. Click on the Alignment tab.
  4. Use the Orientation section to specify the angle (in degrees) to which the text should be turned. You can set any value between 90 degrees and -90 degrees.
  5. Click on OK. The text will be turned as you directed.
  6. Format your columns to suit the new width of your aligned data. 
Back to top 


Word Tips


Word1Setting Line Spacing


Summary: Line spacing is the amount of space between lines of text and paragraphs. There are times when you may want to double space your text. Here is how to do this: 
  1. Select the text you want to edit.
  2. Click on the Home tab in the Ribbon.
  3. Click Line and Paragraph spacing.
  4. Select the spacing you want for this section of text. 
  5. Word will then apply the spacing to the text.


Outlook Tip



Summary: Getting rid of your deleted e-mail automatically is a time saver. Here is how to do this::

When you delete e-mail in Outlook you are moving it to your Deleted Folder, not to the Recycle Bin on your desktop. Disk space is used for this deleted e-mail and your system runs slower. The solution to this is to have Outlook automatically delete your trashed e-mails when Outlook is closed. Here is the setting to do this:

  1. Open Outlook 2010.
  2. Click on the File menu and select File | Options.
  3. In the Outlook Options window, select Advanced.
  4. Go to the the Outlook Start and Exit area in the Advanced list.
  5. Click on the Check box for Empty Deleted Items Folder when Exiting Outlook.
  6. Click OK.

Now Outlook will empty the Delete Folder every time you exit Outlook.

 PowerPoint Tip


PowerPointarticleUsing Multiple Monitors


Summary: It is often useful to have your audience view your presentation on one screen while you view it on another screen. Your view is called the Presenter View. Here is how to do this:


When you use the Presenter View, you can see different views of your presentation without the audience being able to see your screen. Very useful if you are using notes in your presentation.


The first step in making this happen is to Extend Your Desktop.

  1. Press the Right Mouse on your desktop and select Personalize.
  2. Select Display Settings from the list.
  3. Select 2 for the second monitor.
  4. Check the Extend the Desktop on to this monitor check box.
  5. Set the resolution and colors, as appropriate for your second monitor.
  6. Click OK.
The next step is to Enable the Presenter View. 
  1. Click on the Slide Show tab to display the Monitors group.
  2. Set the resolution or leave as Use Current Resolution.
  3. Select the monitor to Show Presentation on.
  4. Check the Show Presenter View box.
  5. Start the slide show. 


K2 Enterprises Canada is a leading provider of professional development seminars for the Canadian accounting world. Each month we publish this free Office Tips e-mail newsletter. These tips will save you time and enhance the appearance of your Office files.


To subscribe to our K2E Canada newsletter send an e-mail to

[email protected]  with "Subscribe to newsletter" in the Subject. 
Your information is always kept secure and never shared
Alan Salmon
President & CEO
K2 Enterprises Canada