K2 Office Tips Header
Volume 13, Number 4 

April , 2018
It's Easter as I write this April newsletter and Spring is supposedly here. We are getting some nice sunny days but it sure is cool.

In March I was head down for the month analyzing the data from the  2018 Canadian Accounting and Bookkeeping Operations and Technology Survey and writing the report. We received an amazing 2,532 respondents and it provides a comprehensive picture of the Canadian accounting and bookkeeping world today.

Here's what Ray Desjardin, CPA CA had to say about the report when he reviewed an advance copy of it.

"As a sole proprietor or the member of a smaller firm, it is very difficult for me to measure how my firm is performing with reference to technological progress.  Compared to my peers, am I spending enough on technology training?  Am I falling behind with respect to hardware and operating systems? Is my software up to date?  Am I leading edge or "bleeding" edge?  The accounting and bookkeeping operations and technology survey helps me evaluate where my firm is performing well and where I need to focus more of my time and effort.  It's a great tool for gauging my firm's technology profile."

If you did not take the survey, you can still get a copy of the report HERE . For the month of April there is an Easter special of $79.95, which saves you $20 from the normal price. 

In 2018 we are continuing our "Road to Excellence" mini-webinars. You will find information on them below. Attend in person and earn 1 verified CPD credit when you answer 75% of the polling questions during the session. Every registrant will receive the recorded webinar; so sign up today to ensure that you're on the list.
 Tuesday April 10 at 12:00 ET 
K2's Road to Excellence with Excel - Part 8 and VohCom

Tuesday May 15 at 12:00pm ET 
K2's Road to Excellence with Excel - Part 9 and Adagio

Wednesday May 23 at 12:00pm ET 
New for 2018 is our broad  curriculum of over 50 technology-focused CPD live webinars accessible from the comfort of your home or office and available for a remarkably low price. We invite you to explore our calendar of  Live Webinars covering a wide range of topics including K2's Power Charting in Excel and Excel Pivot Tables for Accountants - Part 1.  

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

Alan Salmo n, FCPB


Excel Tips


ExcelAutoFilterClosing an Existing Workbook Without Exiting the Program      
Summary: When you close Excel, it exits you from the program. To open another Excel workbook you have to start Excel all over again. This is a big time waster. Here is how to close an Excel workbook and stay in Excel:
To close a workbook and stay in Excel press Ctrl+W. This will close the workbook and keep Excel open. If you have not saved your file before you press Ctrl+W, Excel will prompt you to save the file and then will close.

PS This also works in Word and PowerPoint.  
Summary: When you want to print certain rows/columns of data you are likely to hide the other rows/columns. However, when you then want to unhide cells in hidden rows/columns, it can be a challenge to locate them. Here is how to do this:
The solution is to select all visible cells in the worksheet. You can then easily detect the hidden rows/columns, as they will be highlighted in white. To select the visible cells on the worksheet.
  1. On the Home tab, in the Editing group, select Find & Select.  Select Go To Special
  2. Under Select, click Visible cells only.
  3. Click OK
All visible cells are selected and the borders of rows and columns that are adjacent to hidden rows and columns are marked with a white border. 
Note:  Clicking anywhere on the worksheet will cancel the selection of the visible cells. If the hidden cells that you want to unhide are outside of the visible worksheet area, use the scroll bars to move through the document until the hidden rows and columns that contain those cells are visible.  

Updating Data Without Using Formulas 
Summary: There are times when you need to update a column of figures by the same amount. Here is how to do this:  
Let's assume that you have a budget worksheet and you want to increase the selling price of a list of products by 5%.
  1. In an empty cell enter the value 1.05
  2. Press Ctrl + C to copy the value in the above cell
  3. Select the range to be updated
  4. Select the Home tab on the ribbon
  5. Click on the Paste icon dropdown arrow
  6. Click on Paste Special
  7. In the Paste Special dialog box select Multiply
  8. Click OK
All the values in the range you selected will be multiplied by 1.05. There are no formulas and you can delete the 1.05.

  Back to top  


Word Tip


WordTipFormatting Page Numbers        
Summary: Word has a variety of standard page numbering formats. However, you are not restricted to just these formats. You can format page numbers exactly the same as you format any other text in your document. Here is how to do this:


Your first step, is to insert the page numbers in either the header or footer. When you are working in the Print Layout view, you can double-click on the header or footer, select the page number, and manually format it.

You format the page numbers exactly the same as you format any other text in your document. For example, you can make the page numbers bold, italic, change their size, etc.

However, if you are in the Draft or Outline view, you will have to  switch to the Print Layout view before you can edit the header or footer. (If you use the Header and Footer tools on the Insert tab of the ribbon in order to access the header or footer, Word switches you to the Print Layout view automatically.)



Back to top    
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.
Alan Salmon
K2E Canada Inc.