Screen LibraryExcel 2013 : the missing manual /
Saved in:
| Main Authors: | |
|---|---|
| Published: |
|
| Literature type: | Book |
| Language: | English |
| Series: |
The missing manual
|
| Subjects: | |
| Item Description: | Includes index. |
| Carrier Form: | xxv, 991 p. : ill. ; 24 cm. |
| ISBN: |
9781449357276 (pbk.) : 144935727X |
| Index Number: | HF5548 |
| CLC: | TP317.3 |
| Call Number: | TP317.3/M135 |
| Contents: | Worksheet basics. Creating your first spreadsheet ; Adding information to worksheets ; Moving data ; Managing worksheets ; Formatting cells ; Smart formatting tricks ; Viewing and printing worksheets -- 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 -- Organizing worksheets. Tables : list management made easy ; Grouping and outlining data ; Templates -- Charts and graphics. Creating basic charts ; Formatting and perfecting charts ; Inserting graphics ; Visualizing your data -- Sharing data with the rest of the world. Protecting your workbooks ; Worksheet collaboration ; Using Excel on the web ; Exchanging data with other programs -- Advanced data analysis. Scenarios and goal seeking ; Pivot tables ; Analyzing databases ; Analyzing XML and web data -- Programming Excel. Automating tasks with macros ; Programming spreadsheets with VBA -- Appendix. Customizing the ribbon. |