K2 Office Tips Header
Volume 9, Number 9  

September, 2014

September in Brampton has been a very good month. The weather has been perfect; sunny and not too hot and we are really enjoying our deck.  

 

Nancy and I travelled to Kelowna to attend the Institute of Professional Bookkeepers of Canada annual conference last week. Getting easier and easier for me to fly. I did an Excel session and a keynote on the "Bookkeeping Office of the Future". Both were well received.

 

This month my focus has been on finalizing the details for our 2014 Accounting Technology  seminar series that I have been coordinating for the last twenty two years. The seminar is designed for the smaller accounting firms, bookkeepers and technology consultants. It features a series of presentations designed to bring the attendees up to date on what's new in the technology world for them and their clients. The cost is $39.95, plus tax and you receive a free webinar, which is in itself is worth $39.95, plus you earn 10 CPDs. Most of the cities are sold out. To check on which cities are still available "
CLICK HERE
"
  

In August we launched two new on demand webinars. The first is entitled "Excel Tables - Revolutionize How You Work with Excel!" Tables were new in Excel 2007. Think of them as two-dimensional Excel databases with special functionality to ease and enhance the way users sort, filter, format, and analyze information. To purchase this webinar CLICK HERE.

 

The second is entitled "Plain Tech Cookbook - Plain Tech Talk for Your Office". This on demand webinar will help you to understand what hardware to buy, including notebooks, Ultrabooks, desktops, servers, wireless networking tools, and firewalls, along with printers and scanners - in other words simple recommendations for hardware. Additionally, it includes software recommendations in several categories such as anti-virus and collaboration to help round out your purchasing strategy. To purchase this webinar please CLICK HERE.
 

As usual, I welcome your comments at [email protected]

 

Sincerely, 

 

Alan Salmon

Excel Tips

Excel1Want to Automatically Sum a Column or a Row From the Keyboard?    

Summary: There are many different ways to sum a column or a row. Here's how to quickly do it from the keyboard.  

  1. Select the first empty cell at the bottom or to the right of the numbers you want to add.
  2. Select ALT + "=". 
  3. Press the Enter key.

The numbers will be summed. 

 


Excel2AWant to Display all the Formulas in a Worksheet?     

Summary:  There are times when you are auditing a workbook when it is useful to display the formulas in a cell, rather than the results. Here is how to do this:

  

To display the formulas hold down the CTRL key and the "Tilde" key. This is the key furthest to the left on the row with the number keys. It looks like an "s" on it's side.


 
This will display all the formulas in the worksheet. Hit CTRL + "Tilde" again and your numbers will reappear..

  

Back to top

 

Excel3Quickly Adding or Deleting a Column
Summary: Managing columns and rows in a worksheet is an all day task. Here is how to use keyboard shortcuts to save time when you are doing this task:

To add a column select a cell in the column to the left of where you want the new column.
  • CTRL + "=" will add the column.
  • CTRL + "-" will delete the column. 

 

Word Tip

 

Word1Quickly Creating Numbered or Bulleted Lists            

Summary: We often use numbered and/or bulleted lists in a Word document. You can add them from the ribbon, but here's a neat shortcut to add them from the keyboard. 

To create a numbered list type a number with a period and then a space at the beginning of the sentence. After you enter your text for the first number press Enter and Word will move down a row and enter the next number.

To create a bulleted list type "*" and then a space at the beginning of the sentence. After you enter your text for the first bullet press Enter and Word will move down a row and enter the next number.

It's that easy.

 

 

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

[email protected]  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