The best kept secret of concatenating data in Excel.

How to dynamically create an expiration date control in Excel.

How to format table borders for data while typing in Excel.

How to professionally format a pivot table in Excel.

Extract data from a table dynamically using a form control in Excel.

How to create progress bars in Excel without using charts or conditional formatting.

How to make segmented partial sequences in Excel in a very simple way.

Extracting days, months, and years from a set of dates in Excel without using any functions.

How to add values ​​in the same cell separated by a delimiter in Excel

The best way to filter data in Excel is by typing any part of the text.

How to consolidate tables if you don't have the stack function or have an older version of Excel.

How to create date sequences in Excel and make them dynamic…

How to delete data only from cells that DO NOT have functions in Excel.

How to use Solver in Excel, explained like never before…

How to total values simulating a pivot table without using new functions in Excel.

How to dynamically customize formats in Excel.

How to replace the letters Ñ in Excel very quickly like no one ever taught you.

How to present data in Excel in a simple and very practical way.

How to create autofill lines to enter data in Excel.

How to delete functions from an Excel sheet without deleting the data.

How to give a super professional format to pivot tables in Excel.

How to count the number of words in a cell in Excel…

How to dynamically apply conditional formats to due date data in Excel.

What's the difference between filtering and segmenting data in Excel? Here's how.

Free Excel course: learn Excel from scratch to advanced... we'll tell you all about it.

How to insert calculated fields such as VAT and TOTAL into Excel pivot tables

How to automatically enter data between sheets in Excel.

How to use defined names in Excel, explained in one minute.

Como usar un control de formulario para crear un filtro dinámicamente en excel.

How to create a dynamic sequence in Excel when you don't have the sequence function.

How to use Solver in Excel to automatically calculate budgets.

Highlight cells in Excel like a PRO!

How to avoid embarrassment at work when you don't know how to use Excel: macros in a minute.

How to ensure that one sheet does not exceed the stock of another sheet when invoicing in Excel.

How to dynamically insert sparklines in Excel using multiple merged cells.

How to get the most out of the TEXT function in Excel in combination with custom formatting

Dynamic control performed in one minute in Excel.

A super pivot table trick, how to update automatically…

How to use conditional formats to automatically hide and show data in a table.

How to connect pivot tables with dynamic filters or data slicers in Excel.

How to filter, rank, and sort data with a single function statement in Excel.

Don't use the If function anymore when you have many conditions, do this instead.

How to create a totalized report in Excel without using pivot tables

How to distinguish between Excel's most used functions: VLOOKUP and XLOOKUP

How to use ActiveX controls in Excel explained in one minute.

The best explanation on how to use sequences in Excel, all in one minute.

Keyboard shortcuts every Excel user should know.

How to perform a search in Excel without using search functions