Excel 2016 Bible

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

$90.95

Paperback

Not in-store but you can order this
How long will it take?

Availability Information

We source books from suppliers in Australia and overseas. For books we don't currently have in stock, the time it takes to get them from our suppliers can vary widely - from a few days to a few months - so we check each book with each supplier to determine the expected time it will take to be supplied to us.

We then advise you accordingly. If the time taken to get any book is too long for you, you can let us know and we will cancel or adjust your order, and refund as required.

To find out the anticipated arrival time for specific items prior to ordering, please contact us by phone or email:

Phone +61 2 9264 3111, or 1800 4 BOOKS (1800 4 26657) if outside Sydney:
option 1 Abbey's Bookshop (Crime, History, Science, Kids & more) • info@abbeys.com.au
option 2 Language Book Centre (ESL & Foreign Languages) • language@abbeys.com.au
option 3 Galaxy Bookshop (Sci-fi, Fantasy, Romance, Graphic Novels) • sf@galaxybooks.com.au

QTY:

English

John Wiley & Sons Inc
16 October 2015

Excel

Series: Bible

The complete guide to Excel 2016, from Mr. Spreadsheet himself

Whether 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 work Master formulas, formatting, pivot tables, and more Get acquainted with Excel 2016's new features and tools Customize downloadable templates and worksheets

Whether 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.

By: John Walkenbach (J-Walk and Associates Inc. San Diego CA)
Imprint: John Wiley & Sons Inc
Country of Publication: United States
Edition: 2nd Revised edition
Dimensions: Height: 229mm, Width: 183mm, Spine: 58mm
Weight: 1.792kg
ISBN: 9781119067511
ISBN 10: 1119067510
Series: Bible
Pages: 1152
Publication Date: 16 October 2015
Audience: Professional and scholarly , Undergraduate
Format: Paperback
Publisher's Status: Active

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

John Walkenbach, principal of J-Walk and Associates, Inc., is a leading authority on spreadsheet software and creator of the award-winning Power Utility Pak. He has written more than 50 books and 300 articles and reviews for publications including PC World, InfoWorld, and Windows.

OUR STORE IS CLOSED ON ANZAC DAY: THURSDAY 25 APRIL

Excel 2016 Bible

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

$90.95

Paperback

See Also

Contact Abbeys

Contact Galaxy

Contact Language

Contact Us

About ABBEY'S