K2 Office Tips Header
Volume 10, Number 5  

May, 2015

Nancy and I are back from a wonderful holiday in Ireland and stayed in two real castles including Ashford Castle, on the west coast, where we did a falcon walk. The falconer took two falcons with him and when we entered the woods he released them and they flew off into the trees. When he whistled mine came swooping back and landed on my gloved hand. It was an amazing experience.


My focus now is on the 2015 edition of the Accounting Technology Seminar Series. This is a one day seminar offered in thirteen Canadian cities that provides bookkeepers and accountants with an update on the technology that they and their clients use. It is worth ten non-verifiable CPDs. This is my 23rd year in organizing the tour. Last year ten of the thirteen cities sold out, so early registration is well advised.  



As usual I would welcome your comments at alan@k2e.ca.




Alan Salmon

Excel Tips

Excel1Understanding Regions in Excel  

Summary: Regions are important in Excel. This tip will help you understand how Excel uses regions .  

Much of the work that you do in Excel is done using a specific area of the worksheet. These areas are called Regions. For example, when you sort data, Excel first selects a region that it will sort. A region is defined as the area surrounding an active cell that is bounded by blank columns and rows. Regions are often called a list or a table.


To see what Excel considers to be the region surrounding a cell, simply select the cell and press Shift+Ctrl+* (that's the asterisk.) The region is then highlighted.


Excel2AFiltering for Unique Items         

Summary: There are times when you want to copy a list of unique items to another column. This involves using filters in Excel.


Here are the steps to filter a data set for unique items.

  1. Select the data to be filtered.
  2. Go to the Data tab.
  3. Click on Advanced in the Sort and Filter group.
  4. Select Copy to another location.
  5. Select Unique Records.
  6. In the Copy To box enter the cell location where you want Excel to place the Unique Records.
  7. Click on OK.
You will now have a list of the unique items in the original data set.


Back to top


Excel3Watching a Formula Update on Another Sheet 
Summary: The Watch Window in the Formula tab lets you watch a cell update as you make changes that affect it. This is highly useful when you have formulas that span multiple sheets and you need to watch a cell on one sheet while you make changes to another sheet. Here is how to do this:
  1. Select the Formula tab. 
  2. In the Formula Auditing group select Watch Window.
  3. Click Add Watch to open the Add Watch dialog box.
  4. Select the cell on the worksheet that you want to watch update and click Add.
  5. Repeat steps 3 and 4 to add additional cells to monitor.

If you leave the Watch window open and make changes to cells that will affect the watched cells you will see the changes in the Watch Window. 


Click on the Watch Window icon again to minimize the Watch window area.


Word Tip


Word1Showing or Hiding Screen Tips             

Summary: When you hold your mouse over a command or tool, a ScreenTip is displayed. The tip can be just the name of the command or tool, or it may be enhanced with a short description. You can hide the tips or change whether they are enhanced or not.Here is how to do this:  
  1. Click on the File tab.
  2. Select Options.
  3. Click on the General Option.
  4. Open the Screen Tips Style drop-down list, and select the option you want
  5. Click on OK.

 PowerPoint Tip


PowerPointarticleLines and Arrows in PowerPoint  

Summary: Most presentations will include lines and arrows. It is easy to add a simple line and then format it to suit your particular needs. Here is how to do this: 


To Draw a Line

  1. Click on the Home tab or the Insert tab.
  2. Click on the Shapes button in the Drawing group.
  3. Select a Line or Arrow shape from the available list.
  4. Click and drag the mouse pointer to add the line to your slide.
  5. Release the mouse button to draw the line.

Adding a Quick Style to a Line

  1. Click on the line that you want to add the Quick Style to.
  2. Click on the Home tab.
  3. Click on the Quick Style button from the Drawing Group.
  4. Highlight the style that you want to use.
  5. Click on the Style.

Adding Arrows to Lines

  1. Click on the line that you want to add the arrow to.
  2. Click on the Format tab.
  3. Click on the Shape Outline button from the Shape Styles Group.
  4. Click on the Arrows button.
  5. Click on the Arrows type that you want.
  6. Click on Close.

Modifying a Line

  1. Click on the line that you want to add the arrow to.
  2. Click on the Format tab.
  3. Click on the Shape Outline button from the Shape Styles Group.
  4. To change the thickness of line click on Weight.
  5. Choose the thickness you want to apply to the line.
  6. To change the style of the line click on Dashes.
  7. Choose the style of the line you want to apply to your line.
  8. Click on Close.

Formatting a Line

  1. Click on the line that you want to format.
  2. Click on the Format tab.
  3. Click on the Format Shape Dialog Box launcher from the Shape Styles Group.
  4. Adjust the various settings to change the formatting.
  5. Click on Close. 


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

alan@k2e.ca  with "Subscribe to newsletter" in the Subject. 
Your information is always kept secure and never shared
Alan Salmon
President & CEO
K2 Enterprises Canada