Part 1: Examining the Excel
environment
Chapter 1
What’s new in Microsoft Excel 2013 . . . . . . . . . . 3
Chapter 2
Exploring Excel fundamentals . . . . . . . . . . . . . . 15
Chapter 3
Custom-tailoring the Excel workspace . . . . . . . 75
Chapter 4
Security and privacy . . . . . . . . . . . . . . . . . . . . . 105
Part 2: Building worksheets
Chapter 5
Planning your worksheet design . . . . . . . . . . . 123
Chapter 6
How to work a worksheet . . . . . . . . . . . . . . . . 131
Chapter 7
How to work a workbook . . . . . . . . . . . . . . . . . 173
Part 3: Formatting and editing
worksheets
Chapter 8
Worksheet editing techniques . . . . . . . . . . . . 191
Chapter 9
Worksheet formatting techniques . . . . . . . . . 285
Part 4: Adding graphics and printing
Chapter 10
Creating and formatting graphics . . . . . . . . . 371
Chapter 11
Printing and presenting . . . . . . . . . . . . . . . . . . 437
Part 5: Creating formulas and
performing data analysis
Chapter 12
Building formulas . . . . . . . . . . . . . . . . . . . . . . . . 467
Chapter 13
Using functions . . . . . . . . . . . . . . . . . . . . . . . . . 527
Chapter 14
Everyday functions . . . . . . . . . . . . . . . . . . . . . . 537
Chapter 15
Formatting and calculating date
and time . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 565
Chapter 16
Functions for financial analysis . . . . . . . . . . . . 583
Chapter 17
Functions for analyzing statistics . . . . . . . . . . 601
Chapter 18
Performing a what-if analysis . . . . . . . . . . . . . 633
Part 6: Creating charts
Chapter 19
Designing charts . . . . . . . . . . . . . . . . . . . . . . . . 667
Chapter 20
Formatting charts . . . . . . . . . . . . . . . . . . . . . . . 697
Chapter 21
Using sparklines . . . . . . . . . . . . . . . . . . . . . . . . . 711
Part 7: Managing databases
and tables
Chapter 22
Managing information in tables . . . . . . . . . . . 721
Chapter 23
Analyzing data with PivotTable reports . . . . . 767