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

Microsoft Excel VBA

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

Macro Recorder Part 2 – a larger example:

  • Introduction
  • Some Useful Functionality In Excel For Cell Selection
  • Importing A Text File
  • Filling Blank Cells With Data
  • Adding A Column With The Date
  • Creating A Pivot
  • Creating A Chart
  • Deleting Sheets And Charts
  • Putting Them All Together

Forms:

  • Introduction
  • Creating A Simple Switchboard Form To Call Our Previous Macros
  • Adding A Button To The Ribbon To Display The Form
  • Using The Auto Open Events To Display The Form
  • The Name List Form, Dealing With Events
  • Using String Functions To Manipulate Text
  • Creating A Form To Interact With Data On A Sheet

Loops:

  • Introduction
  • Looping Through Data In A Column With The For Loop
  • The While Loop
  • Using ‘Cells’ To Access A Cell
  • Looping Through Variable Length Lists
  • Looping Through Data In A Column With Spaces
  • Calling Formula To Determine When To Stop A Loop
  • Creating Reusable VBA Code
  • Finding And Formatting Data Using Loops

User Defined Functions:

  • Introductions
  • Creating A User Defined Function (UDF)
  • Creating A Variable Discount Calculation UDF
  • Error Handling In VBA
  • Debugging In VBA

Automation:

  • Introduction
  • Automating Word From Excel
  • Automating Powerpoint From Excel
  • Automating Outlook From Excel
  • Getting Data From Access Into Excel Using VBA

Security:

  • Introduction
  • Personal Macro Workbook
  • Macro Security Levels
  • Using A Digital Signature

VBA Language review:

  • VBA Language review

Now! Learn Microsoft Excel VBA Free Video Course by clicking below download button, If you have a any question so! comment now!..

This image has an empty alt attribute; its file name is How-to-free-courses-on-telegram.jpg

Wait 15 Second For Download This File For Free

howtofree download online free tutorials 1

if you find any wrong activities so kindly read our DMCA policy also contact us. Thank you for understand us…

Leave a Reply

Your email address will not be published. Required fields are marked *

Share This

Share This

Share this post with your friends!