Purchase Excel 2019

Posted on  by

Home > Topics > Microsoft Office > Excel

9781509306114

Register your book to access additional benefits.

  • By Bill Jelen, Tracy Syrstad
  • Part of the Business Skills series.
  • Microsoft 365 & Office is available in two ways: a one-time purchase of a specific version, and as a subscription service. For the Student one-time purchase version, you will get Office Word, Excel and PowerPoint. The Home & Business version has those listed above, plus Outlook.
  • Office 2019 is a one-time purchase that comes with classic apps like Word, Excel, and PowerPoint for PC or Mac, and does not include any of the services that come with an Microsoft 365 subscription. One-time purchases don’t have an upgrade option, which means if you plan to upgrade to the next major release, you'll have to buy it at full price.

This eBook includes the following formats, accessible from your Account page after purchase:

This one-time purchase includes classic 2019 versions of Word, Excel and PowerPoint. It also includes Microsoft support for 60 days at no extra cost. The installation was quick and easy. Office 2019 is a one-time purchase that comes with classic apps like Word, Excel, and PowerPoint for PC or Mac, and does not include any of the services that come with an Microsoft 365 subscription.One-time purchases don’t have an upgrade option, which means if you plan to upgrade to the next major release, you'll have to buy it at full price.

EPUBThe open industry format known for its reflowable content and usability on supported mobile devices.

MOBIThe eBook format compatible with the Amazon Kindle and Amazon Kindle applications.

PDFThe popular standard, which reproduces the look and layout of the printed page.

This eBook requires no passwords or activation to read. We customize your eBook by discreetly watermarking it with your name, making it uniquely yours.

This eBook includes the following formats, accessible from your Account page after purchase:

EPUBThe open industry format known for its reflowable content and usability on supported mobile devices.

MOBIThe eBook format compatible with the Amazon Kindle and Amazon Kindle applications.

PDFThe popular standard, which reproduces the look and layout of the printed page.

This eBook requires no passwords or activation to read. We customize your eBook by discreetly watermarking it with your name, making it uniquely yours.

This eBook includes the following formats, accessible from your Account page after purchase:

EPUBThe open industry format known for its reflowable content and usability on supported mobile devices.

MOBIThe eBook format compatible with the Amazon Kindle and Amazon Kindle applications.

PDFThe popular standard, which reproduces the look and layout of the printed page.

This eBook requires no passwords or activation to read. We customize your eBook by discreetly watermarking it with your name, making it uniquely yours.

This eBook includes the following formats, accessible from your Account page after purchase:

EPUBThe open industry format known for its reflowable content and usability on supported mobile devices.

MOBIThe eBook format compatible with the Amazon Kindle and Amazon Kindle applications.

PDFThe popular standard, which reproduces the look and layout of the printed page.

This eBook requires no passwords or activation to read. We customize your eBook by discreetly watermarking it with your name, making it uniquely yours.

  • Published 12/28/2018
  • 1st Edition
  • 624 pages
  • Book 978-1-5093-0611-4
  • eBook 978-1-5093-0721-0

Renowned Excel experts Bill Jelen (MrExcel) and Tracy Syrstad explain how to build more powerful, reliable, and efficient Excel spreadsheets.

Use this guide to automate virtually any routine Excel task: save yourself hours, days, maybe even weeks. Make Excel do things you thought were impossible, discover macro techniques you won’t find anywhere else, and create automated reports that are amazingly powerful. Bill Jelen and Tracy Syrstad help you instantly visualize information to make it actionable; capture data from anywhere, and use it anywhere; and automate the best new features in Excel 2019 and Excel in Office 365. You’ll find simple, step-by-step instructions, real-world case studies, and 50 workbooks packed with examples and complete, easy-to-adapt solutions.

By reading this book, you will:

  • Quickly master Excel macro development
  • Work more efficiently with ranges, cells, and formulas
  • Generate automated reports and quickly adapt them for new requirements
  • Learn to automate pivot tables to summarize, analyze, explore, and present data
  • Use custom dialog boxes to collect data from others using Excel
  • Improve the reliability and resiliency of your macros
  • Integrate data from the internet, Access databases, and other sources
  • Automatically generate charts, visualizations, sparklines, and Word documents
  • Create powerful solutions with classes, collections, and custom functions
  • Solve sophisticated business analysis problems more rapidly

About This Book

  • For everyone who wants to get more done with Microsoft Excel in less time
  • For business and financial professionals, entrepreneurs, students, and others who need to efficiently manage and analyze data

Online Sample Chapter

Table of Contents

Free Excel Download

Introduction

  1. Unleash the Power of Excel with VBA
  2. This Sounds Like BASIC, So Why Doesn't It Look Familiar?
  3. Referring to Ranges
  4. Looping and Flow Control
  5. R1C1-style Formulas
  6. Creating and manipulating Names in VBA
  7. Event Programming
  8. Arrays
  9. Creating Classes and Collections
  10. Userforms: An Introduction
  11. Data Mining with Advanced Filter
  12. Using VBA to Create Pivot Tables
  13. Excel Power
  14. Sample User-Defined Functions
  15. Creating Charts
  16. Data Visualizations and Conditional Formatting
  17. Dashboarding with Sparklines
  18. Reading from and Writing to the Web
  19. Text File Processing
  20. Automating Word
  21. Using Access as a Back End to Enhance Multiuser Access to Data
  22. Advanced Userform Techniques
  23. Windows Application Programming Interface (API)
  24. Handling Errors
  25. Customizing the Ribbon to Run Macros
  26. Creating Add-Ins
  27. An Introduction to Creating Office Add-ins
  28. What's New in Excel 2019 and What's Changed

Downloads

Follow the instructions to download this book's sample files.

  1. Click the Download button below to start the download.
  2. If prompted, click Save.
  3. Locate the .zip file on your computer. Right-click the file, click Extract All, and then follow the instructions.
Download

Features

  • The fastest, best way to go beyond the Macro Recorder and move up the Excel VBA learning curve
  • Shows how to automate powerful new Excel 2019 features for analysis, formatting, sharing, and presentation
  • Includes the best practical explanation of object-oriented programming for non-programmers ever written!
  • Co-authored by Excel legend and Microsoft MVP Bill Jelen ('MrExcel') as part of the popular MrExcel's Library series

If you find an error, you can report it to us through our Submit errata page.

Other titles you might like

  • Online video $299.99
  • Book $24.99
Free excel download

Can I Purchase Just Excel

  • Book $24.99