Видео

In this video, we'll look at how to get a unique count in a pivot table. Pivot tables are excellent tools for counting and summing data, but you might struggle to get a unique or distinct count, because this feature is hidden in a normal pivot table. exceljet.net/tips/how-to-add-unique-count-to-a-pivot-table

Pivot Tables make it incredibly easy to analyze data quickly without formulas. In the example, we use a pivot table to summarize product sales by product, then assign a rank to each product in the list. This is something you can do in less than a minute. exceljet.net/tips/how-to-rank-with-a-pivot-table

Calculating a running total in an Excel table is a little tricky, because it's not obvious how to build the formula with structured references. You can easily get the current row with the @ notation, but what about the first row in a column? You might be surprised that you can use INDEX for this. Comments at: exceljet.net/tips/how-to-create-a-running-total-in-a-table

In this video, we show to use the MATCH function inside VLOOKUP to generate a dynamic column index. This makes it easy to refer to columns inside VLOOKUP. As a bonus, you can reorder the columns and the formula will keep working correctly. Comments at: exceljet.net/tips/how-to-use-vlookup-with-an-excel-table

In the video, we build one set of SUMIFS formulas with a table, and one set without. This makes it really easy to see the nice benefits you get when you combine tables and formulas. Comments at: exceljet.net/tips/how-to-use-sumifs-with-a-table

Because tables support structured references, you can learn a lot about a table with basic formulas. In this video, we run through about a dozen examples. It's a nice demo of how formulas and tables work together to save you time. Comments at: exceljet.net/tips/how-to-query-a-table-with-formulas

In this video gives a brief introduction to structured references. Structured references is just a fancy name for formulas that use table names instead of normal cell references. This sounds boring, but it's actually cool and useful. Comments at: exceljet.net/tips/introduction-to-structured-references-and-tables

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 data. A chart can show you patterns and outliers almost instantly. It can even show when data has been faked. Best of all, you get all of this with almost no effort. Comments at: exceljet.net/tips/use-a-throwaway-chart-to-san...

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 below the surface. This video provides a general introduction and shows many of the options available to customize the display of data labels in an Excel chart. Comments at: exceljet.net/tips/how-to-use-data-labels-in-a-chart

In this video, we look at how to highlight high and low values in an Excel chart using data labels and formulas. The result is a simple solution that always displays the min and max values dynamically as values change. Comments at: exceljet.net/tips/dynamic-min-and-max-with-data-labels

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 chart type to choose, try a column or bar chart first. These simple charts are extremely easy to read. Comments at: exceljet.net/tips/how-to-build-a-column-chart

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 feature of data labels. A nice example of what can be done with Excel's charting engine. Comments at: exceljet.net/tips/how-to-chart-generations-with-floating-bars

In this video, we look at a step by step approach to randomly assign people to groups with formulas. Along the way, we use three functions (RAND, RANK, and CEILING), helper columns, and nesting. We use COUNTIF to verify results. Comments at: exceljet.net/tips/how-to-randomly-assign-people-to-teams

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. Comments at: exceljet.net/tips/excel-formula-errors-and-fixes

How to build a simple dynamic chart

How to use the CHOOSE function

How to generate random values

How to copy a pivot table without the data

How to group a pivot table manually

Calculate due dates with the WORKDAY function

Build friendly messages with concatenation

How to plot survey data in a bar chart

Shade groups of rows with conditional formatting

Shortcut Recipe Remove Blank Rows

How to highlight approximate match lookups

30 Excel Shortcuts in 12 minutes

Two-way lookup with INDEX and MATCH approximate

How to highlight exact match lookups

Simplified formula example 401k Match