K2 Office Tips Header
Volume 7, Number 11  

November, 2012
ExceltopIn This Issue 
Excel Tips 

Quick Link
 Technology Tips Video
WordtopIn This Issue 
Word 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 into our busiest teaching time of the and I have teaching assignments across Canada until the week before Christmas. We just finished a very successful Accounting Technology seminar in thirteen cities across Canada. This is the 20th year that I have been hosting this series and it was great to see so many familiar faces.


My latest eBook, entitled Microsoft Word - Part 1 is now available. This one hundred and thirty page book is chock full of tips that will help you create great documents in Word. Like my other seven eBooks, it sells for $34.95 and gets you 2 CPDs. 


The web store link is http://www.mcssl.com/store/alanswebstore


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




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. Press 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 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.


 PowerPoint Tip


Summary: PowerPoint has the capability to translate text into other languages. Here is how to do this: 

  1.  Click on the Review tab.
  2. Highlight the text you want to translate.
  3. Select the Translate button from the Proofing Group.
  4. Choose the language to translate from and to.
  5. Click on Insert to insert the translation into your PowerPoint slide. 


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