Posts Tagged ‘Office Skills’
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.
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.
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
BLOGS AND PEER SUPPORT SITES
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
Bill Jelen’s (Mr. Excel) site includes peer support forum and many pages of Excel help and tips from Mr. Excel himself
YouTube gateway to the ExcelisFun channel –hundreds of well documented videos illustrating how to do just about anything in Excel.
An excellent collection of Excel related links
Clever data validation example
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
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.
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:
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.
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.
Different actions require different kinds of clicking. A Single Click means quickly pressing and releasing the mouse key once only.
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
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.
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