Data Management & Solutions
11 articles · sorted newest first
- The Excel Name Manager: Named Ranges, Named Formulas and LAMBDA — Benefits and Pitfalls
- Power Pivot and the Data Model in Excel: A Beginner's Guide
- How to Combine Data from Multiple Sheets into One with Dynamic Arrays
- 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