Griddy Blog
Practical spreadsheet notes.
Guides for formulas, cleanup, charts, and the spreadsheet work people actually get stuck on.
Page 6 of 11 · 128 posts
How to Calculate Percentage in Excel
Calculate percentages in Excel for budgets, margins, growth, discounts, and completion rates with practical formulas that avoid common mistakes.
How to Track Expenses in Excel
Track expenses in Excel with a clean transaction log, categories, receipt status, and summary formulas that make monthly review easier.
How to Use the LEN Function in Excel
LEN counts characters in Excel. Use it to audit invoice IDs, product codes, imported text, and fields that need a fixed length.
How to Use the SORT Function in Excel
SORT creates a live sorted copy of a range in Excel. Use it for dashboards, invoice lists, project reports, and clean review views.
How to Use the TRIM Function in Excel
TRIM removes extra spaces from text in Excel. Use it to clean imports, vendor names, lookup keys, and pasted data before formulas break.
How to Use LEFT, RIGHT, and MID in Excel
LEFT, RIGHT, and MID extract characters from text. Use them to clean IDs, split codes, pull dates, and standardize imported data.
How to Use MATCH in Excel
MATCH returns the position of a value inside a row or column. Use it when a lookup needs the row number, column number, or field position.
How to Use ROUND, ROUNDUP, and ROUNDDOWN in Excel
ROUND, ROUNDUP, and ROUNDDOWN control decimal precision in Excel. Use them for pricing, budgets, forecasts, and clean reporting.
How to Use TEXTJOIN in Excel
TEXTJOIN combines text from multiple cells with a delimiter. Use it to build clean labels, addresses, summaries, and client-facing strings.
Expense Tracker vs Expense Report: What's the Difference?
An expense tracker records ongoing spend. An expense report packages specific costs for review or reimbursement. Here's when to use each one.
How to Build an Expense Report in Excel
Build an expense report in Excel with the right columns, approval fields, receipt tracking, and formulas for clean reimbursement totals.
How to Categorize Expenses in Excel
Categorize expenses in Excel with clear rules, dropdowns, lookup tables, and review fields so spending reports stay consistent.