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”
Getting Started With Excel UserForms
With some VBA programming, you can create an Excel UserForm, to use for data entry. Click a button, and the data is stored on a hidden worksheet, and the form is cleared out, so you can start a new entry.
If you’re just getting started with Excel UserForms, the short video below shows how a completed form works.