Join OfficeTipsAndMethods

Have some suggestions to share with the world?

Join OfficeTipsAndMethods and share your insight in a Comment. You must be a member to comment and all comments are moderated before being published. Membership is free and we would never share your personal information with anyone.

Become an OTM Member

Log In

YouTube Video Channel
Article Categories

Posts Tagged ‘Office Skills’

Good News! Microsoft Release Free OneNote

Microsoft have announced the release of OneNote for Mac, Android, and Windows platforms.What is OneNote, you ask? Take a minute and view this video.

OneNote has become an essential personal assistant for my day to day work. I have used it to create several notebooks, each dedicated to one aspect of what I do on a daily basis.

For example for my Office Applications training practice, I have a notebook with one section group for each client. When I am in contact with a new training client, the first thing I do is create a new section group for that client. Within that section group, I will create a new section for each training engagement I discuss with the client. Section contents include emails, notes on phone meetings and any other information relevant to the training session.

On a volunteer basis, I desktop publish a weekly bulletin. I receive content for the bulletin from a number of sources. With a quick click of a button, I forward the content as I receive it to the current week section of that notebook. When it comes time to put the bulletin together, all I have to do is go to the current week section of my bulletin notebook.

Those are just a couple of examples of how OneNote helps me keep my one-man show afloat. OneNote, however, is not just a tool for individuals. Large organizations also benefit from this easy to learn and use tool. Pfizer, for example, estimates that OneNote improves its effectiveness by 15%.

Potential uses for OneNote may not be infinite but its usefulness is really limited only by your imagination. Once you start to use it, the possibilities the you will realize for your own OneNote use will grow exponentially.

So You Want to Expand Your Office Knowledge?

Here are some useful links that I have recently come across on the Web. The list is weighted in favour of Excel only because, at the moment, I am doing mostly Excel training.


Migrating from Excel 2003 to Excel 2010

A help guide to working with the Fluent User Interface (Ribbon) first introduced in Office 2007 and enhanced in Office 2010, replacing traditional menus and toolbars


Office Tips and Methods

A blog focusing on tips and how to techniques for getting the most out of Microsoft Office Applications


User peer support forum primarily focused on Microsoft Access but with an active Excel forum as well

Mr. Excel

Bill Jelen’s (Mr. Excel) site includes peer support forum and many pages of Excel help and tips from Mr. Excel himself

Excel is Fun!

YouTube gateway to the ExcelisFun channel –hundreds of well documented videos illustrating how to do just about anything in Excel.

Microsoft Answers


An excellent collection of Excel related links

Clever data validation example

Charting Examples

Color Palette and the 56 Excel ColorIndex Colors:

Create an Excel UserForm

Excel Add-ins Directory:

Analytics and Visualization

Excel for Developers


Excel VBA – Reference Guide

Free Spreadsheets!forum/microsoft.public.excel.programming


Index of /Excel:

The Spreadsheet Page:

Excel Add-ins Directory

Use Excel spin boxes to help with financial modeling:

VBA for Microsoft Office Excel 2007

Yahoo Groups MS_Excel

Yahoo Groups Excel VBA:training.

Essentials–Windows Mouse

Mouse and keyboard essentials can become second nature quite quickly, once you learn them. However, if you are new to Windows computing or have simply learned by doing, you may be missing some of the basics.

This article will focus on basic keyboard skills which all seem simple once you know how to use them but which some people find very difficult to use in the first place. The article includes some examples of shortcuts that are possible with the mouse or keyboard actions but our main interest is how to use the mouse and keyboard keys alone or in various combinations. Many times when you ask for help the article or forum post suggests that you use mouse or keyboard keys is certain ways. This article is about what these suggestions mean.

How familiar are you with your mouse? Here are some basic points to be aware of:

  • Mouse

    • Right or Left

      A basic windows mouse has two ‘keys,’ left and right. When you rest your right hand, palm down on the mouse, your index finger rests naturally on the left key and you second finger rests on the right. The left key is used to select or choose the item you have used the mouse to point to on the screen. The right mouse key is typically used to open a shortcut menu of choices that are appropriate to whatever it is you are doing at the moment.

    • Click or Drag

      A Click is a single quick down and up motion of the specified mouse key. A Drag on the other hand, means that you should press and hold down the specified mouse key while you move the mouse in the desired direction.

    • Scroll Wheel

      Your mouse may have a wheel between the left and right keys. You can spin this wheel in either direction. The action spinning the wheel causes depends, in part on where you are pointing when you spin it. For example, in Word 2007, or 2010 (or any of the Office applications with the ribbon interface), spinning the wheel which change the active ribbon tab.

    • Single Click

      Different actions require different kinds of clicking. A Single Click means quickly pressing and releasing the mouse key once only.

    • Double Click

      A Double click, on the other hand, means rapidly pressing the mouse key twice. The setting for just how quickly it is necessary to repeat the click for Windows to interpret your mouse action as a double click is adjustable (see below.)

    • Control Panel Adjustments

    Windows 7 Control Panel

      You can use the Mouse options in the Windows Control panel to adjust double click speed and to switch the Left and Right mouse key if you prefer to use the mouse in your left hand

      • Adjust double click speed

        If you have difficulty double-clicking you can use the mouse properties to adjust the time between the first and second click.

      • Switch Left and Right

        If you are left-handed you can use the mouse properties so that the mouse keys are reversed.