Excel 2010 : the missing manual /
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.
Saved in:
| Main Author: | |
|---|---|
| Format: | Electronic eBook |
| Language: | English |
| Published: |
Sebastopol, Calif. :
O'Reilly Media,
©2010.
|
| Series: | Missing manual.
|
| Subjects: | |
| Online Access: | CONNECT |
Table of Contents:
- 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.
