Tutorials

Microsoft Excel

Excel Slicers for Tables: Filter Without the Drop-Down

https://youtube.com/shorts/PEyZhzqf75w Stop clicking tiny filter dropdowns in your Excel tables. Here's a better way to filter your data. With slicers, you get big, clickable buttons...
Microsoft Excel

How to Remove Blank Rows in Excel in Seconds

https://youtube.com/shorts/MxQWNYSnThE Blank lines can turn a clean worksheet into a cluttered mess. If you're trying to filter, sort, or build a pivot table, those gaps...
Microsoft Excel

Automatically Bold Totals in Excel (No Tables Required)

Totals should not depend on row numbers, and you definitely shouldn't be formatting them manually. When you have about 200 rows of data (and...
Microsoft Excel

Paste Special Not Working in Excel? Full Troubleshooting Guide

https://youtu.be/-GtA23bz4Y4 When Paste Special is not working in Excel stops you mid-task, it feels like Excel is just refusing to cooperate. You copied the data,...
Microsoft Excel

Excel Row Numbering: 2 Ways That Update Automatically

We need to number our rows, but we have no idea how large our data set's gonna get. That's why Excel row numbering needs...
Microsoft Excel

Quick Way to Add Leading Zeros in Excel

https://youtube.com/shorts/upVL8oU3Hzg Employee data can look perfect until you notice the ID column. You expect a six-digit ID number, but Excel shows something shorter because the...
Microsoft Excel

Design Structured Excel Models (Audit & Business-Ready)

https://youtu.be/bm9iAzs6NKY If someone were to open our Excel file today, would it be a model or a mess? A sheet can look like a regular...
Microsoft Excel

Shrink Large Excel Datasets With Pivot Tables

https://youtube.com/shorts/MmoUf3VW-js When you need to analyze last year’s sales data and it’s almost 1200, scrolling row by row doesn’t work. This is where Excel pivot...
Microsoft Excel

Audit Excel Formulas: Highlight and Review All Formula Cells

https://youtu.be/2OrC5e03uoM Inherited an Excel file and can’t easily find the formulas, and some have errors? This is how to audit excel formulas so you can...
123...11Page 1 of 11