an XL ideas Lab
Your Custom Text Here
Convert an Excel range from one reference to relative or absolute referencing.
Convert an entire workbook from formulas to numbers instantly.
Use the Evaluate function in Excel to populate a cell from a number sequence.
In Excel extract the left most item from a horizontal list using INDEX and MATCH.
An Excel custom function that allows sequental number sequences to be created.
Protect an Excel worksheet and use the auto filter. A how to guide.
Add a count formula across multiple sheets in Excel.
Excel VBA to select sheets and print out the selected sheets using PDF.
A Power BI Desktop example using Power BI
This is a list of Excel dashboards - the best I have produced to date. These are time saving Excel tools.