Last week, you had a chance to win John Walkenbach’s new book – 101 Excel 2013 Tips, Tricks & Timesavers, thanks to Katie Mohr at Wiley. Thanks for all your comments – those were great tips!
Show Temperature in Excel Color Scale
How hot was it in your neighbourhood last week? It was so hot, here in Mississauga, that I stayed inside, most of the week. On the bright side, I got lots of work done, but I’d rather have cooler temperatures, than hot, muggy days.
Remove Picture Background and Excel Book Giveaway
Do you ever put a picture or clip art on a spreadsheet? I don’t use them very often, but occasionally I’ll add a small picture on an instruction worksheet, or insert a company logo on a printable form.
Continue reading “Remove Picture Background and Excel Book Giveaway”
Missing Drop Down Arrows in Excel 2013
You can create drop down lists on a worksheet with Excel’s data validation feature, and they make data entry much easier – usually! Sometimes things go wrong though, like missing drop down arrows in Excel 2013. Have you seen that problem?
See Formula Results in an Excel Data Table
Do you ever use the Data Table feature in Excel? It’s one of the “What-if Analysis” tools, found on the Ribbon’s Data tab, along with Scenario Manager, and Goal Seek.
You can experiment with one or two variables in a formula, and see formula results in an Excel Data Table, in a compact layout.
Continue reading “See Formula Results in an Excel Data Table”
Use Check Box Result in Excel Formula
To make it easy for people to enter data on a worksheet, you can insert a check box control, using the Form Control tools on the Developer Tab. Then, use check box result in Excel formula solutions.
Create Excel Table With Specific Style
When you create a named Excel table with the Table command on the Ribbon’s Insert tab, the table retains any formatting that it currently has, and the default Table Style is applied.
Excel Crashing After Combo Box Click
Last week, I was updating my web page that shows how to show a combo box in a cell that has a drop down list. Here’s a screen shot of that workbook.
Dependent Drop Down Lists in Excel
In Excel, you can set up drop down lists that are dependent on the selection made in another cell. In this example, you select a region in column B, and only the customers in that region are in the dependent drop down list in column C.
Calculate Loan Payments with PMT Function
Even if you’re not a financial wizard, you’ve probably had to figure out a loan payment at least once in your life. Fortunately, Excel makes it easy to calculate loan payments, with the PMT function.
Continue reading “Calculate Loan Payments with PMT Function”