Do you want to have more time to do what you really want instead of struggling with Excel..well you are in the right place!
You can get your INSTANT copy of my Excel book – Your Excel Survival Kit – A guide to surviving and thriving in an Excel world ..complete with bonuses here. This book covers all the topics that you need to master the main topics of Excel. PLUS tipsheets full of fast, highly effective Excel tips. All for $17!
Table of Contents
- Back to Basics – What do you know already?
- Getting your data together – Catching Your File
- Further Cleaning, Slicing and Dicing
- The Vlookup() : An Excel Essential
- Creating Pivot Tables
- Using Power Query to quickly clean up data
- Beyond the Pivot Table: Power Pivot
Bonus No. 1 – Data Cleansing Tipsheet
If you work with Excel, you will know that you spend a fair chunk of time just cleaning up data – this sheet shows you how to quickly separate how your data, how to quickly fill in blanks, cleaning up dates etc.
Bonus No. 2 – Data Validation Tipsheet
A big part of sorting out Excel problems is preventing them. That’s where Data Validation comes in. This is full of tips to show you how to protect your cell entries, create dropdown lists that you can easily update, restrict date entries and much more…
Bonus No. 3 – Conditional Formatting Tipsheet
Conditional formatting allows you to visually and instantly identify entries that meet certain conditions e.g. have I got duplicates? What are my top 10 items? My bottom 10 items? Can I add a traffic light system? This sheet shows you how to do all that…
Bonus No. 4- A list of carefully selected Excel resources – saving you having to trawl through the Internet looking for recommended resources
Bonus No. 4 – A list of Excel keyboard shortcuts
I get asked all the time about keyboard shortcuts in my class – here’s a great list.
You Might Be Asking – Who Are You & How Can You Help Me?
My name is Anne Walsh and I’ve been working as a trainer in Excel for the best part of 20 years. I’ve done my 10,000 hours and what is in the book are the answers to the questions that come up over and over again in my training classes. How do I do formulas? How do I do pivot tables? How do I do a chart?
I know my stuff and I know how to explain Excel so that it is accessible and easy to understand.
Here are some testimonials about the work I do..
What You Can Expect
Instant access to the book – complete with instructions on how to get it onto your computer and other devices
Instant access to the files that go with the book – you will need to work through the exercises to get the full benefit of the book..you won’t get fit by watching the people in the gym – you have to do the exercises!
A copy of the tipsheet on Data cleansing – cleaning up data is a constant chore in Excel – this covers some of the fastest (and some not so well known ones )
A copy of the tipsheet on Conditional Formatting
A copy of the tipsheet on Data Validation
A list of carefully curated Excel resources. I am constantly looking to update my own Excel skills and here is a list of the ones that I have found most useful.
What’s it worth?
Excel is used by 750 million people throughout the world. Microsoft’s CEO recently described it as the most important product Microsoft has ever produced. If you are looking for a job, the chances are you will be expected to have strong Excel skills. This book covers the key Excel skills you will need. The bonus tipsheets cover techniques that are not in the book but which will make you the Excel hero/heroine in your office.
- Book – List price of $19.95
- Tipsheets : Priceless
- Keyboard shortcuts: Priceless
“Hope your Survival Kit is selling well. It’s a very good manual. When I read it I felt that you were there in the room with me telling me how to do the different tasks in excel. Especially the little remarks , comments.” John Farrell, OPEN EIR Staff Development & Coaching
“Anne Walsh knows her stuff! She’s a certified Microsoft Excel trainer and it shows. As well as a useful ‘Back to Basics’ reference section at 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. I’ve been using Excel for years, and I have learned a heap of short-cuts I never knew before that have made my Excel work faster and easier than ever before. I wish I’d had this book years ago, it would have made my life so much easier. Best of all, Anne has a warm, humorous approach that makes the technical work of learning Excel feel far more fun than similar books. Highly recommended.”
I have been looking for work that often requires advanced Excel Skills and this was the book for me! Anne explained that over 90% of data in organisations ends up in an excel spreadsheet for final preparation. This book gives you a chance to catch up in Chapter 1 on the basics, like function key commands and Control plus C, Control plus V for copy and paste for example. Chapter 2 talks about the importance of validating and normalising data, while chapter 3 gives quick and easy solutions to cleansing your excel data. Chapter 4 covers understanding when to use vlookups and is a very powerful chapter on the topic of vlookups. Pivot tables is covered well, and is a necessary part of the armory of any clerk or accountant. Power query is used to cleanse data and is an exciting chapter to someone who used to spend laborious hours tidying up spreadsheets! I am using the latest, office 365 and had to tweak some of the commands that Anne has in her book (based on excel 2010, I think). There were install issues with power pivot, so I didn’t complete this chapter satisfactorily. Overall the book was enjoyable, and much cheaper than attending a week long course on advanced excel!