TutortekTutortek
  • Home
  • Courses
    • Web Designing
    • Analytics
      • Power BI
      • MSBI
      • Advanced Excel
      • SQL
      • R
      • VBA Macro
      • Tableau
    • Digital Marketing
      • Digital Marketing
      • SEO
      • PPC
    • Cloud Computing
      • Azure
      • AWS
    • Tally
      • Basic Tally ERP 9.0
      • Advanced Tally ERP 9.0
  • Services
    • Business Intelligence
    • Web Development
    • Intranet Development
    • Master Data Management
    • POC
      • Pipedrive Azure POC
      • Sharepoint Azure POC
  • Portfolio
  • Interview Questions
    • Hadoop
      • Hive
      • HDFS
      • HBASE
      • PIG
      • SPARK
    • Digital Marketing
    • Web Development
    • Web Designing
      • Web Designing
      • JavaScript
    • BI & Analytics
      • Power BI
      • MSBI
      • Tableau
      • VBA Macro
      • SQL
    • Cloud Computing
      • AWS
  • Blog
  • Contact
    • Home
    • Courses
      • Web Designing
      • Analytics
        • Power BI
        • MSBI
        • Advanced Excel
        • SQL
        • R
        • VBA Macro
        • Tableau
      • Digital Marketing
        • Digital Marketing
        • SEO
        • PPC
      • Cloud Computing
        • Azure
        • AWS
      • Tally
        • Basic Tally ERP 9.0
        • Advanced Tally ERP 9.0
    • Services
      • Business Intelligence
      • Web Development
      • Intranet Development
      • Master Data Management
      • POC
        • Pipedrive Azure POC
        • Sharepoint Azure POC
    • Portfolio
    • Interview Questions
      • Hadoop
        • Hive
        • HDFS
        • HBASE
        • PIG
        • SPARK
      • Digital Marketing
      • Web Development
      • Web Designing
        • Web Designing
        • JavaScript
      • BI & Analytics
        • Power BI
        • MSBI
        • Tableau
        • VBA Macro
        • SQL
      • Cloud Computing
        • AWS
    • Blog
    • Contact
      Register Login

      IT & Software

      • Home
      • All courses
      • IT & Software
      • Excel VBA Macro Training

      Excel VBA Macro Training

      tutortek
      IT & Software, Technology
      (0 review)
      Free
      Excel VBA Macro Training

      Excel VBA Introduction

      • Accessing the visual basic editor
      • Switching between Applications
      • The VB editor windows
      • Creating and Removing Modules
      • Renaming Modules
      • Setting up of code fonts and colours
      Next VBA Introduction Part-2
      • Description
      • Curriculum
      • Instructors
      • Reviews (0)

      COURSE DESCRIPTION

      Visual Basic for Applications (VBA) is a scripting language developed by Microsoft which allows the development of user-defined functions and the automation of certain processes and calculations. VBA is built into most Microsoft Office applications to extend their functionality. It can be used to control many aspects of the host application, including manipulating user interface features, such as menus and toolbars, and working with custom user forms or dialog boxes.

      COURSE DETAILS

      Tutortek’s VBA Macro Course (online / classroom) training is designed to help you become a top VBA Macro’s Professional. During this course, our expert instructors will help you:

      • Process Automation
      • Report Generation Automation
      • Eliminate Manual Process/Manual Interaction
      • Organize & Managing data easily using the tool
      • Excel Based Automation
      • Automation of Import/Export utility
      • Organizing data into Multiple workbooks/worksheets
      • Interaction to Databases (MS-Access, SQL Server etc.)
      • Interaction of Applications (eg: PowerPoint, Outlook, Word)
      • Automate the Send e-mail (Download attachment, send file etc.)
      • Eliminate Manual Process/Manual Interaction
      • Automate complex analysis easily

      EXCEL VBA MACRO COURSE CAN BE TAKEN UP BY:

      Students & Freshers :As a fresher it would be little difficult to get the job.Learning VBA Macro will open new doors of oppurtunities for you.

      Working Professionals :Who are not satisfied with their current profile & wants to boost their career with the latest technology.

      Course Features

      • Lectures 20
      • Quizzes 0
      • Duration 35 hours
      • Students 26
      • Assessments Self
      • Share:
      • 0/20

        • Lecture1.1
          Excel VBA Introduction
          30m
        • Lecture1.2
          VBA Introduction Part-2
          30m
        • Lecture1.3
          Running VBA Code
          30m
        • Lecture1.4
          Message Boxes in VBA
          30m
        • Lecture1.5
          Input Boxes in VBA
          30m
        • Lecture1.6
          Selecting Cells and Ranges by using VBA:
          30m
        • Lecture1.7
          Working with Sheets
          30m
        • Lecture1.8
          Errors Handling and Debugging
          30m
        • Lecture1.9
          Working with Workbooks
          30m
        • Lecture1.10
          Variables in VBA
          30m
        • Lecture1.11
          Object variables in VBA
          30m
        • Lecture1.12
          With Statements
          30m
        • Lecture1.13
          If Statements
          30m
        • Lecture1.14
          Select Case Statement
          30m
        • Lecture1.15
          Looping in VBA
          30m
        • Lecture1.16
          For Next Loops
          30m
        • Lecture1.17
          For Each Loops
          30m
        • Lecture1.18
          Creating Functions
          30m
        • Lecture1.19
          File System Object
          30m
        • Lecture1.20
          User VBA Forms
          30m
      tutortek

      Reviews

      Average Rating

      0
      0 rating

      Detailed Rating

      5 stars
      0
      4 stars
      0
      3 stars
      0
      2 stars
      0
      1 star
      0

      You May Like

      Web Designing training Read More
      tutortek

      Web Designing training

      20
      0
      Free
      Power BI Training Read More
      tutortek

      Power BI Training

      16
      0
      Free
      Advanced Excel Training Read More
      tutortek

      Advanced Excel Training

      15
      0
      Free

      Quick Contact





      Latest Courses

      Search Engine Optimization

      Search Engine Optimization

      Free
      Digital Marketing Training

      Digital Marketing Training

      Free
      Pay Per Click (PPC) Training

      Pay Per Click (PPC) Training

      Free

      Address

      OFFICE #1554, Sri Chowdeswari Tower,1st Floor,
      East End Main Road, East end Circle,
      Jayanagar 9th Block, Bangalore,
      India- 560069.
      +91 9886635020
      enquiry@tutortek.com

      Company

      • Home
      • Blog
      • Contact Us
      • Become a Teacher

      Popular Courses

      • Digital Marketing
      • AWS

      Follow Us

      • Facebook
      • Google Plus
      • Likedin
      • Pinterest

      Copyright © 2017 Tutortek designed by godigitali. All Rights Reserved.