MICROSOFT EXCEL 2019: ADVANCED TECHNIQUES FOR DATA ANALYSIS

This book will provide you with a thorough coverage of Advanced Techniques for Data Analysis. You will master: Advanced Filters, Advanced Functions, Pivot Tables, Advanced Charts, Whatif Analysis, Forecasting, Using Benfords Law to detect fraudulent transactions. The book has been written by an experienced Data Scientist with wide knowledge in technologies like Microsoft Excel, Power Business Intelligence (Power BI), Integrated Data Extraction and Analysis (IDEA), Audit Command Language (ACL) which is now called HighBond, etecetera and has trained employees of large corporations, government departments in East Africa.As a result of the endless trainings, the Author constantly refines the book by observing which skills students find difficult to understand and then developing simpler and better ways of explaining them. This has made the book effective for students of all ages and abilities.This book is designed to teach Excel and not as a reference book. It can, therefore, be used by those who wish to provide advanced Excel 2019 training courses like Schools, Colleges and Universities to provide structured, objective-led, and highly effective classroom courses. Each Session in the book has clearly defined objectives and an exercise to ensure that learning has taken place. The book assumes a practical, hands-on approach with real world examples.