How-To Geek on MSN

The Excel shortcut that speeds up data entry (Ctrl+Enter)

By combining To Go Special with Ctrl+Enter, you can fill thousands of empty cells with the correct data in seconds. First, ...
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.

Use Microsoft Excel data types to save unnecessary typing

If you’ve ever doing an assignment for work or study that requires you to display information about a country, you could ...
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 ...