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
Table of Contents:
  • Examining the Excel environment
  • Building worksheets
  • Formatting and editing worksheets
  • Adding graphics and printing
  • Creating formulas and performing data analysis
  • Creating charts
  • Managing databases and tables
  • Collaborating
  • Automating Excel
  • Integrating Excel with other applications
  • Appendixes