🚨 Time is Running Out: Reserve Your Spot in the Lucky Draw & Claim Rewards! START NOW
watching now
3 Students

Description

What Will You Learn?

  • How to create 25+ chart types in Excel, including the newly introduced ones
  • How to communicate a clear message through your charts
  • How to use powerful tools (such as pivot tables)

Requirements

  • A personal computer
  • MS Excel (any version)
  • Basic understanding of Excel operations
  • NFT Certificate
  • 31 Lessons
  • Beginner
  • English
  • +100 XP

Share Course on Social media

Curriculum

Course consist of total 3h 56min of content, in total.

Section 2: Most important Charts & Best practices
2:28:30
Bar and column charts
12:38
Formatting charts
15:13
Best Practices Bar Chart
10:07
Line Charts
09:05
Avoiding the Spaghetti plot
05:28
Area Charts
06:04
Pie and Doughnut Charts
13:05
Why we should avoid Pie charts
04:06
Scatter plot or XY chart
16:17
Frequency Distribution and Histograms
13:03
Waterfall chart
12:01
Hierarchy Charts Sunburst and Treemap
07:57
Combination charts
07:32
Highlighting chart message
03:25
Eliminating Distractions from the Graph
06:54
Avoiding clutter
05:35
Section 3: Pivot charts
16:13
Pivot Charts
07:48
Pivot Table Basics
08:25
Section 4: Less used charts
26:30
Stock charts
11:28
Radar charts
04:52
Surface charts
05:15
Heatmaps
04:55
Section 5: Sparklines
05:44
Mini charts Sparklines
05:44
Section 6: Infographics using Excel charts
21:05
Creative Infographic 1
14:13
Creative Infographic 2
06:52

About the Instructor

Working as a Project manager in an Analytics consulting firm, Pukhraj has multiple years of experience working on analytics tools and software. He is competent in MS office suites, Cloud computing, SQL, Tableau, SAS, Google analytics, and Python.

Abhishek worked as an Acquisition Process owner in a leading telecom company before moving on to learning and teaching technologies like Machine Learning and Artificial Intelligence.

See All Instructor Courses

BitDegree platform reviews