$31.99 with 33 percent savings
Digital List Price: $47.99

These promotions will be applied to this item:

You have subscribed to ! We will pre-order your items within 24 hours of when they become available. When new books are released, we’ll charge your default payment method for the lowest price available during the pre-order period.
Update your device or payment method, cancel individual pre-orders or your subscription at
Your Memberships & Subscriptions
Kindle app logo image

Download the free Kindle app and start reading Kindle books instantly on your smartphone, tablet or computer – no Kindle device required.

Read instantly on your browser with Kindle for Web.

Using your mobile phone camera, scan the code below and download the Kindle app.

QR code to download the Kindle app

Follow the author

Something went wrong. Please try your request again later.

Excel 2019 All-in-One For Dummies 1st Edition, Kindle Edition

4.4 4.4 out of 5 stars 4,108 ratings
3.9 on Goodreads
67 ratings

Make Excel work for you 

Excel 2019 All-In-One For Dummies offers eight books in one!! It is completely updated to reflect the major changes Microsoft is making to Office with the 2019 release. From basic Excel functions, such as creating and editing worksheets, to sharing and reviewing worksheets, to editing macros with Visual Basic, it provides you with a broad scope of the most common Excel applications and functions—including formatting worksheets, setting up formulas, protecting worksheets, importing data, charting data, and performing statistical functions.
   
The book covers importing data, building and editing worksheets, creating formulas, generating pivot tables, and performing financial functions, what-if scenarios, database functions, and Web queries. More advanced topics include worksheet sharing and auditing, performing error trapping, building and running macros, charting data, and using Excel in conjunction with Microsoft Power BI (Business Intelligence) to analyze, model, and visualize vast quantities of data from a variety of local and online sources.  

  • Get familiar with Worksheet design
  • Find out how to work with charts and graphics
  • Use Excel for data management, analysis, modeling, and visualization
  • Make sense of macros and VBA

If you’re a new or inexperienced user looking to spend more time on your projects than trying to figure out how to make Excel work for you, this all-encompassing book makes it easy!

Due to its large file size, this book may take longer to download

From the Publisher

Excel 2019 For Dummies
Excel 2019 All-in-One For Dummies
Excel Formulas & Functions For Dummies
Excel Macros For Dummies
Excel Data Analysis For Dummies
Customer Reviews
4.4 out of 5 stars 845
4.4 out of 5 stars 4,108
4.4 out of 5 stars 1,576
4.5 out of 5 stars 250
4.5 out of 5 stars 210
Price $37.99 $42.99 $36.65 $35.99 $27.35
Format Paperback Paperback Paperback Paperback Paperback
Audience Level Beginner Beginner to Intermediate Beginner to Intermediate Intermediate Intermediate
Content Length 432 pages 815 pages 400 pages 312 pages 352 pages
Author Greg Harvey Greg Harvey Ken Bluttman Michael Alexander Paul McFedries
Pub Date October 2018 November 2018 November 2018 March 2017 November 2018
Imprint For Dummies For Dummies For Dummies For Dummies For Dummies
Product Description Covers everything you need to know to perform basic spreadsheet tasks; shows you how to streamline processes and work more efficiently; includes help with charts, formulas, pivot tables, and more Features 8 books in 1 package covering everything from Excel basics to building and running macros; shows how to get the most out of your Excel spreadsheets and data; includes advanced content on data management, analysis, modeling, and visualization Shows you how to harness the power of Excel to make tasks easier with formulas; includes step-by-step instructions on Excel's 150 most useful functions; provides examples of specialized functions Shows how using macros can save you time; includes links to code snippets - no programming experience required; features over 70 of the most useful Excel macros that can be customized for your needs Explains how to use Excel as a tool for analyzing big data sets; shows how to mine and analyze critical data to make more informed business decisions; includes coverage on using Excel to share data with stakeholders
Available on Kindle
Excel VBA Programming For Dummies
Financial Modeling in Excel For Dummies
Excel Sales Forecasting For Dummies
Statistical Analysis with Excel For Dummies
Customer Reviews
4.5 out of 5 stars 538
4.4 out of 5 stars 224
4.2 out of 5 stars 48
4.4 out of 5 stars 226
Price $32.06 $21.91 $37.99 $29.81
Format Paperback Paperback Paperback Paperback
Audience Level Intermediate to Advanced Intermediate to Advanced Intermediate to Advanced Intermediate to Advanced
Content Length 416 pages 336 pages 408 pages 552 pages
Author Michael Alexander & John Walkenbach Danielle Stein Fairhurst Conrad Carlberg Joseph Schmuller
Pub Date November 2018 April 2017 July 2017 July 2016
Imprint For Dummies For Dummies For Dummies For Dummies
Product Description Explains how to use Visual Basic for Applications; provides essential skills for programming with Excel; includes step-by-step instructions for creating VBA macros and enhancing productivity Highlights Excel modeling tools and how to use them; covers using Excel to predict trends and create client solutions; shows how to use model scenarios and what-if analysis Shows how to use Excel as a forecasting tool; provides tips for setting up pivot charts, tables, graphs, and more; covers more advanced topics like forecasting with regression Explains how to use Excel to interpret statistics; focuses on using Excel to predict trends and make data-driven decisions; covers how to handle random variables and work with probability
Available on Kindle

Product description

From the Inside Flap

Your complete guide to Microsoft Excel 2019

Excel is the number one number-crunching program just about everywhere. Everything you need to know to take advantage of this winning spreadsheet application is right here! Learn how to create, edit, share and review worksheets. Then take your skills to another level by creating formulas, editing macros, generating pivot tables, charting and analyzing data, and so much more—take a deep dive into Excel with this all-in-one approach!

8 Books Inside…

  • Excel Basics
  • Worksheet Design
  • Formulas and Functions
  • Worksheet Collaboration and Review
  • Charts and Graphics
  • Data Management
  • Data Analysis
  • Macros and VBA

From the Back Cover

Your complete guide to Microsoft Excel 2019

Excel is the number one number-crunching program just about everywhere. Everything you need to know to take advantage of this winning spreadsheet application is right here! Learn how to create, edit, share and review worksheets. Then take your skills to another level by creating formulas, editing macros, generating pivot tables, charting and analyzing data, and so much more take a deep dive into Excel with this all-in-one approach!

8 Books Inside…

  • Excel Basics
  • Worksheet Design
  • Formulas and Functions
  • Worksheet Collaboration and Review
  • Charts and Graphics
  • Data Management
  • Data Analysis
  • Macros and VBA

Product details

  • ASIN ‏ : ‎ B07K3YSX5R
  • Publisher ‏ : ‎ For Dummies; 1st edition (Oct. 29 2018)
  • Language ‏ : ‎ English
  • File size ‏ : ‎ 28.7 MB
  • Text-to-Speech ‏ : ‎ Enabled
  • Screen Reader ‏ : ‎ Supported
  • Enhanced typesetting ‏ : ‎ Enabled
  • X-Ray ‏ : ‎ Not Enabled
  • Word Wise ‏ : ‎ Not Enabled
  • Print length ‏ : ‎ 794 pages
  • Customer Reviews:
    4.4 4.4 out of 5 stars 4,108 ratings

About the author

Follow authors to get new release updates, plus improved recommendations.
Greg Harvey
Brief content visible, double tap to read full content.
Full content visible, double tap to read brief content.

Greg Harvey has authored tons of computer books, the most recent being Excel Timesaving Techniques For Dummies and Roxio Easy Media Creator For Dummies, and the most popular being Excel 2003 For Dummies and Excel 2003 All-In-One Desk Reference For Dummies. He started out training business users on how to use IBM personal computers and their attendant computer software in the rough and tumble days of DOS, WordStar, and Lotus 1-2-3 in the mid-80s of the last century. After working for a number of independent training firms, he went on to teach semester-long courses in spreadsheet and database management software at Golden Gate University in San Francisco.

His love of teaching has translated into an equal love of writing. For Dummies books are, of course, his all-time favorites to write because they enable him to write to his favorite audience, the beginner. They also enable him to use humor (a key element to success in the training room) and, most delightful of all, to express an opinion or two about the subject matter at hand.

Greg received his doctorate degree in Humanities in Philosophy and Religion with a concentration in Asian Studies and Comparative Religion last May. Everyone is glad that Greg was finally able to get out of school before he retired.

Customer reviews

4.4 out of 5 stars
4,108 global ratings

Review this product

Share your thoughts with other customers

Top reviews from Canada

Top reviews from other countries

Translate all reviews to English
  • Sean Mcmorris
    5.0 out of 5 stars Indispensable if you need Excel for work
    Reviewed in the United States on March 8, 2021
    Verified Purchase
    I find this all-in-one book indispensable. There is just too much to do and remember in Excel not to have a reference guide. I don't use this book as a training course (some have commented that the book is too long), but as a reference when I need to lookup an issue or learn how to do a specific function I am unfamiliar with. Yes, most things these days can just be googled, but it is nice (and stress relieving) to have a reliable reference guide to go to when needed. Plus, it is organized and indexed. You take your chances when just doing an internet search for an answer. Anyway, it's not expensive and I find this book very useful as a starter and guide for all things Excel. If, after reading a section I want more in-depth instruction, then I know what to google to find it. Physical books still have a place in our lives. Recommended.
  • Rob Sosef
    1.0 out of 5 stars Excel
    Reviewed in the Netherlands on November 7, 2022
    Verified Purchase
    Ik kan dit product niet gebruiken, ik pakte hem net pas uit toen ik zag dat het een Engelse versie was.
    Dus ik heb er niets aan.
  • Luis Salazar
    5.0 out of 5 stars Rapidez en el servicio
    Reviewed in Mexico on March 29, 2019
    Verified Purchase
    El libro llego antes del tiempo estimado a pesar de ser un envío internacional. Llego en muy buenas condiciones. Además el libro esta muy completo con la información que contiene.
  • krch6
    5.0 out of 5 stars For all levels!
    Reviewed in the United Kingdom on October 25, 2020
    Verified Purchase
    Fantastic book. I am familiar with excel and slightly above basic knowledge of formulas, so wasnt sure where I'd fit in this book. It's so easy to navigate what you want to learn and accommodates all levels from a very beginner to very advanced. It's an easy pick up if I want to do something quickly or easy to browse if I have time to sit and learn. I'd recommend to EVERYONE who needs to use excel at any stage.
  • Hugo A.
    5.0 out of 5 stars Super
    Reviewed in Germany on November 29, 2019
    Verified Purchase
    Sehr übersichtlich

Report an issue


Does this item contain inappropriate content?
Do you believe that this item violates a copyright?
Does this item contain quality or formatting issues?