Excel Tip – 3 Different Count Functions

Have you ever wanted to know how many entries were in a list in Excel? You can use the Count functions to give you an accurate number. The first Count function only counts cells that contain numbers. Will ignore any cell that has text in it =COUNT(A2:A24) The second...

Excel Tip – Total Multiple Columns at Once

If you have columns similar to the example below there is an easy way to total them all at once. Select the empty cells beneath each column (where you want to see the answer). Click in the cell beneath the first column, hold down Ctrl and click on the cell underneath...

OneNote Tip – Tag Items for Follow-up

Make sure that items are followed up and completed by using tags. You can mark them as Important and add a check box beside your item that can be checked off when the task is complete. Or put a question mark if more information is needed. In OneNote, click at the...

Outlook Tip – Keyboard shortcuts to move between sections

For all those of you who love your keyboard shortcuts, here are some for Outlook. When Outlook is open they enable you to navigate between Outlook’s different sections. You can go to your Inbox by pressing CTRL+1. Calendar CTRL+2. Contacts CTRL+3. Tasks CTRL+4. Notes...