Microsoft Excel 2010 inside out

"Apply best practices for designing and managing spreadsheets; use built-in functions for complex calculations, or develop your own; master data visualization tools--charts, Sparklines, SmartArt; retrieve external data from from databases, servers, and the Web; perform advanced financial, stati...

Full description

Bibliographic Details
Main Author: Dodge, Mark
Other Authors: Stinson, Craig
Format: eBook
Language:English
Published: Redmond, Wash. Microsoft Press 2011
Series:Inside out
Subjects:
Online Access:
Collection: O'Reilly - Collection details see MPG.ReNa
Description
Summary:"Apply best practices for designing and managing spreadsheets; use built-in functions for complex calculations, or develop your own; master data visualization tools--charts, Sparklines, SmartArt; retrieve external data from from databases, servers, and the Web; perform advanced financial, statistical, and "what-if" analysis; create dynamic PivotTable and PivotChart views; customize the ribbon and create your own templates; control data access and integrity as you collaborate on spreadsheets online; write and debug macros with Visual Basic for applications"--Page 4 of cover
Physical Description:xxviii, 1122 pages illustrations
ISBN:9780735652255
9780735652378
0735652252