Greg Harvey

Excel 2016 All-in-One For Dummies

• Broschiertes Buch

Produktbeschreibung

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

---

Hinweis: Dieser Artikel kann nur an eine deutsche Lieferadresse ausgeliefert werden.

Produktdetails

• Verlag: John Wiley & Sons / John Wiley & Sons Inc
• Seitenzahl: 816
• Erscheinungstermin: 4. Dezember 2015
• Englisch
• Abmessung: 185mm x 231mm x 42mm
• Gewicht: 1080g
• ISBN-13: 9781119077152
• ISBN-10: 111907715X
• Artikelnr.: 42577102

Autorenporträt

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.

Inhaltsangabe

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
Chapter 2: VBA Programming 735
Index 759