Data Management & Solutions
9 articles · sorted newest first
- How to Combine Data from Multiple Sheets into One with Dynamic Arrays new
- Excel Data Validation & Dependent Lists
- Data bars, colour scales and sparklines: data visualisation in Excel that doesn't use traditional charts.
- Conditional formatting and custom cell formats in Excel — icons, colour rules, and data visualisation without charts
- Workbook Analysis (FastExcel)
- When VBA is too risky and every task needs not Excel but a working application
- How to use Excel Tables: why every dataset should be in Table format
- How to structure an Excel workbook. The four-layer architecture for maintainable spreadsheets.
- How to clean messy data in Excel. Remove duplicates, trim spaces, fix formats