an XL ideas Lab
Your Custom Text Here
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.
No Spaces in Excel sheet names is a good habit to get into.