Bibliograph

Excel 2013, the missing manual, Matthew MacDonald

Type

Label

Excel 2013, the missing manual, Matthew MacDonald

Language

eng

Illustrations

illustrations

Index

index present

Literary Form

non fiction

Main title

Excel 2013

Oclc number

876367134

Responsibility statement

Matthew MacDonald

Series statement

The Missing manual

Sub title

the missing manual

Summary

The world?s most popular spreadsheet program is now more powerful than ever, but it?s also more complex. That?s where this Missing Manual comes in. With crystal-clear explanations and hands-on examples, Excel 2013: The Missing Manual shows you how to master Excel so you can easily track, analyze, and chart your data. You?ll be using new features like PowerPivot and Flash Fill in no time

Table Of 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 your information. 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 A: Customizing the ribbon

Creator