📚 Syllabus & Course Curriculum
Data Science & Analytics
Module-by-module breakdown of Excel for Data Analytics, from foundations to a certified capstone project.
Outline
What is Microsoft Excel? • Role of Excel in Data Analytics • Understanding Rows, Columns, Cells, and Worksheets • Applications of Excel in Business and Research
Outline
Entering and Organizing Data • Sorting and Filtering Data • Basic Data Cleaning Concepts • Formatting Data for Analysis
Outline
Introduction to Excel Formulas • Common Functions such as SUM, AVERAGE, MIN, and MAX • Using Simple Calculations for Insights • Understanding Basic Data Summaries
Outline
Creating Basic Charts and Graphs • Presenting Data Visually • Introduction to Tables and Simple Reports • Dashboard Basics for Beginners
Outline
Excel in Business, Finance, Education, and Research • Using Excel for Decision-Making • Career Opportunities in Data Analytics • Mini Learning Activity / Concept-Based Practice
Earn government-registered certification in Excel for Data Analytics
e-Certificate and e-Marksheet issued on successful completion.
