Complete Guide to Excel 365: Working With Charts & Sparklines

Excel    |    Beginner
  • 11 videos | 1h 16m 44s
  • Includes Assessment
  • Earns a Badge
Rating 4.7 of 576 users Rating 4.7 of 576 users (576)
One of the primary purposes of using Excel is to analyze and present data in a focused, accessible, and accurate way. A great way to do this is with charts and sparklines. In this course, you'll create basic chart types, such as line, bar, and pie charts, as well as more advanced charts, like treemaps and sunburst charts. In doing this, you'll work with the different aspects of Excel's chart customization capabilities, from chart element transparency to the orientation and exploding out of slices in a pie chart. Next, you'll advance to use more statistically-oriented chart types, including histograms, scatter plots, and box-and-whisker plots. Finally, you'll learn to create, customize, and work with Excel's sparklines, which are lightweight visualizations usually contained within a single cell.

WHAT YOU WILL LEARN

  • Discover the key concepts covered in this course
    Insert charts and customize chart elements, such as the axes, title, data labels, data callouts, and grid lines, and add analytical elements based on standard deviation, percentage, and standard error, such as trendlines and error bars
    Use the chart design item from the toolbar ribbon to change chart layout and color, switch rows and columns, change selected data and chart type, and control whether #n/as and empty cells are displayed as gaps or zeros
    Create charts that occupy an entire worksheet and control their appearance using worksheet functions, plot pie charts and alter transparency, glow, and other visual aspects, explode and re-orient sections of pie charts, and work with treemaps and sunburst charts
    Use histograms to summarize the statistical properties of data, bin data by category, bin width, or fixed number of bins, perform automatic binning, and set overflow and underflow bins
    Perform univariate eda (exploratory data analysis), use box-and-whisker plots to plot the mean, median, inter-quartile range and outliers, and choose between inclusive and exclusive median methods in quartile calculation
  • Perform bivariate eda (exploratory data analysis), use scatter plots to examine relationships between two numeric data columns and the chart design menu to create linear, exponential, and other types of trendlines, and identify positively and negatively trending data
    Plot geographical data such as countries, states, counties, or postal codes using the map chart type, use other chart types such 2-d and 3-d column and area charts, and combine multiple visualizations into a single chart using a combo chart type
    Construct at-a-glance visualizations using sparklines to build lightweight charts without axes or units contained within individual cells, and use named ranges to control data displayed in a sparkline visualization
    Contrast line and column sparklines, control the appearance of high, low, and negative points, apply custom formatting to first and last points, display data in reverse order, and use the quick access toolbar to view undoable actions
    Summarize the key concepts covered in this course

IN THIS COURSE

  • 2m 18s
  • 6m 49s
    To insert charts and customize chart elements:1. Select the data you want to use to create the chart.2. Click the Insert tab, and then click the Chart button.3. In the Chart Type dialog box, click the type of chart you want to create, and then click OK.4. To customize chart elements, such as the axes, title, data labels, data callouts, and grid lines:a. Click the chart element that you want to change.b. On the Format tab, in the Current Selection group, click Format Selection.c. In the Format Chart Area dialog box, make the changes that you want, and then click Close FREE ACCESS
  • Locked
    3.  Customizing Chart Appearance
    9m 55s
    Find out how to use the chart design item from the toolbar ribbon to change chart layout and color, switch rows and columns, change selected data and chart type, and control whether #N/As and empty cells are displayed as gaps or zeros. FREE ACCESS
  • Locked
    4.  Creating Treemaps and Pie and Sunburst Charts
    7m 39s
    In this video, find out how to create charts that occupy an entire worksheet and control their appearance using worksheet functions. You will also learn how to plot pie charts and alter transparency, glow, and other visual aspects. Additionally, you will learn how to explode and re-orient sections of pie charts, and work with treemaps and sunburst charts. FREE ACCESS
  • Locked
    5.  Creating Histograms
    10m 23s
    In this video, you will use histograms to summarize the statistical properties of data, bin data by category, bin width, or fixed number of bins, perform automatic binning, and set overflow and underflow bins. FREE ACCESS
  • Locked
    6.  Using Box-and-Whisker Plots
    9m 9s
    In this video, find out how to perform univariate EDA (exploratory data analysis), use box-and-whisker plots to plot the mean, median, inter-quartile range, and outliers, and choose between inclusive and exclusive median methods in quartile calculation. FREE ACCESS
  • Locked
    7.  Analyzing Scatter Plots
    6m 36s
    In this video, you will perform bivariate EDA (exploratory data analysis), use scatter plots to examine relationships between two numeric data columns, create linear, exponential, and other types of trendlines using the Chart Design menu, and identify positively and negatively trending data. FREE ACCESS
  • Locked
    8.  Plotting Maps and Combo Charts
    5m 4s
    In this video, you will learn how to plot geographical data such as countries, states, counties, or postal codes using the Map chart type, as well as other chart types such 2-D and 3-D column and area charts. You will also learn how to combine multiple visualizations into a single chart using a combo chart type. FREE ACCESS
  • Locked
    9.  Creating Sparklines
    8m 34s
    In this video, you will construct visualizations using sparklines to build lightweight charts without axes or units contained within individual cells, and use named ranges to control data displayed in a sparkline visualization. FREE ACCESS
  • Locked
    10.  Customizing Sparklines
    8m 44s
    In this video, you will contrast Line and Column sparklines, control the appearance of high, low, and negative points, apply custom formatting to first and last points, display data in reverse order, and use the Quick Access Toolbar to view undoable actions. FREE ACCESS
  • Locked
    11.  Course Summary
    1m 34s

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

Rating 4.5 of 2242 users Rating 4.5 of 2242 users (2242)
Rating 4.5 of 271 users Rating 4.5 of 271 users (271)
Rating 4.6 of 416 users Rating 4.6 of 416 users (416)

PEOPLE WHO VIEWED THIS ALSO VIEWED THESE

Rating 4.4 of 6009 users Rating 4.4 of 6009 users (6009)
Rating 4.6 of 104 users Rating 4.6 of 104 users (104)
Rating 4.5 of 250 users Rating 4.5 of 250 users (250)