Tag: A-Office
Buy Office 2007 Now and Upgrade to Office 2010 for Free!
As Office 2010 draws closer to completion, Microsoft has assailed any fears for those purchasing Office 2007 before the official release of 2010 by...
How to Import Your Contacts into Outlook 2010
When I began using Outlook 2010 the first thing that I noticed was the dramatic change of the File menu compared to 2007 and...
Create a Webcast with PowerPoint 2010
The other day I was working on a presentation in PowerPoint 2010 beta (which you can download for free from Microsoft) and found...
Force Outlook 2010 to Download All Messages and Attachments with IMAP
The other day I decided to give Microsoft another try and ran Outlook 2010 which was already installed with the Office 2010 beta (which...
Let Excel Speak to You and Save Time
If you're like me and you're not that great with the number pad on a standard keyboard, Excel's ability to speak what you type...
How to Find and Replace Cell Formats in Excel
One of Excel's most powerful formatting tools is the Find and Replace command. Find and replace allows users to specify elements to locate in...
Save Time by Customizing the Office Quick Access Toolbar
One of my favorite and frequently used toolbars is the Quick Access Toolbar located above the Office Ribbon. By default the toolbar has shortcuts...
Use Rules to Validate Data Entry in Excel 2007
Data entry rules in Excel give users more control over the type of data that can be entered into cells in spreadsheets. We discussed...
Group and Ungroup Rows and Columns in Excel
Outlining and grouping rows or columns in Excel makes it easy to organize and declutter spreadsheets that have a ton of data on display....
Use Comments in Excel to Document Your Work
Commenting in Excel allows you to keep annotations and references on specific cells. Comments are generated by the user as described in the tutorial...
Use AutoFill and Save Time Entering Data in Excel
As a frequent user of Excel I find that one of the most useful features is AutoFill. When preparing spreadsheets for presentations or when...
Use Validation Lists in Excel to Control User Input
If you create spreadsheets in Excel and would like a way to ensure that data entered by others is consistent, you can use data...
How to Display Multiple Excel Windows in the Taskbar
I often work with multiple Excel windows at any given time and I have found that I work best with Excel when all open...