2015
Udemy
Lokesh Paliwal
1:44
English
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.
Section 1: Getting Started
1 Introduction
2 Working File: Download This first - 1 слайд
Section 2: Custom Formatting
3 Custom Formatting
Section 3: How to Create Chart in Excel
4 How to Create Chart in Excel
5 Chart Formatting
Section 4: Chart Formatting Excercises
6 Thermometer Chart
7 Pareto Analysis Chart
8 Population Pyramid Chart
Section 5: Interactive chart with Form Controls
9 Interactive Chart with Combobox
10 Interactive Chart with Checkboxes
11 Interactive Chart with Scroll Bar
12 Speedometer Chart with Spin Button
Section 6: Dashboard Designing
13 Dashboard Introduction
14 Dashboard Design - 2D Stacked Bar Chart with Combo boxes(Sketch 1)
15 Dashboard Design - Region wise Chart
16 Dashboard Design - Product wise Chart
Download File Size:394.22 MB