Hands-on Data Science

Data-informed Decision-Making: Data Analytics in Excel- Introductory to Intermediate

Adrian Dunkley

Adrian Dunkley CEO

Adrian Dunkley is the founder and CEO of StarApple AI, Jamaica's first AI and Data Science company, he has a background in fintech, tourism, and sports science. He's held leadership roles in multinational corporations and is the President of the Jamaica Technology and Digital Alliance. Adrian aims to establish a Caribbean Space Agency and is a Data Scientist and A.I Engineer with 15+ years of experience. He holds a double major in Mathematics and Physics and a Masters in Enterprise Risk Management.

3 Hours

Duration

500Per Person
Individual
200Per Person
Groups of 5+ participants

Course Description:

In this 2-day course, we cover the foundational to intermediate aspects of Excel for data analysis. You’ll learn how to clean, organize, and analyze data using Excel’s powerful features. Our experienced trainers will guide you through a series of practical exercises using real government datasets, ensuring you gain the skills to make data-informed decisions using Excel.

Syllabus:

Excel Basics for Data Analysis: Overview of Excel features, navigating the interface, and setting up datasets for analysis.
Data Cleaning and Organization: Techniques for cleaning data, handling missing values, and organizing data for analysis.
Data Analysis Tools in Excel: Learning to use Excel’s built-in tools such as PivotTables, charts, and conditional formatting for data analysis.
Introduction to Formulas and Functions: Mastering key Excel formulas and functions relevant to analyzing and summarizing data.
Practical Exercises with Government Datasets: Hands-on application of Excel skills on real government data to practice cleaning, organizing, and analyzing data effectively.

Prerequisites:

There are no prerequisites for this course.

Grading Policy:

2 exams
1 capstone project

Other Courses

Data Analytics Feb 29

Data Visualization Mastery for Transparent Public Communication

In our 2-day course, learn from data visualization experts to craft compelling stories with data, focusing on clarity, user-centered design, and accessibility.

Enroll
Intelligent Communication Mar 1

Data-Driven Dialogues: Enhancing Corporate Communication with Data Science, 2024/25 Series

Data Dialogue: Transform data into clear, actionable insights with our 2-hour workshop for enhancing communication and decision-making skills

Enroll
Data Visualization Jan 14

Dragons and Data: Data Science Hackathon

Put your data science skills to the test in a fun and challenging hackathon
Enroll