Excel

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.

Quick poll-taking with Outlook

March 1, 2007 Categorized in: ExcelOutlook

Need to poll the ranks? If you’re an Outlook (2003) user, you can send an e-mail message with voting buttons to make things easier. Here’s how to do it.
Say you’re trying to use an Excel spreadsheet to track weekly wages for office employees. It’s simple enough to create a formula (hours x hourly rate) that calculates wages for someone who works 40 hours or less. But what if someone works 45 hours one week?