Read more
Informationen zum Autor Greg Harvey, PhD, is the president of Mind Over Media, LLC., and a bestselling author of books on Excel, including all editions of Excel For Dummies and Excel Workbook For Dummies . He began teaching business users about computers back in the 1980s, and has been a dedicated educator ever since. Klappentext 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 Get up to speed right away with the all-new, all-powerful Excel 2016 Excel, the #1 spreadsheet tool used by millions, has undergone a massive makeover. Each of the self-contained minibooks in this easy-to-follow guide covers one important area of Excel 2016. Find out how to make the most of your worksheets, create eye-popping charts, analyze data like a pro, and even customize Excel with VBA programming! Start here ? if you're new to Excel, Book I covers all the essentials Worksheet 101 ? learn to enter data and build, format, print, and manage worksheets in Book II Getting functional ? Book III shows you how to build formulas to calculate just about anything Let's team up ? see how to share spreadsheets safely with other people and programs in Book IV Charts and graphs ? in Book V, find out how to choose and create the ideal visual representation for your data What to do with it ? discover in Book VI how to maintain, filter, query, and manage volumes of data Analyze everything ? Book VII shows you amazing ways to analyze data and summarize it with pivot tables Macro mania ? learn to automate common tasks with macros and create custom user-defined functions in Book VIII Open the book and find: Tips for using Excel on a touchscreen device How to customize the Ribbon and the Quick Access toolbar Advice on editing spreadsheets Ways to find and eliminate formula errors Secrets of sharing on OneDrive ® Steps for querying your data All about Office and Excel Add-ins Zusammenfassung Your one-stop guide to all things Excel 2016 Excel 2016 All-in-One For Dummies, the most comprehensive Excel reference on the market, is completely updated to reflect Microsoft's changes in the popular spreadsheet tool. Inhaltsverzeichnis Introduction 1 Book I: Excel Basics 11 Chapter 1: The Excel 2016 User Experience 13 Chapter 2: Customizing Excel 2016 43 Book II: Worksheet Design 75 Chapter 1: Building Worksheets 77 Chapter 2: Formatting Worksheets 127 Chapter 3: Editing and Proofing Worksheets 185 Chapter 4: Managing Worksheets 233 Chapter 5: Printing Worksheets 269 Book III: Formulas and Functions 297 Chapter 1: Building Basic Formulas 299 Chapter 2: Logical Functions and Error Trapping 341 Chapter 3: Date and Time Formulas 363 Chapter 4: Financial Formulas 379 Chapter 5: Math and Statistical Formulas 393 Chapter 6: Lookup, Information, and Text Formulas 413 Book IV: Worksheet Collaboration and Review 435 Chapter 1: Protecting Workbooks and Worksheet Data 437 Chapter 2: Using Hyperlinks 459 Chapter 3: Sending Workbooks Out for Review 467 Chapter 4: Sharing Workbooks and Worksheet Data 495 Book V: Charts and Graphics 519 Chapter 1: Charting Worksheet Data 521 Chapter 2: Adding Graphic Objects 553 Book VI: Data Management 581 Chapter 1: Building and Maintaining Data Lists 583 Chapter 2: Filtering and Querying a Data List 607 Book VII: Data Analysis 649 Chapter 1: Performing What-If Scenarios 651 Chapter 2: Performing Large-Scale Data Analysis 675 Book VIII: Macros and VBA 721 Chapter 1: Recording and Running Macros 723 ...
