K2 Office Tips Header
Volume 10, Number 10  

October, 2015
ExceltopIn This Issue 
Excel Tips



WordtopIn This Issue 
Word Tip
 
 
Quick Link
 Technology Tips Video
 
Quick Links

 

Previous versions of Office Tips


 


 

 

 



 

   

 


 


 


 


 


 


 


 


 


 


 


 


 


 


 


 


 

Fall has officially arrived in Brampton and the weather is much cooler. We still have some leaves on our trees, but they will soon be long gone.

September and October are busy months for me. Nancy and I had a great time at the Institute of Professional Bookkeepers of Canada annual conference in Niagara Falls. 

  

IPBC released their Benchmark Survey which is the authoritative resource on the state of the bookkeeping profession in Canada. For further information on this study go to the IPBC web site. 

 

In October my focus has been on the 2015 edition of the Accounting Technology Seminar Series. We have now done ten cities with four more to go. Attendance is up and the feedback has been very positive.

 

November and December is professional development time for the CPAs across Canada. K2E Canada Inc. will be doing 57 technology seminars for the Canadian CPA Associations in the next two months. Managing all of these events is always a challenge for me and certainly keeps me busy.


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

 

Sincerely,

 

Alan Salmon

Excel Tips

Summary: It is easy to Hide and Unhide columns in Excel. The exception is when you hide Column A. If you later want to unhide column A the solution can be challenging. Here is how to do this:   
  1. Press the F5 function key.
  2. Excel displays the Go To dialog box.
  3. In the Reference field at the bottom of the dialog box, enter A1.
  4. Click on OK.
  5. Cell A1 is now selected, even though it is not visible on the screen.
  6. Select the Home tab on the ribbon.
  7. Select Hide and Unhide.
  8. Select Unhide Columns.
Column A will now be visible.
     
Excel2AFiltering for Unique Items           
Summary: There are times when you want to copy a list of unique items to another column. This involves using filters in Excel.
  
Here are the steps to filter a data set for unique items.
  1. Select the data to be filtered.
  2. Go to the Data tab.
  3. Click on Advanced in the Sort and Filter group.
  4. Select Copy to another location.
  5. Select Unique Records.
  6. In the Copy To box enter the cell location where you want Excel to place the Unique Records.
  7. Click on OK.
You will now have a list of the unique items in the original data set.

Back to top

Excel3Deleting Duplicates from a Data Set 
Summary: It is very easy to delete duplicate values from a data set. Here is how to do this: 
  1. Select a cell in the data set.
  2. Go to the Data Tab.
  3. Click on the Remove Duplicates in the Data Tools group.
  4. Excel will highlight the data set. If there are columns missing in the selection, go back and make sure there are no blank columns in the selection.
  5. Make sure that My Data has Headers is selected if your data set has headers.
  6. By default, all the columns are selected. A selected column means that the tool will use all the columns to check for duplicates. Duplicates in an unselected column will be ignored. Select the columns that you want to match for duplicates. 
  7. Click OK. The data set will update, deleting any duplicate rows. A message will appear to tell you how many rows were deleted and how many rows remain in the data set.

    Note there is no undo for this process. Save your work before you run this process. 

 

Word Tip

 

WordTip2Inserting Captions          
Summary: You can add captions to screen shots, pictures, charts, text boxes and other graphic objects. Here is how to do this: 
Word's captioning features include preset captions for Figures, Equations, or Tables. Word also handles the caption numbering for you, such as Figure 1, Figure 2, etc.Here's how to add a caption:
  1. Right-click on the figure that you want to add a caption for.
  2. Click Insert Caption.
  3. The Caption dialog box will open.
  4. Click on the Label drop-down arrow.
  5. Select a Caption label.
  6. At this point you change the location of the caption below the figure.
  7. Click OK and Word will insert the Caption.

 

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
President & CEO
K2E Canada Inc.
647-722-4741