Excel Masterclass: A-Z Data Analysis Statistics & Dashboard

Master Excel for Formulas-Functions, PivotTables, Analysis Tools, Graphs and Dashboard for A-Z Data Analysis in 15 Days.

Created by: Shahriar's Sight Academy
Empowering Tomorrow's Data Leaders

What Will I Learn?

• You will learn to clean and format data, including removing duplicates, handling missing data, and managing outliers to ensure data integrity.
• You will learn advanced techniques for sorting and filtering data to efficiently extract relevant insights from large datasets.
• 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 best practices for enhancing your Excel dashboard, including layout optimization, graphical elements, etc., to maximize impact and usability.

Requirements

• Microsoft Excel Installed
• Desktop/Laptop (Mac or Windows)
• Dedication to learn

Target audience

• Individuals aiming to develop comprehensive knowledge in data cleaning, analysis, visualization, and dashboard creation in Excel.
• Beginners interested in learning practical Excel techniques for efficient data manipulation, visualization, and interpretation.
• Professionals seeking to enhance their data analysis skills within the familiar environment of Microsoft Excel.