» » InfiniteSkills Learning Visual Basic For Excel



Information of news
  • Author: kityvn
  • Date: 9-09-2013, 14:54
9-09-2013, 14:54

InfiniteSkills Learning Visual Basic For Excel

Category: Tutorials

InfiniteSkills Learning Visual Basic For Excel
InfiniteSkills Learning Visual Basic For Excel
English | 89 Webrips (MP4) + WorkFiles | Size: 950.23 MB
Category: Computer Science



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 training 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.

Duration: 8 hours – 90 tutorial videos
Date Released: 2012-06-12
Instructor: Guy Vaccaro

00. 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

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?
I recommends Buy premimum account for High speed+parallel downloads!

rapidgator




extabit


uploaded




uploaded


Rapidgator.net
Site BBcode/HTML Code:
Dear visitor, you went to the site as unregistered user.
We recommend you Sign up or Login to website under your name.
Information
Would you like to leave your comment? Please Login to your account to leave comments. Don't have an account? You can create a free account now.