Category: Tips and Tricks
Excel Solutions has a very detailed walkthrough showing you how to Protect your data in excel.
Excel by Joe is back with more Excel techniques for Fantasy Sports. This time he optimizes for Best Ball scoring, but the theory is useful outside of the sports world too!
You may know how to insert line breaks, but Excel Champs shows you how to use line breaks within a CONCATENATE formula!
JKP shows you what to do if your Add-ins are not loading correctly.
Excel Dashboard School walks you through the FREQUENCY function, entered as an Array Formula
Dinesh Kumar Takyar shows you how to open other programs from within Excel. How? VBA of course!
Get Digital Help is back with a way to pull date ranges from a schedule with an ingenius combination of several formulas.
Chris Webb goes in-depth on combining data from multiple Excel worksheets with Power BI.
Wellsr shows you how to use VBA to change the opacity of a form, allowing you to fade in or out. I didn’t know this was possible!
Able Bits shows you several ways to solve a common issue in Excel.. dealing with numbers that are formatted as text!
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!