Excel

Ditch PowerPoint for ... flip charts?

Switzerland’s Anti-PowerPoint Party is seeking support for a national referendum to ban the use of PowerPoint. Author Matthias Poehm believes PowerPoint is the wrong tool for making an effective presentation. His advice? Go back to using a flip chart.

1-Minute Strategies: Feb. '11

Let your body language broadcast your confidence ... Keep track of your “must read” pile with Delicious.com. It’s a particularly useful tool for longer-term storage of important articles, and you can access it from any device ... On your résumé, list accomplishments, not just job duties.

Deck the halls with Microsoft Office

4 great tips for using Microsoft Word, PowerPoint, Excel and Outlook to help you manage your holiday tasks.

Pivoting Multiple Ranges in Excel 2007: Yes You Can!

I’m not sure whether it was intentional, but there seems to be something missing from the Create Pivot Table dialog box in Excel 2007 and 2010.

Quick Excel Tip

Duplicate a style you’ve created in one MS Excel workbook in another workbook. Here's how:

Calculation anomalies in Excel® 2007: That darned penny!

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®

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

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?

“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:

Admins' favorite keyboard shortcuts

Whether it’s a speedy way to create a bar chart or a trick for switching from one window to the next, keyboard shortcuts can help even the experienced admin knock out work faster. Here are a few of our readers’ faves:

Quick Search

Advanced Search

  • Reply to this week's question:

    Get Weekly Forum Updates

Tools

Articles