Excel 2019 VBA Full Course Tutorial (7+ Hours)

Excel 2019 VBA Full Course Tutorial (7+ Hours)

Learnit Training

1 год назад

351,551 Просмотров

Ссылки и html тэги не поддерживаются


Комментарии:

Loulou gasté
Loulou gasté - 10.09.2023 07:28

Hello, Thanks for this video! where can we dowlnoad the powerpoint please?

Ответить
Abiona Oluwasegun
Abiona Oluwasegun - 28.08.2023 11:20

Hello Trish, I love this tutorial. I must say, its the best so far. And I really enjoy it. Pls, kindly drop the link to the power point slide for download. I couldn't find any link to that here in the description.

Ответить
blazerelf
blazerelf - 17.08.2023 00:34

really helpfull; althought I feel it skipped explaining some really important concepts like what are classes, objects and methods in more detail and how to know which to use when

Ответить
Thea Webster
Thea Webster - 23.07.2023 18:52

Good stuff ! Had to run it at 1.25x speed, because I had programming experience and could skip some parts.

Ответить
PRANEETH CHAVVA
PRANEETH CHAVVA - 22.07.2023 15:47

Thanks!

Ответить
Yanwei Deng
Yanwei Deng - 21.07.2023 07:45

This is a very detailed and helpful course. Thank you very much! I am not able to find the slides in the course description, could you share a link to downloading the slides?

Ответить
Zhiwen Chen
Zhiwen Chen - 05.07.2023 21:42

It is a great tutorial

Ответить
Luis Sanchez
Luis Sanchez - 02.07.2023 00:59

Excellent Course

Ответить
Lovekesh Mangla
Lovekesh Mangla - 29.06.2023 12:05

the instructor has very defined teaching skills. Appreciations and thankings.

Ответить
Vivienne Smithdorf
Vivienne Smithdorf - 23.06.2023 17:20

A BRILLIANT video! Thank you!

Ответить
Axel Lara
Axel Lara - 15.06.2023 23:50

I'm starting into coding and this is a good video to start with. Thanks for putting this together!

Is the PDF still available for rookies like me?

Ответить
allan lopez
allan lopez - 14.06.2023 17:40

it's difficult to understand. yes it can automate work but there's many process too many code to many syntax

Ответить
Muhammad Irfan
Muhammad Irfan - 05.06.2023 12:56

great series to learn VBA, i found it very helpful

Ответить
Russel Gall
Russel Gall - 31.05.2023 21:38

I loved Trish's Class, just one problem. She keeps saying that her Powerpoint was included, but I can't find it anywhere. I did get the Powerpoint from Chelsea that she did, both from her class and Trish's class. Please help!

Ответить
Jaiprakash Jaiswal
Jaiprakash Jaiswal - 01.05.2023 13:45

Sales-fiscal year.xlsx file not opening

Ответить
Jaiprakash Jaiswal
Jaiprakash Jaiswal - 01.05.2023 08:58

Fix Vehicles.xlsm closes or become unresponsive when trying to change G column formatting to Accounting/Currency

Ответить
ProductsEveryday
ProductsEveryday - 28.04.2023 09:14

can anyone give me the exercise files? I can't get access to it, showing an error!

Ответить
Usman Ghani
Usman Ghani - 25.04.2023 06:16

Thank you very much, U'r super teacher because u made it easy and simple

Ответить
Kyle Dalton
Kyle Dalton - 17.04.2023 05:26

You are an outstanding instructor. That is so appreciated and so valuable. Thank you, Thank you.

Ответить
Alejandro Minder
Alejandro Minder - 15.04.2023 15:33

It is a good introduction for absolute beginners because you explain every step in detail. But working with Activate, ActiveCell, Select, Selection, Copy and Paste is very inefficient. You could get or set values directly to an object like VinNumber = shNewVehicles.Range("A2").Value or shNewVehicles.Range("A1").Value = "VIN". No need to activate or select the range, just get or set the value.

Ответить
AVENDRA AMBATI
AVENDRA AMBATI - 08.04.2023 21:05

Excellent presentation

Ответить
GYUTAE KIM
GYUTAE KIM - 02.04.2023 04:38

The link to exercise files does not work... 😅

Ответить
Ikarus
Ikarus - 01.04.2023 15:25

Is excel 2016 able to do the same things?

Ответить
Kishan Thacker
Kishan Thacker - 31.03.2023 08:58

slides not available in description

Ответить
Israel OGOU
Israel OGOU - 29.03.2023 15:26

I have just started this course. I can say this is the best content on this subject I have ever encountered. That is very well explained and it motivates to continue.

Ответить
Waleed Kasem
Waleed Kasem - 28.03.2023 23:21

God bless you for this detailed and perfect illustration.

Ответить
Johnavon Joseph Jin
Johnavon Joseph Jin - 27.03.2023 12:21

For the first exercise GetNewVehicles, I tried to copy and paste the values as instructed, but after saving the macro and running it, it opens the Received vehicles file and asks me if I want to save this copy of the file, then after I click ok, the macro continues to run but nothing is pasted. I use MacOS. Would like some help.

Ответить
Luyue Cui
Luyue Cui - 04.03.2023 15:37

I'm unable to follow the course because I use a Mackbook..... I'm sooo sad

Ответить
SGH 2018
SGH 2018 - 04.03.2023 12:19

Dear Guys ! You put so much usefull stuff in here !! Awsome tutorial for someone who has some basic knowledge and wants to move up quickly . Please do more videos !

Ответить
Sajjad Khan
Sajjad Khan - 03.03.2023 20:54

Very informative.. I love to learn VBA from this video.

Ответить
Asim Imdad
Asim Imdad - 01.03.2023 20:04

very useful. plz share link to download PPT used in lecture

Ответить
YM CA
YM CA - 27.02.2023 00:08

You are amazing. This session is better than any other books or Tutorial I have seen!

Ответить
Quý Nguyễn
Quý Nguyễn - 26.02.2023 13:43

I am not a native language english speaker and totally a beginner with VBA but I will try as hard as possible to can apply VBA in my work.Thank so much for this Great Video.

Ответить
Memets
Memets - 16.02.2023 15:44

Thank you so much for the detailed module. I have learned a lot from it.

Ответить
Makarand Pingle
Makarand Pingle - 13.02.2023 17:34

Thanks a lot god bless you,👍

Ответить
makeuplily
makeuplily - 10.02.2023 04:55

THANK YOU for being very detailed, Trish! I am a total beginner and have watched other great videos from other channels but none have shared full details into each part, as you have successfully done so. I am between jobs, and the new opportunities I am interested in require VBA expertise. Thank you for making this available at a free cost (unemployed), blessings to you always!

Ответить
Timetriad
Timetriad - 01.02.2023 00:50

👍🏻 By far the best I’ve seen! I’ve learned more in less than 2 hours than I did with LinkedIn Learning. 👍🏻 Kudo’s to you Trish. I hope to learn more from you… now back to the course. 😎

Ответить
Zpinoza
Zpinoza - 30.01.2023 22:55

Yes, thank you very much for making a instruction video that makes me actually stay to the end.

Ответить
Mahlon Kalunga
Mahlon Kalunga - 30.01.2023 20:42

I cannot find the slides used in the video.

Ответить
Terrie Mtunami
Terrie Mtunami - 23.01.2023 21:21

Thank you for the stuff, My code ended with this error, how to debug this

Error msg
"object doesn't support property or method"

I click debug it highlighted this

Set PvtTable = WorkSheets("Reports").PivotTable("SalesPivot")

Using Excel 2016

Ответить
Milot X
Milot X - 13.01.2023 21:56

thank u so much you giving something very valuble for free god bless you

Ответить
Isidro Orta
Isidro Orta - 04.01.2023 23:43

hola, no lo tienes en español?

Ответить
Chow Trump
Chow Trump - 02.01.2023 17:11

No need for Excel. My indian boss do all the calculations in his head in milli secs

Ответить
ricban1950
ricban1950 - 23.12.2022 12:59

I've been writing VBA macros since Excel 2003 or earlier without problems. However when I added Office 2019 to a new laptop running Windows 11 and loaded my spreadsheets (using compatibility mode) the old macros don't work. Do you have a solution please ?

Ответить
Yair Reichman
Yair Reichman - 20.12.2022 13:18

It was Great! Thanks a lot!
Where can i find the presentation file?

Ответить