Tags
Language
Tags
March 2024
Su Mo Tu We Th Fr Sa
25 26 27 28 29 1 2
3 4 5 6 7 8 9
10 11 12 13 14 15 16
17 18 19 20 21 22 23
24 25 26 27 28 29 30
31 1 2 3 4 5 6

Your Excel Survival Kit : Your Guide to Surviving and Thriving in an Excel World

Posted By: readerXXI
Your Excel Survival Kit : Your Guide to Surviving and Thriving in an Excel World

Your Excel Survival Kit :
Your Guide to Surviving and Thriving in an Excel World

by Anne Walsh
English | 2016 | ISBN: 161547045X | 178 Pages | PDF | 4.74 MB

This book is for you if you are being asked to use Excel more than you ever expected and you are looking for a guide to take you to what is relevant and most frequently used. It’s also for you if you have seen that in your organization, it’s the Excel power users who get promoted, and you want to join them.

This book is also for you if you have done any of these things:

• Spent hours or even days trying to produce an analysis that can be done in minutes with a pivot table
• Cleaned up data by clicking on each individual cell (perhaps thousands of times) and pressing Backspace rather than using Trim to do them all in one go
• Set up repeating data in separate sheets instead of all together in one and then gone through Hell trying to put it all together at the end of the year
• Called on tape, glue, scissors, and a stapler to get an Excel sheet printed on one page instead of on multiple pages
• Manually pulled in matching entries from separate workbooks instead of using the Vlookup function
• Found yourself in a job where your boss is talking about pivot tables and Vlookups, and you have no idea what he/she is talking about — but you know you have to learn fast, and you are terrified

This book is going to get you through. It is, after all, your Excel Survival Kit. One of the key things you need to understand about Excel is that it is susceptible to the “garbage in, garbage out” idea, so a good part of this book is about making sure the data you will be using is clean, consistent, and Excel friendly.