MyPage is a personalized page based on your interests.The page is customized to help you to find content that matters you the most.


I'm not curious

Excel: Learn VBA (Macros) & Increase Your Productivity!

Course Summary

Embrace Excel Automation: Learn to run VBA (Macros), build dashboards, and automate reports with powerful case studies.


  • +

    Course Syllabus

    • Agenda
      • Before you begin
    • Snapshot of what you will learn
      • Work once and enjoy thereafter
      • Data cleaning with an Excel robot
    • Creating Controllable Dashboards to manage reports
      • Dynamic Charts
      • Control + F = VLOOKUP
      • Letting the Function do it all by itself
      • Data Validation Drop Downs to control the charts
      • Applying controls to your charts for Easy handling
    • Visual Basic For Applications: Automating your Work
      • Introduction to VBA Programming
      • Hierarchy followed to communicate to VBA
      • Using Logic to create Sentences
      • Tangible Object hierarchy & Intangible Object Hierarchy
      • Connecting the above dots to write a meaning full code here
      • Using Properties and Methods on Objects
    • Learn more with Hands on
      • Sub Routines: Creating Macros
      • Ways of Executing a Macro from Excel Window
      • Private Sub Routines: Using the predefined Macros
      • Function Routines: To create a user defined Function
      • Basic Error Debugging & Recording
    • Implementation on a case study
      • Writing your first Macro on Data Cleaning
      • Making your code dynamic
      • Loops to do the repetitive task
      • Recording implementation in Data Cleaning
      • Trailing Macros one after Another
      • Self Executable Macros
      • Logic Behind a UDF
      • UDF to Extract numeric from any string


Course Fee:
USD 99

Course Type:

Self-Study

Course Status:

Active

Workload:

1 - 4 hours / week

Related Posts:

Attended this course?

Back to Top

 
Awards & Accolades for MyTechLogy
Winner of
REDHERRING
Top 100 Asia
Finalist at SiTF Awards 2014 under the category Best Social & Community Product
Finalist at HR Vendor of the Year 2015 Awards under the category Best Learning Management System
Finalist at HR Vendor of the Year 2015 Awards under the category Best Talent Management Software
Hidden Image Url

Back to Top