Video
Understanding data series
When you create a chart in Excel, you're plotting numeric data organized into one or more "data series". In this video, we'll take a closer look at data series...Read more
Search results
Looking for more? Try chatting with the Exceljet Chatbot.
Video
Chart elements and layouts
In this video, we'll look at chart elements and chart layouts. A chart layout is a specific set of chart elements arranged in a particular way...Read more
Video
How to copy and resize charts
In this video, we'll look at how to resize and copy charts, including a way to snap the chart to cells...Read more
Video
Selecting chart elements
In this video, we'll look at how to select and customize chart elements...Read more
Video
Dynamic min and max data labels
In this video, we'll look at how to dynamically highlight high and low values in an Excel chart using data labels...Read more
Video
How to plot survey data in a bar chart
In this video, we'll look at how to plot over 3000 survey responses to a question in an Excel bar chart...Read more
Video
How to use data labels
In this video, we'll cover the basics of data labels, which can be used to display data values in a chart directly...Read more
Video
How to make a histogram chart
In this video, we'll look at how to create a histogram chart. A histogram chart displays the count of items grouped into bins using columns...Read more
Video
How to make a Pareto chart
In this video, we'll look at how to create a Pareto chart. A Pareto chart plots the distribution of data in columns by frequency, sorted in descending order. ...Read more
Video
Use a throwaway chart to sanity check data
In this video, we'll look at how to use a "throwaway" chart to explore data. This is an easy way to quickly size up data...Read more
Video
Working with table rows and columns
In this video, we'll look at how to work with rows and columns to structure data in an Excel Table...Read more
Video
How Excel Table ranges work
One of the most useful features of Excel Tables is that they create a dynamic range. In this video, we'll take a closer look at how table ranges work.
...Read more
Video
How to create an Excel Table
In this video, we'll look at how to create an Excel Table from source data on a worksheet...Read more
Video
How to remove an Excel Table
In this video, we'll look at different ways to remove a table from an Excel worksheet...Read more
Video
How to copy and lock structured references
In this video, we'll look at how to copy and lock structured references in a formula. Structured references are a special syntax used by Excel Tables...Read more
Video
Structured reference syntax examples
Structured references are used to refer to Excel tables in formulas. In this video, we get into the nitty gritty with many examples.Read more
Video
Structured references inside a table
In this video, we'll look at how to use structured reference syntax inside a table...Read more
Video
Introduction to structured references
This video provides a brief introduction to structured references. Structured references are an easy way to refer to tables in Excel formulas.Read more
Video
How to use SUMIFS with an Excel Table
In this video, we'll look at how to use the SUMIFS function with an Excel table, with a side-by-side comparison without a table...Read more
Video
How to use table slicer styles
In this video, we'll look at how to use slicer styles to control the look of slicers. You can use styles to quickly change a slicer, and keep slicers consistent...Read more
Video
How to use VLOOKUP with a table
In this video, we look at how to use VLOOKUP to lookup values in an Excel Table.Read more
Video
How to add a totals row to a Table
In this video, we'll look at how to add and configure a Total Row to an Excel Table. The Total Row can automatically show summary calculations below a table...Read more
Video
How to use Calculated Columns
In this video, we'll look more closely at calculated columns in Excel Tables, a feature to automatically enter and maintain formulas...Read more
Video
Conditional formatting formula in a table
In this video we'll look at how to apply conditional formatting to a table with a formula...Read more
Video
Introduction to table styles
In this video, we'll introduce Table Styles. Table styles make it easy to save and apply table formatting...Read more
Video
How to apply a table style
In this video, we'll look at how to apply a table style. Table styles quickly change the look and feel of an Excel Table.
...Read more
Video
How to create a new table style
In this video, we'll look at how to create and modify your own custom table style...Read more
Video
How to copy a table style to another file
In this video, we'll look at how to move a custom table style into another Excel workbook...Read more
Video
How to set up a running total in a table
Setting up a running total in an Excel table is a bit tricky because it's not obvious how to use structured references. This video explores some options...Read more
Video
How to set a default custom table style
In this video, we'll look at how to make a custom table style the default table style in new workbooks...Read more