Description
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.
Preview
1 image
Download Files
