This course will help you to create dynamic, interactive charts in excel using excel form controls. In each exercise you will learn how to create customize charts in excel and create awesome reports in excel.
You will get one course workbook and sample dashboard to do pratice in this course. In my sample workbook, you will also get the step by step guide to create the Interactive and dynamic charts in excel.
These tutorials will give you career-building skills that you can use to become better in making chart reports and more efficient at your job.
Topics which we will cover in our exercise are:
1) How to create Chart in Excel
2) Tips about Chart Formatting
3) Form controls
4) Interactive Charts in Excel
5) How to Design Dashboard
So go ahead and learn from the following in depth Interactive Charts in excel.
This lecture will help you to understand custom formatting with examples of Date, Large Numbers and Colors.
This lecture will help you to understand the relative and absolute referencing.
Conditional Formatting helps you to change the appearance of a cell, when cell met certain criteria or rules.
This lecture will teach you step by step how to create chart in excel.
This lecture will help you to understand the chart formatting like how to format vertical and horizontal axis. How to Change chart color. How to adjust the vertical axis units.
This lecture teaches you how to create thermometer chart in excel. A thermometer charts shows you how much of a goal has been achieved.
Pareto Analysis is a statistical technique in decision-making used for the selection of a limited number of tasks that produce significant overall effect. It uses the Pareto Principle (also known as the 80/20 rule) the idea that by doing 20% of the work you can generate 80% of the benefit of doing the entire job.
This lecture will guide you step by step how to create Pareto Chart in Excel.
In this lecture, you will learn how to create population pyramid chart in excel. Topics we will cover in this exercise are, How to create 2D Bar Chart, how to format axis labels of vertical axis and how to format font in horizontal axis.
In this lecture you will learn how to create combo box, how to write "HLookup Formula" and how to create Interactive chart with combo box.
This lecture will teaches you how to create and link check boxes with chart in excel. You will also learn how to write "IF Formula" in Excel.
In this lecture you will learn how to create Chart with Scroll bar and how to write "Index Formula" in excel.
Speedometer chart is the combination of Doughnut and Pie Chart. you will learn in this lecture how to create doughnut and Pie chart and how to combine them into single chart to create Speedometer Chart.
In this lecture you will understand the data set and KPI's(Key Performance Indicator) which we will designs in dashboard sheet.
In this lecture you will learn how to create 2D stacked bar chart with combo box.
This is the example of Column chart with secondary line chart axis.
In this lecture you will create Productwise chart and will give the final touch to the dashboard.
I am the founder of ExcelCrazy and has worked with prestigious companies like Cisco, Sapient in the past 8 years as Data Consultant. Now working as full time trainer(Excel, VBA, SAS and Tableau) and Data consultant.