How to build the spreadsheet Your check register can be a great guide to start your checkbook-balancing spreadsheet. You'll want to include columns for check numbers if any, transaction date, a ...

Learn how to calculate simple, weighted and exponential moving averages in Microsoft Excel using Data Analysis Tool Pack or Formula.

Learn how to calculate the net present value (NPV) of your investment projects using Excel's XNPV function.

We show you how to use Excel to count days between two dates using the DAYS, DATEDIF, NETWORKDAYS, and TODAY functions, and Subtraction.

I discovered artificial intelligence tool GPT Excel in my quest to cut down on all the busywork it takes to create and update spreadsheets.

Use Microsoft Excel to calculate EBITDA (earnings before interest, tax, depreciation, and amortization) profit margin.