#1
4th December 2015, 05:20 PM
| |||
| |||
Visual Basic Online Course Free
I want to so online Microsoft Visual Basic for Applications (VBA) Course from Virtual Training Company (VTC) so can you please provide me the details of this course?
|
#2
4th December 2015, 05:20 PM
| |||
| |||
Re: Visual Basic Online Course Free
Virtual Training Company (VTC ) is a producer of online computer and software training. They supply individuals, businesses, education providers, and non-profit organizations with access to software tutorials. Online Microsoft Visual Basic for Applications (VBA) Course The Microsoft Office suite of applications (Word, Excel, PowerPoint, and Access) allows users to customize views or output, but the processing performed by the applications cannot be changed. Course: Microsoft Visual Basic for Applications (VBA) Author: Robert Ekblaw SKU: 34345 ISBN: 978-1-61866-050-3 Release Date: 2012-06-26 Duration: 7.5 hrs / 80 tutorials Work Files: Yes Captions: Yes Subject: Programming Course Content- Introduction What VBA Is (06:58) What This Course Is About (07:21) VBA vs. Visual Basic (05:46) Using the VBA Editor (04:55) Data and Variables Data Types (05:56) Storage and Data Sizes (06:51) Declaring Variables (04:29) Variable Names (05:09) Putting Values in Variables (05:46) Creating Constants (06:15) String Variables (06:30) Handy String Functions (07:43) What an Array Is (05:29) Creating Arrays (05:24) Resizing Arrays (06:00) 2-Dimensional Arrays (05:16) Sample Variables (05:55) Using Macros Macro Recording (05:30) Recording a Macro (04:51) Running a Macro (03:33) Editing a Macro (06:29) Help in VBA (06:19) Application Object (05:16) VBA Expressions Simple Arithmetic Operators (04:46) Advanced Arithmetic Operators (04:39) Comparison Operators (04:24) Logical Operators (06:08) Order of Operations (05:14) Mathematical Expressions (08:09) Using Functions in Formulas (06:28) Mathematical Functions (04:11) Conversion Functions (04:21) String Functions (06:37) Finding Words in Strings (07:56) Replacing and Comparing Strings (06:33) Sample Expressions (06:34) Working with Dates (05:31) Date Functions (06:49) Dialog Boxes User Interaction (05:55) Using Message Boxes (06:10) Format Options (07:14) Results of Message Boxes (02:33) Using Input Boxes (06:48) Functions and Procedures Creating a Subroutine (03:19) Understanding Parameters (04:16) Parameter Passing (05:06) Function vs Procedure (04:40) Return Statement (04:25) Sample Function AVE (03:23) Arrays as Parameters (03:30) Conditional Processing What Conditional Processing Is (03:54) IF Block (06:21) Complex Conditions (04:49) Nested IFs and Elseif (06:02) Using IF in Coin Toss (04:55) Sample Function MIN (06:49) Multiple Outcomes (05:42) SELECT Block (04:53) Multiple CASE Statements (05:24) Conditional Functions (04:36) Loops Parts of a Loop (04:24) Infinite Loops (04:14) DO WHILE Loop (04:49) DO UNTIL Loop (05:03) FOR Loops (05:46) Running Arrays (04:55) Update AVE Function (07:38) Sample Array Sort (06:34) Sample Swap Routine (06:15) Tracing FOR Loops (05:48) Step Value in for Loops (06:35) EXIT Statement (06:34) Testing Your Work The Debug Environment (05:10) Seeing Values (05:01) Stepping Through Code (06:05) Breakpoints (06:20) Finding and Fixing Errors (05:36) Conclusion What We Learned (04:05) Planning for your VBA Code |
|