Articles
Practical spreadsheet guides, templates, and tutorials
Learn how to use Excel and Google Sheets efficiently. Clear explanations, productivity tips, and ready-to-use spreadsheet tools for business, finance, and everyday work.
Sep 29, 2026
Win Rate, Profit Factor and Expectancy: How to Calculate Them in Excel
Learn the four numbers that describe a trading edge: win rate, payoff ratio, profit factor and expectancy. Formulas, COUNTIF/SUMIF/AVERAGEIF setup for Excel and Google Sheets, a worked 10-trade example, a breakeven win rate table, common pitfalls and a calculator you can paste your own trade results into.
Read more
How to Build a Rental Property Income and Expense Spreadsheet
Build a rental property income and expense spreadsheet that works at tax time: five tabs, one transactions table, expense categories mapped to Schedule E lines, repairs vs. improvements, SUMIFS formulas for monthly and annual summaries, NOI, cash flow, cap rate and cash-on-cash, a worked example and a free rental cash-flow calculator.
Read more
Can You Sell PLR on Etsy? What the Rules Allow and How to Do It Right
Can you sell PLR on Etsy? Etsy's Creativity Standards require digital items to be the seller's original design, so a PLR license alone isn't enough. Learn the two permissions you need, how much to change a PLR spreadsheet, an 8-step workflow, common mistakes, and an interactive Etsy readiness self-check.
Read more
How to Lock Cells in Excel and Google Sheets (and Protect Formulas)
Lock cells in Excel and Google Sheets the right way: protect formulas while leaving input cells editable, lock rows and columns when scrolling with Freeze, and lock references with $A$1 and F4. Exact menus for Windows, Mac, the web and Sheets, why protection isn't security, lifehacks, troubleshooting and an interactive reference tool.
Read more
How to Build a Stock Portfolio Tracker in Google Sheets
Learn how to build a stock portfolio tracker in Google Sheets: a Transactions tab as the single source of truth, GOOGLEFINANCE prices on their own tab, SUMIFS formulas for shares held, average cost, unrealized and realized gains and dividends, a worked example, an interactive cost-basis calculator and a monthly dashboard review.
Read more
How to Build an Options Trading Journal in Excel
Learn how to structure an options trading journal in Excel: one row per strategy with its legs in a second tab, strikes, expiration, net premium and the contract multiplier, Excel formulas for P&L, max loss and return on risk, a worked put-credit-spread example, an interactive calculator and a review by strategy, DTE and exit reason.
Read more
Sep 16, 2026
PLR vs MRR: What the Licenses Mean and Which Digital Products You Can Resell
PLR, MRR, resell rights and personal use compared in one table, with an interactive license decoder, a five-minute guide to reading a license file and advice on which license fits a spreadsheet-template business.
Read more
How to Rebrand and Sell PLR Spreadsheets: A Step-by-Step Guide
A practical guide to turning a PLR spreadsheet into your own product: what the license allows, a 7-step rebrand in Excel and Google Sheets, packaging, pricing with real marketplace fees, an interactive profit calculator and a listing checklist.
Read more
Sep 15, 2026
How to Build a Forex Trading Journal in Excel
Learn how to structure a forex trading journal in Excel: pair, lot size, pips, spread, commission and swap, with P&L formulas, a worked EUR/USD example, a risk-based lot-size calculator and a weekly review by pair and session.
Read more
Sep 14, 2026
Crypto Scalping Risk Management: Position Size, Stop-Loss & Leverage
Learn a practical crypto scalping risk-management workflow. Calculate position size from account risk and stop distance, include a cost allowance, understand leverage, and recreate the method in Excel.
Read more
Sep 13, 2026
Warren Buffett’s 90/10 Rule: How to Model It in Excel
Learn what Warren Buffett’s 90/10 rule actually says, then build an Excel model that calculates current weights, target values, allocation drift and rebalancing gaps.
Read more
Sep 13, 2026
How to Build a Crypto Trading Journal in Excel
Learn how to structure a crypto trading journal for spot and perpetual trades, record fees and funding, calculate net P&L, and build a repeatable weekly review in Excel.
Read more
