Excel Data Cleaning Fundamentals
What you'll learn
- How to detect and fix errors in datasets imported into Excel for analysis
- How to categorize and fix errors in the different data types in excel using basic to advanced excel functions
- Different concepts and techniques used in excel data cleaning
- Basic Knowledge of Microsoft Excel
Analyst from time to time may need to analyze small datasets from larger datasets that may exist in other applications or other forms of storage for very quick results.
Excel has proven to be a very reliable support analytical tool in this regard , it is easy to learn and work with, it provides the analyst with reliable and easy ways of importing datasets into excel for quick analysis.
The main challenge that analysts face having imported datasets into excel from different applications is the issue of data inconsistencies, anomalies and other errors.
The course is designed to provide the analysts with the necessary skill set to overcome this problem, by providing a step by step instruction using a follow along exercise and also several case study exercise and quizzes, on how to use basic to advanced excel functions , concepts and techniques in a fast and efficient way to detect and fix errors that result from datasets imported from other sources into excel for analysis.
The techniques in this course are simple but yet very effective in excel data cleaning , and will not require the use of macros or any excel add on tools
Who this course is for:
- Analysts, who want a quick start in excel data cleaning
- Marketing professionals
- Anybody who wants a quick start to some essential excel data cleaning concepts and techniques
Nasiru Musa has a BSc In Accounting from ABU Zaria (Nigeria) , MSc Information systems from the university of Liverpool and a Post graduate certificate in corruption studies from the Hong Kong University, he is also a certified anti money laundering specialist (CAMS) ,he has several years of experience in Auditing, Financial Investigation, Information systems and Law enforcement intelligence analysis.
He has worked for over 8 years in the Nigerian Financial Intelligence Unit , where he has lead several teams in cases bordering on Corruption, Human trafficking , illicit drug financial investigations , Money laundering and Terrorist financing. He was also a trainer and a training administrator with the training academy of the prestigious economic and financial crimes commission (EFCC) in Nigeria. He is currently into Intelligence Analysis ,AML/CFT and Productivity tools training and consulting
He was also a certified fraud examiner (CFE), certified information systems auditor (CISA), and a certified information security manager (CISM) from 2008 to 2015
Feel free to contact him on LinkedIn for more information on any of his current or upcoming courses.