Excel 2019 All-in-One For Dummies
£16.60£26.60 (-38%)
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!
Read more
Additional information
| Publisher | For Dummies, Nov-18 edition (26 Oct. 2018) |
|---|---|
| Language | English |
| Paperback | 816 pages |
| ISBN-10 | 111951794X |
| ISBN-13 | 978-1119517948 |
| Dimensions | 18.54 x 4.06 x 23.11 cm |
by ddb
TM Books provided me excellent custoer service whereby they provided an additional free book of Excel 2019 Dummies where the previous sent book was of poor print quality. This has now been resolved as a happy customer. Many Thanks.
by Alison Druce
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.
by krch6
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.
by Annie40
Good book good price. Highly informative but you do need to have some basic knowledge of excel to start, you also need to know exactly what you want to do ,
by CountyMountie
I don’t like to leave poor reviews but on this occasion I can’t be positive about this product. I agree with other people that the print quality of this book is poor – especially the illustrations. The paper is very yellow and thin.
I wear spectacles for reading but have a very weak prescription. I found that I needed excellent light just to read this. The illustrations were very poor. It looks as though the ink leaches into the paper and the detail is lost.
The content itself was not the easiest to follow and in some cases o had to go to other sources to find a better explanation of the formula and/or functionality.
I was really disappointed and should have taken the print quality review into account.
In fairness to the publisher,, this is a hefty book and I suspect the only way to make it cost effective is to use the lower paper and print.
I found it too frustrating and returned it for a refund.
by LilyRose
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.
by David A.
As described and on time
by Bryan
This is a comprehensive book, I’ve not found anything that can’t sort a query with Excel, it is quite hard going though, maybe my level of tech knowledge makes it like that.