What you'll learn

You will master the fundamentals of data analytics, including facts and theories, statistical analysis, hypothesis testing, and machine learning.

You will learn how to apply conditional formatting in Excel to visually highlight key trends, insights, and anomalies within your data.

You will learn essential Excel formulas and functions such as SUM, AVERAGE, COUNT, IF statements and MORE, enabling you to manipulate data effectively.

You will learn to utilize Excel's lookup functions (VLOOKUP, HLOOKUP, XLOOKUP) to efficiently search for and retrieve specific information within datasets.

You will learn various graph and chart types in Excel for data visualization, including bar charts, pie charts, scatter plots, and more to communicate insights.

You will learn advanced analysis using PivotTables and PivotCharts, enabling you to analyze, and visualize complex datasets with ease and interactivity.

You will learn to use Excel's built-in data analysis tools for statistical analysis, i.e., descriptive statistics, t-tests, ANOVA, correlation, and regression.

You will learn to design and create dynamic DASHBOARD in Excel, by a visually interactive format for effective decision-making and reporting.

You will learn the important Python programming basics such as variables naming, data types, lists, dictionaries, dataframes, sets, loops, functions etc.

You will master a range of methods and techniques for data cleaning, sorting, filtering, data manipulation, transformation, and data preprocessing in Python.

You will learn to use Python for data visualizations, exploratory data analysis, statistical analysis, hypothesis testing methods and machine learning models.

You will work on practical data analysis projects to apply learned skills. Enhance problem-solving abilities through hands-on data analysis exercises.

Requirements

Access to computer and internet

Basic computer literacy

No coding experience required

Dedication, patience and perseverance