Five Excel Skills That Matter
Master five core Excel skills and you cover 80 percent of daily analysis.
Cleaning Duplicate Rows in Excel
CONCATENATE, sort and IF statements find duplicates while keeping an audit trail.
What Makes Excel Models Good
Good models climb four levels: working, flexible, easy to use, visual.
Mistake-Proofing Your Work
Poka-yoke, a Japanese mistake-proofing concept, offers a practical way to prevent errors by design.
If It Skips Excel, Think Twice
Genuine data-driven consulting engagements almost always require heavy spreadsheet work.
Small Spreadsheet Errors, Big Costs
Small spreadsheet formatting mistakes signal a lack of rigor even when the math is correct.