Tables, named ranges, line breaks, modern functions, and helper columns make Excel formulas easier to read, audit, and fix.

Q. I was excited to see the article about ways to calculate depreciation in Excel, especially when I saw one of them was double-declining balance (DDB). As tax professionals, we’re always trying to ...

Running a successful business requires a lot more than showing up at the office and promoting your products or services. Successful small business owners understand that always knowing where their ...

Financial statements give you overall look at the health of your business at a given time. Microsoft's Excel can make it simple to create these statements by enabling you to create a modifiable ...

Q. How do I spill formulas in Excel? A. Spilling is a feature available in Excel 365 and later versions. With spilling, you can create a formula in one cell, and that formula will then spill over into ...

Excel’s formula bar has limitations that make writing, debugging, and managing complex formulas challenging. A new tool, the Advanced Formula Environment (AFE), developed by Microsoft for Excel 2019 ...

I’m a writer, not an accountant. The mention of double-entry bookkeeping used to put me to sleep — and then give me stress nightmares. Fortunately, I’ve evolved. I won’t pretend that I’ve transformed ...

Samantha (Sam) Silberstein, CFP®, CSLP®, EA, is an experienced financial consultant. She has a demonstrated history of working in both institutional and retail environments, from broker-dealers to ...