K2 Office Tips Header
Volume 9, Number 7  

July, 2014

July in Brampton has been a very good month. The weather has been perfect; sunny and not too hot. We are really enjoying our deck. Got out of the house for a couple of days to attend a family wedding in Burlington.


This month my focus has been on finalizing the details for our 2014 Accounting Technology  seminar series that I have been coordinating for the last twenty two years. The seminar is designed for the smaller accounting firms, bookkeepers and technology consultants. It features a series of presentations designed to bring the attendees up to date on what's new in the technology world for them and their clients. The cost is $39.95, plus tax and you receive a free webinar, which is in itself is worth $39.95, plus you earn 10 CPDs. To register please " CLICK HERE."
My next webinar focuses on "Consolidating Data in Excel".  Combining data from multiple worksheets or workbooks is daily fare for most accountants, yet many professionals do not fully appreciate the breadth of Excel options available for accomplishing this task. 
This webinar will be available the first week in September. To be notified when it is available please "CLICK HERE."   

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




Alan Salmon

Excel Tips

Excel1How do you Set Your Formulas to Update Manually?   

Summary: Excel updates your formulas every time you press the Enter key or press an arrow key. With large workbooks you can reduce the calc time by setting your formulas to update manually. Here is how to to do this:  

  1. Click on the File Button. (Office Button in Excel 2007).
  2. Select Excel Options.
  3. Click on Formulas.
  4. Under Calculation Options select Manual.
  5. Click on OK. 

To recalculate the workbook click on the F9 function key on your keyboard. 


Excel2AUpdating Links Manually          

Summary: With a linked workbook the links are updated automatically each time you open the workbook. However, there are times when you need to update the links manually. Here is how to do this:


With the master worksheet open that contains the links:

  1. Click on the Data tab.
  2. Click on Edit Links.
  3. Click on Update Values.
  4. Click on Close.
The links in the worksheet will now be updated from the source worksheets.


Back to top


Excel3VLOOKUP Trouble Shooting 
Summary: VLOOKUP formulas sometimes return an error or an incorrect answer. When that happens here are some trouble shooting tips.
  • The entire cell contents must match 100%.
  • Be careful of extra spaces before and after a word.
  • If you are matching numbers, make sure that both the lookup value and the matching value are formatted with the same type.
  • Sometimes when you are importing data, numbers get formatted as text. This will also return an error message. 


Word Tip


Word1Using Text Effects             

Summary: Word 2010 and 2013 has a new text effect button and menu that allows you to apply a number of visual effects to selected characters, such as shadow, glow and bevel.Here is how to apply these effects:  
  1. Select the text to which you want to apply the effect.
  2. Click on the Home tab.
  3. Click on Text Effects in the Font Group.
  4. In the Text Effect drop down menu hover over the various effects to see the results on your selected text.
  5. Click on the effect you want to apply.

The selected text will now have the effect applied to it.



K2E Canada Inc.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
Managing Director
K2E Canada Inc.