Buy Online at low price from Helmet Don-Microsoft Excel 2016 Bible: The Comprehensive Tutorial Resource by John Walkenbach Publisher: Wiley (7 December 2015) ISBN-13: 978-8126558940 Language: English Paperback: 1152 pagesWhether you are just starting out or an Excel novice, the Excel 2016 Bible is your comprehensive, go-to guide for all your Excel 2016 needs. Whether you use Excel at work or at home, you will be guided through the powerful new features and capabilities by expert author and Excel Guru John Walkenbach to take full advantage of what the updated version offers. Learn to incorporate templates, implement formulas, create pivot tables, analyze data and much more. Special Features ·Create functional spreadsheets that work ·Master formulas, formatting, pivot tables and more ·Get acquainted with Excel 2016's new features and tools ·Customize downloadable templates and worksheets Table of Content Acknowledgments Introduction Part I: Getting Started with Excel Chapter 1: Introducing Excel Chapter 2: Entering and Editing Worksheet Data Chapter 3: Essential Worksheet Operations Chapter 4: Working with Cells and Ranges Chapter 5: Introducing Tables Chapter 6: Worksheet Formatting Chapter 7: Understanding Excel Files Chapter 8: Using and Creating Templates Chapter 9: Printing Your Work Part II: Working with Formulas and Functions Chapter 10: Introducing Formulas and Functions Chapter 11: Creating Formulas That Manipulate Text Chapter 12: Working with Dates and Times Chapter 13: Creating Formulas That Count and Sum Chapter 14: Creating Formulas That Look Up Values Chapter 15: Creating Formulas for Financial Applications Chapter 16: Miscellaneous Calculations Chapter 17: Introducing Array Formulas Chapter 18: Performing Magic with Array Formulas Part III: Creating Charts and Graphics Chapter 19: Getting Started Making Charts Chapter 20: Learning Advanced Charting Chapter 21: Visualizing Data Using Conditional Formatting Chapter 22: Creating Sparkline Graphics Chapter 23: Enhancing Your Work with Pictures and Drawings Part IV: Using Advanced Excel Features Chapter 24: Customizing the Excel User Interface Chapter 25: Using Custom Number Formats Chapter 26: Using Data Validation Chapter 27: Creating and Using Worksheet Outlines Chapter 28: Linking and Consolidating Worksheets Chapter 29: Excel and the Internet Chapter 30: Protecting Your Work Chapter 31: Making Your Worksheets Error Free Part V: Analyzing Data with Excel Chapter 32: Importing and Cleaning Data Chapter 33: Introducing Pivot Tables Chapter 34: Analyzing Data with Pivot Tables Chapter 35: Performing Spreadsheet What-If Analysis Chapter 36: Analyzing Data Using Goal Seeking and Solver Chapter 37: Analyzing Data with the Analysis ToolPak Chapter 38: Working with Get & Transform Part VI: Programming Excel with VBA Chapter 39: Introducing Visual Basic for Applications Chapter 40: Creating Custom Worksheet Functions Chapter 41: Creating UserForms Chapter 42: Using UserForm Controls in a Worksheet Chapter 43: Working with Excel Events Chapter 44: VBA Examples Chapter 45: Creating Custom Excel Add-Ins Part VII: Appendixes Appendix A: Worksheet Function Reference Appendix B: Excel Shortcut Keys Index
QUESTIONS & ANSWERS
Have a Question?
Be the first to ask a question about this.