The Hidden Excel Feature That Will Save You Hours

Excel tables can save you hours of work each week. Learn powerful tips to automate tasks like updating charts, using slicers, and more!

*Download the Free Excel Workbook*

*TIP: Stay logged in for quick access to all FREE workbook downloads.*

*Get weekly email tips and be more productive.*

*Chapters:*
00:00 Most Excel users overlook this powerful tool
00:31 USE CASE #1 ✅ Coffee Chart Demo
04:04 - Add a Pivot Chart and Pivot Table
06:17 - Make the Chart look better
09:06 - Add a Timeline and Slicers
11:00 - Auto updating Chart title
13:56 - Add new data to the Chart (auto-update!)
15:04 USE CASE #2 ✅ Budget Expenses
20:32 USE CASE #3 ✅ Fantasy Sales
28:44 Instantly split data to multiple sheets!

*Watch this video next*

[launchexcel]

*Watch this video next*



*Download the Free Excel Workbook*

And you can stay logged in for quick access to future workbook downloads.

*Chapters:*
00:00 Most Excel users overlook this powerful tool
00:31 USE CASE #1 ✅ Coffee Chart Demo
04:04 - Add a Pivot Chart and Pivot Table
06:17 - Make the Chart look better
09:06 - Add a Timeline and Slicers
11:00 - Auto updating Chart title
13:56 - Add new data to the Chart (auto-update!)
15:04 USE CASE #2 ✅ Budget Expenses
20:32 USE CASE #3 ✅ Fantasy Sales
28:44 Instantly split data to multiple sheets!

[tamersalem]

Thank you for your interest in spreading knowledge and science. My greetings to you, respected person. Please provide a link to the Excel sheet to benefit from it. ❤

[JoséMoratoCarvalho]

Dear Victor
I would like you to make a video showing the one in the title, just like you did in the graphic title, but slicing a normal table (not dynamic).
I managed to do it, but it was a very complicated formula and I would like to see your solution to this problem, to see if it is simpler.
Grateful. 🤗

[SybedeJong]

Why would you make the cells 'white' when you can also hide the gridlines (View > Gridlines checkbox) ?