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 Автор: 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
Microsoft Excel 2019 Pivot Table Data Crunching Название: Microsoft Excel 2019 Pivot Table Data Crunching Автор: Bill Jelen, Michael Alexander Издательство: Microsoft Pres Год: 2019 Страниц: 512...
Excel 2019 Bible Название: Excel 2019 Bible Автор: Michael Alexander Издательство: Wiley Год: 2018 Страниц: 1120 Формат: True PDF, EPUB Размер: 124 Mb Язык: English ...
Power Pivot and Power BI, 2nd Edition Название: Power Pivot and Power BI: The Excel User's Guide to DAX, Power Query, Power BI & Power Pivot in Excel 2010-2016 2nd Edition Автор: Rob...
Excel 2016 Pivot Table Data Crunching Название: Excel 2016 Pivot Table Data Crunching Автор: Bill Jelen, Michael Alexander Издательство: Packt Publishing Год: 2015 Страниц: 432 Формат:...