7 Common Excel Mistakes Almost Everyone Makes (How to Fix Them)

[@MyOnlineTrainingHub]

❓I'm curious how many of these mistakes you’re guilty of?
Master Excel & Power BI with 20% off all my courses until December 5, 2024: bit.ly/excelmistakes24courses

[@Quidisi]

You are so correct, #6 Merged Cells, are EVIL.
But #2 (inconsistent formulas in a column) are even MORE EVIL.
A few years back, against my better judgment, and to prevent circular references (because I didn't want to add a helper column) I committed sin #2, and then distributed my spreadsheet template to a wide audience. 🤦‍♂Oh boy, did I ever come to regret that stupid decision. Never again!

[@MyOnlineTrainingHub]

live and learn 😅

[@JoeMeyer8998]

Very helpful 👍

[@Jakeu1701]

To auto apply the alpha numbered list, you could make it a table and use concatenate. "A"&sequence(...

[@chrism9037]

Great video Mynda. I was guilty of the running total trap earlier in my career before learning the right way to do it😅

[@MyOnlineTrainingHub]

Yeah, me too, Chris. 😁

[@mogarrett3045]

excellent

[@jairoenriquecastilamendoza8966]

Hi, is it possible to use the sequence function in a format table ?

[@evilangel4136]

2:02 =sum(F4, E5)

[@MyOnlineTrainingHub]

Yep, you can do that too 😁

[@tanveerabbas3271]

cool❤

[@MyOnlineTrainingHub]

Thanks for watching 😁

[@rafiullah-zz1lf]

I feel like 🎩 as I know all except weekday in pivot. How skilled am I.😂

[@MyOnlineTrainingHub]

Great to hear! 💪