Excel VBA Programming Tutorial 1.0

License: Free Trial ‎File size: 51.38 MB
‎Users Rating: 4.0/5 - ‎1 ‎votes

This Tutorial is Based on Excel 2007 & 2010================Excel VBA, which stands for Excel Visual Basic for Applications, is the name of the programming language of Microsoft Excel. With Excel VBA you can automate a task in Excel by writing a so called Macro. This can save you a lot of time! More importantly there are certain things you cannot do with Excel alone. Excel VBA allows you to do these things in Excel.================Goals of the Tutorial:-- Learn Excel tools by utilizing them in various cases >>>Tools and materials covered here are merely a sample of Excel functionality -- Understand the logic and syntax behind Visual Basic programming, which interacts with the Excel interface>>> No programming background required-- Create dynamic algorithms to approach cases>>> When data is changed, but retains its original format, the algorithm should be able to automatically handle the transition appropriately================Contents Overview :- Case 1: Multiplication Table- Case 2: Percentile Calculations- Tutorial 1: Variables and Arrays- Case 3: Hello World - Tutorial 2: Functions- Tutorial 3: Loops and Decisions- Case 4: Gradebook Tallying - Case 5: Loop through Data- Tutorial 4: Recording Macro- Case 6: Select, Pull, Display - Tutorial 5: Userform- Case 7: Subway Data All-Around Analysis================Application feature :- Offline (No need to connect to the INTERNET).- Bookmark pages.- Zoom on pages.- Support text searching helps quick locating.- Every page has its small thumbnail.- Slight click the Previous and Next buttons to turn pages.- Full Screen: slight click the center of screen to switch full screen reading mode.- Press any corner of Tutorial page and slide for turning page.- Book mode reading (Landscape mode) , Just rotate the device.- Perfect quality for big screen Phone and Tablet.

VERSION HISTORY

  • Version 1.0 posted on 2013-06-12
    Several fixes and updates
  • Version 1.0 posted on 2013-06-12

Program Details