Excel Visualization: Building Column Charts, Bar Charts, & Histograms

Microsoft    |    Intermediate
  • 10 videos | 1h 17m 16s
  • Includes Assessment
  • Earns a Badge
Rating 4.5 of 177 users Rating 4.5 of 177 users (177)
Data visualizations in Excel reveal the insights uncovered by your data in easy-to-consume representations. You can identify categorical values, recognize how parts sum up to a whole, see percentages rather than absolute values, discretize continuous variables, and approximate the probability density function of variables. In this course, you'll build charts to uncover all of this information. You'll start by working with column and bar charts. You'll then create and differentiate between clustered and stacked column charts. You'll move on to formatting and customizing bar and column charts before working with 2D and 3D chart types and customizing them in various ways. Lastly, you'll work with histograms, examining how they work, what they're used for, and how to customize them to your needs.

WHAT YOU WILL LEARN

  • Discover the key concepts covered in this course
    Create various kinds of clustered column charts and stacked column charts, hide a selection of rows, and hide a chart using that feature
    Use 100% stacked column charts to visualize the proportions of separate categories and visualize data using various 3d column charts
    Create a basic 3d column chart and illustrate the potential disadvantage of these charts
    Describe the difference between a column chart and a bar chart, create a clustered bar chart, and perform various operations, such as sorting on that chart
  • Customize various aspects of a bar chart, such as the axis configurations, the overlap between the bars, and the size of the bars
    Illustrate the use of many different kinds of excel bar charts, such as stacked, 100% stacked bar charts, and 3d bar charts
    Create a histogram to bin a continuous data series, visualize the counts of rows in each bin, and create histograms for normally and non-normally distributed data series
    Customize histograms using various options, such as the overflow and underflow bins to truncate the histogram on either side
    Summarize the key concepts covered in this course

IN THIS COURSE

  • 1m 50s
  • 7m 52s
  • Locked
    3.  Visualizing Data Using 3D Column Charts in Excel
    7m 33s
  • Locked
    4.  Creating Excel 3D Column Charts & Identifying Issues
    9m 20s
  • Locked
    5.  Creating and Working with Various Excel Bar Charts
    7m 43s
  • Locked
    6.  Formatting Bar Charts in Excel
    7m 19s
  • Locked
    7.  Distinguishing the Use of Various Excel Bar Charts
    12m 30s
  • Locked
    8.  Visualizing Binned Data Using Excel Histograms
    9m 45s
  • Locked
    9.  Customizing Histograms Using Various Excel Features
    11m 14s
  • Locked
    10.  Course Summary
    2m 10s

EARN A DIGITAL BADGE WHEN YOU COMPLETE THIS COURSE

Skillsoft is providing you the opportunity to earn a digital badge upon successful completion on some of our courses, which can be shared on any social network or business platform.

Digital badges are yours to keep, forever.

YOU MIGHT ALSO LIKE

Course Tableau for Data Visualization: Advanced Features
Rating 4.6 of 71 users Rating 4.6 of 71 users (71)
Course Manipulating PivotTable data in Excel 365
Rating 4.4 of 330 users Rating 4.4 of 330 users (330)
Course Excel Visualization: Building Box Plots, Sunburst Plots, Gantt Charts, & More
Rating 4.5 of 159 users Rating 4.5 of 159 users (159)

PEOPLE WHO VIEWED THIS ALSO VIEWED THESE

Course Complete Guide to Excel 365: Working With Charts & Sparklines
Rating 4.7 of 576 users Rating 4.7 of 576 users (576)
Course Using conditional formulas in Excel 365
Rating 4.3 of 364 users Rating 4.3 of 364 users (364)
Course Customer Service: Adapting to Your Customers' Cues
Rating 4.5 of 7114 users Rating 4.5 of 7114 users (7114)