Page 14 - Excel 2013 All-in-One For Dummies

xii
Excel 2013 All-in-One For Dummies
Chapter 3: Sending Workbooks Out for Review . . . . . . . . . . . . . . . . . .463
Preparing a Workbook for Distribution .................................................... 463 Adding properties to a workbook.................................................... 465 Digitally signing a document ............................................................ 465
Workbook Sharing 101 ................................................................................ 470 Turning on file sharing ...................................................................... 472 Modifying the Share Workbook options ......................................... 474 Turning on change tracking.............................................................. 475 Merging changes from different users ............................................ 479
Workbooks on Review ................................................................................ 483 Adding comments..............................................................................484 Marking up a worksheet with digital ink.........................................486
Chapter 4: Sharing Workbooks and Worksheet Data . . . . . . . . . . . . .489
Sharing Your Workbooks Online ............................................................... 490 Sharing workbooks saved on your SkyDrive .................................. 490 E-mailing workbooks ......................................................................... 494 Sharing workbooks with Instant Message ...................................... 494 Presenting worksheets online..........................................................495 Editing worksheets online ................................................................ 496 Reviewing workbooks online............................................................ 499
Excel 2013 Data Sharing Basics.................................................................. 499 Excel and Word 2013 ......................................................................... 501 Excel and PowerPoint 2013............................................................... 506
Exporting Workbooks to Other Usable File Formats .............................. 507 Saving and exporting worksheets as PDF files...............................508 Saving worksheets as XPS files ........................................................ 509 Saving worksheets as HTML files..................................................... 510
Book V: Charts and Graphics..................................... 513
Chapter 1: Charting Worksheet Data . . . . . . . . . . . . . . . . . . . . . . . . . . .515
Worksheet Charting 101 ............................................................................. 516 Embedded charts versus charts on separate chart sheets..........518 Inserting recommended charts........................................................ 518 Inserting specific chart types from the Ribbon ............................. 519 Inserting charts with the Quick Analysis tool................................521 Creating a chart on a separate chart sheet .................................... 522 Refining the chart from the Design tab ........................................... 523 Customizing chart elements from the Format tab......................... 529 Customizing the elements of a chart ............................................... 532 Formatting elements of a chart........................................................536 Saving a customized chart as a template ....................................... 541
Adding Sparkline Graphics to a Worksheet ............................................. 542 Printing Charts.............................................................................................544