How to Create Complex Macros in Excel

In this Macros tutorial, we look at how to create more complex Macros in Excel.
Recording complex Macros starts with how to save your files as Macro enabled workbooks, we then show you multiple steps to sort data with numerous handy functions.
Have Macros complete repetitive tasks in Excel for you in no time.
🌍 Get unlimited training with Simon Sez IT’s 150+ courses ⏩ www.simonsezit.com/courses/
🚀 Level up your skills with a free 30-day trial to our complete training library of 8,500+ 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 2019 T...
✅ Pivot Table Tutorials for Beginners here 👉 • How to Use Microsoft E...
✅ Microsoft Teams playlist 👉 • Microsoft Teams Tutori...
✅ 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:
kzbin.info...
If you enjoyed the video, please give a thumbs up 👍🏽 ;-)

[@SimonSezIT]

We have additional free Microsoft Excel training here 👉 kzbin.info/aero/PLzj7TwUeMQ3gv7nwM6ad7r5ma_3UoOPtc & here 👉 kzbin.info/aero/PLzj7TwUeMQ3g6U7Mwyy7G9Gwh-k2yNtfI & Top 10 Excel Functions Training 👉 kzbin.info/aero/PLzj7TwUeMQ3isgpmQEWFwWqFZ95Ih-AhA 🔥 Check out our FREE 300+ hour training course playlist here ➡ kzbin.info/aero/PLzj7TwUeMQ3hsADWJd2sJh4o8jATTyaRU

[@kenneththurman4273]

Is there a benefit of using this vs copying and pasting? What’s the difference?

[@zoomingby]

Thanks for this! Not to nitpick, but at 4:55 you should provide some details on how to use the shift key to assign shortcuts. I was pressing ctrl + shift and that didn't work. You only press shift plus the desired letter which is extremely counterintuitive and I had to google how to actually do it.

[@darrylmorgan]

Really Nice Tutorial...Thank You Deb :)

[@SimonSezIT]

You're welcome 😊

[@accountingempire4525]

That was an amazing video . I have been struggling to understand the difference between relative and absolute referencing

[@SimonSezIT]

Glad it was helpful!

[@hello-ge7cw]

nice video,i havent even watched it

[@SimonSezIT]

I hope you do and you like it!

[@praveenthakur122]

fooled us

[@salimtheone]

This is not a good example to explain macros.