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
1204 STUDENTS ENROLLED

Testimonials

After spending over 2 years in the field of market research, I realized that my career was stuck. So, I decided to join Lokesh Paliwal’s Data Analysis program. Now I am working with one of the MNC...Read more

Excel Trainer in Gurgaon

Aishwarya

Analyst

Recent Posts

Tableau Training in Delhi  

2012 - 2018

LOKESH@EXCELCRAZY[DOT]COM

Excel Crazy Analytics Services. All rights reserved.

NM 23, OLD DLF COLONY, SECTOR 14, GURUGRAM (DELHI - NCR) 8826547882

Drop us a Query

Call Us: +91 8826547882

Drop us a Query