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?

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

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

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.

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…”

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.