Get a month of TabletWise Pro for free! Click here to redeem 
TabletWise.com
 

Excel VBA for Beginners

This class will walk you step by step into learning Excel VBA from zero

Excel VBA for Beginners

This class will walk you step by step into learning Excel VBA from zero
16
Views
9:08:02
Share the link to this class
Copied
In this section, we introduce the basic concepts of Excel VBA. We speak about the object model and language syntax. We also speak about the recording macros in preparation for writing VBA code.
In this section, we take a look at the cells collection object which is another way of dealing with cells in Excel VBA.
In this section, we will learn how to deal with worksheets using Excel VBA.
in this section, we take a look at variables. We learn about the different types and usage of each type and how to deal with them.

Learn step by step how to automate your spreadsheets using the power of programming in Excel! 

This course is designed to teach beginners who have no background in programming how to program in Excel VBA!

What you need before taking this course?

  • The will to learn!
  • You need to be at least an intermediate user of Excel, know how to write formulas, draw charts, and use pivot tables.

A Powerful Skill at Your Fingertips

Learning how to program in Excel will increase your market value and allow you to save time on your spreadsheets.

It will also be a great way to tap into the world of programming, and will help lay the foundation in case you need to learn any other programming language!

Who should take this course?

  • Someone who wants to learn how to program/write code in Excel using the Visual Basic for Applications (VBA) language.
  • Someone who needs to know how to write formulas, use pivot tables, and draw charts in Excel.

You will find all the Course files attached at the beginning of the course.

Requirements

  • Should have basic knowledge of formulas, use pivot tables, and draw charts in Microsoft Excel.
  • You Have a PC/Mac (Windows Preferred) with Microsoft Excel installed on it.
In this section, we introduce the basic concepts of Excel VBA. We speak about the object model and language syntax. We also speak about the recording macros in preparation for writing VBA code.
In this section, we take a look at the cells collection object which is another way of dealing with cells in Excel VBA.
In this section, we will learn how to deal with worksheets using Excel VBA.
in this section, we take a look at variables. We learn about the different types and usage of each type and how to deal with them.

About the instructors

 

Abdelrahman Abdou

Share the instructor profile
Copied
All Classes
Free for 30 Days
   The video is currently being processed.
   An error occurred while uploading the video. Please upload another video.
   Please upload the required file.
Quiz: #TITLE#
Questions: #QUESTIONS_COUNT#
Quiz: #TITLE#
Question /#QUESTIONS_COUNT#
Quiz: #TITLE#
Result: You correctly answered out of questions. Result: You correctly answered out of question. Result: You correctly answered out of questions attempted. Result: You correctly answered out of question attempted. Result: You did not attempt any question.
0
Saves
16
Views
This class has not been saved

Sign Up