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…”
January 29, 2012
Categorized in: Excel
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.
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.
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.