Excel

Get that Excel chart onto a slide

December 13, 2012 Categorized in: ExcelPowerPoint

Q: What is the best way to paste an Excel chart into PowerPoint 2010?

Start the New Year off right with Excel templates

December 10, 2012 Categorized in: Excel

If you’ve ever accidentally saved over a document you needed by using it to create a new one, or accidentally deleted long and complex formulas, you’ll appreciate these tips on selecting, modifying and creating Excel templates.
You’ve plugged in the values for a PMT (payment) function to determine how much the payment will be only to find that the payment is a bit too much for your budget. You could keep plugging in numbers until you get the right answer, or find out the exact answer in a couple of clicks with one of the “What If” analysis tools in Excel.

3 great Excel questions

May 30, 2012 Categorized in: ExcelThe Office Tech Pro

Some people ask why I keep teaching these applications. “Don’t I get bored?” Not with great questions like these! I solved one of the following questions awhile back for my own use. The other two started out as “I don’t know, let’s see…”
There is a way to get the look of Merge and Center without the inconvenience.
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.
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.
4 great tips for using Microsoft Word, PowerPoint, Excel and Outlook to help you manage your holiday tasks.
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

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: