Excel for data analysis enables professionals to transform raw data into meaningful insights using BI techniques and dashboard designing. With formulas, Power Query, PivotTables, and visualizations, Excel supports data-driven decision-making through interactive, accurate, and business-ready reports.
Curriculum
- 3 Sections
- 47 Lessons
- 52 Weeks
Expand all sectionsCollapse all sections
- Section 11
- Section 21
- Section 3 - 39 Amazing Charts in Excel45
- 3.1Part 1 – Introduction of 39 Amazing Charts in Excel – Excel for Data Analysis – Cohort 2
- 3.2Part 2 – Important Tips 1.1 – Excel for Data Analysis – Cohort 2
- 3.3Part 3 – Important Tips 1.2 – Excel for Data Analysis – Cohort 2
- 3.4Part 4 – Important Tips 1.3 – Excel for Data Analysis – Cohort 2
- 3.5Part 5 – Important Tips 1.4 – Excel for Data Analysis – Cohort 2
- 3.6Part 6 – Stylish Progress Circle Chart – Excel for Data Analysis – Cohort 2
- 3.7Part 7 – Weekly Sales Report – Excel for Data Analysis – Cohort 2
- 3.8Part 8 – Max Sales in Stacked Column Chart Amazing Techniques – Excel for Data Analysis – Cohort 2
- 3.9Part 9 – Progress Circle Chart – Excel for Data Analysis – Cohort 2
- 3.10Part 10 – Dynamic Min and Max in Column Chart – Excel for Data Analysis – Cohort 2
- 3.11Part 11 – Funnel Chart – Excel for Data Analysis – Cohort 2
- 3.12Part 12 – Double Doughnut Chart – Excel for Data Analysis – Cohort 2
- 3.13Part 13 – Dynamic Performance Chart – Excel for Data Analysis – Cohort 2
- 3.14Part 14 – Timeline – Excel for Data Analysis – Cohort 2
- 3.15Part 15 – Waterfall Chart – Excel for Data Analysis – Cohort 2
- 3.16Part 16 – Revenue Comparison – Excel for Data Analysis – Cohort 2
- 3.17Part 17 – Dynamic Charts using Drop Down with Name Manager – Excel for Data Analysis – Cohort 2
- 3.18Part 18 – Dynamic Charts using Option Button – Excel for Data Analysis – Cohort 2
- 3.19Part 19 – Thermometer Chart – Excel for Data Analysis – Cohort 2
- 3.20Part 20 – Half Circle KPI info Graphics Chart – Excel for Data Analysis – Cohort 2
- 3.21Part 21 – Dynamic Chart with Option Button for Employees Count by Age group – Excel for Data Analysis – Cohort 2
- 3.22Part 22 – Dynamic Pictograph using Vlookup and Option Button – Excel for Data Analysis – Cohort 2
- 3.23Part 23 – Dynamic Speedometer Chart – Excel for Data Analysis – Cohort 2
- 3.24Part 24 – Speedometer Chart – Adv. Data Analytics – Excel for Data Analysis – Cohort 2
- 3.25Part 25 – Dynamic Chart with Name Ranges Index Match Functions – Excel for Data Analysis – Cohort 2
- 3.26Part 26 – Daily Sales using Scrollbar and Line Chart – Excel for Data Analysis – Cohort 2
- 3.27Part 27 – Conditional Formatting in Stylish Doughnut Chart – Excel for Data Analysis – Cohort 2
- 3.28Part 28 – Dynamic Charts using Scroll Bar and HLookup – Excel for Data Analysis – Cohort 2
- 3.29Part 29 – Infographics in Excel – Excel for Data Analysis – Cohort 2
- 3.30Part 30 – Info Graphics Group of Circle Chart in Excel – Excel for Data Analysis – Cohort 2
- 3.31Part 31 – KPI’s Dashboard – Excel for Data Analysis – Cohort 2
- 3.32Part 32 – KPI’s Dashboard – Excel for Data Analysis – Cohort 2
- 3.33Part 33 – Multi Category Chart – Excel for Data Analysis – Cohort 2
- 3.34Part 34 – Create a line chart depending on date selection below – Adv. Data Analytics – Excel for Data Analysis – Cohort 2
- 3.35Part 35 – Dynamic Maps Chart – Adv. Data Analytics – Excel for Data Analysis – Cohort 2
- 3.36Part 36 – Stylish Traffic Lights – Excel for Data Analysis – Cohort 2
- 3.37Part 37 – Stunning Thermometer Chart – Excel for Data Analysis – Cohort 2
- 3.38Part 38 – Multilayered Doughnut Chart – Excel for Data Analysis – Cohort 2
- 3.39Part 39 – Multilayered Doughnut Chart – Excel for Data Analysis – Cohort 2
- 3.40Part 40 – Stunning Battery Chart in Excel – Excel for Data Analysis – Cohort 2
- 3.41Part 41 – Ultimate Thermometer Chart – Excel for Data Analysis – Cohort 2
- 3.42Part 42 – Informative KPI Indicator 1 – Excel for Data Analysis – Cohort 2
- 3.43Part 43 – Informative KPI Indicator 2 – Excel for Data Analysis – Cohort 2
- 3.44Part 44 – Sales Funnel Chart in Excel – Excel for Data Analysis – Cohort 2
- 3.45Part 45 – Forecast Vs Actual Chart with Safe Zone Range in Excel – Excel for Data Analysis – Cohort 2
