K2 Office Tips Header
Volume 12, Number 10 

November , 2017
We are having a wonderful fall this year in Brampton, ON. It makes up for the lousy summer.  
October has been dedicated to the annual Accounting Technology Seminar Series. This is the 25th year that we have traveled with Alan Salmon & Associates Inc. from coast to coast presenting this one-day update on the technology that accountants, bookkeepers and their clients use.    
Research has been a passion of mine for many years. I am pleased to invite your company to become a partner in the 2018 Canadian Accounting Technology Survey. This comprehensive instrument will survey the demographics, practice management and technology that accountants and bookkeepers are currently using and what their plans are for future investments in IT. Look for information on how you can participate in the survey in the December issue of our newsletter.  
Our mini-webinars twice a month are turning out to be very popular. I still have four to do before the end of the year and you will finding information on each of them below. Attend in person and earn 1 verified CPD credit when you answer a minimum of 3 polling questions during the session. Every registrant will receive the recorded webinar so sign up today to ensure that you're on the list.     
More Ways to Earn Verified CPD credits with K2E Canada Inc.  
K2E Canada Inc. along with our partner K2 Enterprises offers a broad curriculum of technology-focused CPD webinars that are accessible from the comfort of your home or office. We invite you to explore our schedule of Live Webinars covering a wide range of topics including Securing Your Data, Practical tools for Protecting Information, Detecting and Preventing Spreadsheet Errors and many more.    
As usual, I welcome your comments at  alan@k2e.ca
Alan Salmo n, FCPB


Excel Tips


ExcelAutoFilterUnderstanding 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.
QuickCloseQuickly Close all Open Workbooks Without Closing Excel  

You need to add the Close All icon to your Quick Access Toolbar
  1. Right mouse click on your Quick Access toolbar and select Customize QAT.
  2. Select All Commands from the drop down arrow in the middle panel of the QAT window.
  3. Select Close All.
  4. Click on Add. The Close All icon will now move to the Quick Access Toolbar selections on the right.
  5. Click on OK.
The Close All icon will now be in your Quick Access Toolbar. To close all your open workbooks just click on the Close All icon. Note that you will still have to save any workbook that has been changed. 
  1. Click on the File Tab in the Ribbon. In Excel 2007 click on the Office Button.
  2. Select Options.
  3. Click on Formulas in the left hand panel.
  4. Under Workbook Calculations click on the Manual radial button.
  5. Click on OK. 
With calculation set to manual, you press the F9 Function Key to recalculate your workbook.    


Word Tip


WordTipSetting 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. 
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   CLICK HERE
Your information is always kept secure and never shared.
Alan Salmon
K2E Canada Inc.