K2 Office Tips Header
Volume 11, Number 9 

September , 2016
As I write this the first day of fall is upon us and the long hot summer is coming to a close. We haven't been out on deck very much in the last month; the 35 plus temperature is just too much for me. Hopefully, we will have a nice fall.

September has been has been a busy planning month for me. We are well along with plans for an outstanding Accounting Technology Seminar series, which will visit 14 cities from coast to coast in October. Registrations are close to 1,400, and some of the cities only have a few seats left. To make sure you get a seat go to  www.salmon.ca to register.  

The second is a series of free mini seminars. The next one is on October 25th at 12:00 EDT. It last for an hour and features 25 minutes my Excel Magic tips and then switches over to TaxCycle where you will learn how it integrates with Excel. The session will be recorded, so if you can't join us for the live session, register and you can view the webinar on your time. You will receive 1 CPDs for attending. CLICK  here to register for this free event.

Nancy and I are looking forward to attending the IPBC IGNITE conference this week in Vancouver. I am doing a keynote and an Excel session. It will be wonderful to see so many old friends.

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

Sincerely,
Alan Salmo n

Excel Tips

ExcelTopShading Cells Based on Whether the Value in the Cell is Odd or Even
Summary:  If you have a series of values in a range of cells, you can use Conditional Formatting to distinguish the odd numbers from the even numbers. Here is how to do this:    
  1. Select the cells that contain the odd and even values.
  2. Select Conditional Formatting from the Format menu. Excel displays the Conditional Formatting dialog box.
  3. Use the left-most drop-down list and choose Formula Is.
  4. In the formula area, enter =MOD(A1,2)=1. This formula will return True if the cell contains an odd value.
  5. Click on Format and change the format to reflect the formatting you want applied to the cells containing odd values. Click on the button In the Conditional Formatting dialog box.
  6. Repeat steps 3 through 5 for the second condition, but this time use the formula =MOD(A1,2)=0. This condition returns True if the cell contains an even value.
  7. Click on OK to apply the conditional formats to the cells.
When this conditional formatting applied, if the cell is odd it will be one color and if even it will be another. If the cell contains text, the cell will not be colored; it will have the color of the cell before you added the conditional formatting. The conditional formatting takes precedent over any formatting you applied to a cell, so even if you try to change the cell color via the toolbar, the conditional formatting takes precedent.
  
ExcelTip2Quickly 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's 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. 
 

ExcelTip3 Going to the Corners of a Selected Range

Once you have selected the range, hold down the Ctrl key while you press the period key. Excel will move you around the outside corners of the range, in order.

In addition, you can move from the upper-left corner of the selection to the lower-right corner by pressing Shift+Tab once. To move back (from bottom-right to upper-left), just press the Tab key once. 
 

 

Word Tip

 

Summary: Word has a variety of standard page numbering formats. However, you are not restricted to 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:
  1. Your first step, of course, is to insert the page numbers in either the header or footer.
  2. 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.
  3. 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.)

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