Название: Your Excel Survival Kit: Your Guide to Surviving and Thriving in an Excel World Автор: Anne Walsh
Издательство: Holy Macro! Books
Год: 2016
Страниц: 178
Язык: английский
Формат: pdf (true), epub
Размер: 19.5 MB
You have just been promoted into a job that requires more Excel skills than ever. You are floundering, drowning in a sea of spreadsheets. This book walks you through in an easy accessible way - vlookups, pivot tables, Power Query, and Power Pivot. The Excel Survival Kit is small enough to slip into your purse.
I have been teaching Excel for well over 20 years (I’ve got my 10,000 hours done!), and I still feel joy when I see people’s faces light up as they grasp what a pivot table can do for them or when they realise that printing is much easier than they thought. After you have read this book, my hope is that you start to see Excel’s power and begin to really leverage it. I feel so privileged when I help people realize that Excel can be their best office friend.
The reality is that in most workplaces—even those with very sophisticated systems—data usually ends up in Excel. If you can get to grips with the concepts in this book, you will soon feel comfortable working with Excel.
Who This Book Is For:
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 Vlookup()s, and you have no idea what he/she is talking about—but you know you have to learn fast, and you are terrified
Скачать Your Excel Survival Kit: Your Guide to Surviving and Thriving in an Excel World