We're well into autumn, here in Canada, so it's time for another Excel roundup. To get Excel links and articles every week, sign up for my weekly Excel newsletter.
Here are a few of the Excel articles that I've published recently.
Drop Downs – Sometimes data validation arrows disappear, for no apparent reason. See some of the causes for that behaviour, and how to fix or avoid the problems
Macros – Put your macros on a custom Excel Ribbon tab, by making simple changes on a worksheet, in my free sample workbook.
Pivot Tables – Use macros to automatically name drilldown sheets, and delete some or all of them when closing the workbook
Comments – Use these macros to move or resize Excel comments that have wandered away from their original locations
Watch the recordings from a couple of recent Microsoft events.
Power BI - If you missed Microsoft's Business Applications Summit this summer, watch the session videos online. Type "Excel" in the Search box, to see a list of those sessions.
Microsoft Ignite – You can also watch sessions from September's Microsoft Ignite conference. Here is the list of Excel sessions, and they all look interesting.
Shortcuts - Harvard Business Review has a list of 10 Excel features and shortcuts that everyone should know. Does it really take 15 minutes to learn Freeze Panes?
Errors - Jon Peltier wrote a tongue-in-cheek article about Excel error messages. How many of those gems have you seen?
Solver - Kevin Lehrbass shows how to use Excel's Solver feature to solve a puzzle, with simple formulas.
VLOOKUP - If you're using Excel in Office 365, you should notice significant improvements in Lookup function speed, after the latest update. For other versions of Excel, here's a comparison of VLOOKUP speed and INDEX/MATCH.
Data Model - Rick de Groot has a good lesson on how to use the Data Model in Excel. There are lots of screen shots, and clear explanations.
Prediction - Dave Smith, from Excel with ML, shows how to build a recommender system in Excel, similar to the Netflix system.
ModelOff - The Excel questions and answers have been posted for last year's ModelOff competition. You might find a new formula or two, to use in your own Excel projects.
Models - Brett Whysel, a former investment banker, shares 8 ways to make more powerful Excel models -- "begin with your end in mind".
Macros - Jon Acampora shows two ways to assign keyboard shortcuts to your macros, and lists the pros and cons of both methods.
Passwords - Doug Glancy shows how to make a Password form in Excel, with a Cap Lock warning, and a "Show Text" button.
Automation – You can create macros to save time in Excel, but are you automating yourself out of a job?