programming and automation using Microsoft Excel with its’ macro and VBA coding functionality
The class project will take a list of numbers and then move only the numbers that are less than 10 to a new list with the click of a button.
What you’ll learn
- It will walk you through essential concepts and slowly demonstrate some powerful automation that this skill can bring to your clerical computer-based tasks..
- It will automate processes at your business or job..
- React dynamically to user events like entering a cell value or opening a workbook.
- Acquire critical Excel knowledge within the first 2 hours of tutorials..
- Learn all about: tables, charts, formatting, formulas and functions, macros, pivot tables/charts, and much more!.
Course Content
- 介绍 –> 1 lecture • 5min.
- Excel VBA Concepts –> 10 lectures • 20min.
- Variant –> 30 lectures • 3hr 17min.
- Moving Data –> 10 lectures • 58min.
Requirements
The class project will take a list of numbers and then move only the numbers that are less than 10 to a new list with the click of a button.
Lessons on more advanced topics will continue past the video for this introductory project.
I appreciate your patience while I continue to build this course library!
Class Description:
This class will introduce you to the concepts of programming and automation using Microsoft Excel with its’ macro and VBA coding functionality. The beginning is suitable for beginners who have never done any programming before. It is an excellent introduction to Excel Macros and also programming in general with transferrable knowledge for other programming languages.
It will walk you through essential concepts and slowly demonstrate some powerful automation that this skill can bring to your clerical computer-based tasks.
As the class continues, I will introduce increasingly advanced concepts. I will bring you along as I create example projects that combine and utilize the concepts discussed in earlier lessons.
The approximate structure of the course is that the lessons at the beginning will teach you individual concepts shown by themselves. These are the building blocks. The later lessons will show example projects where I demonstrate and explain every step of building example tools that could automate processes at your business or job.
Please feel free to contact me with any questions and leave a review. Thank you for any time you spend watching! If you leave a question in the discussion, I’d be happy to answer it and maybe even record a video lesson for the answer.