WhatsApp UsSkype Us9:00am to 5:30pm (Mon-Fri) Stay Safe!

Microsoft Office Excel 2019 Data Cleaning for Data Analytics

Training Modes
 Virtual: Zoom (Learn more)
 In-Class (Bring your own laptop)

Course Code
 
OKEDC9
Duration
 
7 Hours (1 Day)
Course Fee
 
$342.40 inclusive of GST
Funding
 
UTAP for NTUC Members
This Course is For
 
Anyone who works with data for analysis work and need to ensure data correctness.

Preferred Date

You can also register by:

  1. Form: Click here to download. Email back to us.
  2. Ministries on HRP / ACE: Inform your Training Coordinator the Course Code, Course Date and the Training Provider is Oaks Training c/o GIL Consultancy.
    IMPORTANT NOTE: OAKS TRAINING begins with the letter O and not the symbol @ in HRP
  3. PHONE: Call +65 6423 1183.


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)


No Exam
No Exam! Ample hands on practice to master lessons taught.

Certificate
Certificate of Attendance will be given subject to 90% attendance.

Trainer
Local native speaking Trainers with more than 20 years of experience.

Empowering the Enduser is what we are committed to equiping our learners. We understand the challenges and expectations faced in their daily work. To help learners bridge the gap is what drives us. We believe in the common person and their will to succeed.

Classes in Mandarin

Select courses can be delivered in Mandarin on request basis via Zoom.

  • Microsoft Office
  • Video Editing
  • Essential Digital Skills

Contact Us

Mon-Fri, 8:30am-5:30pm
WhatsApp: Click here
Skype: Click here
Phone: 6423-1183
Online Enquiry: Click here
Locate Us: Click here