Inside Microsoft Excel: Advanced Business Functionality

Daunted no more! Finally learn to use all the complex tools Excel has to offer.

Microsoft Excel is an important tool in almost every professional environment. But most users don’t know how to take advantage of the application’s full potential. Excel is a powerhouse that can do everything from analyze complex and continuously changing data to identify performance trends by specific metrics (such as geography)—and even forecast future hits and misses.

And it’s not as hard as you think to learn these advanced techniques—not when you have an expert resource at your fingertips! DartnellCorp brings you Inside Microsoft Excel: Advanced Business Functionality, a training manual on the diverse and varied uses of Excel. With this compilation, you’ll learn to leverage Excel’s vast functionality to increase your productivity, enhance your methods for financial and statistical analysis, and improve your predictive abilities. This guidebook explores how to use both well-known and lesser-known functions, features, and formulas to upgrade your Excel skills.

Inside Microsoft Excel: Exploring Excel for Business will reveal how to:

Filter data from large, complicated lists and databases

Compare vendor prices with Excel formulas

Spot and track trends, based on specified criteria

Combine widespread data using PivotTables

Translate data blocks into meaningful information using Charts and Sparklines

Use Solver for investment analysis

And more!