Excel Intermediate

In this lesson, I demonstrate the power and functionality of slicers in Microsoft Excel, covering how to create and use them effectively within tables. You'll learn the difference between slicers and traditional filters, how to manage slicers for numerical and date fields, and the importance of holding down the Ctrl key for multi-select. Additionally, I provide practical examples, quick methods to delete slicers and clear filters, and compare slicers with PivotTable timelines.

In this lesson, we go through 5 methods for adding a Running Totals column to a table. I use the Quick Analysis feature, the SUM and SCAN functions as well as PivotTables towards the end to do this.

Sparklines in Excel are miniature charts. Sparklines are great when you need to show fluctuation or trends since they give you a visual representation of your data. I have five tips for using Sparklines. Sparklines are located on the Insert tab and have their own group, called Sparklines. There are three commands for sparklines - Line, Column, and Win/Loss.

In this lesson, I demonstrate how to generate random data using Microsoft Excel's online template feature, available with an M365 subscription. I'll guide you through starting Excel, navigating to the random data generator, and selecting the types of information you want to create. Then, we'll generate 1,000 random records and show how to copy this data to a new worksheet.

In this lesson I demonstrate how to import data from a web page, transform and format it for excel.

In this lesson I demonstrate how to add a blank row after every row, by sorting data using a helper column.

When you download data from a credit card company or bank, they frequently put positive and negative numbers in the same column. I like to have the numbers separated into two columns. You can achieve this in multiple ways. I'll use sorting, conditional formatting, and an IF Function. We will also use the COUNTIF function to determine how many negative and positive numbers we have. I'll also show Find and Replace (CTRL + H) to change the cell reference quickly.

In this lesson, I demonstrate two dynamic methods to separate date and time in Excel. Learn how to use the Integer function and PowerQuery to split date/time values efficiently. Perfect for analyzing data trends like popular class times! In this lesson I show you how to use the Integer function to extract date and time separately, create a PivotTable to analyze popular class times, utilize PowerQuery for a more dynamic approach, and refresh data automatically with PowerQuery.

In this lesson, I demonstrate multiple ways to remove duplicates using Excel. We start with a simple list of customer numbers and use Conditional Formatting to highlight duplicate values. Next, I show how to use the UNIQUE function to list unique values, followed by the method to actually remove duplicates with Excel's built-in feature. For a more complex scenario, I use the CONCATENATE function and helper columns to manage duplicate customer names and numbers, including using COUNTIF for advanced duplicates detection.

In this lesson, I demonstrate how to remove duplicate records in Excel while keeping the most recent entries based on the invoice date. I'll walk you through an example where we sort data by customer number and invoice date, and then use the 'Remove Duplicates' feature effectively. This technique ensures that only the most recent purchase records are retained, making data management easier.

In this video, I demonstrate three effective ways to find unique values from multiple columns in Microsoft Excel. Here's what I cover: I walk you through using the UNIQUE function, creating a PivotTable with a special trick, and utilizing the Remove Duplicates feature. Using a sample dataset of training class sign-ups, I show how each method can help you identify unique combinations of class names and dates.

I also share a cool PivotTable trick using the "Add This Data to the Data Model" option, which allows for distinct count calculations - a feature you might not have seen before!