Excel

Q. My tables never look right when I paste them into Power­­Point. How should I paste Excel data into PowerPoint?
Q. How can I return characters to the left of a dash in an Excel cell using the LEFT function?
Q. I have a spreadsheet where three address lines are separated by a line break. How do I use text-to-columns to separate the lines into columns?

New features in Office 2013

December 26, 2012 Categorized in: ExcelInternetPowerPointWord

Microsoft Office 2013 has arrived with some new features that could make your job easier.

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.