Visual Basic for Excel TrainingCareerVision Training
£ 72 - (Rs 6,120)
- Distance learning
What you'll learn on the course
Visual Basic training
Basic IT training
• Format: DVD or Instant Download
• Duration: 8 Hours (90 lessons)
• Instructor: Guy Vaccaro
• Platform: Windows PC or Mac
Take your skills to the next level. This Learning Visual Basic for Microsoft Excel Tutorial Video is the ultimate in comprehensive instruction for the discerning professional.
These training classes use broadcast quality audio and video to deliver concise and informative training right to your desktop. The course is presented via an intuitive, easy-to-use interface, allowing you to learn at your own pace.
These Learning Visual Basic for Microsoft Excel Tutorials break even the most complex subjects down into easy to follow segments, following along is simple. Practical working files further enhance the learning process and provide a degree of retention that is unmatched by any other form of training.
Benefits of this Software Training:
• Tuition by expert tutors.
• Narrated training videos demonstrate the key tools and professional techniques helping you to work faster and smarter.
• Learning is fast as the trainers guide you using simplistic terms and minimal jargon.
• Personal Tutoring - Step-by-step video training from your own desktop.
• Delivered via DVD/CD training or online tuition.
• The tutor transfers knowledge to you quickly and effectively.
• All the concepts of each application are explained clearly and precisely.
• Course works on PC and Mac.
• Alternative to a boring book or manual and expensive training courses, seminars and amp; classes.
• Jump to and from lessons - learn at your own pace.
• The visual and practical nature shortens the learning curve compared to standard training manuals.
The following sections are available for free viewing. Click on the links below to get started.Free Videos From This Course Excel 2010 Security Settings And Macro Files Quick Tour Of The Visual Basic Editor Declaring Variables And Data Types String And Date Types Expanded Referencing Cells Using The Range Object Add Formulas To Cells Through VBA Code Using Worksheet Excel Functions In VBA Code Controlling The Program Flow With IF THEN ELSE The FOR NEXT Loop Make The VBA Ignore Errors Speeding Up The VBA Tips Creating A UserForm UserForm Controls - ListBox And/Or Combo Box
Getting Started What Will I Get Out Of This Course About The Author The Working Files Explained What Is VBA? Excel 2010 Security Settings And Macro Files The Developer Ribbon
Macros Recording And Running A Simple Macro Editing An Existing Macro In The Visual Basic Editor The New Macro Enabled File Type Quick Tour Of The Visual Basic Editor Watch A Macro Write Your VBA
Procedures And Functions What Is A Module? Creating A Sub Procedure Manually How To Call A Sub Procedure Creating A Function Procedure How To Call A Function
Getting Started With VBA Programming Using Comments Within Your VBA Code Declaring Variables And Data Types The Scope Of A Variable The Static Declaration And Variable Expiry Constants Instead Of Variables An Intrinsic Constant String And Date Types Expanded VBA Operators Arrays Multi-Dimensional Arrays Dynamic Arrays
Manipulating Excel Objects Referencing Cells Using The Range Object The CELLS Property The OFFSET Property The VALUE Of Ranges The TEXT Object Of The RANGE A Number Of Read Only RANGE Properties The FONT Property And Colors Formatting Numeric Values Add Formulas To Cells Through VBA Code Common METHODS Of The RANGE Object
Working With Excel VBA Functions What Is A Function? Built In VBA Date Functions Text Manipulation With VBA Functions Determining File Sizes Using FILELEN Using Worksheet Excel Functions In VBA Code User Defined Functions
Controlling Program Flow And Execution Using GOTO And Labels Controlling The Program Flow With IF THEN ELSE Multiple Criteria Plus Nested IFs Adding ELSEIF To Speed Up Execution SELECT CASE As An Alternative To IF The FOR NEXT Loop FOR NEXT With A VBA Collection DO WHILE Loop
Events How To Create An Event WorkBook Events - Open Workbook Events - Closing And Saving Workbook Triggers - Activate And Deactivate Worksheet Triggers - Activate And Deactivate Other Useful Worksheet Triggers Using Application Events
Debugging And Error Handling Error Trapping the Easy Way Make The VBA Ignore Errors Interact With The User When An Error Occurs Making Use Of The ERR Object Debugging Techniques Using Breakpoints To Help Debug Setup And Use A Watch Speeding Up The VBA Tips
Interacting With Users Through Forms Using MSGBOX To Interact With Users Use INPUTBOX For Accepting Values From Users Selecting A Range With The INPUT Box An Introduction To UserForms Creating A UserForm Using Command Buttons Adding Option Buttons In A Frame Adding The Code That Makes The Form Work Calling Your UserForm And Validating Content UserForm Controls - The CheckBox UserForm Controls - ListBox And/Or Combo Box Images On UserForms Labels And Text Boxes Multiple Tabs On A UserForm Allowing The User To Highlight A Range Scrollbar And Spin Controls Controlling Tab Order And Aligning Controls
Running And Storing VBA Code Trigger A Procedure From The Quick Access Toolbar Customizing The Ribbons Adding Buttons To Sheets Adding A Keyboard Shortcut Trigger Where To Store Your VBA Code Adding Code To The PERSONAL File
Summary So What's Next?