Month: August 2018
JKP shows you what to do if your Add-ins are not loading correctly.
Excel is Fun announces a new Iron Chef competition for some of the top Excel Youtubers!
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!