K2 Office Tips Header
Volume 10, Number 8  

August, 2015

Summer is winding down here in Brampton. The weather has been great and we have enjoyed our deck immensely. I have had some health issues this month but it looks like I am on the road to recovery.


My focus now is on the 2015 edition of the Accounting Technology Seminar Series. This is a one day seminar offered in fourteen Canadian cities that provides bookkeepers and accountants with an update on the technology that they and their clients use. It is worth ten CPDs. This is my 23rd year in organizing the tour. Toronto and Calgary are already sold out and the others are filling up fast, so now would be a good time you to register.  


As well, I am finalizing the IPBC Benchmark Study report. The response to the survey in June was great and the report will provide readers with a clear understanding of the state of the bookkeeping profession in Canada today. Look for this to be released at the upcoming IPBC conference.

Hot off the press. Office 2016 will be released September 22, 2015.

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




Alan Salmon

Excel Tips

ExcelTopUsing Text to Columns to Convert Text to Dates
Summary: Working with dates requires those dates to be in an Excel Date format. Here is how to convert a text date to one of the many Excel date formats:   
  • Select the range of text dates.
  • Click the Data tab.
  • Select Data Tools | Text to Columns and a wizard dialog box will open.
  • In the wizard dialog box, click Next twice to go to Step 3 of the Wizard.
  • Use the default settings in the first two steps of the wizard.
  • In Step 3 of the wizard, select the Date option and select your desired format.
  • Click Finish and the text dates will convert to dates that can be formatted and used in calculations.

Excel2ASelecting only Visible Cells in a Worksheet          
Summary: There are times when you want to only copy the visible data in a worksheet. Here is how to do this:
An example of this is when you need to copy SubTotals that have hidden rows and columns. A normal copy and paste will include the hidden data.

Here's the steps:
  • Select the range of cells.
  • From the Home tab, in the Editing group, select Find & Select.
  • Under Select, select Visible cells only.
  • Select OK.
  • On the Home tab, in the Clipboard group, select Copy.
  • Activate the worksheet you want to copy the data to.
  • On the Home tab, in the Clipboard group, select Paste.
Just the visible cells will be pasted in the worksheet.
Back to top

Excel3Creating a Text Box 
Summary: There are times when you want to add a note to a cell. It is easy to do this with a Text Box. Here is how to do this: 
  1. On the Insert Ribbon select Text Box.
  2. Draw a rectangle in your worksheet about the size and shape that you want your text to fill.
  3. Paste or type in you text.Select the text in the text box and use the Mini Toolbar to format the text to an appropriate font size.
  4. Right click in the text box and select Format Shape
  5. On the Line Color category, select No Line. In the Text Box category you, you can specify the number of columns you would like in the Text Box. 


Word Tip


WordTip2Highlighting Information in a Word Document Using Shading          
Summary: There are times when you would like to highlight a piece of text in your Word document. Here is how to do this: 

You can do this with Word's shading tool.  
  • To add shading to a paragraph involves the following steps:Click and place your insertion point in the paragraph that you want to shade.
  • Click on the Home tab of the ribbon.
  • In the Paragraph group, click on the down-arrow to the right of the Shading tool. (This tool looks like a tilted paint bucket, spilling paint to the right.) Word then displays a shading palette.
  • Hover over a color and your paragraph will be shaded with that color. 

When you find a colour that you like, click on the colour and your paragraph will be shaded. 



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