Provider
Topic
Level
College & Adult
Price
Free
Monthly
Add-ons available
Common Core
Yes
No
Images
No items found.
Learn to automate your most repetitive tasks at the push of a button with Excel macros and VBA. In this online course, you will learn to create powerful macros using VBA (Visual Basic for Applications) to really make Excel work for you. With no prior programming experience required, you'll have your daily spreadsheets running like clockwork to save you hours of time and boost your productivity.
Highlights:
- 41 practical tutorials.
- Understand the differences between macros and VBA.
- Run your macro from the Macro dialog, a keyboard shortcut or worksheet button.
- Understand the syntax and structure that make up a valid macro.
- How VBA Objects and the Objects model relate to each other.
- Using step vs run in entry level debugging.
- How to create variables and assign strings, values or objects.
- Implementing logic tests in VBA.
- Set up looping with Do loops and Do While loops.
- Create a VBA Message Boxes.
- Set up an error trap in VBA to handle errors.
- Create a User Defined Function (UDF).
Video tutorials are recorded in Microsoft Excel 2016 for PC. Learn more about how a GoSkills Excel certification can boost your career.
Want to be a more efficient Excel user? Start learning 200 of the best Excel shortcuts for PC and Mac.
Once enrolled, our friendly support team and tutors are here to help with any course related inquiries.
Posted
Aug 2023
This resource has religious influence.
Similar resources
Our unique approach to learning
As pioneers of microlearning, we’ve been creating bite-sized courses since 2013. Our unique ‘GoSkills format’ includes a 3-5 minute video, an exercise to apply your knowledge, and a short quiz for every lesson.
This data-backed approach works, increasing retention rates by 20% and learning speeds by 28%. GoSkills also has one of the highest completion rates in the industry.
Here’s what our customers say:
“Perfect bite-size lessons that were brief and to-the-point, well thought out to build on key skills, with great exercises to build "muscle" memory, and solid quizzes that hone important points.”
“Love the bite sized modules! Easy to squeeze one or two in when I have time.”
“I liked that the lessons covered one thought at a time, in small bites.”
Our simple and easy-to-use online training platform empowers managers to create bite-sized and interactive learning programs for their teams, so they can achieve the same results.
We help individuals grow their career
Our subscribers have access to over 100 bite-sized courses taught by leading industry experts. By learning the most sought after business and technical skills, we help individuals stand out in the job market and find confidence at every stage of their career.
Introduction to Tableau
College & Adult
Illustrator - Advanced
College & Adult
Illustrator - Basic
College & Adult
Photoshop - Advanced
College & Adult
Photoshop for Beginners
College & Adult
Intro To C# Programming
College & Adult