This course will help you to create dynamic, interactive charts in excel. In each exercise, you will learn techniques to create customized charts in excel.

You will get course workbooks and three sample dashboard to do practice in this course.

These tutorials will give you career-building skills that you can use to become better in Data analysis and Visualization using Excel.

Topics which we will cover in our exercise are:

1) Custom and Conditional Formatting, Advanced Excel Formulas

2) Charts and Custom Charting

3) Excel Pivot Tables

4) Advanced Excel Formulas

5) Interactive Charts

6) Excel Dashboard Designing: Sales, Product and Call Center Dashboard

So go ahead and learn from the following in-depth Data Analysis and Excel Dashboarding.

Course Curriculum

SECTION 1: CUSTOM AND CONDITIONAL FORMATTING
Custom Formatting – Part 1FREE 00:09:00
Custom Formatting – Part2FREE 00:15:00
Conditional Formatting – Part 1 00:16:00
Conditional Formatting – Part2 00:16:00
SECTION 2: FORMULAS AND FUNCTION
Dollar Use and IF Formula 00:11:00
Data Validation 00:18:00
SECTION 3: WHAT IF ANALYSIS AND GOLA SEEK
Goal Seek in Excel 00:04:00
SECTION 4: ADVANCED FUNCTIONS
Text Functions in Excel 00:09:00
VLOOKUP and HLOOKUP Formulas 00:07:00
Offset, Index and Match Formulas 00:08:00
SECTION 5: PIVOT TABLES
Pivot Table Designing 00:11:00
Pivot Table Designing Part2 00:16:00
Pivot Table-Part 2 (Show Values As and Group By) 00:16:00
Calculated Fields 00:15:00
Pivot Charts 00:11:00
Pivot Slicer and Dashboard 00:17:00
SECTION 6: CHARTING
Chart Creation in Excel 00:08:00
SECTION 7: CUSTOM CHARTS
Custom Indicators in Excel Charts 00:09:00
Bullet Graph in Excel 00:12:00
Step Chart in Excel 00:07:00
Pareto Chart in Excel 00:10:00
Waterfall Chart in Excel 00:06:00
Progress Chart in Excel 00:06:00
Bump Chart in Excel 00:17:00
SECTION 8: INTERCATIVE CHARTS
Name Ranges in Excel 00:07:00
Interactive Chart Using Combobox 00:06:00
Interactive Chart Using Radio Button 00:16:00
SECTION 9: DASHBOARDING
SALES DASHBOARD: Introduction 00:03:00
Sales Dashboard: Section1 Introduction 00:05:00
Sales Dashboard: Section 1 00:21:00
Sales Dashboard: Section2 00:17:00
Sales Dashboard: Section3 00:17:00
Sales Dashboard: Section 4 00:00:00
Sales Dashboard: Section 5 00:16:00
Sales Dashboard: Final Formatting 00:12:00
1209 STUDENTS ENROLLED

Testimonials

The experience has been great! I was only halfway through my Full Stack Data Analyst program when I bagged an opportunity at one of the leading MNC.

Karan Jeena

Karan Jeena (HR Analyst)

ZS Associates

Recent Posts

Tableau Training in Delhi

All Rights Reserved. EC Analytics Consulting 2014 - 2019.

NM 23, Sector 14, OLD DLF Colony - Gurgaon (Haryana) India. 9582876837 | Privacy Policy

Drop us a Query

Call Us: +91 8826547882

Drop us a Query