"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"--P. [4] of cover.

Includes index.