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

by Greg Harvey (Author)

298 ratings

in Microsoft Excel Guides

ISBN-13: 978-1119517948

ISBN-10: 111951794X

Why is ISBN important?

Have one to sell? Sell on Amazon

Share <Embed>

Buy new

$18.99

In Stock.

Ships from and sold by Amazon.com.

List Price: $39.99
Save: $21.00 (53%)

FREE Shipping on orders over $25.00 shipped by Amazon or get Fast, Free Shipping with Amazon Prime

Price

New from

Used from

eTextbook

"Please retry"

$20.79

—

Paperback

"Please retry"

$18.99

$18.01

$17.96

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!

Related materials

Page 1 of 1Start OverPage 1 of 1

Excel VBA Programming For Dummies (For...

ISBN-13: 978-1119518174

$21.99
Excel Formulas & Functions For Dummies

ISBN-13: 978-1119518259

$18.84
Excel 2019 For Dummies

ISBN-13: 978-1119513322

$18.89
Related Text

Financial Modeling in Excel For Dummie...

ISBN-13: 978-1119357544

$18.18
Related Text

Excel Macros For Dummies (For Dummies ...

ISBN-13: 978-1119369240

$19.89
Related Text

Statistical Analysis with Excel For Du...

ISBN-13: 978-1119271154

$21.90
Related Text

Excel Dashboards and Reports For Dummi...

ISBN-13: 978-1119076766

$23.49
Excel Data Analysis For Dummies (For D...

ISBN-13: 978-1119518167

$13.39
Related Text

Excel Power Query PowerPivot For Dummi...

ISBN-13: 978-1119210641

$23.63
Related Text

Excel Sales Forecasting FD 2e (For Dum...

ISBN-13: 978-1119291428

$20.80

Customers who viewed this item also viewed these digital items

Page 1 of 1 Start overPage 1 of 1

This shopping feature will continue to load items when the Enter key is pressed. In order to navigate out of this carousel please use your heading shortcut key to navigate to the next or previous heading.

Ken Bluttman

74

Kindle Edition
$15.99
Greg Harvey

110

Kindle Edition
$15.99
M.L. Humphrey

98

Kindle Edition
$2.99
Michael Alexander

96

Kindle Edition
$25.17
Nathan George

34

in Spreadsheets
Kindle Edition
$5.99
Peter Weverka

142

Kindle Edition
$20.79

Customers who bought this item also bought these eBooks

Page 1 of 1 Start overPage 1 of 1

Ken Bluttman

74

Kindle Edition
$15.99
Dan Gookin

49

Kindle Edition
$13.29
Doug Lowe

31

Kindle Edition
$15.86
Peter Weverka

142

Kindle Edition
$20.79
M.L. Humphrey

98

Kindle Edition
$2.99
Laurie A. Ulrich

37

Kindle Edition
$15.99

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

Series: All-in-One For Dummies
Paperback: 816 pages
Publisher: For Dummies; 1 edition (November 13, 2018)
Language: English
ISBN-10: 111951794X
ISBN-13: 978-1119517948
Product Dimensions: 7.3 x 1.5 x 9 inches
Shipping Weight: 2.4 pounds (View shipping rates and policies)
Customer Reviews:
Amazon Best Sellers Rank: #3,228 in Books (See Top 100 in Books)
- #3 in Computer Science (Books)
- #1 in Microsoft Excel Guides
- #1 in Spreadsheet Books

Would you like to tell us about a lower price?
If you are a seller for this product, would you like to suggest updates through seller support?

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.

Customer reviews

5 star		69%
4 star		19%
3 star		6%
2 star		2%
1 star		5%

How does Amazon calculate star ratings?

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 20, 2019

Format: PaperbackVerified 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.

20 people found this helpful

Helpful

Comment

Mary H. Cosgrove

Too much to read

Reviewed in the United States on April 20, 2019

Format: PaperbackVerified 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

15 people found this helpful

Helpful

Comment

Foreverspeechless

dummies for excel

Reviewed in the United States on May 7, 2019

Format: PaperbackVerified Purchase

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

15 people found this helpful

Helpful

Comment

Bruce C. Douglas

worthless guide to a mangled piece of software

Reviewed in the United States on December 28, 2019

Format: PaperbackVerified 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.

6 people found this helpful

Helpful

Comment

Pierre Rogers

Printing is too light

Reviewed in the United States on June 1, 2019

Format: PaperbackVerified 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.

9 people found this helpful

Helpful

Comment

pam savant

content

Reviewed in the United States on March 12, 2019

Format: PaperbackVerified Purchase

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

9 people found this helpful

Helpful

Comment

Kelldub

I am a dummy when it comes to excel

Reviewed in the United States on October 16, 2019

Format: PaperbackVerified Purchase

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

4 people found this helpful

Helpful

Comment

scott

Not a quick start guide.

Reviewed in the United States on September 15, 2019

Format: PaperbackVerified Purchase

not an easy read. lots of info but does nor take you directly into utilizing excel. many online videos are much more concise and helpful.

3 people found this helpful

Helpful

Comment

Top international reviews

Internal design and paper appalling.

Reviewed in the United Kingdom on March 25, 2019

Format: PaperbackVerified 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...

6 people found this helpful

Sending feedback...

Thank you for your feedback.

Sorry, we failed to record your vote. Please try again

Nicola K

Brilliant book

Reviewed in the United Kingdom on January 19, 2020

Format: PaperbackVerified 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

3 people found this helpful

Sending feedback...

Thank you for your feedback.

Sorry, we failed to record your vote. Please try again

N. Mahoney

ideal for purpose

Reviewed in the United Kingdom on December 13, 2019

Format: PaperbackVerified Purchase

A great reference tool to have on hand when using Excel

3 people found this helpful

Sending feedback...

Thank you for your feedback.

Sorry, we failed to record your vote. Please try again

David Garside

does what it should

Reviewed in the United Kingdom on April 8, 2019

Format: PaperbackVerified Purchase

I hadn't used Excel for some time and as it has developed and grown I found myself very unfamiliar. However the book was really useful either to just dip in and find what I wanted or to learn new skills using excel, money well spent and always there.

4 people found this helpful

Sending feedback...

Thank you for your feedback.

Sorry, we failed to record your vote. Please try again

Helen Ormston

Easy read

Reviewed in the United Kingdom on November 3, 2019

Format: PaperbackVerified Purchase

Great for when you need to start working on new excel projects.

2 people found this helpful

Sending feedback...

Thank you for your feedback.

Sorry, we failed to record your vote. Please try again

Mark

Goo

Reviewed in the United Kingdom on July 26, 2019

Format: PaperbackVerified Purchase

Not as informative as I would have liked. A good coverage though.

2 people found this helpful

Sending feedback...

Thank you for your feedback.

Sorry, we failed to record your vote. Please try again

JadeH

Great for self-taught excel

Reviewed in the United Kingdom on June 3, 2019

Format: PaperbackVerified Purchase

Very good easy to follow book to teach yourself some excel.

2 people found this helpful

Sending feedback...

Thank you for your feedback.

Sorry, we failed to record your vote. Please try again

Wendy Myers

Easy Read

Reviewed in the United Kingdom on June 15, 2019

Format: PaperbackVerified Purchase

Easy to follow, well explained instructions, brilliant self teaching aid

3 people found this helpful

Sending feedback...

Thank you for your feedback.

Sorry, we failed to record your vote. Please try again

Davinia

Avoid it

Reviewed in the United Kingdom on August 2, 2019

Format: PaperbackVerified Purchase

Massive book, not easy to understand it at all, a bit mess. I keep following google stuff instead of the book

One person found this helpful

Sending feedback...

Thank you for your feedback.

Sorry, we failed to record your vote. Please try again

Adrian West

Good sound buy

Reviewed in the United Kingdom on October 25, 2019

Format: PaperbackVerified Purchase

Good excel info book, well worth the money

Sending feedback...

Thank you for your feedback.

Sorry, we failed to record your vote. Please try again

Mary

Paperback

Reviewed in the United Kingdom on October 3, 2019

Format: PaperbackVerified Purchase

Paperback

Sending feedback...

Thank you for your feedback.

Sorry, we failed to record your vote. Please try again

Amazon Customer

Just what we needed

Reviewed in the United Kingdom on March 10, 2020

Format: PaperbackVerified Purchase

Just what we needed

Sending feedback...

Thank you for your feedback.

Sorry, we failed to record your vote. Please try again

Amazon Customer

Easy to understand

Reviewed in the United Kingdom on January 31, 2020

Format: PaperbackVerified Purchase

Very helpful

Sending feedback...

Thank you for your feedback.

Sorry, we failed to record your vote. Please try again

Amazon Customer

Excel 2019

Reviewed in the United Kingdom on January 7, 2019

Format: PaperbackVerified Purchase

Great Delivery. As Described

One person found this helpful

Sending feedback...

Thank you for your feedback.

Sorry, we failed to record your vote. Please try again

Richard Wood

I hope it explains

Reviewed in the United Kingdom on October 6, 2019

Format: PaperbackVerified Purchase

Just starting to read the book

Sending feedback...

Thank you for your feedback.

Sorry, we failed to record your vote. Please try again

You've read the top international reviews

See all reviews from the United States

Pages with related products. See and discover other items: electronic readers, electronic reader, Electronic Readers

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

Related materials

Customers who viewed this item also viewed these digital items

Customers who bought this item also bought these eBooks

From the Publisher

Editorial Reviews

From the Back Cover

About the Author

Product details

Customer reviews

Customer images

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

Top international reviews