MS Excel 2013 VBA & Macros


203
Learners
This Online Training Course on MS Excel 2013 Expert Level covers the concepts of Macros and VBA in Excel. The Curriculum includes range objects, sub programs, user forms, data writing and more. This course is delivered by WIN Corporate Training, a leading Training Institute on Excel for over 14 years
Course Faculty
WIN Corporate Training
Leading Excel Corporate Trainer with 14+ yrs training experience. more>>
Basic Course Offerings
24 Lecture Topics
7+ Hours of Video Lectures
Course Specials
1+ Practise Tests With Solutions
Interactive Discussion Forum
Course Completion Certificate
Basic Plan

  • 30 days Free access to Basic Course Offerings covering HD Video Lectures delivered by Industry Experts.
  • Videos may contain ads
INR 0
Enrol Now
EFY Times
Standard Plan

  • 180 days access to basic course offerings covering HD video lectures
  • Course specific discussion forum for anytime doubt resolution
  • Ad-free Videos
  • Course Completion Certificate
USD 46.67/USD 38.89
Enrol Now
Enterprise Plan

  • Ideal for multiple participants.
  • Single payment option for instant multi user on-boarding.
  • Attractive discounts on bulk purchases.
  • Option to include white labelled LMS with custom dashboard report.
  • Multi course selection available.
Course Overview
This Online Training Course on MS Excel 2013 Expert Level covers the concepts of Macros and VBA in Excel. The Curriculum includes range objects, sub programs, user forms, data writing and more.

This course is delivered by WIN Corporate Training, a leading Training Institute on Excel for over 14 years.

Course Curriculum
1 Macro VBA basics Part 1 17:37
2 Macro VBA basics Part 2 Preview 14:19
3 Variable Datatype 23:12
4 Comparison Operators 24:57
5 Condition Statement Part 1 20:37
6 Condition Statement Part 2 11:55
7 Loops 27:56
8 Excel VBA Objects 04:46
9 Workbook Object 32:10
10 Worksheet Object Part 1 07:16
11 Worksheet Object Part 2 23:41
12 Range Object Part 1 28:19
13 Range Object Part 2 22:11
14 Range Object Part 3 23:23
15 Range Object Part 4 21:30
16 Range Object Part 5 19:50
17 Range Object Part 6 18:07
18 Sub Programs in VBA Functions and Procedures Part 1 17:05
19 Sub Programs in VBA Functions and Procedures Part 2 15:11
20 User Forms and Controls Part 1 15:55
21 User Forms and Controls Part 2 07:37
22 Writing Data to the excel File using VBA 10:01
23 Sorting Filtering Charts Pivot Table in VBA Part 1 18:35
24 Sorting Filtering Charts Pivot Table in VBA Part 2 14:21
Excel Practise Test 1  
Excel Expert Final Exam  

Eligibility Criteria
Participants should have good knowledge on Excel features. Financial Analysts, MBA grads, Data Analysts and Professionals working on advanced excel functionalities will benefit from this course

Ratings & Reviews
Mr. PRATIKKUMAR DHANSUKHBHAI TANDEL
Engineer, ISGEC Hitachi Zosen Ltd
Good basic concepts and step by step learning

Frequently Asked Questions

There are no limitations in accessing the course. You can assess the course through the web (ApnaCourse.com) on any device

Most courses are self paced courses with a typical duration of 6 months (180 days) access period. This means, you get 180 access to the course from the moment you enrol into it. You can extend you access by 180 more days at any point during the subscription or post expiration of subscription. Some courses also support a Live Online Classroom courses that Virtual batches on specific dates.

Yes. If your access to a course expires, you can extend that through an online payment and continue from where you left of.

We engage only experienced and certified faculties for each course. Each faculty has decades of relevant teaching / training experience that they bring onto ApnaCourse. For details on their experience, please visit the Faculty section in the website.

We offer a course completion certificate on most courses. This certificate is jointly given by our partner trainer or training instiute who provided the course.

For any course specific doubts, there is an Online forum on ApnaCourse called Social Circle for every Course. Post your questions there and an expert would be able to respond on it. For general payment or enrolment related information, please email at support@apnacourse.com or connect our helpdesk.

Pl visit our detailed FAQ section at https://www.apnacourse.com/about/faq. If you still have doubts, feel free to contact our helpdesk.


×
×
Course Expert
WIN Corporate Training
WIN Corporate Training is run by renowned corporate trainer Mrs. Vijayalakshmi. Her delivery style and conversations are completely unique, practical and activity based which implants long lasting impact on participants. The trainer has 14+ years of experience in Technical Training. She has trained participants in Net, Java, Database and Advanced Excel with VBA Technologies. Clientele includes EY, Goldman Sachs, Axa, ABB, Deloitte, L&T Infotech, Oracle and many other top MNC's.
×
All batches are currently full