Synopses & Reviews
What do you need to do with Excel? This book shows you how to do it!So you don't plan to devote your life to mastering Excel, but you do 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.
- Moving around the parts get familiar with the Ribbon, Quick Access toolbar, Formula bar, and other elements of the Excel screen
- Those feisty formulas and functions learn what they are and how to use them
- Editing etiquette discover the different ways to select and format cells, choose number formats, and customize fonts
- Worksheets and workbooks understand the difference and learn to organize data within them
- Basic maintenance keep your data in line and your workbooks up to date
- Doing things with data create data tables and scenarios that let you use what-if analysis to learn from your data
- What it means turn your data into professional-looking charts that are easy to interpret
Open the book and find:
- Steps for using Flash Fill to extract and copy elements
- How to use the Quick Analysis tool
- Apps for Office installation tips
- How to preview chart formats with the Recommended Charts feature
- Help using Recommended PivotTables to summarize data lists
- Ways to download and format online graphic images
- Methods for getting external data into your spreadsheets
- Data analysis advice
Learn to:
- Save spreadsheets in the cloud to work on them anywhere
- Use Excel 2013 on a Windows desktop, laptop, touchscreen PC, or tablet
- Share spreadsheets via SkyDrive, online meetings, and social media sites
- Analyze data with PivotTables
Synopsis
Excel 2013 For Dummies will be updated to reflect the major changes Microsoft is making to Office.
Covers everything you need to know to perform the task at hand. Includes information on creating and editing worksheets, formatting cells, entering formulas, creating and editing charts, inserting graphs, designing database forms, adding database records, using seek-and-find options, printing, adding hyperlinks to worksheets, saving worksheets as web pages, adding existing worksheet data to an existing web page, and sending worksheets via e-mail.
Synopsis
The bestselling Excel book - completely updated for Excel 2013!As the world's leading spreadsheet application, Excel has an enormous user base. The release of Office 2013 brings major changes to Excel, so Excel For Dummies comes to the rescue once more! Featuring the friendly For Dummies style, this popular guide shows beginners how to get up and running with Excel while also helping more experienced users get comfortable with the newest features.
- Walks you through the exciting new features of Excel 2013
- Presents everything you need to know to perform basic Excel 2013 tasks
- Covers creating and editing worksheets and charts, formatting cells, entering formulas, inserting graphs, designing database forms, and adding database records
- Discusses printing, adding hyperlinks to worksheets, saving worksheets as web pages, adding existing worksheet data to an existing web page, and much more
Whether you're new to Excel or are looking to get up and running with the 2013 version, Excel 2013 For Dummies has everything you need to know!
Synopsis
A value-priced book-and-DVD bundle on the latest release of Microsoft ExcelThe release of the newest version of Excel brings major changes to the world's leading spreadsheet application and this book-and-DVD package covers them all! Featuring the enormously popular Excel For Dummies book, the bundle also includes a must-have instructional DVD replete with step-by-step instructions covering the most essential Excel 2013 tasks. Featuring the always-popular friendly For Dummies style, veteran and bestselling author Greg Harvey answers questions and walks you through everyday topics so that you can quickly and easily feel comfortable with Excel 2013.
- Serves as an ideal resource for getting comfortable and confident with the new features of and updates to Excel 2013
- Covers creating and editing worksheets and charts, formatting cells, entering formulas, inserting graphs, designing database forms, and adding database records
- Discusses printing, adding hyperlinks to worksheets, saving worksheets as web pages, adding existing worksheet data to an existing web page, and much more
With this book-and-DVD bundle, you'll be excelling at Excel 2013 in no time!
Synopsis
Master Excel essentials with these visual, step-by-step tutorials
This handy DVD walks you step by step through all the essential tasks involved in using Excel 2013. With over 60 common Excel tasks, you’ll get in-depth video training that provides the show-and-tell, covering the basics of launching and navigating the program, creating and editing spreadsheets, and printing your worksheets. Then you’ll learn how to get organized, analyze your data, create charts and data lists, and share your spreadsheets. In no time, you’ll be an Excel pro!
Discover how to:
Launch Excel and navigate worksheets
Enter data and use AutoFill
Print formulas in a worksheet
Create pivot tables and pivot charts
Sort and filter data lists
Share workbooks via SkyDrive
About the Author
Greg Harvey, PhD, is President of Mind Over Media, an online media company. He has written all editions of Excel For Dummies, Excel All-in-One For Dummies, and Excel Workbook For Dummies. Greg is an experienced educator with a wide variety of interests.
Table of Contents
Introduction 1
Part I: Getting Started with Excel 2013 9
Chapter 1: The Excel 2013 User Experience 11
Chapter 2: Creating a Spreadsheet from Scratch 41
Part II: Editing without Tears 95
Chapter 3: Making It All Look Pretty 97
Chapter 4: Going Through Changes 143
Chapter 5: Printing the Masterpiece 175
Part III: Getting Organized and Staying That Way 201
Chapter 6: Maintaining the Worksheet 203
Chapter 7: Maintaining Multiple Worksheets 229
Part IV: Digging Data Analysis 251
Chapter 8: Doing What-If Analysis 253
Chapter 9: Playing with Pivot Tables 267
Part V: Life beyond the Spreadsheet 289
Chapter 10: Charming Charts and Gorgeous Graphics 291
Chapter 11: Getting on the Data List 327
Chapter 12: Linking, Automating, and Sharing Spreadsheets 351
Part VI: The Part of Tens 375
Chapter 13: Top Ten Beginner Basics 377
Chapter 14: The Ten Commandments of Excel 2013 379
Index 381