MS Excel 2013 VBA & Macros


190
Learners
1
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
WIN Corporate Training
Leading Excel Corporate Trainer with 14+ yrs training experience. more>>
Course Offerings
24 Lecture Topics
7+ Hours of Video Lectures
1+ Practise Tests With Solutions
Interactive Discussion Forum
Course Completion Certificate
Not sure if its the right course ?
Free Preview ( 30 minutes )
Or
Get in touch with our Career Consultants
This course has a
Online Training
  • 180 Days access to HD Video Lecture delivered by industry experts
  • Interactive Discussion Forum for solving queries.
  • Course Completion Certificate
New
This course is available only under Privilege Membership.
Privilege Membership: A pay-once access-all;subscription membership on ApnaCourse.com
Get access to 125+ courses at USD 133.31/ USD 66.64.
.
Enrol Now
Corporate Training
  • Hybrid (Online + Onsite) Learning Approach.
  • White Labeled Learning Management System (LMS).
  • Standard/customizable dashboards for individuals and teams.
  • Affordable Pricing.
  • Dedicated Account Manager.
Contact Us
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. Excel 2013 Expert - VBA and Macros
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
×
×
Course Expert
WIN Corporate Training
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