title: Hidden Secrets of Data Analysis in Excel: How to Use Microsoft Excel Differently to Gain a Productive Edge
author:  Jason Khoo 
description: Jason Khoo is the founder and chief trainer of everydayExcel Business Lab Pte Ltd, a company which has successfully differentiated itself by offering Microsoft 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 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.
zlib_text: ![](Images/image00040.jpeg)
  
  ![](Images/image00034.jpeg)
  
  A complete guide to cleaning and
  
  preparing data for analysis using
  
  Excel™ and Google Sheets™
  
  Produced by:
  
  Copyright 2019 Inzata Analytics. Published by DSM Media. All Rights Reserved.
  
  Table of Contents
  
  CHAPTER 1: INTRODUCTION
  
  CHAPTER 2: WHY CLEAN DATA?
  
  Top 5 Benefits of Data Cleaning
  
  Improve the Efficiency of Customer Acquisition Activities
  
  Improve Decision Making Processes
  
  Streamline Business Practices
  
  Increase Productivity
  
  Increase Revenue
  
  CHAPTER 3: HOW SPREADSHEETS BECAME
  
  THE #1 BI TOOL IN THE WORLD
  
  Risks of Cleaning Data In Spreadsheets
  
  Performance and Size Limits in Spreadsheet Tools
  
  Excel Limits
  
  Google Sheets Limits
  
  CHAPTER 4: WHICH IS BETTER? GOOGLE OR
  
  EXCEL?
  
  Desktop App (Excel)
  
  Cloud App (Google Chrome or Excel Online)
  
  CHAPTER 5: TYPES OF DATA QUALITY
  
  PROBLEMS
  
  Most Common Data Problems
  
  Missing values
  
  Nul values
  
  Partial or Incomplete Values
  
  Duplicates
  
  Mis-Formatted Data (Data in The Wrong F