Extract Hyperlink Addresses in Excel with VBA or Office Scripts

Office Scripts extract Excel hyperlink URLs without macros; results are hardcoded so the file can stay .xlsx, reuse is straightforward.

How to create a drop-down list in Excel in seconds - and save yourself tons of time

Drop-down lists in Excel are a great way to speed up data entry, keep your sheet tidy, and avoid typos. No formulas required!
How-To Geek on MSN

The hidden Microsoft Excel feature I wish I’d started using years ago

The Camera tool is the best feature in Microsoft Excel that is hidden away from the dashboard, but you can find it today.
How-To Geek on MSN

I build all my calendars in Excel—here's how you can too

Stay on top of your personal and work commitments.
GitHub

redoper1/xlsx-js-style

SheetJS with Style! Create Excel spreadsheets with basic styling options using JavaScript. Based on the gitbrent/xlsx-js-style.
JournalofAccountancy

Create interactive dashboards with Excel PivotCharts and slicers

Q. How can I use Excel to turn static financial reports into interactive dashboards that decision-makers can explore? A. You can use Excel for creating interactive dashboards using PivotCharts ...