Hands-on Data Science
Data-informed Decision-Making: Data Analytics in Excel- Introductory to Intermediate
Adrian Dunkley
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 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
-
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
-
Dragons and Data: Data Science Hackathon
Put your data science skills to the test in a fun and challenging hackathon
Enroll
