Excel 2013: The Missing Manual

The Missing Credits......Page 11
	Intro:	Introduction......Page 15
	Part One:	Worksheet Basics......Page 29
Starting a Workbook......Page 31
Adding Information to a Worksheet......Page 32
Using the Ribbon......Page 40
Using the Status Bar......Page 47
Going Backstage......Page 51
Saving Files......Page 54
Opening Files......Page 69
Adding Different Types of Data......Page 75
Handy Timesavers......Page 84
Dealing with Change: Undo, Redo, \nand AutoRecover......Page 97
Spell-Check......Page 103
Adding Hyperlinks......Page 108
Selecting Cells......Page 113
Moving Cells Around......Page 120
Adding and Moving Columns or Rows......Page 131
	Chapter 4:	Managing Worksheets......Page 135
Worksheets and Workbooks......Page 136
Find and Replace......Page 146
	Chapter 5:	Formatting Cells......Page 155
Formatting Cell Values......Page 156
Formatting Cell Appearance......Page 177
The Format Painter......Page 193
Styles and Themes......Page 194
Conditional Formatting......Page 207
Controlling Your View......Page 217
Printing......Page 230
Controlling Pagination......Page 242
	Part Two:	Formulas and Functions......Page 247
Creating a Basic Formula......Page 249
Functions......Page 255
Formula Errors......Page 262
Logical Operators......Page 266
Formula Shortcuts......Page 268
Copying Formulas......Page 276
Rounding Numbers......Page 289
Groups of Numbers......Page 295
General Math Functions......Page 307
Trigonometry and Advanced Math......Page 316
Advanced Statistics......Page 320
The World of Finance......Page 325
Financial Functions......Page 326
Depreciation......Page 340
Other Financial Functions......Page 343
Manipulating Text......Page 347
Manipulating Dates and Times......Page 356
	Chapter 12:	Lookup, Reference, and Information Functions......Page 373
The Basic Lookup......Page 374
Advanced Lookups......Page 381
Information Functions......Page 393
Tutorial: Generating Invoices from \na Product Catalog......Page 397
Conditions in Formulas......Page 403
Descriptive Names for Cell References......Page 412
Variable Data Tables......Page 423
Controlling Recalculation......Page 428
Solving Formula Errors......Page 429
	Part Three:	Organizing Your \nInformation......Page 439
	Chapter 14:	Tables: List Management Made Easy......Page 441
The Basics of Tables......Page 442
Sorting a Table......Page 452
Filtering a Table......Page 458
Dealing with Duplicate Rows......Page 464
Performing Table Calculations......Page 466
	Chapter 15:	Grouping and Outlining Data......Page 479
Basic Data Grouping......Page 480
Grouping Timesavers......Page 492
	Chapter 16:	Templates......Page 497
Using the Office Online Templates......Page 498
Rolling Your Own Templates......Page 507
	Part Four:	Charts and Graphics......Page 513
	Chapter 17:	Creating Basic Charts......Page 515
Charting 101......Page 516
Basic Tasks with Charts......Page 523
Practical Charting......Page 530
Chart Types......Page 540
Chart Styles and Layouts......Page 555
Adding Chart Elements......Page 559
Formatting Chart Elements......Page 571
Improving Your Charts......Page 584
Advanced Charting......Page 596
	Chapter 19:	Inserting Graphics......Page 605
Adding Pictures to a Worksheet......Page 606
Excel’s Clip Art Library......Page 621
Drawing Shapes......Page 624
SmartArt......Page 635
	Chapter 20:	Visualizing Your Data......Page 639
Data Bars......Page 640
Color Scales......Page 650
Icon Sets......Page 651
Sparklines......Page 655
	Part Five:	Sharing Data with the Rest of the World......Page 665
Understanding Excel’s Safeguards......Page 667
Data Validation......Page 668
Locked and Hidden Cells......Page 680
	Chapter 22:	Worksheet Collaboration......Page 691
Your Excel Identity......Page 692
Preparing Your Workbook......Page 693
Distributing Your Workbook......Page 699
Adding Comments......Page 702
Tracking Changes......Page 707
Sharing Your Workbook......Page 718
Reviewing Workbooks with Inquire......Page 724
Putting Your Files Online......Page 733
Using the Excel Web App......Page 742
Sharing Your Files......Page 752
	Chapter 24:	Exchanging Data with Other Programs......Page 767
Sharing Information in Windows......Page 768
Embedding and Linking Objects......Page 769
Transferring Data......Page 779
	Part Six:	Advanced Data Analysis......Page 789
	Chapter 25:	Scenarios and Goal Seeking......Page 791
Using Scenarios......Page 792
Using Goal Seek......Page 799
Solver......Page 804
	Chapter 26:	Pivot Tables......Page 819
Summary Tables Revisited......Page 820
Building Pivot Tables......Page 823
Multi-Layered Pivot Tables......Page 834
Fine-Tuning Pivot Table Calculations......Page 839
Filtering a Pivot Table......Page 843
Pivot Charts......Page 854
Excel and Databases......Page 859
Creating a Data Connection......Page 861
The Data Model: Boosting Pivot Tables......Page 874
	Chapter 28:	Analyzing XML and Web Data......Page 889
Understanding XML......Page 890
Retrieving Information from XML......Page 895
Creating Web Queries......Page 907
Connecting to Online Data Services with OData......Page 911
	Part Seven:	Programming Excel......Page 919
Macros 101......Page 921
The Macro Recorder......Page 924
Macro Security......Page 931
Creating Practical Macros......Page 939
	Chapter 30:	Programming Spreadsheets with VBA......Page 947
The Visual Basic Editor......Page 948
Understanding Macro Code......Page 954
Exploring the VBA Language......Page 958
	Part Eight:	Appendix......Page 971
	Appendix A:	Customizing the Ribbon......Page 973
Adding Your Favorites to the QAT......Page 974
Personalizing the Ribbon......Page 979
Index......Page 985