Excel 2016 Bible

Häftad, Engelska, 2015

Av John Walkenbach, CA) Walkenbach, John (J-Walk and Associates, Inc., San Diego

649 kr

Skickas måndag 1/12

Fri frakt för medlemmar vid köp för minst 249 kr.

The complete guide to Excel 2016, from Mr. Spreadsheet himselfWhether 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.Navigate this powerful tool for business, home management, technical work, and much more with the only resource you need, Excel 2016 Bible. Create functional spreadsheets that workMaster formulas, formatting, pivot tables, and moreGet acquainted with Excel 2016's new features and toolsCustomize downloadable templates and worksheetsWhether you need a walkthrough tutorial or an easy-to-navigate desk reference, the Excel 2016 Bible has you covered with complete coverage and clear expert guidance.

Produktinformation

Utgivningsdatum2015-11-13
Mått183 x 229 x 58 mm
Vikt1 792 g
FormatHäftad
SpråkEngelska
SerieBible
Antal sidor1 152
FörlagJohn Wiley & Sons Inc
ISBN9781119067511

Tillhör följande kategorier

Affärsapplikationer inom Data och it

Acknowledgments ixIntroduction xliPart I: Getting Started with Excel 1Chapter 1: Introducing Excel 3Chapter 2: Entering and Editing Worksheet Data 9Chapter 3: Essential Worksheet Operations 51Chapter 4: Working with Cells and Ranges 73Chapter 5: Introducing Tables 109Chapter 6: Worksheet Formatting 129Chapter 7: Understanding Excel Files 157Chapter 8: Using and Creating Templates 171Chapter 9: Printing Your Work 181Part II: Working with Formulas and Functions 205Chapter 10: Introducing Formulas and Functions 207Chapter 11: Creating Formulas That Manipulate Text 243Chapter 12: Working with Dates and Times 263Chapter 13: Creating Formulas That Count and Sum 297Chapter 14: Creating Formulas That Look Up Values 327Chapter 15: Creating Formulas for Financial Applications 349Chapter 16: Miscellaneous Calculations 381Chapter 17: Introducing Array Formulas 395Chapter 18: Performing Magic with Array Formulas 421Part III: Creating Charts and Graphics 445Chapter 19: Getting Started Making Charts 447Chapter 20: Learning Advanced Charting 491Chapter 21: Visualizing Data Using Conditional Formatting 539Chapter 22: Creating Sparkline Graphics 563Chapter 23: Enhancing Your Work with Pictures and Drawings 579Part IV: Using Advanced Excel Features 601Chapter 24: Customizing the Excel User Interface 603Chapter 25: Using Custom Number Formats 613Chapter 26: Using Data Validation 633Chapter 27: Creating and Using Worksheet Outlines 647Chapter 28: Linking and Consolidating Worksheets 657Chapter 29: Excel and the Internet 677Chapter 30: Protecting Your Work 689Chapter 31: Making Your Worksheets Error Free 701Part V: Analyzing Data with Excel 731Chapter 32: Importing and Cleaning Data 733Chapter 33: Introducing Pivot Tables 763Chapter 34: Analyzing Data with Pivot Tables 785Chapter 35: Performing Spreadsheet What-If Analysis 823Chapter 36: Analyzing Data Using Goal Seeking and Solver 841Chapter 37: Analyzing Data with the Analysis ToolPak 863Chapter 38: Working with Get & Transform 877Part VI: Programming Excel with VBA 907Chapter 39: Introducing Visual Basic for Applications 909Chapter 40: Creating Custom Worksheet Functions 939Chapter 41: Creating UserForms 955Chapter 42: Using UserForm Controls in a Worksheet 977Chapter 43: Working with Excel Events 993Chapter 44: VBA Examples 1005Chapter 45: Creating Custom Excel Add-Ins 1021Part VII: Appendixes 1031Appendix A: Worksheet Function Reference 1033Appendix B: Excel Shortcut Keys 1053Index 1061