These promotions will be applied to this item:
Your Memberships & Subscriptions

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.
Excel 2019 All-in-One For Dummies 1st Edition, Kindle Edition
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!
- ISBN-13978-1119517948
- Edition1st
- PublisherFor Dummies
- Publication dateOct. 29 2018
- LanguageEnglish
- File size28.7 MB
Kindle E-Readers
Free Kindle Reading Apps
Customers who bought this item also bought
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$37.99 | $42.99$42.99 | $36.65$36.65 | $35.99$35.99 | $27.35$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$32.06 | $21.91$21.91 | $37.99$37.99 | $29.81$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 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 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
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.
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
- Best Sellers Rank: #491,445 in Kindle Store (See Top 100 in Kindle Store)
- #170 in Office Applications
- #302 in Spreadsheet Software (Books)
- #390 in Software Introductory 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
Top reviews from Canada
There was a problem filtering reviews right now. Please try again later.
- Reviewed in Canada on June 14, 2021Verified PurchaseYou really need to have a basic knowledge before using this book unless you are reading it all. It wasn’t helpful for me, collects dust now and Google tells me how to do stuff.
- Reviewed in Canada on August 28, 2019Verified PurchaseExcellent
- Reviewed in Canada on October 20, 2019Verified PurchaseBook met expectations
- Reviewed in Canada on September 26, 2020Verified PurchaseQuite a few of the instructions in this book are somewhat over my head.
- Reviewed in Canada on January 8, 2020Verified PurchaseThis book is for experts, definitely not for Dummies.. way too complex for me
Top reviews from other countries
- Sean McmorrisReviewed in the United States on March 8, 2021
5.0 out of 5 stars Indispensable if you need Excel for work
Verified PurchaseI 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 SosefReviewed in the Netherlands on November 7, 2022
1.0 out of 5 stars Excel
Verified PurchaseIk 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 SalazarReviewed in Mexico on March 29, 2019
5.0 out of 5 stars Rapidez en el servicio
Verified PurchaseEl 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.
- krch6Reviewed in the United Kingdom on October 25, 2020
5.0 out of 5 stars For all levels!
Verified PurchaseFantastic 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.Reviewed in Germany on November 29, 2019
5.0 out of 5 stars Super
Verified PurchaseSehr übersichtlich