ApnaCourse 15% Off Offer
Online Training Course on Excel 2013 Expert - VBA and Macros (MS Excel 2013 VBA & Macros)

MS Excel 2013 VBA & Macros

173 learners in this course
(10)
RATINGS
1
REVIEWS
Course Faculty
 WIN
Leading Excel Corporate Trainer with 14+ yrs training experience. more>>

Self Paced Learning


Learn at your convenience anytime, anywhere
For 180 days access
$ 38.89
Enrol Now
OR
Learn for free with
Privilege Membership
Course Offerings
  24 lecture topics
  7+ hours of video lectures
  1+ practise tests with solutions
  Interactive discussion forum
Special Add-ons (Free with Course)
Certificate for Excel 2013 Expert - VBA and Macros (MS Excel 2013 VBA & Macros)
Certificate
Course Completion Certificate will be issued by WIN Corporate Training Institute
*Important: Certificate will be awarded only after completion of all video lectures, Practise Test and the online Final exam.
Not sure if its the right course ?
Free Preview( 30 minutes )
Or
Get in touch with our Career Consultants
This course has a 100% Money Back Guarantee
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.
Curriculum
I
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  
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
There are no limitations in accessing our courses. You can assess the courses through the web (ApnaCourse.com) on any device through a web browser or through our Android app available on the Google Play Store.
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 are Live Online Classroom courses that are date and time specific. Please visit the respective course page to know more.
No. If a course access expires, you will have to pay to extend the access. You can view the course pricing in the respective course page
We provide high quality content and personalised services. Our courses are delivered only by Renowned Trainers and Training Institutes. Also, the courses are recorded in state-of-art recording studios to bring in high clarity videos. So why go elsewhere, when you can learn from the Best!
We offer a course completion certificate on most courses. This certificate is jointly given by our partner trainer or training instiute which provided the course.
For any course-related information, please email at support@apnacourse.com or connect on our help line number +91 7353 60 5333.
Yes. We have a career consulting feature on ApnaCourse where a subject matter expert will help you decide the relevant courses for you based on your profile, work experience, interests, career goals etc. To know more about career consulting, click Here.
Mr. PRATIKKUMAR DHANSUKHBHAI TANDEL
Engineer, ISGEC Hitachi Zosen Ltd
Good basic concepts and step by step learning

Learn on the Go!

  • Offline Courses |
  • Sync Progress |
  • In-app purchases

Interested in training your team or creating private courses?