Book

Dodge, Mark.

Microsoft Excel 2010 inside out / Mark Dodge, Craig Stinson.

Redmond, Wash. : Microsoft Press, ©2011.

xxviii, 1122 pages : illustrations ; 23 cm

"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.

Inside out

Inside out (Redmond, Wash.)

Microsoft Excel (Computer file)

Business -- Computer programs.

Stinson, Craig, 1943-

Includes index.

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.

2010933199

9780735626881

073562688X

609544191

1

0

1

268884

1

1

005.369 Dodge