O'Reilly logo

Excel 2016 Formulas and Functions by Paul McFedries

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

15. Using Excel’s Business Modeling Tools

At times, it’s not enough to simply enter data into a worksheet, build a few formulas, and add a little formatting to make things presentable. In the business world, you’re often called on to divine some inner meaning from the jumble of numbers and formula results that litter your workbooks. In other words, you need to analyze your data to see what nuggets of understanding you can unearth. In Excel, analyzing business data means using the program’s business modeling tools. This chapter looks at a few of those tools and some analytic techniques that have many uses. You’ll find out how to use Excel’s numerous methods ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required