Course Information
Course Overview
Learn to code and automate Excel with Visual Basic for applications.
Learn how to build your first macros with this beginners VBA course. Learn Excel Visual Basic for Applications to automate your Excel workflow.
Build Projects Including:
Learn how to send messages with MsgBox.
Learn how to automate workbooks with the Workbook object.
Program ranges with the Range object.
Manipulate range properties with VBA macros.
Build hands on projects to automate Excel.
Learn the fundamentals of programming: variables, conditionals, and more with VBA projects.
And much more!
A SCHOOL YOU CAN TRUST
Lifetime access that never expires
Project-based curriculum to superboost your portfolio
Graduation certificate for every course
Absolute beginner-friendly
New courses every month
Efficient lectures with step by step explanations
Relevant industry topics
10 years of award-winning course delivery
1.1 million students in 186 countries
Learn with free tools and affordable courses
Enroll now to go through a deep dive of the most popular spreadsheet tool on the market, Microsoft Excel. Build your own spreadsheets from scratch, and actually understand how they work! Concise, yet comprehensive and informative.
This course is project-based so you will not be learning a bunch of useless coding practices. At the end of this course you will have real world apps to use in your portfolio. We feel that project based training content is the best way to get from A to B. Taking this course means that you learn practical, employable skills immediately.
You can use the projects you build in this course to add to your LinkedIn profile. Give your portfolio fuel to take your career to the next level.
Learning how to code is a great way to jump in a new career or enhance your current career. Coding is the new math and learning how to code will propel you forward for any situation. Learn it today and get a head start for tomorrow. People who can master technology will rule the future.
Course Content
- 10 section(s)
- 72 lecture(s)
- Section 1 Introduction
- Section 2 Send Messages with MsgBox
- Section 3 Workbook and Worksheet Object
- Section 4 Work with the Range Object
- Section 5 Work with Range Properties
- Section 6 More Range Projects
- Section 7 Variables
- Section 8 Work with Conditionals
- Section 9 Work with AND, OR and NOT
- Section 10 Build Conditionals Projects
What You’ll Learn
- Basic Machine Learning Concepts
Reviews
-
AAttila Turkoz
Alex is one of the best coders among instructors and this time comes with organized course materials. Third course from her after m-code and THREE.JS while no bad surprises, good job !!!
-
PPat Harding
So far pretty good pace, Using a later version of Excel the ribbon looks different and there was no explanation to show developer tools. In fact using excel online, there's no developer tools available at all.