KHIZHNYAKOVGuides: how to do it in Excel
Step-by-step guides with examples, formulas and ready-made templates.
How to Build a Calorie Tracker in ExcelWork out your daily calorie and macro targets, log what you eat in grams and see daily totals in a simple Excel spreadsheet.Read the guide →How to Keep a Workout Log in Excel and Actually See ProgressLog sets, reps and weight, calculate volume and estimated 1RM, and track your weight and waist over time in one spreadsheet.Read the guide →How to Calculate NPV, IRR and Payback Period in ExcelA practical walkthrough of NPV, IRR and payback in Excel, with a worked USD example and the most common formula mistake explained.Read the guide →Markup, Margin and Break-even Point: How to Calculate Them in ExcelWhy a 50% markup is only a 33% margin, how to set a selling price in Excel, and how many units you need to sell to break even.Read the guide →How to Calculate Monthly Savings for a Goal in ExcelUse PMT and NPER to find how much to save each month and how long your goal will take, including savings interest and an emergency fund.Read the guide →How to Make a Weekly Meal Planner with an Automatic Grocery List in ExcelWrite your recipes once, pick dishes for each day and let Excel turn the menu into a shopping list that subtracts what you already have.Read the guide →How to Track a Project Budget vs Actual in ExcelCompare plan and actual by month, calculate variance correctly to date, and forecast what the project will cost at completion.Read the guide →How to Plan a Vacation Budget in ExcelBuild a trip budget that handles foreign currencies, separates planned from paid costs, includes a reserve and keeps your packing list in the same file.Read the guide →How to Make a Family Budget in Excel: a Step-by-Step GuideSet up categories, log transactions, total them by month with SUMIFS, catch overspending and plan savings, all in one Excel workbook.Read the guide →How to Make a Habit Tracker in ExcelBuild a monthly habit grid that turns green when you check a day, counts your percentage and streaks, and sits next to a simple task list.Read the guide →How to Do ABC-XYZ Analysis in ExcelRank products by revenue, measure how stable demand is, and combine both into a 3×3 matrix that tells you what to keep in stock and what to cut.Read the guide →How to Calculate Marketing ROI by Channel in Excel: CPL, CAC, ROAS and ROMIFind out which ad channels make money and which burn budget, using a monthly log and a handful of formulas in Excel.Read the guide →How to Build a Small Business Financial Model in ExcelTurn business plan assumptions into a monthly P&L and cash flow forecast, and find your break-even point, cash gap and payback period.Read the guide →How to Calculate Food Cost and Recipe Cost in ExcelCost every dish down to the cent, including trim and waste, and find the menu price that hits your target food cost percentage.Read the guide →How to Make a Social Media Content Calendar in ExcelPlan posts by platform and category, track deadlines and statuses, see the month at a glance and measure engagement in one spreadsheet.Read the guide →How to Price Handmade Products (and Know Your Real Profit)A simple pricing formula for makers that includes your time, a worked example with a candle, and how to track orders, payments and profit.Read the guide →Debt Snowball vs Debt Avalanche: How to Plan Your Payoff in ExcelList your debts, choose snowball or avalanche, and see the payoff order, your debt-free date and how much interest you save versus paying minimums.Read the guide →How to Plan a Wedding Budget and Guest List in ExcelTrack every vendor contract, deposit and balance, keep a reserve, and manage RSVPs, tables and menu counts in one wedding spreadsheet.Read the guide →How to Calculate the Reorder Point in ExcelUse average daily sales, supplier lead time and safety stock to know exactly when to reorder each product and how much to buy.Read the guide →How to Track Accounts Receivable and Build an Aging Report in ExcelLog invoices and payments, calculate balances and days overdue, sort debt into aging buckets and know exactly whom to call this week.Read the guide →How to Track Car Expenses and Fuel Economy in ExcelLog fill-ups and every other car cost, calculate fuel economy and true cost per mile, and get reminders when service is due.Read the guide →How to Calculate Stylist Commission and Salon Payroll in ExcelLog each service once and let Excel work out the stylist's commission, product costs, card fees, salon profit and end-of-month payroll.Read the guide →How to Track Time by Project and Client in ExcelSet up a project timesheet that calculates billable amounts, watches hours budgets and shows what is still to invoice and unpaid.Read the guide →How to Track Freelance Income and Your Real Hourly Rate in ExcelCombine hourly work and fixed-price projects in one spreadsheet, see who still owes you, and find out what you really earn per hour.Read the guide →