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.In this article you will learn Data Analysis and Visualization Using Excel.

You will get course workbooks and three sample dashboards 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.

If you want to learn in detail click here

If you also want to learn Data analysis A-Z click here

### Excel Certification

You can share your certificate in the
on printed resumes, CVs, or other documents.

Shareable on

### Course Curriculum

 SECTION 1: CUSTOM AND CONDITIONAL FORMATTING Custom Formatting – Part 1 FREE 00:09:00 Custom Formatting – Part2 FREE 00:18:00 Conditional Formatting – Part 1 00:16:00 Conditional Formatting – Part2 00:14: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 SECTION 10: CALL CENTER DASHBOARD Call Center – Dashboard Understanding 00:04:00 Call CENTER DASHBOARD Section-1-Part-1 00:23:00 CALL CENTER DASHBOARD Section1-Part2 00:18:00 CALL CENTER DASHBOARD Section-2 Part-1 00:20:00 CALL CENTER DASHBOARD SECTION2-PART2 00:10:00 CALL CENTER DASHBOARD Section-3 00:11:00 FINAL FORMATTING 00:14:00 SECTION 11: PRODUCT DASHBOARD DASHBOARD INTRODUCTION 00:02:00 PRODUCT DASHBOARD Section-1-A.B-and-C 00:19:00 PRODUCT DASHBOARD Section-1-Part-2 00:14:00 PRODUCT DASHBOARD Section-2 00:07:00 PRODUCT DASHBOARD Section-3 00:06:00 FINAL FORMATTING 00:14:00

## 4.6

4.6
7 ratings
• 5 stars5
• 4 stars1
• 3 stars1
• 2 stars0
• 1 stars0
1. ### neel shrivastva

5

This is by far one of the best courses Data Analysis and Visualization Using Excel I’ve attended — even better than all the live training workshops I’ve ever attended. Comprehensive, detailed, well-paced, and digestible in bite-sized lessons. Excellent course!

2. ### Indresh bansal

5

Data Analysis and Visualization Using Excel has been very helpful for me. I never explored the excel pivot capabilities and relied mostly on other tool capabilities. With this course I could get the analysis completed faster and also share it with others much easily as many recipients already have Microsoft tools running on their systems. I am really happy and proud that I selected this course for myself and would recommend to anyone wanting to learn more about data analysis using Pivot.

3. ### nikita singh

5

This course Data Analysis and Visualization Using Excel was exactly what I was looking for on how to navigate pivot charts and tables. I look forward to taking the data visualization course in the future! I came in confident in my ability to figure anything in Excel out on my own, via google. This course showed me how wrong I was. It would have taken me a considerable amount of time to do this all on my own, and I still wouldn’t have been able to do half of what is shown in this course. I highly recommend Lokesh!!!

4. ### swapnil agrwal

3

Overall, this was a very educational course Data Analysis and Visualization Using Excel. I enjoyed it more than I expected. It was a lot for me to take in, but I think it will make more sense as I apply it to my daily work on the job.

I appreciate the easy way Lokesh explained each process and the insightful Pro-tips.

5. ### karan

5

Another good course from Lokesh Paliwal.

I really apreciate the style and clearness of Lokesh in his explanations.

The course covers many topics included best practises and really useful tips to get the best of the data visualization in Excel.

6. ### ayush pandey

5

The course Data Analysis and Visualization Using Excel is well paced and gives you the opportunity to practice the concepts covered with well designed exercises. I highly recommend to anybody who wants to increase their knowledge on excel and pivot tables.

7. ### akash singh

4

Defiantly worth recommending this course 🙂 . I had knowledge about Pivot Tables, but thanks to this course I learned a few important tricks 🙂 Thanks Lokesh,