You have just been promoted to a job that requires more Excel skills than ever. You have heard all these terms: Vlookup(), Pivot Tables, Power Query but really you do not feel competent or confident in any of them. This book takes you by the hand and in a light humorous way walks you through them all. There are the old Excel friends of If functions/ pivot tables/vlookup but you also get to meet some of the new kids on the block like Xlookup, Power B1, and dynamic arrays. You are taken through practical exercises in a systematic clear way that makes Excel accessible and dare I say it, delightful. It's a book you can have beside you all the time as a guide. Reviews of the First Edition: An excellent Excel resource for non-finance and finance experts alike. As well as a useful 'Back to Basics' reference section it the beginning of the book, she takes you step-by-step through the process of downloading data, cleaning it up, then setting it up so you can avoid having to re-do long laborious Excel tasks.
From Vlookup to Pivot Tables, everything is explained clearly with clear examples, diagrams and screen shots to help you see what to do quickly and easily. Anne has a warm, humorous approach that makes the technical work of learning Excel feel far more fun than similar books. Highly recommended. Book jacket.