How to use Dynamic Arrays in Excel and other Advanced Formulas

Рет қаралды 11,716

Күн бұрын

✅ Download the free demo file and follow along here
➡️ www.simonsezit.com/advanced-f...
Welcome to our comprehensive Excel tutorial, "Manage Data Efficiently with Dynamic Array Functions and Advanced Formulas." 🚀💼 In this extensive session, we'll cover a wide array of advanced Excel topics to enhance your data management skills. Learn the ins and outs of VLOOKUP, managing duplicate lookup values, combining, and splitting text efficiently, and harnessing the power of Index and Match with multiple criteria. Dive into the world of COUNTIFS and SUMIF for precise calculations, master NESTED IF statements for complex logic, and explore the transformative capabilities of FILTER and SORT functions.
But that's not all - this tutorial goes beyond the basics. Discover the art of creating functions with LAMBDA, leverage the power of UNIQUE, SORTBY, and SEQUENCE, and delve into a myriad of other text functions. If you're using Excel 365, we'll explore the latest dynamic array functions that can revolutionize your data analysis game. Whether you're a data professional, business analyst, or just an Excel enthusiast looking to level up your skills, this tutorial is tailored for you. Join us on this journey to become an Excel master and efficiently manage your data with confidence. 💡📊
📝 Use the timestamps below to navigate to different sections of the course. If you already know one of these topics, skip ahead!
00:00:00 - Simon Sez IT Intro
00:00:46 - Advanced Formula in Excel
01:04:24 - Dynamic Array Functions in Excel
01:48:29 - New Dynamic Array Functions
✅ Download the free demo file and follow along here
➡️ www.simonsezit.com/advanced-f...
🌍 Get unlimited training with Simon Sez IT’s 170+ courses ⏩ www.simonsezit.com/courses/
🚀 Level up your skills with a free 30-day trial to our complete training library of 9,200+ videos ⏩ www.simonsezit.com/ssit-first...
💻 Watch more free popular training tutorials from Simon Sez IT:
🔥Check out our FREE 300+ hour training course playlist here ➡️
• Simon Sez IT Long Trai...
✅ Check out our free video playlist for Excel beginners 👉 • Microsoft Excel Beginn...
✅ Excel 2021 Tutorials for Intermediate Users here 👉 • Excel 2021 Tutorials f...
✅ Microsoft Excel Tips and Tricks 👉 • Microsoft Excel Tips a...
✅ Microsoft Office 2021 and Office 365 Training here 👉 • Microsoft Office 2021 ...
💬Stay in touch!
SimonSezIT.com: www.SimonSezIT.com/
LinkedIn: / simon-sez-it
FaceBook: / simonsezit
🔔 Subscribe to our channel:
kzfaq.info...
If you enjoyed the video, please give a thumbs up 👍🏽 ;-)

Пікірлер: 29

@KK-ch8yt 4 ай бұрын

Its like heaven of excel teaching

@domkboakyetv5972 4 ай бұрын

really enjoying the lesson. Thank you

@SimonSezIT 4 ай бұрын

You're very welcome!

@douglascristinelli4555 4 ай бұрын

Thanks God for simon sez It free titorial

@SimonSezIT 4 ай бұрын

That's very nice of you, thanks!

@claudemouaya5639 4 ай бұрын

From Congo thank you so much

@SimonSezIT 4 ай бұрын

Hello to you and everyone from the Congo :-)

@meevwhy3704 4 ай бұрын

Thank you!

@SimonSezIT 4 ай бұрын

You're welcome! Thanks for watching our training ;-)

@albertoalamamoran6082 2 ай бұрын

A simply and straightforward marvelous Excel trainning explained and carried on by You Mrs.Ashby, all my support to your great channel and team of work. Stay well and a great HUG from trujillo- Perú.

@SimonSezIT 2 ай бұрын

Thanks for the kind comments 🙂 Learn Microsoft Excel Tips and Tricks here ➡️ kzfaq.info/sun/PLzj7TwUeMQ3gv7nwM6ad7r5ma_3UoOPtc

@krajasekhar7604 4 ай бұрын

More useful

@SimonSezIT 4 ай бұрын

Glad you think so!

@Locomaid 4 ай бұрын

You have demystified so many things for me. Thank you!!!

@SimonSezIT 4 ай бұрын

Oh wow! That's nice of you to say that :-)

@KK-ch8yt 4 ай бұрын

Awesome....

@SimonSezIT 4 ай бұрын

Thanks 🤗

@alexrosen8762 4 ай бұрын

Great tutorial 👌

@makar55555 4 ай бұрын

Much appreciation for your efforts 🌹🌷💐

@SimonSezIT 4 ай бұрын

It's my pleasure - thanks for your feedback.

@anniesuem 4 ай бұрын

Thank you Deb Ashby!

@SimonSezIT 4 ай бұрын

You are so welcome :-)

@marijanapesut6035 3 ай бұрын

Хвала!

@SimonSezIT 3 ай бұрын

Many thanks for the support :-)

@bernabeespinoza6586 2 ай бұрын

mil gracias

@willlamers6929 3 ай бұрын

At timestamp 19:07 all of the cell references are relative. At timestamp 19:18, the reference to the lookup table in cell H11 has changed to A10:E17. The original formula in H4 should have been =VLOOKUP(B4&C4,$A$3:$E$11,4,0). The change makes the lookup table absolute, while the lookup cells stay relative.

@sv6956 4 ай бұрын

Hey, I have a question. What is the meaning of serial code in doing calculations while looking for duplicates if lookup value and lookup array is in the table itself

@sanimunir 2 ай бұрын

Plz check the download file. I tried multiple times to download via my email, but failed. My email address is correct but it does not work.

@karinanurlankyzy114 4 ай бұрын

I dont understand why when you used the asterix to find HYNH product it showed light bulb and not shower seal? that one also has HYNH in its serial name.