Griddy / Blog
Spreadsheet how-tos.
Step-by-step guides for Excel and Google Sheets formulas, data cleanup, charts, and more — and how Griddy handles each one in seconds.
Page 1 of 7 · 76 posts
Excel COUNTA vs COUNT
COUNT counts numbers. COUNTA counts non-empty cells. Learn when to use each one, where they differ, and the mistakes that distort spreadsheet totals.
How to Use CHOOSE Function in Excel
CHOOSE returns a value from a list based on a position number. Learn the syntax, finance examples, and when to use it instead of nested IFs.
How to Use EOMONTH in Excel
EOMONTH returns the last day of a month before or after a date. Learn the syntax, finance examples, and common date mistakes.
How to Use Named Ranges in Excel
Named ranges make formulas easier to read and maintain. Learn how to create them, use them in formulas, and avoid common workbook mistakes.
How to Create a Budget in Excel
Create an Excel budget with income, expense categories, planned vs actual columns, variance formulas, and a review-ready monthly summary.
How to Use AVERAGEIF in Excel
AVERAGEIF calculates the average of cells that meet one condition. Learn the syntax, practical budget examples, and when to use AVERAGEIFS instead.
How to Use MAXIFS and MINIFS in Excel
Use MAXIFS and MINIFS to find the largest or smallest value that meets one or more conditions in Excel, with finance examples and common fixes.
How to Use TEXT Function in Excel
Use Excel's TEXT function to format dates, numbers, percentages, and currency inside formulas without changing the underlying cell value.
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.