Category: Tips and Tricks
Data Pig talks about how to organize your VBA modules to stay organized and also to achieve the best performance.
Contextures shows us how to create dropdowns that will automatically update their options based on your selections.
Get Digital Help talks about CONCATENATE, and the newer improved versions: CONCAT, and TEXTJOIN
Peltier Tech shows you how to create a chart with two types of lines, so you can easily tell the Historical Data from the Projected Forecast.
Excel by Joe seeks to automate Daily Fantasy Sports by using the Solver in Excel!
Access Analytic sings the praises of Power Query; and they raise the question… No more formulas?!
Excel Campus shares several ways to select multiple shapes or objects at once.
r/Excel responds to a post by u/BoldArch with great advice on improving your Data Presentation!
The Spreadsheet Guru shows us how to create custom lists to improve our Slicers!
Excel TV builds a map using Conditional Formatting!