Microsoft Office Excel 2019 Data Cleaning for Data Analytics

---

Prerequisites

Learners should:

• ideally have completed our Excel 2019 Advanced module
• have good working knowledge in creating Microsoft Excel formulas and using Excel functions

This course is suitable for users of Microsoft Office 2016.

Important Note
Must read Things You Would Need to ensure you are properly equiped for this course.

---

Learn how your imported raw data can be free from errors

We hear a lot about Data Analytics but data cleaning which is an important preparation of data before performing the analysis is often overlooked until errors occur. We need a dataset that is free from data errors to be incorporated into our work reports. However, often times, the raw data files presented to us could contain errors such as duplicates, wrong data types, wrong letter case, unnecessary spaces between data just to name a few. Any of these would render your analysis and reports in Microsoft Excel 2019 inaccurate and can be damaging to your company.

This one-day Microsoft Excel 2019 Data Cleaning for Data Analytics course will equip you on using relevant Excel functions and formulas to find and eliminate the more common errors found in raw datasets. The organized and consolidated data can then be used to generate useful and accurate information for your company.

You will learn in Office Excel 2019 Data Cleaning for Data Analysis:

• Import Data into Microsoft Office 365 Excel
  You will learn how to identify and decide on the appropriate format to import the raw data into Microsoft Excel 2019.
• Parse Data
  Imported raw data can come with each row of data all in stored into a single column cell which is not usable for analysis until they are properly separated into their respective columns.
• Remove Unwanted Spaces in Data
  Having additional spaces between words can be an issue when doing comparison and matching of data. You can quickly and effectively remove those unwanted spaces.
• Fill Blank or Empty Cells
  Empty values in cells can cause issues to calculations and retrieval of relevant data. These blank cells can be quickly filled with your required value.
• Fix Errors in Cell Format
  Having cells that contain text (alphanumeric) values instead of a numeric value can be disastrous and result in errors. You will learn how to safely convert such values.
• Duplicate Records
  Duplicate record is a frequently occurring problem in data. Learn how to manage or remove them.
• Highlight Errors
  Data files can contain errors such as Division error, Value error, etc. To have Microsoft Excel highlight them so that you can decide what and how to correct them quickly.
• Extract Dates and Convert Dates
  Dates can be entered in different formats like DD/MM/YYYY or MM/DD/YYYY which will cause errors in your reports, ensuring they are all aligned in the same format is essential. At times there might be a need to obtain portions of the date like the month or year.
• Text Data Order and Format
  Entered values in the wrong format or placement can often cause or pose challenges when handling certain tasks. These issues like sentences entered entirely in uppercase or lowercase, surnames or family names of different races differ in positions, can also cause problems. Being able to address these issues are important.
• Replace or Substitute Text
  The need to replace or substitute a text within a sentence because of changes to for example, the department name or a reference code can be tedious when done manually. In Microsoft Excel 2019 this can be done easily.

---

Our Friendly Trainer

Ms Ow Yeong Yin Leng

Qualified and Experienced to facilitate this course

• More than 20 years of training experience
• Native speaking Trainers
• Microsoft Certified

---

Special Request

Additional Dates: If the dates listed are not suitable for you and you have a group interested in the same course, you can contact us to arrange a date of your choice, subject to our trainer availability.

Evening classes or Classes in Mandarin are also available on request. Contact us for arrangements.

Group discounts are also available. Request a quote from us.

---

Reviews

The trainer explained very clearly and answered all queries." "It was the first time for me learning via Zoom. Overall it seems quite alright.
- Prasannah Kumarasamy (Judiciary)

Trainer is very patient and clear.
- Lee Wei Ann (AIC)

Trainer explained clearly and I enjoyed the lesson. Good.
- Ong (SPF)

Recommended Trainer. Patience and understanding. Thanks Ms Yin Leng.
- David Seah (Judiciary Court)