Excel 2010: The Missing Manual

Description

Offering an updated overview of the latest version of the spreadsheet program, a manual covers the entire gamut of how to build spreadsheets, add and format information, print reports, create charts and graphics, and use basic formulas and functions. Abstract: Offering an updated overview of the latest version of the spreadsheet program, a manual covers the entire gamut of how to build spreadsheets, add and format information, print reports, create charts and graphics, and use basic formulas and functions Content: 50 Part 1: Worksheet basics. Creating your first spreadsheet -- Adding information to worksheets -- Moving data -- Managing worksheets -- Formatting cells -- Smart formatting tricks -- Viewing and printing worksheets -- Part 2: Formulas and functions. Building basic formulas -- Math and statistical functions -- Financial functions -- Manipulating dates, times, and text -- Lookup, reference, and information functions -- Advanced formula writing and troubleshooting -- Part 3: Organizing worksheets. Tables: list management made easy -- Grouping and outlining data -- Templates -- Part 4: Charts and graphics. Creating basic charts -- Formatting and perfecting charts -- Inserting graphics -- Part 5: Advanced data analysis. Visualizing your data -- Scenarios and goal seeking -- Pivot tables -- Analyzing databases, XML, and web pages -- Part 6: Sharing data with the rest of the world. Protecting your workbooks -- Worksheet collaboration -- Using Excel on the web -- Exchanging data with other programs -- Part 7: Programming Excel. Automating tasks with macros -- Programming spreadsheets with VBA -- Part 8: Appendix. Customizing the ribbon.