It’s all about Excel

November 7, 2013 Categorized in: Excel

How is the new Excel Sumlfs different from SumIf, and how do you dissect a formula to troubleshoot?

Create a color legend in Excel

August 16, 2013 Categorized in: Excel

Q. I’d like to provide a “legend” so people know what the different Conditional Formatting colors mean in Excel. How can I do this?
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.