Straight Road to Excel 2013/2016 Pivot Tables

About the Book

The pivot table is without doubt the most powerful data processing tool ever introduced by Microsoft into the Excel product tool set, rivaled only by its younger sibling, Power BI. The ability of pivot tables to transform large quantities of data into a clear, concise summary report is incredible. The power of pivot tables as a data processing tool is only limited by user knowledge and imagination, and unthinkably, there are some Excel users who know next to nothing about pivot tables. This book is written by a Microsoft Office specialist expert (MOSE) and a mining engineer with extensive experience in Excel. The author’s experience in various Microsoft data management tools such as SQL Server, MS Access, and the MS Business Intelligence tools are brought to the fore in this book. By the time you reach the middle of the book, you should be able to increase your productivity with the skills you have learned. Every chapter of the book gives you the chance to practice what you have learned with step-by-step exercises. At the end of the book, you are given over two hundred Excel exercises and step-by-step instructions to perform the exercises. We guarantee that any serious reader who goes through the book and performs the exercises within the chapters of the book and those exercises compiled at the end would be well on the way to becoming an Excel expert and a pivot table guru. If you want to take your learning experience even further, we have provided over sixty questions and answers at our website. You can purchase and download these exercises and begin your learning experience at your own pace. Each exercise includes an extensive video explanation and a walk-through solution, as well as a chance to import your own data to work with.

About the Author

SAM AKRASI (aka Sam Osei-Tutu) is a Mining Engineer by profession and a data aficionado by nature. Sam has been involved in spreadsheet applications for over 30 years, beginning with the now-extinct products such as Symphony and Lotus 1-2-3. His training as a Mining Engineer and love for data have naturally led to his various assignment of processing large amounts of data in the resources industry and other similar industries. Sam has earned a number of Microsoft certifications. Beginning in 1998, when he earned his first certification as a MS Access developer, Sam has maintained his interest in Microsoft data processing tools. He currently holds certifications in SQL Server, Microsoft Office (Excel) Specialist Expert (MOSE) and is currently on the last leg of his MCSE (Business Intelligence) certification. Sam is also a Microsoft Certified Trainer and currently doubles as a consultant and freelance trainer in Excel and the BI tools.