Macros and VBA Excel

Macros and VBA Excel
Starts from:Thu, September 24, 2020
Key Features
Class Description

Available Batches: 2 Hour (Saturday and Sunday).
Course Duration: 2 Months
The Fees/Amount once paid will not be refunded in full or part thereof or transferred or reserved for future or adjusted towards any other Courses/Subject under any circumstances.

Looking for an Excel VBA and Macro Learning course for beginners to experts? Microsoft Excel is a spreadsheet software written in C#, C++ and Microsoft class library developed by Microsoft Team to manage and evaluate various types of data such as entering the data, applying formulas, functions, macros, and micros. Excel program is designed to run on Windows, Mac, and IOS. This course has something for everyone, covering beginner, intermediate and advanced lessons in MS Excel. Excel is the de-facto software used for data collection, analysis and reporting across organizations. It has wide spread usage due to programmatic and automation features like Macros and VBA.  Who can attend this course?
  •  10th and 12th class students.
  •  Undergraduates, graduates and post graduates.
  •  Corporate Employees.
  •   Basics and Advance MS EXCEL 
  •  
  •   Basic of Microsoft Visual Basics.
  •   
  •   VBA Basics Variables, Comments, Constants and Data Types Visual Basic Arrays VBA Conditional Statements VBA Loops VBA objects Subroutines Functions Labels and the On Error statement VBA and Excel functions Excel Objects Excel Events in MS Excel VBA.
  •   MS Excel Vlookup & Hlookup Exact Function.
  •   Remove Duplicates, Create Random Numbers, Change Text To Upper Case, Lower Case & Proper Case in MS Excel.
  •   Add Password To Excel File, Send Email From Excel File, Add Custom Background Image, Zoom In Zoom Out, Auto Fill Data, Add Special Characters, Change Theme and Change Color Of Border Line in MS Excel.
This course delivers expert level training in Microsoft Excel for any professionals inadequate to enhance their office productivity skills. The students will learn how to optimize and analyze data using Pivot functions and MACRO. After completing this course, available Career Opportunities (Industry wise): -
  •   Excel Programmer
  •   Data Analyser
  •   Office Admin
  •   Business Analyst
  •  Project Manager
  •  School/College Office Assistant
  •   Duration: 60 minutes
  •   No. of questions: 50
  •   Maximum marks: 50, Passing marks: 25 (50%).
  •   There is NO negative marking in this course.
  •   If you failed to pass certification exam in first attempt then second attempt will be available in this course.

We are Open Online! - Conducting Online Batches & Admission.

Contact Us
X
WhatsApp WhatsApp us

Student Speaks

Satyam InfoTech - Computer Education Center

Testimonials

Janhavi Kabra Sept 12, 2019

Google
One of the best classes in Kalyan. I have always found the computer as a boring subject but never felt so after joining this class

Tanay Waghchoude Sept 10, 2019

Google
Great Staff, Had a nice experience here. Would definitely recommend. Teaching experience is one of the best.