+91 8411002339 +91 7709292162 info@dw-learnwell.com
You are visiting a Pearson VUE/KRYTERION/PSI authorized test center. Get Trained, Get Certified - All under one roof.

Excel/VBA


Microsoft Excel is one of the technology which every one need to know, since it is required and used in most of the organizations for most common things. It is required for students, required by MBA candidates, is it required by Business Analyst, and more over it is also required for basic Data Analytics. Using Excel you can do various type of data analysis and reports creation activities. Microsoft excel have features of basic usage to the Macros, Pivots and upto report and dashboards which is generally called VBA.

Course Duration: 40-45 Hours Excel/VBA

  • 40-45 Hours extensive Training
  • Video recording of the sessions
  • 70% Practical and 30% Theory
  • Live Industry Oriented Scenarios
  • Life time free Software
  • Study Material, Question Bank
  • Interview Questions, Scenario assignment
  • Live Project
  • Resume Modification – Convert existing experience to show Excel and VBA experience
  • 100% Job assistance
  • Assured Global Microsoft Excel/Office Certification
  • Basic/Advanced Excel
  • Day 1/2: Basic Excel and Orientation & efficiency - Excel foundation, Basic interface, Editing, Viewing, Spreadsheet Structure, Basic Macros and live practicals
  • Day 3/4: Administration - Customizing Excel, Connecting Workbooks, Protecting and Sharing, Documentation, Excel Troubleshooting and live practicals
  • Day 5/6/7: Data Handling - Sorting and Filtering, Controlling User Input, Working with Dates & Times, Working with Text, Lookup and Reference, Logical Functions and live practicals
  • Day 8/9/10: Working with Numbers, Summarizing Data, PivotTables - Simple Summaries, Manipulating Data, Interpreting Data and live practicals
  • Day 11/12: Macros - Understanding Macros, Creating new Macros, Formula Auditing and live practicals
  • Day13/14: Advanced Macros and live practicals
  • VBA
  • Day 15: What Is VBA, Introduction to VBA Window, Introducing the Excel Object Model
  • Day 16/17: Looping in VBA, VBA Sub and Function Procedures, Executing Sub procedures, working on Functions, Changing Excel Settings and live practicals
  • Day 18/19: Code Using Variables, Constants, and Data Types, Understanding variables, Working with Forms/Module/Active-X
  • Day 20/21: Working on advanced Macro Recording, Macro Integration, Pivot Charts and Tables
  • Day 22/23: Real time scenarios and more case studies.
Contact us for detailed syllabus.
  • Having 13+ years in IT Industry
  • Worked in MNC and involved in taking freelancing projects
  • Involved in Data Analytics using Excel
  • Experience of providing corporate training's.
  • Fresher’s those who wish to start a great career in IT Industry
  • Experienced professionals which reqiore Excel in their daily work
  • Business Analyst for the Technical touch
  • Manager’s for handling the team
  • Freelancer, for doing own development
  • Over 3,500 Candidates trained via Classroom, Corporate and Online Training’s.
  • Work on real time scenarios as faced in the MNC’s.
  • Work on real time Data
  • Learn from Experienced professionals working as Technical Lead and Managers in MNC.
  • Attend free Demo and decide
  • 24*7 Support via chat, mobile and Email.
  • Get help in Global Microsoft Certification.
  • Get Study material, Interview Questions, Software
  • Resume Modification to update existing skills with upto 3 years of Microsoft Excel/Office experience
  • 100% Job Assistance.

Students Speak Testimonials

Kirti Patel

Kirti Patel Independent Consultant

When I needed to broaden my Oracle skills, I approached Learn Well Technocraft, They gave me good insight into what was hot and trending in consulting market and recommended me training in Data warehousing/ETL and Informatica. I recommended their training to a friend of mine and he too was full of praise for the training program. I highly recommend their Training.

Rakesh Satpute

Rakesh SatputeAVP - Credit Risk Analytics & Reporting

I wanted to learn Data Analytics since it was needed in my job and nothing could have been better than to find a educator at Learn Well . 6 week (12-14 days) Woww!!, Initially i doubted will I be able to do it , but the brevity with which you briefed us through the topics was really very good. I would like to thank you for rescheduling the classes as per our convenience and would also like to thank you for staying in touch and clearing our doubts even after the commencement of the classes.

Hariharan Rajsekaran

Hariharan RajsekaranETL & Datawarehousing Consultant

The training's walked me through every step of the way in learning and marketing my new skills. Since I am in US, I took training online, they helped me setup my computer with necessary softwares, and delivered hands on training over Skype and Gotomeetings for several weeks, and helped me with preparing resume.

Sandip Pandey

Sandip PandeyTechnical Leader

First of all thank you so much for conducting a fantastic training. I am writing this as a feedback and i am sure everyone else in the batch is surely agreed with me that we had really nice training sessions. The methods, examples and concepts were very helpful in understanding the topic. Some of the really complex topics have been explained so well that it could easily understand for totally novice user.

Sandip Pandey

Vibha ThereBusiness Analyst

I would like thank the trainer and Learn Well Technocraft for delivering great sessions on 'Big data & Hadoop ' . Trainer has a great knowledge about Hadoop and delivered the sessions effectively . Keep up the good work guys !!!

Sandip Pandey

Anirudha LimayeSenior Developer ETL

We wanted to have database training for employees of our company, we were glad we took it from Learn Well. The wonderful thing was all sessions were totally practically oriented. The trainer they sent to our premises, were very qualified and professional. Our employees were able to complete the global certification also after the training.

Placements companies

Client name
Client name
Client name
Client name
Client name
Client name
Client name
Client name
Client name