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 PowerPoint. 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?
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…”
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.
