Master Excel MACROS & VBA in ONLY 1 HOUR!

preview_player
Показать описание

I am using Excel 2016 in this VBA Excel Programming & Macro tutorial but you can also apply what I teach in Excel 2010, Excel 2013, Excel 2019 and Excel Mac versions 2011 and 2016 (as well as the latest Office 365 version).

In this Excel Macro & VBA Programming tutorial for beginners you will learn how to:

👉 Record MACROS & Write VBA Code within 1 HOUR!
👉 AUTOMATE repetitive & boring tasks with a single press of a button that will SAVE YOU Time & Money!
👉 Save and share your Macros!
👉 Debug and step into your VBA code

JUMP TO AN EXCEL FORMULA & FUNCTION TUTORIAL WITHIN THIS VIDEO:

0:00:00 - Introduction
09:00 - Record a Macro
21:40 - Modify a Macro using the VBA Editor
27:30 - Save a Macro Enabled Workbook
29:30 - Insert a Worksheet & Rename it using a Macro
43:25 - Add a Macro to the Quick Access Toolbar
45:45 - How to add a Button to run a Macro
50:03 - Step into & debug your VBA code

------------

🔥 OUR BEST EXCEL RESOURCES 🔥

👨‍🏫 Get 30+ Excel & Office Courses & support for ONLY $1💵 (all levels covered)
Learn Formulas, Macros, VBA, Pivot Tables, Power Query, Power Pivot, Power BI, Charts, Financial Modeling, Dashboards, Word, PowerPoint, Outlook, Access, OneNote, Teams, Project, PowerApps, PowerAutomate, Visio, Forms & MORE!

📚 Download Our Free 101 Excel Tips & Tricks E-Book:

💻 Access 1,000+ Free Excel & Office tutorials over at our award-winning blog:

📚Get All Our 101 Excel E-Book series on Formulas, Macros & Pivot Tables:

📚101 Most Popular Excel Formulas Paperback on Amazon:

📚101 Ready To Use Excel Macros Paperback on Amazon:

📚101 Best Excel Tips & Tricks Paperback on Amazon:

👷 Excel Consulting Services:

💻 Looking for more Microsoft Excel & Office tutorials? Check out our playlist below:
------------

Feel free to comment and ask questions about this Microsoft Excel tutorial below and we will get back to you with the answer ASAP!

If you enjoyed the video, please give a thumbs up, comment, share.

Do not forget to SUBSCRIBE to this channel to get our new Microsoft Excel tutorials delivered straight to you each week! Thank You :)

Cheers,

JOHN MICHALOUDIS
Chief Inspirational Officer & Microsoft MVP

❤️ Let’s connect on social ❤️

#MyExcelOnline #MsExcel #Macros #VBA
Рекомендации по теме
Комментарии
Автор

I found this extremely Helpful. I am going for a new job and they asked if I knew macros after this session I feel confident that I can do this job to the fullest

hewalker
Автор

jump straight to 4:10 to skip the orga stuff at the beginning. Great Video. Thanks a mil.

jam-hu
Автор

Been trying to learn VBA from Youtube. Watched tons of videos but this one actually was awesome. Thank you ❤️

amirwisal
Автор

I used to hate coding before, Aftr watching this detailed explanation I started liking coding, hope I can master in VBA

DanielNelson
Автор

I think It’s not easy to simplify this, but you did it so well. Thank you very much.

Johnsiri
Автор

this is amazing thanks! I watched this video for 5min(with fast forwarding) and then went ahead to build a simple VBA macro for work! I thought it's gonna take me much longer...Awesome information, thanks!

fw
Автор

Thank you John & Kyle. It was really amazing; Mr. Kyle did an awesome introduction to Macros and VBA. God bless you both.

MuhammadImran-snlq
Автор

1st time looking into Macros. Wasn't sure which video to start with. Glad I started with the right one! Excellent work! Thank you.

TheJoshtheboss
Автор

Hi, this is a good vba Page.

I suggest these useful macros:

Workbook route in title bar
Workbook name in title bar
Highlight active cell
Highlight active row & column
Color tabs - worksheets
Uncolor tabs - worksheets
Number to letters

bankinterbankinter
Автор

the way you teach makes it so easy to understand, thank you .

davidbe
Автор

Nice introduction to macros and VBA code. I understood the coding itself but I often had trouble understanding looping. Your explanation of the "do while" looping code was easy to understand and now I feel confident I could use it in a similar circumstance. Thanks !!

jsennette
Автор

I like this so much and it's one of my best videos on youtube

diachpriscilla
Автор

Good video,  and I recommend watching at 1.25x speed.

mmmandyzhu
Автор

Hi, I went though a lot of video in you tube and found your explanation is very simplest way, Thank you Kyle.

tapansaha
Автор

Wow! one of the clearest explanations of VBA code. Thanks a lot

ugonnac
Автор

Wow, I never thought I would get excited about coding but this is really cool.

RW-tdhz
Автор

Such a simple and professional way to understand Macros, you're awesome guys. BEST Luck to you :)

osham
Автор

Nice personality, clear and professional.

massefromla
Автор

really thanks to god..i ve seen a lot video but your video i can understand very much better..really love u a lot a lot..big thumbs up from malaysia

vlogbossku
Автор

I have just found your site and this is exactly what I was looking for for sometime now. I consider myself an intermediate user of Excel but I want to improve my knowledge from a certified organisation such as yours. Please let me know if this online training offer is still in effect today. Thank you.

sml