Details

Introduction 1 <p><b>Part I: Getting Started with Excel 2013 9</b></p> <p>Chapter 1: The Excel 2013 User Experience 11</p> <p>Chapter 2: Creating a Spreadsheet from Scratch 41</p> <p><b>Part II: Editing without Tears 95</b></p> <p>Chapter 3: Making It All Look Pretty 97</p> <p>Chapter 4: Going Through Changes 143</p> <p>Chapter 5: Printing the Masterpiece 175</p> <p><b>Part III: Getting Organized and Staying That Way 201</b></p> <p>Chapter 6: Maintaining the Worksheet 203</p> <p>Chapter 7: Maintaining Multiple Worksheets 229</p> <p><b>Part IV: Digging Data Analysis 251</b></p> <p>Chapter 8: Doing What-If Analysis 253</p> <p>Chapter 9: Playing with Pivot Tables 267</p> <p><b>Part V: Life beyond the Spreadsheet 289</b></p> <p>Chapter 10: Charming Charts and Gorgeous Graphics 291</p> <p>Chapter 11: Getting on the Data List 327</p> <p>Chapter 12: Linking, Automating, and Sharing Spreadsheets 351</p> <p><b>Part VI: The Part of Tens 375</b></p> <p>Chapter 13: Top Ten Beginner Basics 377</p> <p>Chapter 14: The Ten Commandments of Excel 2013 379</p> <p>Index 381</p>

<p><b>Greg Harvey, PhD,</b> is President of Mind Over Media, an online media company. He has written all editions of <i>Excel For Dummies, Excel All-in-One For Dummies,</i> and <i>Excel Workbook For Dummies.</i> Greg is an experienced educator with a wide variety of interests.</p>

<p><b>What do you need to do with Excel? This book shows you how to do it!</b></p> <p>So you don't plan to devote your life to mastering Excel, but you <i>do</i> need to use some of its features? You've come to the right book! This bestselling guide, completely updated for Excel 2013, tells you how to use the program for basic, everyday number-crunching tasks. Create, edit, and print a worksheet, present data in cool ways, and much more.</p> <ul> <li><i><b>Moving around the parts</b> — get familiar with the Ribbon, Quick Access toolbar, Formula bar, and other elements of the Excel screen</i></li> <li><i><b>Those feisty formulas and functions</b> — learn what they are and how to use them</i></li> <li><i><b>Editing etiquette</b> — discover the different ways to select and format cells, choose number formats, and customize fonts</i></li> <li><i><b>Worksheets and workbooks</b> — understand the difference and learn to organize data within them</i></li> <li><i><b>Basic maintenance</b> — keep your data in line and your workbooks up to date</i></li> <li><i><b>Doing things with data</b> — create data tables and scenarios that let you use what-if analysis to learn from your data</i></li> <li><i><b>What it means</b> — turn your data into professional-looking charts that are easy to interpret</i></li> </ul> <p><b>Open the book and find:</b></p> <ul> <li>Steps for using Flash Fill to extract and copy elements</li> <li>How to use the Quick Analysis tool</li> <li>Apps for Office installation tips</li> <li>How to preview chart formats with the Recommended Charts feature</li> <li>Help using Recommended PivotTables to summarize data lists</li> <li>Ways to download and format online graphic images</li> <li>Methods for getting external data into your spreadsheets</li> <li>Data analysis advice</li> </ul> <p><b><i>Learn to:</i></b></p> <ul> <li>Save spreadsheets in the cloud to work on them anywhere</li> <li>Use Excel 2013 on a Windows desktop, laptop, touchscreen PC, or tablet</li> <li>Share spreadsheets via SkyDrive, online meetings, and social media sites</li> <li>Analyze data with PivotTables</li> </ul>

US