Hidden Secrets of Data Analysis in Excel: How to Use Microsoft(R) Excel Differently to Gain a Productive Edge - Paperback

by Jason Khoo (Author)

This book is not designed to teach you all the formulas in Excel, neither is it meant for passing any examinations. The book sets out to help those who would like to save time on their existing Excel tasks. It consists of business case studies intended to introduce key concepts for the effective management of data, analysis of information, and reporting of findings using Microsoft Excel. The case studies will walk you through the entire process of manipulating raw data to reporting and showing you how to use Excel in the various stages of data management. They also illustrate how you can harness the power of formulas beyond their basic purpose. The intention is to lay the foundation for you to explore Excel on your own after you have completed the book. At the end of the day, it would make you less reliant on your IT staff and help you achieve a much quicker turnaround on your tasks, which you previously thought was impossible.

Author Biography

Jason Khoo is the founder and chief trainer of everydayExcel Business Lab Pte Ltd, a company which has successfully differentiated itself by offering Microsoft(R) Excel Courses that empower participants with knowledge of applying the different functions and formulas in Excel to real business needs and scenarios. He is also the author of the book "Excel Secrets for Highly Effective Marketers" and the website www.advanced-excel.com. An expert in spreadsheets and databases, Jason also founded SynergyWorks, a consultancy firm which has helped many companies extract valuable information from databases using Microsoft(R) Excel. He has helped companies save significant amount of money by providing solutions using existing PC applications such as MS Excel instead of purchasing new systems. His clients include multi-nationals corporations such as Discovery Asia, 3M, NCS, Cold Storage, Nippon Paint Singapore, Heinz Asean, Tanah Merah Country Club, and etc.