Month: July 2018
Excel Guru shares a reader’s story of a neat trick to protect a table, without restricting the workbook’s usability. How? Using the Visual Basic Editor to make it Very Hidden!
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?!
The Smallman explains a little known oddity about how Worksheet names are referenced in Excel. Learn something new every day!
Excel User gives you a 3-part in-depth walkthrough of Index-Match, and why it’s better than VLookup!
Excel Campus shares several ways to select multiple shapes or objects at once.