Start here · Essential guide
Spreadsheets for Everyday Planning and Tracking
Learn the core ways a plain spreadsheet handles lists, schedules, budgets and tracking, and how to set one up so it stays readable as it grows.
Tools And Skills
Spreadsheets And Data Handling
Using spreadsheets and simple data tools well.
Charts That Communicate Clearly
How to pick the right chart type, label axes honestly and remove clutter so a chart answers one question instead of confusing the people reading it.
Cleaning Messy Data Before You Analyze It
A practical order of work for fixing duplicates, inconsistent formats and blank cells in a spreadsheet before you total, chart or summarize anything.
Dashboards for Small Teams
How a small team can build a one-page dashboard around a few key measures, choose what belongs on it, and keep it accurate without a dedicated analyst.
Data Validation and Error Prevention
Learn how validation rules such as drop-down lists, number limits and date checks stop bad entries at the source, plus their limits and how to set them up.
Forms and Surveys for Collecting Information
How to design online forms and short surveys with clear questions, fixed answer choices and sensible structure so responses arrive in a sheet ready to use.
Pivot Tables Explained
A plain explanation of pivot tables: how they group rows by category, what rows, columns, values and filters do, and how to avoid common mistakes.
Sharing Spreadsheets Without Breaking Them
Practical ways to protect formulas, ranges and structure when several people edit one spreadsheet, from locked cells and roles to copies and change tracking.
Spreadsheets Versus Databases
A plain comparison of spreadsheets and databases: what each does well, the warning signs that a sheet is outgrowing its role, and how to move on carefully.
Tracking Project Hours in a Spreadsheet
Simple spreadsheet layouts for logging time worked on projects, with formulas for daily and weekly totals, tips for consistent entries and honest limits.
Related topics
More in tools and skills
Tools By Role What different kinds of workers need. Tool Types And Platforms Cloud, automation, extensions, assistants and device choices. Professional Skills Using software to build workplace skills. Automation And Integrations Cutting repetitive work with rules, shortcuts and connected tools. Choosing And Adopting Tools Evaluating, introducing and retiring software sensibly.