Learning Visual Basic for Microsoft Excel Training Video

Courses For Success

Course

Online

£ 98.75 + VAT

*Indicative price

Original amount in AUD:

$ 189

The best Excel courses

See all

See all

Description

  • Type

    Course

  • Methodology

    Online

  • Start date

    Different dates available

Learning Visual Basic for Microsoft Excel Training Video A Practical VBA Training Course That Teaches Real World Skills In this project-based Learning Visual Basic for Microsoft Excel video tutorial series, you'll quickly have relevant skills for real-world applications. Follow along with our expert instructor in this Learning Visual Basic for Microsoft Excel Training Video course to get: Concise, informative and broadcast-quality Visual Basic for Microsoft Excel training videos delivered to your desktop The ability to learn at your own pace with our intuitive, easy-to-use interface A quick grasp of even the most complex Visual Basic for Microsoft Excel subjects because they're broken into simple, easy to follow tutorial videos Practical working files further enhance the learning process and provide a degree of retention that is unmatched by any other form of Visual Basic for Microsoft Excel tutorial, online or offline... so you'll know the exact steps for your own projects. Course Fast Facts: Only 8 hours to complete this course 90 tutorial videos Expert instructors lead each course Download to any Windows PC or Mac and save for viewing off line Course is accessible 24/7 from any computer once downloaded You can study from home or at work at your own pace in your own time Course Description In this Learning Visual Basic for Microsoft Excel Training Video course, you will learn how to apply the VBA programming language to make your Excel spreadsheets much more powerful. Seasoned Microsoft trainer Guy Vaccaro starts you out with the basics of VB programming, and teaches you to use it to its fullest potential within Excel. Guy extends your knowledge past editing odd Macro, directly into creating custom scripts using the VBA Programming Language. This tutorial will teach you about VBA structures, the difference between Functions and Subroutines, how to manipulate Excel Cells, interacting...

Facilities

Location

Start date

Online

Start date

Different dates availableEnrolment now open

About this course

System Requirements - Digital Download Digital Download: Microsoft Windows XP or higher, Mac OS X 10.4 or higher. Minimum screen resolution of 1024x768 Digital Download specific requirements: Between 1GB and 6GB of available hard drive space (depending on the training course) An Internet connection with sufficient bandwidth. You must have at least a 56K modem connection (Broadband recommended). Most modern ADSL and Cable internet solutions will be sufficient. Do I need...

Questions & Answers

Add your question

Our advisors and other users will be able to reply to you

Who would you like to address this question to?

Fill in your details to get a reply

We will only publish your name and question

Reviews

Subjects

  • Excel
  • Basic
  • Visual Basic training
  • Basic IT training
  • Microsoft Excel
  • Basic IT
  • Property
  • Visual Basic
  • Programming
  • Microsoft excel training
  • MS Excel
  • Skills and Training

Course programme

01. Getting Started
  • 0101 What Will I Get Out Of This Course
  • 0102 About The Author
  • 0103 The Working Files Explained
  • 0104 What Is VBA?
  • 0105 Excel 2010 Security Settings And Macro Files
  • 0106 The Developer Ribbon
  • 02. Macros
    • 0201 Recording And Running A Simple Macro
    • 0202 Editing An Existing Macro In The Visual Basic Editor
    • 0203 The New Macro Enabled File Type
    • 0204 Quick Tour Of The Visual Basic Editor
    • 0205 Watch A Macro Write Your VBA
  • 03. Procedures And Functions
    • 0301 What Is A Module?
    • 0302 Creating A Sub Procedure Manually
    • 0303 How To Call A Sub Procedure
    • 0304 Creating A Function Procedure
    • 0305 How To Call A Function
  • 04. Getting Started With VBA Programming
    • 0401 Using Comments Within Your VBA Code
    • 0402 Declaring Variables And Data Types
    • 0403 The Scope Of A Variable
    • 0404 The Static Declaration And Variable Expiry
    • 0405 Constants Instead Of Variables
    • 0406 An Intrinsic Constant
    • 0407 String And Date Types Expanded
    • 0408 VBA Operators
    • 0409 Arrays
    • 0410 Multi-Dimensional Arrays
    • 0411 Dynamic Arrays
  • 05. Manipulating Excel Objects
    • 0501 Referencing Cells Using The Range Object
    • 0502 The CELLS Property
    • 0503 The OFFSET Property
    • 0504 The VALUE Of Ranges
    • 0505 The TEXT Object Of The RANGE
    • 0506 A Number Of Read Only RANGE Properties
    • 0507 The FONT Property And Colors
    • 0508 Formatting Numeric Values
    • 0509 Add Formulas To Cells Through VBA Code
    • 0510 Common METHODS Of The RANGE Object
  • 06. Working With Excel VBA Functions
    • 0601 What Is A Function?
    • 0602 Built In VBA Date Functions
    • 0603 Text Manipulation With VBA Functions
    • 0604 Determining File Sizes Using FILELEN
    • 0605 Using Worksheet Excel Functions In VBA Code
    • 0606 User Defined Functions
  • 07. Controlling Program Flow And Execution
    • 0701 Using GOTO And Labels
    • 0702 Controlling The Program Flow With IF THEN ELSE
    • 0703 Multiple Criteria Plus Nested IFs
    • 0704 Adding ELSEIF To Speed Up Execution
    • 0705 SELECT CASE As An Alternative To IF
    • 0706 The FOR NEXT Loop
    • 0707 FOR NEXT With A VBA Collection
    • 0708 DO WHILE Loop
  • 08. Events
    • 0801 How To Create An Event
    • 0802 WorkBook Events - Open
    • 0803 Workbook Events - Closing And Saving
    • 0804 Workbook Triggers - Activate And Deactivate
    • 0805 Worksheet Triggers - Activate And Deactivate
    • 0806 Other Useful Worksheet Triggers
    • 0807 Using Application Events
  • 09. Debugging And Error Handling
    • 0901 Error Trapping the Easy Way
    • 0902 Make The VBA Ignore Errors
    • 0903 Interact With The User When An Error Occurs
    • 0904 Making Use Of The ERR Object
    • 0905 Debugging Techniques
    • 0906 Using Breakpoints To Help Debug
    • 0907 Setup And Use A Watch
    • 0908 Speeding Up The VBA Tips
  • 10. Interacting With Users Through Forms
    • 1001 Using MSGBOX To Interact With Users
    • 1002 Use INPUTBOX For Accepting Values From Users
    • 1003 Selecting A Range With The INPUT Box
    • 1004 An Introduction To UserForms
    • 1005 Creating A UserForm
    • 1006 Using Command Buttons
    • 1007 Adding Option Buttons In A Frame
    • 1008 Adding The Code That Makes The Form Work
    • 1009 Calling Your UserForm And Validating Content
    • 1010 UserForm Controls - The CheckBox
    • 1011 UserForm Controls - ListBox And/Or Combo Box
    • 1012 Images On UserForms
    • 1013 Labels And Text Boxes
    • 1014 Multiple Tabs On A UserForm
    • 1015 Allowing The User To Highlight A Range
    • 1016 Scrollbar And Spin Controls
    • 1017 Controlling Tab Order And Aligning Controls
  • 11. Running And Storing VBA Code
    • 1101 Trigger A Procedure From The Quick Access Toolbar
    • 1102 Customizing The Ribbons
    • 1103 Adding Buttons To Sheets
    • 1104 Adding A Keyboard Shortcut Trigger
    • 1105 Where To Store Your VBA Code
    • 1106 Adding Code To The PERSONAL File
  • 12. Summary
    • 1201 So What's Next?

Additional information

Digital Download FAQs

Q: What is a digital download?

A digital download is training that you download from the internet using your web browser instead of us shipping you a physical CD.

Q: How instant is the "Instant Purchase"?

If you complete your purchase, you are emailed your access key within minutes of the transaction completing.

Q: How do I access my digital download purchase?

Once you complete your purchase, you will receive an email with an Access Key, and instructions on how to download your purchase. You will enter that Access Key...

See related categories

Learning Visual Basic for Microsoft Excel Training Video

£ 98.75 + VAT

*Indicative price

Original amount in AUD:

$ 189

The best Excel courses

See all

See all