Excel 2019 All-in-One For Dummies 1st Edition
Greg Harvey (Author) Find all the books, read about the author, and more. See search results for this author |



Use the Amazon App to scan ISBNs and compare prices.

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.
Customers who viewed this item also viewed
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 | |
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 | |
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 | ✓ | ✓ | ✓ | ✓ |
Editorial Reviews
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 moretake 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 moretake 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
About the Author
Greg Harvey, PhD, is a veteran computer educator dating back to the days of DOS and Lotus 1-2-3. He has taught spreadsheet and database management courses at Golden Gate University and written dozens of books, including many in the For Dummies series.
Don't have a Kindle? Get your Kindle here, or download a FREE Kindle Reading App.
Product details
- Publisher : For Dummies; 1st edition (October 26, 2018)
- Language : English
- Paperback : 816 pages
- ISBN-10 : 111951794X
- ISBN-13 : 978-1119517948
- Item Weight : 3.25 pounds
- Dimensions : 7.3 x 1.6 x 9.1 inches
- Best Sellers Rank: #25,333 in Books (See Top 100 in Books)
- #3 in Software Suite Books
- #5 in Microsoft Office Guides
- #7 in Microsoft Excel Guides
- Customer Reviews:
About the author

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
Customer Reviews, including Product Star Ratings help customers to learn more about the product and decide whether it is the right product for them.
To calculate the overall star rating and percentage breakdown by star, we don’t use a simple average. Instead, our system considers things like how recent a review is and if the reviewer bought the item on Amazon. It also analyzed reviews to verify trustworthiness.
Learn more how customers reviews work on Amazon
Top reviews from the United States
There was a problem filtering reviews right now. Please try again later.
Excel 2019 is clearly designed for the business user who has to prepare PPT presentations, and wants to use canned templates for displays of data and forecasts, etc., in the minimum time possible. But consider this: If a "for Dummies" book is 800 pages, then don't think that this program will be easy to master, or that this book will be any great help.
The chart are very difficult to read, it should be in color.
The informations are great.
Top reviews from other countries


My daughter has just started work and she needs to know Excel. She has a very basic knowledge but between this and the course on Skillshare she is getting more proficient.
The book is a bit draughting at first but it is in fact 8 books in one and the first book is the basics.
The full book list is:
1. Excel Basics
2. Worksheet Design
3. Formulas and Functions
4. Worksheet Collaboration and Review
5. Charts and Graphics
6. data Management
7. Data Analysis
8. Macros and VBA
The book is some 800 pages long and I use it to delve into to find the odd action I need. This helps me and with the fits basic book my daughter picks up, you guessed it the basics.
All in all a big book but possibly the only one you will ever need.


