Microsoft® Excel® 2010 Formulas & Functions Inside Out 2012Microsoft Excel 2010 Formulas and Functions Inside Out

Купить бумажную книгу и читать

Название: Microsoft Excel 2010 Formulas and Functions Inside Out

Автор: Egbert Jeschke, Helmut Reinke, Sara Unverhau, Eckehard Pfeifer

Издательство: Microsoft Press

Год: 2012

Страниц: 1088

ISBN: 9780735658028; 0735658021

Формат: PDF

Размер: 56.8 Мб

Язык: English

Серия: Inside Out

You’re beyond the basics, so dive right in and really put Excel formulas and functions to work! This supremely organized reference packs hundreds of timesaving solutions, troubleshooting tips, and workarounds. It’s all muscle and no fluff. Discover how the experts increase their data analysis capabilities using Excel 2003, 2007, or 2010—and challenge yourself to new levels of mastery.

Customize Excel formulas using 350+ built-in functions

Create reusable formulas for common calculations

Learn smarter ways to calculate date and time values

Systematically search worksheets with lookup and reference functions

Perform advanced calculations using mathematical, statistical, and financial functions

Build complex formulas by nesting one function inside of another

Analyze profit margins and more with new functions in Excel 2010

Develop your own functions with Visual Basic for Applications (VBA)