1 / 2Excel 2019 All-in-One For Dummies
Excel 2019 All-in-One For Dummies is an 816-page English reference covering spreadsheet basics through advanced tools such as pivot tables, macros and VBA. Its wide scope suits readers who want one reference for varied Excel tasks, although customer feedback is mixed on how easy it is to follow.
At a glance
- Covers worksheet creation and editing, formatting, formulas, protection, data import and charts.
- Includes pivot tables, financial and statistical functions, what-if scenarios and database functions.
- Advanced subjects include worksheet sharing and auditing, error trapping, macros and Visual Basic.
- The listing describes using Excel with Microsoft Power BI for data analysis, modelling and visualisation.
Often bought together
Pros and cons
Pros
- The broad subject range makes it a possible desk reference for both introductory and more advanced Excel tasks.
- Includes practical spreadsheet topics alongside VBA, macros, pivot tables and Power BI.
Technical specifications
9 specifications| Publisher | For Dummies |
|---|---|
| Publication date | 26 Oct. 2018 |
| Edition | 1st |
| Language | English |
| Print length | 816 pages |
| ISBN-10 | 111951794X |
| ISBN-13 | 978-1119517948 |
| Weight listed | 1.04 kg |
|---|---|
| Dimensions | 18.54 x 4.06 x 23.11 cm |
What to know before buying
- The listing describes an edition updated for the 2019 Office release. Confirm that this edition matches the Excel version and features you need, especially if using newer releases.
Who is it for?
A good fit for
- Excel beginners seeking a broad introduction to worksheets, formulas and charts.
- Users who want a single reference spanning spreadsheet basics, data analysis and VBA.
Less suited to
- Readers who need a guide specifically updated for a later Excel or Microsoft 365 release.
- Readers who prefer a short, narrowly focused tutorial rather than a broad reference.

Customer reviews on Amazon
- 5 stars
66% 66% - 4 stars
20% 20% - 3 stars
10% 10% - 2 stars
2% 2% - 1 star
2% 2%
Customer feedback describes the book as comprehensive, useful as a reference and helpful across skill levels. Readers also differ on readability, with some finding it easy to follow and others finding it complicated. That distinction matters for an 816-page guide spanning beginner topics through VBA and data analysis. The aggregate rating is generally positive, but ratings alone do not establish which parts work best for a particular reader.
Positive themes
- Customers describe the coverage as comprehensive and useful for solving Excel problems.
- Feedback says it can serve readers at different experience levels.
Mixed feedback
- Readability feedback differs, with some finding the material easy to follow and others finding it too complicated.
Frequently asked questions
What topics does this book cover?
The listing describes worksheet design, formulas, charts, data management, pivot tables, financial and statistical functions, macros, VBA and use with Power BI.
Is it suitable for beginners?
The listing targets new and inexperienced users, and customer feedback says readers across skill levels have found it useful. Feedback on readability is mixed, so the broad coverage may take effort to work through.
Is this a guide to the latest Excel version?
No. It is titled for Excel 2019 and described as updated for the 2019 Office release. Check that its coverage matches your software version.
Alternative options

Microsoft 365 Excel All-in-One For Dummies (For Dummies: Learning Made Easy)
£25.85

Excel Data Analysis For Dummies (For Dummies (Computer/Tech))
£23.02

Excel for Beginners: Learn the Excel Skills You Actually Use at Work, One Real Task a Day for 7 Days, with the Task Ladder Method, 200+ Screenshots and Downloadable Practice Files
£15.52

Microsoft Copilot For Dummies
£14.09

Microsoft Power BI For Dummies (For Dummies (Computer/Tech))
£18.80

Windows 11 All-in-One For Dummies, 2nd Edition
£22.87

Microsoft Teams For Dummies (For Dummies (Computer/Tech))
£15.41

Microsoft 365 Word For Dummies
£13.55

Windows 11 For Seniors For Dummies, 2nd Edition (For Dummies (Computer/Tech))
£14.09

























