Microsoft Excel 2013 BIBLE

DETAIL


 The comprehensive tutorial resource. Master excel formulas for useful worksheet. Create Compelling chart and diagrams. Analyze and present data with pivot tables.

• Author: John Walkenbach
• Language: English
• Published: 2013
• Page:1059
• Format: pdf
• Size: 216 MB

CONTENTS

Part I: Getting Started with Excel 1
Chapter 1: Introducing Excel 3
Chapter 2: Entering and Editing Worksheet Data 29
Chapter 3: Essential Worksheet Operations 49
Chapter 4: Working with Cells and Ranges 69
Chapter 5: Introducing Tables 101
Chapter 6: Worksheet Formatting 119
Chapter 7: Understanding Excel Files 145
Chapter 8: Using and Creating Templates 161
Chapter 9: Printing Your Work 171

Part II: Working with Formulas and Functions 193
Chapter 10: Introducing Formulas and Functions. 195
Chapter 11: Creating Formulas That Manipulate Text. 231
Chapter 12: Working with Dates and Times 251
Chapter 13: Creating Formulas That Count and Sum 285
Chapter 14: Creating Formulas That Look Up Values. 313
Chapter 15: Creating Formulas for Financial Applications. 333
Chapter 16: Miscellaneous Calculations. 359
Chapter 17: Introducing Array Formulas. 373
Chapter 18: Performing Magic with Array Formulas. 397

Part III: Creating Charts and Graphics 419
Chapter 19: Getting Started Making Charts. 421
Chapter 20: Learning Advanced Charting. 457
Chapter 21: Visualizing Data Using Conditional Formatting. 503
Chapter 22: Creating Sparkline Graphics. 525
Chapter 23: Enhancing Your Work with Pictures and Drawings 539

Part IV: Using Advanced Excel Features 561
Chapter 24: Customizing the Excel User Interface. 563
Chapter 25: Using Custom Number Formats. 573
Chapter 26: Using Data Validation. 591
Chapter 27: Creating and Using Worksheet Outlines. 603
Chapter 28: Linking and Consolidating Worksheets 613
Chapter 29: Excel and the Internet. 631
Chapter 30: Protecting Your Work. 643
Chapter 31: Making Your Worksheets Error Free. 655

Part V: Analyzing Data with Excel 683
Chapter 32: Importing and Cleaning Data  685
Chapter 33: Introducing Pivot Tables. 715
Chapter 34: Analyzing Data with Pivot Tables. 739
Chapter 35: Performing Spreadsheet What-If Analysis 777
Chapter 36: Analyzing Data Using Goal Seeking and Solver 793
Chapter 37: Analyzing Data with the Analysis ToolPak 813

Part VI: Programming Excel with VBA 825
Chapter 38: Introducing Visual Basic for Applications. 827
Chapter 39: Creating Custom Worksheet Functions 855
Chapter 40: Creating UserForms 869
Chapter 41: Using UserForm Controls in a Worksheet. 889
Chapter 42: Working with Excel Events. 903
Chapter 43: VBA Examples. 915
Chapter 44: Creating Custom Excel Add-Ins. 931

Part VII: Appendixes 941
Appendix A: Worksheet Function Reference 943
Appendix B: Excel Shortcut Keys 961

DOWNLOAD HERE