Recommendations for Online Excel Courses - ????

spydey · Mar 8, 2018

Looking for some recommendations of online Excel courses to advance myself a bit.

If it is advanced Excel dealing with pivots, dashboards, power queries, etc. That would be great!

Also looking at introduction to VBA up to Advanced VBA. All VBA knowledge I have, I have pieced together. I would like some structure and to fill in any holes/blanks I currently have.

I have been looking at the following sites but am always skeptical about "flashy" sites or sites with countdowns to pressure buyers.

https://myexcelonline.com

https://www.myonlinetraininghub.com

https://academy.powerspreadsheets.com

I also found a number of sites that offer packages at and "amazing" discount ..... I rarely believe those sites.

Any thoughts, recommendations, etc?

Thanks!

-Spydey

hiker95 · Mar 8, 2018

Looking for some recommendations of online Excel courses to advance myself a bit.

JLGWhiz · Mar 8, 2018

My personal opinion of how to best learn VBA is to set up a project that you want to automate. Make a flow chart (it can be a simple block diagram) of the steps you need to accomplish to produce an output from the project. Then develop a macro for each of the steps. You can tie the steps together with a master macro that calls the individual macros in the order needed to produce the output. You can use on line turtorials, publications and on line forums like this one to help you along. But the key to learning is not so much being shown how to do it as it is doing the research to understand how the underlying applications work, understanding the conventions and limitations of the applications and using those conventions properly when developing code. "Practice makes perfect" is not just and addage, it is a fact.

spydey · Mar 8, 2018

Ba-Jimminey Cricket!! That is like 5000% more than I had initially hoped for. It will take me like years to get through all that! Better start now! lol

Thank you hiker95!!!!!! I very much appreciate your willingness to share some an in depth compiled list of knowledge.

Thank you!

-Spydey

hiker95 · Mar 8, 2018

spydey said:
Ba-Jimminey Cricket!! That is like 5000% more than I had initially hoped for. It will take me like years to get through all that! Better start now! lol

Thank you hiker95!!!!!! I very much appreciate your willingness to share some an in depth compiled list of knowledge.

Thank you!

-Spydey

spydey,

Thanks for the feedback.

You are very welcome. Glad I could help.

And, come back anytime.

spydey · Mar 8, 2018

JLGWhiz said:
My personal opinion of how to best learn VBA is to set up a project that you want to automate. Make a flow chart (it can be a simple block diagram) of the steps you need to accomplish to produce an output from the project. Then develop a macro for each of the steps. You can tie the steps together with a master macro that calls the individual macros in the order needed to produce the output. You can use on line turtorials, publications and on line forums like this one to help you along. But the key to learning is not so much being shown how to do it as it is doing the research to understand how the underlying applications work, understanding the conventions and limitations of the applications and using those conventions properly when developing code. "Practice makes perfect" is not just and addage, it is a fact.

JLGWhiz,

I very much agree with you, thus why some online training, reference material, classes, lessons, etc, are critical. I don't want to just be told how to do something or have it provided to me. I want to learn how to do it myself. I am a very avid fly fisher and believe quite deeply in the addage of giving a man a fish and he will eat for a day, teach a man to fish and he will never go hungry (summarized).

I have worked on a number of VBA project and have done exactly as you mentioned above. I start with a flowchart, write each step and/or sub-step as a separate macro in a module, then tie them all together with a single module calling each macro step needed. It works well. The main issue I am running into is I have pieced together all my knowledge and feel like there are holes or blanks. I find myself doing a lot of trial and error on things that in my mind's eye should be quite simple and straightforward, but I find my self getting hung up on. I try to do the research and put it all together, which has proven successful, but I would just like to ensure that any blanks are filled in with the lacking parts.

And yes, practice makes perfect!!!

Hopefully that makes sense.

-Spydey

JLGWhiz · Mar 8, 2018

spydey said:
JLGWhiz,

I very much agree with you, thus why some online training, reference material, classes, lessons, etc, are critical. I don't want to just be told how to do something or have it provided to me. I want to learn how to do it myself. I am a very avid fly fisher and believe quite deeply in the addage of giving a man a fish and he will eat for a day, teach a man to fish and he will never go hungry (summarized).

I have worked on a number of VBA project and have done exactly as you mentioned above. I start with a flowchart, write each step and/or sub-step as a separate macro in a module, then tie them all together with a single module calling each macro step needed. It works well. The main issue I am running into is I have pieced together all my knowledge and feel like there are holes or blanks. I find myself doing a lot of trial and error on things that in my mind's eye should be quite simple and straightforward, but I find my self getting hung up on. I try to do the research and put it all together, which has proven successful, but I would just like to ensure that any blanks are filled in with the lacking parts.

And yes, practice makes perfect!!!

Hopefully that makes sense.

-Spydey

One thing grossly overlooked or ignored by many tyros is the help facility in VBA, accessed from the vb editor menu bar. Probably because it is not the most user friendly help facility. But it gives you access to the vba language spec sheets which can be found by searching keywords of the code language or typing "how do I ..." filled in with the problem topic. That will initiate a web search from which several options can be investigated. I use this facility regularly, because I cannot possibly remember all the various syntax, arguments, etc. of VBA. But I have noted that over 90 % of the problems posted in the forum can be answered using that facility. So it is a useful tool.

Recommendations for Online Excel Courses - ????

spydey

Active Member

Excel Facts

hiker95

Well-known Member

JLGWhiz

Well-known Member

spydey

Active Member

hiker95

Well-known Member

spydey

Active Member

JLGWhiz

Well-known Member

Similar threads

Forum statistics

Share this page

Recommendations for Online Excel Courses - ????

spydey

Active Member

Excel Facts

hiker95

Well-known Member

JLGWhiz

Well-known Member

spydey

Active Member

hiker95

Well-known Member

spydey

Active Member

JLGWhiz

Well-known Member

Similar threads

Forum statistics

Share this page

We've detected that you are using an adblocker.

Which adblocker are you using?

Disable AdBlock

Disable AdBlock Plus

Disable uBlock Origin

Disable uBlock