Excel 2010
Excel, the world's most popular spreadsheet program, has the muscle to analyze heaps of data. Beyond basic number-crunching, Excel 2010 has many impressive features that are hard to find, much less master -- especially from online help pages. This Missing Manual clearly explains how everything...
| Main Author: | |
|---|---|
| Format: | eBook |
| Language: | Inglés |
| Published: |
Beijing ; Sebastopol, California :
O'Reilly
2010.
|
| Edition: | First edition |
| Series: | Missing manual.
|
| Subjects: | |
| See on Biblioteca Universitat Ramon Llull: | https://discovery.url.edu/permalink/34CSUC_URL/1im36ta/alma991009628439006719 |
Table of Contents:
- 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.
