A common source of errors in Excel is "the gap"—a situation where you add new data to the bottom of a list, but your formulas ...

This video explains how the dollar sign is used in Excel formulas to control whether cell references stay fixed or change ...

Learn how accounting spreadsheets work with real examples of journals plus when to switch to accounting software.

Carol M. Kopp edits features on a wide range of subjects for Investopedia, including investing, personal finance, retirement planning, taxes, business management, and career development. Monte Carlo ...

Use the Sharpe ratio to evaluate an asset's risk vs. return Yarilet Perez is an experienced multimedia journalist and fact-checker with a Master of Science in Journalism. She has worked in multiple ...

Microsoft's spreadsheet program can do way more than you might imagine. These are the hacks and tricks you need to know. Our team tests, rates, and reviews more than 1,500 products each year to help ...

Microsoft Excel has been the premier spreadsheet software for decades, since outdoing the once venerable Lotus 1-2-3, the first killer app for PCs in the 1980s. And Excel's dominance has yet to be ...