Excel

Quick Excel Tip

November 10, 2010 Categorized in: Excel

Duplicate a style you’ve created in one MS Excel workbook in another workbook. Here’s how:
If you work with currency data and percentages, you have likely had an argument with that darned penny! You have flawlessly crafted your worksheet, expertly constructed formulas and can’t reconcile the penny that results when your calculations round up.

Laborless tables in Excel®

September 9, 2010 Categorized in: ExcelThe Office Tech Pro

If someone asked you what a table was (in data speak), you would likely respond with something like a set of data presented in columns in rows. When Excel® 2007 says tables it means a very specific way of formatting data that not only visually arranges into a tabular format, but gives you tools that let you work with that data easily.

Getting MS Office help that helps

June 23, 2010 Categorized in: ExcelWord

Ever sought help in Microsoft Office—only to feel like you needed more help? Melissa P. Esquibel, a Microsoft Certified Trainer who writes “The Office Tech Pro” blog, offers these tips for getting the right help fast, so you can get back to your task:

That Excel error message means what?

May 24, 2010 Categorized in: Excel

“Excel error messages aren’t always terribly clear to us,” says Melissa Esquibel, a Microsoft Certified Trainer who writes “The Office Tech Pro” blog. “We know we have a problem, but we don’t know where to go to start fixing it!” For example, she says, here’s how to decipher three of the most common messages:
This content requires a subscription. PLEASE LOGIN Email Address: Password:   Forgot Password? | Setup Username/Password Subscribe today to get: The nation’s premier newsletter for administrative professionals Unlimited access to AdminProToday.com — updated daily! Skill-building online training, plus valuable forms, templates, skills assessments and more Expert advice on office technology, business communication, workplace politics and […]
Size matters when it comes to planning events. For smaller events, you can go solo. But for larger ones, it takes a committee, a nod from management and a zinger of a spreadsheet for keeping tasks and timelines on track. To help you track the details, try this sample checklist below adapted from Midwest Meetings:

Clearing away the paper clutter

November 7, 2008 Categorized in: ExcelOrganizing

With the holiday season comes an uptick in mail and catalog clutter. Here’s an admin’s suggestion for keeping your office clear of paper clutter …
Ever receive a spreadsheet where someone entered the entire field in ALL UPPER CASE? How do you change the field to upper and lower cases?
For the boss whose drawers and briefcase are whitened with business cards and receipts, it might be time for this tech solution: Neat Receipts ( www.neatreceipts.com ).
Have you discovered all the shortcuts buried within Excel? Try zipping around Excel spreadsheets using these keyboard techniques.
You can’t do much in Excel if you store dates and times as text. When you store them as numbers, though, endless possibilities exist.
Create a quick-and-dirty Excel chart in one keystroke.