How-To Geek on MSN

How to simplify complex Excel formulas for better auditing

Tables, named ranges, line breaks, modern functions, and helper columns make Excel formulas easier to read, audit, and fix.
How-To Geek on MSN

Document formulas in Excel like code with N() function

The simplest way to start documenting Excel formulas like a coder is by using the N () function. Although its primary job is to convert non-numeric values into numbers, it has a hidden quirk: because ...

Beyond The Year In Review: Your Business’ History As An Business Asset

Many owners look ahead for answers, but past decisions offer clearer guidance. Your business history is a strategic tool for ...
Journal of Accountancy

How CPAs can use exponential smoothing in Excel for better forecasts

FORECAST.ETS applies an exponential triple smoothing (ETS) algorithm to create forecasts that can include trend and seasonal ...

Investor Relations & Strategy: How to Use Bloomberg in Excel

We invite you to join our industry specialists for a virtual session on how to use Bloomberg functionality in Excel. This ...