Excel Made Practical — Guide + Practice Workbooks

Stop guessing in Excel. Start using it to run your business.

Most Excel guides teach with made-up lists of fruit and fake sales reps. This one teaches with the stuff you actually deal with: quotes, orders, customers, costs and margins.

Excel Made Practical takes you from your first click to PivotTables, one clear step at a time. By the end you'll have built a working job pricing and profit tracker you can keep using.

What's inside

• 📘 14-page step-by-step guide with spreadsheet examples for every concept
• ✏️ Practice workbook where the data is already typed in, so you just fill in the formulas as you go
• ✅ Solutions workbook with every answer filled in, so you can check your work or copy what you need

You'll learn to

• Write formulas that update themselves, and finally understand that $ sign
• Total, average and count with SUM, AVERAGE, COUNT and friends
• Make Excel decide for you with IF, SUMIF and COUNTIF ("How much has this customer spent?")
• Pull prices from a price list automatically with VLOOKUP and XLOOKUP
• Add drop-down lists that stop typos before they break your numbers
• Make problems stand out with color-coded alerts for overdue jobs and low margins
• Build charts and PivotTables that summarize months of sales in seconds
• Fix the errors that trip everyone up: #N/A, #DIV/0!, #VALUE! and more

Perfect for: small-business owners, freelancers, trades and shop owners, office staff, and anyone who's tired of fighting their spreadsheets.

The bonus you'll keep using: the final project walks you through building a tracker that prices each job (blank cost + markup + setup and rush fees), calculates your profit margin, flags low-margin jobs and totals what you've collected.

Works with Excel for Windows, Mac and Microsoft 365. Instant download (one .zip with the PDF and both .xlsx workbooks), so you can start in the next five minutes.

Bundle deal: Get this guide, Open Anyway and The 90-Day Business Planner for $30.75 instead of $41. Add all three to your cart and use code GRIT3 at checkout for 25% off.

Ready to put your new skills to work? The Owner's Toolkit bundles the Bookkeeping Kit, the Job Pricing & Breakeven Calculator and the 13-Week Cash Flow Forecast for $30 instead of $47.