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

by Greg Harvey (Author)

3,711 ratings

ISBN-13: 978-1119517948

ISBN-10: 111951794X

Why is ISBN important?

Share <Embed>

Other Sellers

from

Other Sellers

See all 2 versions

Used: Good | Details

Sold by extracash4kids

Fulfilled by Amazon

Access codes and supplements are not guaranteed with used items.

Get Fast, Free Shipping with Amazon Prime

FREE delivery Tuesday, May 31 if you spend $25 on items shipped by Amazon

Or fastest delivery Friday, May 27. Order within 16 hrs 31 mins

Select delivery location

Excel Power Pivot & Power Query... for $29.99

Excel Dashboards & Reports for... for $29.99

Excel Macros For Dummies, 2nd E... for $22.19

In Stock.

Ships from and sold by Amazon.com.

Available at a lower price from other sellers that may not offer free Prime shipping.

List Price: $39.99 Details

Save: $20.60 (52%)

Get Fast, Free Shipping with Amazon Prime

FREE delivery Tuesday, May 31 if you spend $25 on items shipped by Amazon

Or fastest delivery Friday, May 27. Order within 16 hrs 31 mins

Select delivery location

Excel Power Pivot & Power Query... for $29.99

Excel Dashboards & Reports for... for $29.99

Excel Macros For Dummies, 2nd E... for $22.19

Available at a lower price from other sellers that may not offer free Prime shipping.

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.

Total price:

To see our price, add these items to your cart.

Choose items to buy together.

by Greg Harvey Paperback
$19.39
In Stock.
Ships from and sold by Amazon.com.
Get it as soon as Tuesday, May 31
by Inc. BarCharts Pamphlet
$5.95
In Stock.
Ships from and sold by Amazon.com.
Get it as soon as Tuesday, May 31
by Inc. BarCharts Ring-bound
$5.95
In Stock.
Ships from and sold by Amazon.com.
Get it as soon as Tuesday, May 31

Inc. BarCharts
1,474
Pamphlet
7 offers from $5.95
Paul McFedries
102
Paperback
41 offers from $21.83
Leonard J. Ledger
88
Paperback
in Microsoft Excel Guides
1 offer from $19.97
John Michaloudis
765
Paperback
in Computer Programming Logic
18 offers from $14.01
Michael Alexander
1,067
Paperback
64 offers from $17.87
Greg Harvey
744
Paperback
71 offers from $6.33

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 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

8 Books Inside…

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

Start reading Excel 2019 All-in-One For Dummies on your Kindle in under a minute.

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:
3,711 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

5 star		68%
4 star		18%
3 star		9%
2 star		2%
1 star		3%

How customer reviews and ratings work

Reviews with images

See all customer images

Top reviews from the United States

There was a problem filtering reviews right now. Please try again later.

John Isner

Looks to me like hasty and sloppy editing job

Reviewed in the United States on June 21, 2019

Verified Purchase

I'm only ten minutes into the first chapter of the book and I'm already tempted to return it. The text on page 15, which refers to Figure 1-1 (the very first figure in the book!), bears almost no relationship to what's actually shown in the figure. This is clearly the result of a hasty and sloppy editing job, and it does not bode well for the rest of the book.

48 people found this helpful

Helpful

Bruce C. Douglas

worthless guide to a mangled piece of software

Reviewed in the United States on December 28, 2019

Verified Purchase

The early visions of MS Excel were capable doing everything from balancing your checkbook to sophisticated data analyses, including multiple regressions and easy-to-create matrix algebra formulations. I used them widely in my peer- reviewed publications on sea level rise and coastal processes. The latest version has those things, but also is cluttered with endless templates and options, and is not at all intuitive. Commands and procedures have changed, and this book (all 800 pages of it) is no real help in using the program. Example: Want to change the color of data points or lines in a chart? Try to find how to do that in this book. The index is no help.

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.

32 people found this helpful

Helpful

Sean Mcmorris

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.

12 people found this helpful

Helpful

Mary H. Cosgrove

Too much to read

Reviewed in the United States on April 21, 2019

Verified Purchase

This is for Excel for Dummies?? Really wanted less -- there is a lot to read - excellent book if you know your way around Excel, but for dummies--NO

34 people found this helpful

Helpful

Foreverspeechless

dummies for excel

Reviewed in the United States on May 7, 2019

Verified Purchase

the book sucks. examples aren't clear and large enough to see. overall, wished i gone to school instead of buying this book

29 people found this helpful

Helpful

Kelldub

I am a dummy when it comes to excel

Reviewed in the United States on October 16, 2019

Verified Purchase

This is very helpful with me trying to learn excel at age 42 with no previous experience

15 people found this helpful

Helpful

Pierre Rogers

Printing is too light

Reviewed in the United States on June 1, 2019

Verified Purchase

The printing is too light and difficult to read.
The chart are very difficult to read, it should be in color.
The informations are great.

18 people found this helpful

Helpful

pam savant

content

Reviewed in the United States on March 12, 2019

Verified Purchase

This book covers a whole lot more than just excel....great purchase!

16 people found this helpful

Helpful

Top reviews from other countries

Internal design and paper appalling.

Reviewed in the United Kingdom on March 26, 2019

Verified Purchase

I am a big fan of Dummies books but this one is dreadful - it is very thick but printed on very thin grey paper and the diagrams are tiny and also faded looking and the outside cover material is also thin and not likely to last. Very disappointed - I have the kindle version of it but prefer to have a book to hand but I think I have wasted my money this time I can't see me using it unlike the other well thumbed books in the same series. Great amount of info if you can read it...

20 people found this helpful

Alison Druce

A big book but possibly the only one you will ever need

Reviewed in the United Kingdom on October 12, 2021

Verified Purchase

This is a very big book and not what I expected.

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.

4 people found this helpful

krch6

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.

6 people found this helpful

Nicola KS

Brilliant book

Reviewed in the United Kingdom on January 20, 2020

Verified Purchase

Not used Excel in years so very rusty and behind with the times. This book has helped me so much to get back into it and more

10 people found this helpful

LilyRose

Good value for money

Reviewed in the United Kingdom on February 11, 2021

Verified Purchase

We have frequently described an enjoyable book as one that we can't put down. This is hard to pick up due to its huge size and weight. Joking aside, this represents good value for money as it appears to have everything one needs to solve problems. I would agree with MC that the illustrations are small, but not without use. My copy is printed on the normal thickness paper I have in my other "...for Dummies" books.

3 people found this helpful

See all reviews

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

Frequently bought together

Customers who viewed this item also viewed

From the Publisher