Learn Microsoft Excel VBA Free Video Course
Learn Microsoft Excel VBA Free Video Course
Microsoft Excel VBA Extend your knowledge of recorded macros using Excel VBA. Learn about Forms, Loops, Defined Functions and Automation
Course Video Size : 02 GB High Quality Video Content
part 01
What you will learn
- If you are performing repeated actions on workbooks or sheets, it may be possible to automate that work. Importing data, cleaning that data, archiving existing information and similar activities are good candidates for
Requirements of Microsoft Excel VBA:
- Advanced knowledge of Excel
Description of Microsoft Excel VBA:
Microsoft Excel VBA course provides a solid foundation in Excel VBA. Using Excel VBA will extend your knowledge of recorded Macros and provide you powerful skills to automate Excel. This course explains how and where Macros can be useful in Excel and how to use Excel for as much of the “heavy lifting” as possible.
Who this course is for:
- Users familiar with recording and editing basic macros in Excel who want to go further in automating and customising Excel using VBA – Visual Basic for Applications. No previous programming experience is required but an expert level of Excel use is assumed.
Course content of Microsoft Excel VBA:
Introduction of Microsoft Excel VBA:
- Introduction
- Excel Overview
- Recording a Macro
- Reviewing Macro Code
- Overview Of VBA And Office
- Objects, Methods And Properties
- Differences Between Office 2003, 2007, 2010 And 2013
- Creating A Macro Enabled Workbook
Macro Recorder Part:
- Introduction
- Recording A Macro To Format Cells
- Recording A Macro To Format Cells As Currency
- Recording A Macro To Swap Two Columns
- Recording A Macro Using Relative References Rather Than Absolute
- Recording A Macro To Turn Gridlines On And Off
- Tweaking Macros To Change Their Functionality
Leave a Comment