Microsoft Excel VBA For Beginners

by Skillsgen Claim Listing

This course is for those who wish to take their first steps toward using the incredibly powerful tool that is Visual Basic in Excel. You will learn how to programmably automate tasks and get the basics of forms; objects; expressions and variables down.

Price : Enquire Now

Contact the Institutes

Fill this form

Advertisement

Skillsgen Logo

img Duration

1 Day

Course Details

This course is for those who wish to take their first steps toward using the incredibly powerful tool that is Visual Basic in Excel. You will learn how to programmably automate tasks and get the basics of forms; objects; expressions and variables down. Please be sure to read the pre-requisites for this course to ensure you meet the requirements.

 

Course Content
Using the Recorder:

  • Naming Macros
  • Assigning Shortcuts
  • Absolute and Relative Recording
  • Where macros are stored
  • Personal Macro Workbook

Getting Started:

  • Developer tab
  • Filing
  • Macro Security

Overview:

  • VBA or Macros?
  • What it can be used for

Editing Code :

  • Understanding the code structure
  • Simple edits
  • Calling procedures

The VB Editor:

  • Overview of the VB Editor
  • Projects and the Project Explorer
  • Properties and Code Windows

Running Macros:

  • Shortcut keys
  • Quick Access Toolbar
  • Worksheets buttons and shapes
  • Ribbon

The If statements:

  • Single line
  • Blocked If
  • Logical expressions

Exploring Code with the Immediate Window:

  • Variables and Constants
  • Dimensioning
  • Option Explicit
  • Data Types
  • Scope
  • Locals and Watch Windows

Stepping and Debugging:

  • Step Intro, Over, Out
  • Setting Breakpoints
  • Editing code while Stepping
  • Dealing with Runtime error

Writing Macros:

  • VBA Terminology
  • Procedures, Subroutines, Macros, Functions
  • Objects, Methods, Properties

Adding Simple Interactivity to Macros:

  • Creating an Interactive Message Box
  • Creating a Custom Input Box
  • Liverpool Branch

    South Road, Liverpool

Check out more MS Excel courses in UK

Aspyra Training Logo

Microsoft Access 2016 (Advance)

This Access Advanced course will enable delegates to acquire sufficient skills and knowledge in Microsoft Access 2016 in order to design and create a multi-table database and automate operations.

by Aspyra Training [Claim Listing ]
  • Price
  • Start Date
  • Duration
Wirral Metropolitan College Logo

MS Excel (Beginners/intermediate)

This course is for those who are able to use a computer to create and save files and want to develop their spreadsheet skills.

by Wirral Metropolitan College [Claim Listing ]
  • Price
  • Start Date
  • Duration
Prospect IT Training Logo

Microsoft Word Training

Microsoft Word is a word processor published by Microsoft. It is one of the office productivity applications included in the Microsoft Office suite. We offer three levels of training for Word.

by Prospect IT Training [Claim Listing ]
AJ Training Logo

Microsoft Office Training Course

Microsoft Office Editions, the easiest way to help more people use information to make a positive impact on business. The Office Editions offer great technologies and features while improving upon existing and familiar tools to facilitate effective and efficient collaboration and information sharin...

by AJ Training [Claim Listing ]
Skilltec Logo

Microsoft Excel Level 1 Training Course

This course introduces delegates to the basic functions of Microsoft Excel and will enable them to create worksheets and perform formatting and functions within the worksheet.

by Skilltec [Claim Listing ]

© 2024 coursetakers.com All Rights Reserved. Terms and Conditions of use | Privacy Policy