The Excel Trick I Use EVERY DAY (and you should too!)

One overlooked Excel feature that will change how you work with data forever.

I'm about to show you how one overlooked tool can transform the way you work with data. It's not a complex formula or a hidden setting - it's something so fundamental, you'll be shocked you haven't been using it all along.

LEARN MORE
===========



#Excel #ExcelTrick #ExcelTutorial

[MyOnlineTrainingHub]

❓What Excel feature do you use daily that others might be missing out on?

[bjbrooks]

Excellent romp through the capabilities of tables. But what I must comment on is the sheer quality of the video presentation. The content, the text, the pace, the examples, the fluent delivery, the highlighting, all perfect. Awesome, using the word in its proper sense. Thank you 🙂

[kgadeberg]

I have been using tables for years and can now hardly enter a single value in Excel without turning it into a table 🙂 I think my favourite benefit is the ability to reference cells using the structured formulas but also find the filtering very useful (right-click any cell and use 'Filter by Selected Cell's value' is one I use all the time)

[lewesmariner]

For Tables, I use keyboard shortcuts CTRL and full stop/period to cycle through the four corners of the Table (good for getting to the bottom of a large Table).
Also CTRL and spacebar to select the Table column you are in (excluding heading - repeat to include heading) - great shortcut for functions such as SUM and SUMIFS

[msmith]

Great look at tables and their value!
I didn't learn about tables until I started studying Power Query a few years ago. Once I realized how useful they are, I started incorporating them into my workflows.

[bjornkumpf]

I love the way you explain ... precise, unagitated, without gimmickry (Ich liebe es, wie Sie erklären ... präzise, unaufgeregt, ohne Effekthascherei)

[DrDamoStrikesBack]

I've been using tables for years and can't live with out them. I literally use them many times a day. The default behaviour of copying formulae down when adding rows is amazing. Structured referencing is also a boon for any non-trivial work. Lookups and aggregation that refer to a table (or its component columns) as named objects saves significant time and prevents the possibility ranging errors when expanding the table. Also, tables are fantastic as a data source for pivot tables—hugely useful.

[traciesmobile]

Named tables are great. They make formulae so much easier.

[jokearney]

Tables are a complete game-changer in being able to safely and accurately update a table of data, and the pivots and graphs that feed off it. So great!

[humansizedaperture]

EVERYTIME THE ANSWER IS TABLES An Angel gets their wings. Also, I will be using filters on my table tomorrow. Thank you so so much for the tip. I’m always clicking filters.

[chahineatallah]

Yes agreed, tables are great, I use them mainly due to auto update in pivot tables without changing data source to include new data and for fixed headings without need for freeze

[lewerim]

I use Tables for almost EVERYTHING!
My favorite feature is that I reference column header values in formulas and VBA. And when (not if, right?) those names change the formulas update on their own.

[hadiuzzaman]

I really learned something new. Thanks a ton. 😊

[chrism]

Thanks Mynda, they're pretty much all I use since I use Power Query everyday!

[stephenyounger]

Really terrific video, I had no ideas tables were so easy to use and so powerful. Kicking myself for hours spent updating old spreadsheets. Thank you

[Tooxcade]

Short and Sweet explanation. Thank you so Much

[brianmills]

Frankly, it's hard to imagine working without tables now. They save time, reduce errors, simplify formula writing (after investing a little time in understanding structured formulas), and more. Thanks for beating the drum a bit more on this unbelievably powerful tool.

[babydadoo]

Love this content! A few months back I was blown away when looking at a coworkers code which used tables to easily manipulate data in VBA, and will be looking at more options to use them in my work go forward

[apeel]

YouTube showed me your channel as I often watch other excel tutorials. I learned a LOT. Thank you! I am now a subscriber and look forward to more of your content.

[leerv.]

Pick just one of my favorite Table features? That's really REALLY hard, Mynda! I would have to say I enjoy table references the most! Who wants to try to explain =IF(AA5*AQ5>AK5, etc....) to a peer (or yourself, when you look back at an old sheet) when it could read ?