Synopses & Reviews
8 books in 1
- Excel Basics
- Worksheet Design
- Formulas and Functions
- Worksheet Collaboration and Review
- Charts and Graphics
- Data Management
- Data Analysis
- Macros and VBA
Excel newbie or expert in older versions here's the reference you need for Excel 2013!
Understanding how to use the many features of Excel 2013 is only half the battle. The other half is understanding what these features can do for you. So whether you're starting out or upgrading, using Excel on your desktop or tablet, this all-in-one guide covers what you need to know to master worksheets, formulas, functions, charts, even data analysis.
- For beginners start out right with an entire minibook devoted to mastering Excel basics
- Working with worksheets learn to set up, edit, manage, and dress up worksheets and print reports
- Get functional explore formulas and functions from basic to complex and put them to work
- Team effort share and collaborate on worksheets while keeping your data secure
- Make it look great present your data with impressive charts and graphs that help interpret the information
- Manage your data take advantage of Excel's tools for managing large amounts of data and filtering out the information you need
- Look ahead use Excel's computational abilities to forecast and predict possible future outcomes
- Extend Excel install Apps for Office, use COM add-ins, and write macros and custom functions with the Visual Basic Editor
Open the book and find:
- How to build your own workbook templates
- Instructions for using Excel on a touchscreen
- All the ways to enter data
- Tips for preventing formula errors
- Hints for sharing data with other Office 2013 programs
- Graphics you can include in your charts
- How to query external data sources
- A guide to PowerPivot and Power View add-ins
Synopsis
Excel 2013 All-In-One For Dummies will be completely updated to reflect the major changes Microsoft is making to Office.From basic Excel functions, such as creating and editing worksheets, to sharing and reviewing worksheets, to editing macros with Visual Basic, the Excel 2013 All-in-One For Dummies provides the reader with a broad scope of the most common Excel applications and functions -- including formatting worksheets, setting up formulas, protecting worksheets, importing data, charting data, and performing statistical functions.
Covers importing data, building and editing worksheets, creating formulas, generating pivot tables, and performing financial functions, what-if scenarios, database functions, and Web queries.
More advanced topics include: worksheet sharing and auditing, performing error trapping, building and running macros, charting data, and using Excel in conjunction with Visual Basic and the Web.
Synopsis
The comprehensive reference, now completely up-to-date for Excel 2013!As the standard for spreadsheet applications, Excel is used worldwide - but it's not always user-friendly. However, in the hands of veteran bestselling author Greg Harvey, Excel gets a whole lot easier to understand! This handy all-in-one guide covers all the essentials, the new features, how to analyze data with Excel, and much more. The featured minibooks address Excel basics, worksheet design, formulas and functions, worksheet collaboration and review, charts and graphics, data management, data analysis, and Excel and VBA.
- Covers the changes in the newest version as well as familiar tasks, such as creating and editing worksheets, setting up formulas, and performing statistical functions
- Walks you through the new analysis tools that help make it easier to visualize data with the click of a mouse
- Details new ways to explore your data more intuitively and then analyze and display your results with a single click
Whether you're an Excel newbie or a veteran user to wants to get familiar with the latest version, Excel 2013 All-in-One For Dummies has everything you need to know.
About the Author
Greg Harvey, PhD, is President of Mind Over Media and a highly skilled instructor. He has been writing computer books for more than 20 years, and his long list of bestsellers includes all editions of Excel For Dummies, Excel All-in-One For Dummies, and Excel Workbook For Dummies.
Table of Contents
Introduction 1
About This Book 1
Foolish Assumptions 2
How This Book Is Organized 3
Book I: Excel Basics 3
Book II: Worksheet Design 3
Book III: Formulas and Functions 4
Book IV: Worksheet Collaboration and Review 5
Book V: Charts and Graphics 5
Book VI: Data Management 6
Book VII: Data Analysis 6
Book VIII: Macros and VBA 6
Conventions Used in This Book 7
Icons Used in This Book 8
Where to Go from Here 9
Book I: Excel Basics 11
Chapter 1: The Excel 2013 User Experience 13
Chapter 2: Customizing Excel 2013 41
Book II: Worksheet Design 73
Chapter 1: Building Worksheets 75
Chapter 2: Formatting Worksheets 125
Chapter 3: Editing and Proofing Worksheets 183
Chapter 4: Managing Worksheets 231
Chapter 5: Printing Worksheets 269
Book III: Formulas and Functions 297
Chapter 1: Building Basic Formulas 299
Chapter 2: Logical Functions and Error Trapping 339
Chapter 3: Date and Time Formulas 361
Chapter 4: Financial Formulas 375
Chapter 5: Math and Statistical Formulas 389
Chapter 6: Lookup, Information, and Text Formulas 409
Book IV: Worksheet Collaboration and Review 431
Chapter 1: Protecting Workbooks and Worksheet Data 433
Chapter 2: Using Hyperlinks 455
Chapter 3: Sending Workbooks Out for Review 463
Chapter 4: Sharing Workbooks and Worksheet Data 489
Book V: Charts and Graphics 513
Chapter 1: Charting Worksheet Data 515
Chapter 2: Adding Graphic Objects 545
Book VI: Data Management 575
Chapter 1: Building and Maintaining Data Lists 577
Chapter 2: Filtering and Querying a Data List 601
Book VII: Data Analysis 643
Chapter 1: Performing What-If Scenarios 645
Chapter 2: Generating Pivot Tables 667
Book VIII: Macros and VBA 707
Chapter 1: Building and Running Macros 709
Chapter 2: VBA Programming 721
Index 745