Exceljet

Quick, clean, and to the point

Excel Training videos

These videos come from our accelerated video training.
Tip: Use a throwaway chart to sanity check data
In most cases, you'll want to take time to build clean, uncluttered charts that are easy to read. However, a quick, messy chart is a great way to "sanity check" unfamiliar...
Run time: 2:51
Tip: How to use data labels in a chart
Excel charts have a flexible system to display values called "data labels". Data labels are a classic example a "simple" Excel feature with a huge range of options just...
Run time: 2:42
Tip: Dynamic min and max with data labels
The data labels in Excel charts are flexible and powerful. While you can easily use them to display values from source data, you can also display values from other cells. The video below...
Run time: 3:14
Tip: How to build a column chart
The video below shows how to make a basic column chart in Excel, and how you can use custom number formats with data labels to quickly streamline a chart. If you're not sure which...
Run time: 3:21
Tip: How to chart generations with floating bars
In this video, we show how to plot American generations in a floating horizontal bar chart. This seems like a simple problem, but it requires a formula, clever formatting, and a special...
Run time: 3:37
Tip: How to randomly assign people to teams
In this video, we look at a step by step approach to randomly assign people to groups with teams using formulas. Along the way, we use three functions (RAND, RANK, and CEILING), helper...
Run time: 3:49
Tip: Excel formula errors and fixes
In this video, we show examples of the 8 Excel formula errors you're likely to run into, and simple steps you can take to fix them. We look at #NAME?, #DIV/0!, #NUM!, #NULL!, #NA, #...
Run time: 4:22
Tip: How to build a simple dynamic chart
In this video, we look at how to build a chart that automatically includes new data, and dynamically highlights the top and bottom values. This is an easy way to create an interactive chart...
Run time: 3:56
Tip: How to use the CHOOSE function
In this video, we'll look at how you can use the CHOOSE function for simple lookups. The CHOOSE function doesn't need an external table, and can sometimes replace more complicated...
Run time: 3:41
Tip: How to generate random values
In this video, we'll look at a few ways to generate random values with the RANDBETWEEN function. You can use this approach to generate random numbers, random prices, random dates, and...
Run time: 3:39
Tip: How to copy a pivot table without the data
When you copy and paste a pivot table, a hidden data cache still remains. This video shows a simple way to copy a pivot table without the source data, while preserving all formatting.
Run time: 2:45
Tip: How to group a pivot table with custom buckets
Pivot tables are awesome tools for grouping data, and they do a lot of grouping automatically. But pivot tables also let you group data into your own custom buckets, which is great for...
Run time: 2:45
Tip: Calculate due dates with the WORKDAY function
This video show how to calculate due dates with the WORKDAY and WORKDAY.INTL functions. You can use WORKDAY to calculate intelligent ship dates, delivery dates, and completion dates that...
Run time: 3:40
Tip: How to plot survey data in a bar chart
In this video, we demo how to plot results from a survey question in an Excel bar chart. Along the way, we use the COUNTIF function to build a summary table, and show a simple technique for...
Run time: 3:42
Tip: Shade groups of rows with conditional formatting
In this video, we'll look at how to use conditional formatting to shade alternating groups of rows. For example, you can use this approach to shade groups of 3 rows, groups of 4 rows,...
Run time: 3:01

Pages

Thanks for the website - great resource and find emails of tips/hints really handy. -Jasmit
Excel foundational video course
Excel Pivot Table video training course
Excel formulas and functions video training course
Excel Shortcuts Video Course
Excel Charts video training course