Data Management and Analysis in Excel & SQL

Kaplan Singapore


Course introduction

The objective of the workshop is to familiarise participants with the fundamentals of how to manage, transform and analyse data using the various functions and power of Microsoft Excel. Excel is a very widely used tool within many organisations and departments and being able to produce a quick analysis is an asset.



Course Benefits


Course Objectives

Along with Excel being a data source and tool to manipulate data, databases nowadays are becoming very popular and a part of every organisation. Hence, learning and knowing the basics of SQL (Structured Query Language) has become very important. This workshop also takes you through the nuances and fundamentals of how SQL can be used with databases to ingest, manipulate and store data.
 



Course Pre-Requisites


Pre-Requisites

  • Minimum age: 16 years old
  • Knowledge of basic PC skills
  • A basic proficiency in reading, writing and understanding English



Target Audience


Who Should Attend
Students, working professionals and PMETs.



Course Outline


Mode of training: Classroom

Duration: 8 hours (1 day)

For latest course schedule, please enquire with your course consultant or simply fill up the enquiry form.

Course Structure:
Module 1: Pivot Table
Module 2: Functions & Formulas
Module 3: Advanced Charts
Module 4: Simple Data Analysis
Module 5: Basics of SQL (M/S SQL Server 2019)



Available Course Sessions


Please click here to stay updated on upcoming sessions.



Trainer Profile


Aditya

Aditya is a tech enthusiast with more than 6 years of experience across various technologies in data science, machine learning, deep learning and computer vision. He has worked across various domains including automotive, banking, retail among others. He is a true believer of ‘You got to see it work to know it works’ and sets goals towards achieving the same in any of the endeavours he undertakes. Being highly inclined towards tech, he founded Xaltius Pte. Ltd in Singapore which has a major focus on building AI and AR based products for various sectors. He also founded Code For India which specializes in delivering top notch skills in Data Science and AI as required in the industry today. He also loves to teach students and professionals Data Science and AI and does that regularly in Singapore.


Kaplan reserves the right to change trainer, in light of unforeseen circumstances.



 

Top