EXCEL 2000 Bible

by John Walkenbach

Published 11 February 2000
If you're looking for inside information and time-saving tips to maximize the power of Excel on your desktop and on the Web, then look no further than the Gold Edition of the best-selling Microsoft Excel 2000 Bible. Author John Walkenbach, a leading authority on spreadsheet software, has packed this book with valuable information for Excel users at every level: Acquaint yourself with essential Excel features, and navigate through basic files and workbooks. Dive deep into spreadsheet make-up and maintenance, from controlling worksheet data to working with rows, columns, cells, and ranges. Add visual elements to spreadsheets by formatting styles, fonts, and cell alignment, plus build charts, pictures, and drawings. Investigate advanced techniques that enable you to create and use worksheet outlines, link and consolidate worksheets, and utilize arrays. Explore Excel's Internet tools, and see how you can share data with other applications. Analyze data with Excel, and program Excel 2000 with VBA.
The bonus CD-ROM includes a fully functional trial version of Power Utility Pak 2000, with 50 general-purpose utilities and 40 custom worksheet functions, examples, and enhanced shortcut menus.

If Access can do it, you can do it too! Client lists. Sales figures. Web research. Take charge of your data to better run your business or organization. With expert advice from Cary Prague and Michael Irwin, you'll quickly master Access 2002's top database management capabilities and its hot new Web features. Using step-by-step instructions and practical examples and advice, the authors demonstrate everything you need to know to organize, present, analyze, and share data on a network or over the Web. Access 2002 Bible provides comprehensive coverage of all new features and capabilities, including vastly improved Data Access Pages which gives you more ways to provide information over the Web. In addition, Access 2002 carries several performance improvements and an enhanced new file format.

Ever considered changing the fonts in your presentation depending on the audience size? Or wondered what colors work best for selling? Packed with practical advice you can't find anywhere else, the Microsoft PowerPoint 2000 Bible brings you in "one big book" absolutely everything you need to plan, build, and run dynamite PowerPoint presentations that get your point across.

A must-have collection of Office 2010 application Bibles, written by the world?s leading experts Talk about a bargain! Office 2010 Library offers enormous savings on four invaluable resources that boast nearly 5,000 pages and cover the core Office programs: Excel, Access, PowerPoint, and Word. The world?s leading experts of these applications provide you with an arsenal of information on the latest version of each program. Three CDs are also included that feature bonus material, including helpful templates, worksheets, examples, and more to enhance your Microsoft Office 2010 experiences. * Features four essential books on the most popular applications included in the Office 2010 suite: Excel, Access, PowerPoint, and Word * Excel 2010 Bible?serves as an indispensable reference for Excel users, no matter your level of expertise, and updates you on the latest Excel tips, tricks, and techniques * Access 2010 Bible?offers a thorough introduction to database fundamentals and terminology * PowerPoint 2010 Bible?shows you how to use the new features of PowerPoint 2010 and make successful presentations * Word 2010 Bible?begins with a detailed look at all the new features in Word 2010 and then expends to cover more advanced, intricate topics Office 2010 Library presents you with all-encompassing coverage that you won?
t find anywhere else!


Packed with examples, techniques, and tips from Microsoft MVP John Walkenbach, this perennial bestseller has been updated for Excel 2007 and is equally valuable for beginners and power users. You'll learn how to master Excel's new "menuless" Ribbon interface, develop custom functions, create UserForms, analyze data with external database files and PivotTables, and much more. Here's valuable comprehensive coverage of the fundamentals as well as advanced 2007 features like the new user interface and wider use of XML and Web services.

Excel 2016 Bible

by John Walkenbach

Published 9 October 2015

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.


The complete guide to Excel 2019

Whether you are just starting out or an Excel novice, the Excel 2019 Bible is your comprehensive, go-to guide for all your Excel 2019 needs. Whether you use Excel at work or at home, you will be guided through the powerful new features and capabilities 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 2019 Bible.

  • Create functional spreadsheets that work
  • Master formulas, formatting, pivot tables, and more
  • Get acquainted with Excel 2019's new features and tools

Whether you need a walkthrough tutorial or an easy-to-navigate desk reference, the Excel 2019 Bible has you covered with complete coverage and clear expert guidance.


An indispensible collection of Office 2013 Bibles Eager to delve into the new suite of Office 2013 applications? Look no further than this spectacular collection of four invaluable resources that boast nearly 5,000 pages and cover the core Office programs: Excel, Access, PowerPoint, and Word. The world's leading experts of these applications provide you with an arsenal of information on the latest version of each program. * Features four essential books on the most popular applications included in the Office 2013 suite: Excel, Access, PowerPoint, and Word *Excel 2013 Bible - serves as an essential reference for Excel users, no matter your level of expertise, and updates you on the latest Excel tips, tricks, and techniques *Access 2013 Bible - offers a detailed introduction to database fundamentals and terminology *PowerPoint 2013 Bible - shows you how to use the newest features and make successful presentations *Word 2013 Bible - begins with a detailed look at all the latest features and then cover more advanced, intricate topics Look no further than Office 2013 Library for the most thorough coverage on every aspect of the Office 2013 suite!

Client lists. Figure sales. Web research. Take charge of your data before it takes over your business. With expert advice from Cary Prague and Michael Irwin, you'll quickly master Access 2000's top database management capabilities -- and its revolutionary Web features. Using step-by-step instructions and practical examples, the authors demonstrate everything you need to know to organize, present, analyze, and share data efficiently over a corporate network or the Internet.

EXCEL for Windows 95 Bible

by John Walkenbach

Published 1 September 1995

Access 2019 Bible

by Michael Alexander and Richard Kusleika

Published 20 September 2018
Master database creation and management

Access 2019 Bible is your, comprehensive reference to the world's most popular database management tool. With clear guidance toward everything from the basics to the advanced, this go-to reference helps you take advantage of everything Access 2019 has to offer. Whether you're new to Access or getting started with Access 2019, you'll find everything you need to know to create the database solution perfectly tailored to your needs, with expert guidance every step of the way. The companion website features all examples and databases used in the book, plus trial software and a special offer from Database Creations. Start from the beginning for a complete tutorial, or dip in and grab what you need when you need it.

Access enables database novices and programmers to store, organize, view, analyze, and share data, as well as build powerful, integrable, custom database solutions — but databases can be complex, and difficult to navigate. This book helps you harness the power of the database with a solid understanding of their purpose, construction, and application.

  • Understand database objects and design systems objects
  • Build forms, create tables, manipulate datasheets, and add data validation
  • Use Visual Basic automation and XML Data Access Page design
  • Exchange data with other Office applications, including Word, Excel, and more

From database fundamentals and terminology to XML and Web services, this book has everything you need to maximize Access 2019 and build the database you need.


Access 2016 Bible

by Michael Alexander and Richard Kusleika

Published 15 October 2015
Master database creation and management

Access 2016 Bible is your, comprehensive reference to the world's most popular database management tool. With clear guidance toward everything from the basics to the advanced, this go-to reference helps you take advantage of everything Access 2016 has to offer. Whether you're new to Access or getting started with Access 2016, you'll find everything you need to know to create the database solution perfectly tailored to your needs, with expert guidance every step of the way. The companion website features all examples and databases used in the book, plus trial software and a special offer from Database Creations. Start from the beginning for a complete tutorial, or dip in and grab what you need when you need it.

Access enables database novices and programmers to store, organize, view, analyze, and share data, as well as build powerful, integrable, custom database solutions but databases can be complex, and difficult to navigate. This book helps you harness the power of the database with a solid understanding of their purpose, construction, and application.

  • Understand database objects and design systems objects
  • Build forms, create tables, manipulate datasheets, and add data validation
  • Use Visual Basic automation and XML Data Access Page design
  • Exchange data with other Office applications, including Word, Excel, and more

From database fundamentals and terminology to XML and Web services, this book has everything you need to maximize Access 2016 and build the database you need.


With more than 400 pages of additional information on security, help systems, programming, performance optimization, advanced client/server techniques, and more, this deluxe GOLD edition will answer all your Access 2000 questions and help you create state--of--the--art database systems for your business. In this indispensable resource, three of the world's best--known Access experts share everything they've learned through years of building and managing Access databases.

Excel 97 Bible

by John Walkenbach

Published 24 January 1997
Excel 97 has finally arrived, putting in your hands more and better features than ever before. Excel 97 Bible gets you up to speed with all of them quickly ---- even if you've never used Excel before. With Excel guru John Walkenbach to guide you, you'll get the low--down on everything from enhanced what--if analysis tools to the easy--to--use Internet Assistant, which turns your spreadsheet into a Web page that others can view over the Internet or your organization's intranet. Comprehensive and authoritative, Excel 97 Bible is the indispensable, all--in--one reference you need to unleash the power of the world's most popular spreadsheet application.

Containing practical examples and advice, this is a comprehensive reference tool to learning and mastering Excel 2000. Beginning with easy, hands-on lessons, it discusses how to get Excel to work for maximum results. The book also focuses on Excel 2000 Internet publishing features. It covers creating HTML documents in Excel and publishing them on the Web, sharing documents across a corporate intranet and importing data into Web-based forms. There is a special section on QuickStart and "At Work" sections which show the reader how to create business solutions using Excel. The accompanying CD-ROM contains an electronic version of the book, Excel add-ins, utilities, Internet Explorer, and more.


Your personal, hands-on guide to the latest and most useful features in Microsoft Excel 365

Excel 365 is Microsoft’s latest cloud-based version of its world-famous spreadsheet app. Powerful and user-friendly, it’s an ideal solution for businesses and people looking to make sense of—and draw intelligence from—their data.

The Excel 365 Bible carries over the best content from the best-selling Excel 2019 Bible while reflecting how a new generation uses Excel in Excel 365. The authoring team with their decades of Excel and business intelligence experience and recognition from the Excel community as Excel MVPs delivers an accessible and authoritative roadmap to Excel 365. Interested in the basics? You’ll learn to create spreadsheets and workbooks and navigate the user interface. If you’re ready for more advanced topics you can skip right to the material on creating visualizations, crafting custom functions, and using Visual Basic for Applications to script automations.

You’ll also get:

  • Over 900 pages of powerful tips, tricks, and strategies to unlock the full potential of Microsoft Excel 365
  • Guidance on how to import, manage, and analyze large amounts of data
  • Advice on how to craft predictions and "What-If Analyses" based on data you already have

Perfect for anyone new to Excel, as well as experts and advanced users, the Excel 365 Bible is your comprehensive, go-to guide for everything you need to know about the world’s most popular, easy-to-use spreadsheet software.