The smartest thing Excel does happens in places you can't see.

Hidden inside Excel is a tool that forecasts future patterns from your data in just a few clicks.

Please note: This item is from our archives and was published in 2016. It is provided for historical reference. The content may be out of date and links may no longer function. Q. Our company creates ...

Many financial systems do a fine job of generating standard reports, but accountants often need more. In those cases, accountants can create custom solutions in Excel, but that approach has drawbacks.

Investopedia contributors come from a range of backgrounds, and over 25 years there have been thousands of expert writers and editors who have contributed. Samantha (Sam) Silberstein, CFP®, CSLP®, EA, ...

We can create a master sheet in a Workbook and link other sheets to it, and create links to access them instantly. This gives us a lot of convenience in managing data and multiple sheets. It makes it ...

Econometrics is important, but a great deal of the work of economists is simply looking at data, graphing data, charting data, calculating ratios and percent changes, and performing other data ...

Use one or both of these simple Microsoft Excel macros to list all the sheets in an Excel workbook. Whether your Microsoft Excel workbook has three sheets or 50, knowing what you have is important.

If you’re trying to achieve financial independence or just keep better track of your money, you need to be using a budget. It’s non-negotiable. While there are plenty of budgeting apps out there, you ...

Retrieving up to date stock market prices for Excel is a snap with the free Stock Connector add-in. Here’s a walkthrough of how you get it and how it works. One of the most powerful and most useful ...