Excel Masterclass: A-Z Data Analysis Statistics & Dashboard

Focused View

Shahriar's Sight Academy

7:26:04

7 View

1. Dont Ignore It. Start From Here!

1. Instructions you MUST follow.html

2.1 Microsoft Excel Data Analysis Cheat Sheet.pdf

2. Excel functions and shortcuts cheatsheet.html

2. Necessary Foundation of Data Analysis

1.1 1. Un DA.pdf

1. What is data analysis.mp4

07:11

2.1 2. Key COMP.pdf

2. Key components of data analysis.mp4

10:18

3.1 11. EDA.pdf

3. Understanding exploratory data analysis.mp4

05:37

4. Methods of exploratory data analysis Part 1.mp4

12:15

5. Methods of exploratory data analysis Part 2.mp4

11:17

6.1 12. 13. 14. Methods of EDA.pdf

6. Methods of exploratory data analysis Part 3.mp4

15:36

7. Necessary foundation on data analysis.html

3. Necessary Foundation of Statistical Analysis

1.1 22. Statistical Data Analysis.pdf

1. What is statistical data analysis.mp4

08:31

2.1 24. stat v s eda.pdf

2. Statistical data analysis vs EDA.mp4

04:10

3.1 6. Sampling methods.pdf

3. Population vs sample and its methods.mp4

11:05

4.1 23. Types of Statistics.pdf

4. Types of statistical data analysis.mp4

04:58

5. A recap on descriptive analysis.mp4

03:14

6. Inferential statistics Part 1 T-tests and ANOVA.mp4

06:54

7.1 25. 26. 27. methods of ds and is.pdf

7. Inferential statistics Part 2 Relationships measures.mp4

03:16

8.1 28. Lin reg.pdf

8. Inferential statistics Part 3 Linear regression.mp4

11:53

9. Necessary foundation on statistical analysis.html

4. Necessary Foundation on Hypothesis Testing

1.1 36. Hypothesis Testing.pdf

1. Hypothesis testing for inferential statistics.mp4

06:03

2.1 37. Selecting Appropriate Statistical Test.pdf

2. Selecting statistical test and assumption testing.mp4

10:26

3.1 38. CSP.pdf

3. Confidence level, significance level, p-value.mp4

03:37

4.1 39. Making Decision and Conclusion.pdf

4. Making decision and conclusion on findings.mp4

02:55

5.1 40. Example HT.pdf

5. Complete statistical analysis and hypothesis testing.mp4

07:01

6. Necessary foundation on hypothesis testing.html

5. Necessary Foundation on Data Visualizations

1.1 44. Data Visualization.pdf

1. Visualizing data for the best insight delivery.mp4

04:33

2. Several methods of data visualization Part 1.mp4

04:04

3. Several methods of data visualization Part 2.mp4

05:38

4.1 45. 46. 47. Data Visualization Methods.pdf

4. Several methods of data visualization Part 3.mp4

07:17

5. Data visualization and methods.html

6. Data Cleaning and Formatting in Excel

1.1 employee dataset.xlsx

1. Identify and remove duplicates.mp4

04:52

2. Removing duplicated values.html

3.1 missing mployee dataset.xlsx

3. Dealing with missing values.mp4

14:55

4. Imputing missing values.html

5.1 outliers sales data.xlsx

5. Defining and removing outliers.mp4

09:50

6. Dealing with outliers.html

7.1 Incon sales data.xlsx

7. Dealing with inconsistent values.mp4

07:12

8. Replacing inconsistent value.html

9.1 text to column.xlsx

9. Text-to-columns for data separation.mp4

03:28

10. Text-to-columns.html

7. Sorting and Filtering for Data Precision

1.1 filtering data.xlsx

1. Sorting and filtering data.mp4

07:26

2. Sorting and filtering in Excel.html

3.1 advanced filtering data.xlsx

3. Advanced filtering with criteria.mp4

05:59

4. Advanced filtering method.html

8. Conditional Formatting for Tabular Analysis

1.1 highlight cells.xlsx

1. Highlighting cells based on conditions.mp4

08:24

2. Cells highlighting in criteria.html

3.1 topbottom.xlsx

3. Findings top and bottom insights.mp4

04:44

4. Findings top and bottom insights.html

5.1 colorbar.xlsx

5. Creating color scales and color bars.mp4

06:52

6. Creating color scales and color bars.html

9. Formulas and Functions for Analyzing data

1.1 SAMM business growth data.xlsx

1. SUM, AVERAGE, MIN, and MAX functions.mp4

09:42

2. Perform SUM and AVERAGE operation.html

3.1 SA business growth data.xlsx

3. SUMIF, and AVERAGEIF functions.mp4

08:32

4. Using SUMIF and AVERAGEIF functions.html

5.1 CCC business growth data.xlsx

5. COUNT, COUNTA, and COUNTIF functions.mp4

08:04

6. Utilizing COUNTIF functions.html

7.1 YMD business growth data.xlsx

7. YEAR, MONTH and DAY for date manipulation.mp4

03:41

8. Extracting year, month and day.html

10. Advanced Formulas and Functions for Analyzing data

1.1 IF business growth data.xlsx

1. IF STATEMENTs for conditional operation.mp4

10:42

2. Applying NESTED IF operation.html

3.1 VLOOK employeeInfo.xlsx

3. VLOOKUP for column-wise insight search.mp4

06:56

4. Utilizing VLOOKUP function.html

5.1 HLOOK sales crosstab.xlsx

5. HLOOKUP for row-wise insight search.mp4

06:59

6. Utilizing HLOOKUP function.html

7.1 XLOOK sales data.xlsx

7. XLOOKUP for robust & complex insight search.mp4

07:05

8. Utilizing XLOOKUP function.html

11. Graphs and Charts for Data Visualization

1.1 Bar sales data.xlsx

1. Data analysis with Stacked and cluster bar charts.mp4

12:43

2. Insight generation using Stacked bar charts.html

3.1 Pie-Line sales data.xlsx

3. Data analysis with Pie chart and line chart.mp4

08:32

4. Insight generation using Pie chart.html

5.1 Area-Tree sales data.xlsx

5. Data analysis with Area chart and TreeMap.mp4

08:29

6. Insight generation using Area chart.html

7.1 Hist-Box sales data.xlsx

7. Data analysis with Boxplot and Histogram.mp4

05:14

8. Insight generation using Boxplot.html

9.1 Scatter-Combo sale data.xlsx

9. Data analysis with Scatterplot and Combo chart.mp4

04:57

10. Insight generation using Scatter plot.html

11.1 Decor sale data.xlsx

11. Adjusting and decorating graphs and charts.mp4

04:47

12. Data Analysis in PivotTables and PivotCharts

1.1 Pivot data p1.xlsx

1. PivotTables for group data analysis PART 1.mp4

09:16

2. Group data analysis in PivotTable.html

3.1 Pivot data p2.xlsx

3. PivotTables for crosstab data analysis PART 2.mp4

05:06

4. Crosstab data analysis in PivotTable.html

5.1 Pivot data p3.xlsx

5. PivotCharts and Slicers for interactivity.mp4

06:41

6. PivotCharts and Slicers for analysis.html

13. Data Analysis Tools for Statistical Analysis

1.1 data for statistics.xlsx

1. Descriptive statistics and analysis.mp4

06:12

2. Descriptive statistics.html

3.1 data for ind t-tests.xlsx

3. Independent sample t-test.mp4

08:41

4. Finding the difference between genders.html

5.1 data for paired t-tests.xlsx

5. Paired sample t-test.mp4

05:08

6. Finding the difference between time frames.html

7.1 data for anova.xlsx

7. Analysis of variance One way.mp4

07:30

8. Finding the difference among regions.html

9.1 data for corr.xlsx

9. Correlation test - relationship measure.mp4

10:16

10. Finding the relationship between numeric data.html

11.1 data for reg.xlsx

11. Regression analysis - influence measure.mp4

12:23

12. Measuring the influence of IV on DV.html

14. Building Dashboard in Excel

1.1 1. acc inf.xlsx

1. Integrating analysis and graphs for dashboard.mp4

08:40

2.1 2. canvas.xlsx

2. Building a canvas for implementing dashboard.mp4

05:32

3.1 3. dashboard.xlsx

3. Creating dashboard with drag and drops.mp4

07:36

4.1 4. decor dash.xlsx

4. Final adjustment of dashboard elements.mp4

05:09

5. Creating a complete dashboard.html

15. Final Project - Data Analysis A-Z in Excel

1. Bank churn data analysis in Microsoft Excel.html

2. Final remark for you.html

Description

Learn Excel with Important Formulas-Functions, PivotTables, Analysis Tools, Graphs and Dashboard for A-Z Data Analysis.

What You'll 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.

Who is this for?

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.

What You Need to Know?

Microsoft Excel Installed

Desktop/Laptop (Mac or Windows)

Dedication to learn

More details

Description
Unlock the power of data analysis with Excel in this comprehensive course designed to take you from novice to proficient data analyst. Whether you're new to Excel or looking to expand your skills, this course equips you with the essential tools and techniques to excel in data analysis.

Throughout the course, you'll dive deep into data cleaning and formatting, learning how to remove duplicates, handle missing data, and manage outliers effectively. You'll discover advanced sorting and filtering methods to extract valuable insights from complex datasets, and you'll master conditional formatting to visually highlight trends and anomalies.

With a focus on practicality, you'll gain proficiency in essential Excel formulas and functions for calculations, date manipulation, and conditional operations. You'll also harness the power of lookup functions to quickly retrieve specific information, streamlining your analysis workflow.

Data visualization is a key component of effective analysis, and you'll learn to create a variety of graphs and charts in Excel to communicate insights with clarity. From bar charts to scatter plots, you'll explore different visualization techniques to enhance data interpretation and presentation.

PivotTables and PivotCharts offer dynamic ways to summarize and analyze data, and you'll learn how to leverage these tools for advanced analysis and visualization. Additionally, you'll delve into Excel's statistical analysis tools, performing tasks such as descriptive statistics, t-tests, correlation, and regression analysis.

As you progress, you'll bring your newfound skills together to create dynamic dashboards in Excel, consolidating information into visually appealing and interactive formats for effective decision-making and reporting. You'll refine your dashboard with layout optimization and graphical elements, ensuring maximum impact and usability.

By the end of this course, you'll emerge as a proficient Excel user, equipped with the knowledge and skills to tackle data analysis challenges confidently and efficiently. Whether you're a professional seeking to enhance your career prospects or a student aiming to develop practical Excel expertise, this course empowers you to master data analysis from zero to hero.
Who this course is for:
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.

User Reviews

Rating

average 0

Total votes0

Focused display

Introducing Shahriar: Accomplished Data Analyst and Passionate InstructorWelcome to the dynamic world of data analytics, where every byte of information holds the key to unlocking insights and shaping informed decisions. Meet Shahriar, a seasoned freelancer and a dedicated data enthusiast, who is now poised to share his wealth of knowledge and expertise as an esteemed Instructor at Udemy.With a rich tapestry of experiences spanning over three prolific years in the field, Shahriar has made an indelible mark as a Data Analyst extraordinaire. Over the course of his illustrious career, he has successfully spearheaded and completed an impressive portfolio of more than 300 projects, transcending geographical boundaries and leaving a trail of satisfied clients worldwide.Proficient in an array of cutting-edge tools and languages including Python, R, Excel, SQL, Tableau and SPSS, Shahriar's prowess extends across a spectrum of domains within the data realm. His unparalleled skills encompass data analysis, machine learning, data manipulation, data visualization, and applied statistics, to name just a few. His holistic approach to problem-solving ensures that every project is meticulously analyzed, curated, and executed to perfection, delivering results that are not just insightful but also actionable.Embark on this transformative learning journey with Shahriar and unravel the mysteries of data in a way that only a true storyteller can unveil. The world of data analytics awaits, and Shahriar is your guiding light.

Udemy

View courses Udemy

Students take courses primarily to improve job-related skills.Some courses generate credit toward technical certification. Udemy has made a special effort to attract corporate trainers seeking to create coursework for employees of their company.