K2 Office Tips Header
Volume 9, Number 12  

December, 2014
ExceltopIn This Issue 
Excel Tips 


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

 

 Follow us on Twitter 

   Like us on Facebook


 

  

  

  

  

  

  

  

  

  

  

  

  

  

  

  

  

The year is winding down quickly here in Brampton, ON. Nancy and I are looking forward to the festive season with our families. They are so large now that we have to do two family Christmas's, one for her family and one for mine and we do these the Sunday before and the Sunday after Christmas. Christmas Day for the Salmons is a quiet one with just the two of us enjoying our many blessings.

 

This is a special Christmas for both of us. Nancy's sixth grandchild was born in June. My first great grandson was born in August. So we will have little ones again in the house.  

 

There are just a few weeks left to ensure that you have enough professional development hours for the 2014 year. On-Demand Webinars from K2E Canada Inc. are an affordable and convenient way to earn 2 CPDs from the comfort of your home or office, on your time. 

 
We're extending our Black Friday sale by taking $10 off the price of any webinar in our catalog - that's a 20% savings - until December 31st. 

Visit our webstore and enter the Coupon Code BFSALE to receive the discount upon checkout. 
 
Nancy and I want to wish you and yours all the best for the season and hope you have a wonderful 2015.
 

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

 

Sincerely, 

 

Alan Salmon

Excel Tips

Excel1Quickly Inserting the Date into a Worksheet  

Summary: There are many times when you need to insert the date into a cell in a worksheet. Here is an Excel shortcut that will do that very quickly:  
 
Select the cell where you want to enter today's date. Hold down the Ctrl key while you press the ; (Semi colon key) on your keyboard. Excel will enter today's date into the cell.

 


Excel2AUpdating a Workbook Manually         

Summary:  Normally your Excel workbook recalculates automatically whenever you make a change to a worksheet. With large workbooks this can slow your work down as the workbook constantly recalculates. To overcome this problem, you can turn the calculation mode to manual, so you determine when you want the workbook to recalculate. Here is how to do this: 

 

  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.  

Back to top

 

Summary: Often times when you import data into Exel dates will come in as text . They do not display properly and you cannot do date arithmetic. Here is how to convert text date to dates: 

Select the desired cell that contains the text date. Let's assume the selected cell is A1.

 

  1. In cell A2 enter the following formula.
    =DATEVALUE (A1)
  2. The DATEVALUE function returns the serial number of the date represented by the text date.
  3. Right click on the selected cell that contains the formula.
  4. Select Format Cells.
  5. Select Date
  6. Select the desired date format.
  7. Press the Enter key.
  8. To convert the formula to a value copy the cell(s) that contain the =DATEVALUE formula.
  9. Then in A1 do a Paste Special Values.
     

You can now delete the cells that contain the =DATEVALUE formula. 

 


 

Word Tip

 

Word1Selecting a Group of Words
            

Summary: Many times when you are working with a Word document, you need to select a group of words. Here is a fast way to do this: 
  1. Position the insertion pointer inside the word at one end of the group you want selected.
  2. Click on the word at the other end of the group, while you are holding down the Shift key.
The group of words is now selected.

 

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 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
Managing Director
K2E Canada Inc.
647-722-4741