contactus
facebook
twitter
twitter
linkedin
youtube
googleplus

Visitor :

Demo Class
Course Enquiry Call 011- 43522158, +91-9654382235
logo
enquiry

Now you can Dynamically increase your productivity with the help of MS-Excel.By enrolling for this program not only you will acquire advanced level knowledge of spreadsheets, worksheets,tabular data and charts. you will also get your work done much faster.thus all working professionals & freshers looking for job opportunities in Banking,Insurance, FMCG,BPOs,KPOs & retail Sectors increase your proficiency so that you have a lot more time to spare for fulfilling day at work.

Course Duration: 35-40 HRS with Highly Skilled Trainers

Attitude's VBA/Dashboard Training Delivery Method:
  • Web / Desktop Base
  • Instructor-Led Classroom Sessions
  • Presentations/Demonstration/Practical of Concepts.
  • Handouts/Assignments/Real-time Exposure to Work on Clients

DASHBOARD & VBA Objective:

Dashboard Reports Allow User to Get High-Level Overview of the Business and Help Them Make Quick Decisions. Dashboards are Often Called as Management Information System (MIS), Which Provides Information that Organizations Require to Manage Themselves Efficiently and Effectively.

Introduction to Programming Introduction to logical thinking flowcharts & algorithms:
  • Define Objective, Start & End Points; Identifying Solution & Breaking it Into Sequential Steps Writing a Algorithm
  • Step-by-Step Instructions, Flowcharts, Process Flow Diagrams. Excel Macros - an Introduction
  • The Power of Macros - What, When, How to use Macros. Introduction to Object Oriented Programming
  • Objects, Its Functions, Methods and Properties Introduction to Events
  • Details of Events, How & When to use of Events, Preparing to 'Macro' Visual Basic Editor (VBE) Developer Tab, Security
  • Introduction to the VBE, Properties window, Project Explorer, Password Protection of Code How to use the VBE - Features, Options, Intelligence Technology
  • Debugging Mode, Bookmarks, Breakpoints, Watch Window, Immediate Window and Locals Window Inbuilt VBE Help Feature - Tips and Tricks.
  • Terms like 'Compile', 'Debug' 'Keywords' etc. Recording Macro
  • If and when to use Macro recorder with the code More On Excel Macros - I Structure of an Excel Workbook from VBA Point of View - Common Objects
  • MS Excel Objects like Applications, Work sheets, Workbook, etc. Coding plate form , Variables and Constants
  • What are Variables and Constants?
  • Type of Variables; How and When to use Variables to Store Information.
  • Typical Variable Naming Prototype
  • When to use Constants or Variables More on Excel Macros - II Loops
  • For-Next, For-Each, Do-While, For Each Loop Decision-Making and Code Branching
  • If-Then-Else, Select-Case, And/or Conditions User Defined Functions (UDF)
  • What are user’s Defined Functions? How to createÿ & use them. Form Controls vs. ActiveX Controls Getting into the Code Msg Box and Input Box Working with Data in Excel
  • Data Types in Excel Worksheets, Like Dates, Texts, and Nulls etc. Working with Workbooks, Worksheets Ranges and Cells etc.
  • Working with Dynamic Ranges. Protecting Worksheets, Cells and Ranges. Working with Multiple Files Opening & Saving Files Introduction to User Forms
  • Working with User Forms & User Forms Events
  • User form Controls
  • How to use Data Validation in the Control
  • Use of Text Box, Label, Drop down, List box, Image Box
  • What is the Use of Message Box in VBA
  • Searching Data into to the Database and finding records from the database
  • Connecting VBA to Outlook
  • Working with User Forms & User Forms Events
  • Sending Email to Multiple Users Through VBA
  • How to Establish Connection Between VBA and Internet Explorer to Open any Internet Website Through VBA
  • Data Validation & Input Restrictions Effective Coding
  • Testing and Debugging Your Code
  • Effective Error Handling
  • Automation Development Report & Live Project

ATTITUDE offers 100% job guarantee practical career courses after 12th, Graduation in commerce or non commerce

Job & Career Options available after VBA/MACRO,Dashboard Certification

  • Investment Banking Analyst
  • Management Consultant
  • Accountant
  • Marketing
  • Business Intelligence Analyst
  • Management
Placed Learners
Download Brochure
testimonial
Hi I found the institute truly managed in professional way the name signifies its core vlaues faculties are professional in their approach.Cleaniless and simplicity are beyond imagination.

Ajay Sharma

testimonial
Nice Institute for better career prospect for trainees. The trainers were having great knowledge about corporate sectors and guide us well.

Vishal Kaushik

testimonial
Excellent way of training by trainers, simply superb! Overall all supporting staff in institute & best placement team to serve .

Hatim Tanwar

testimonial
it was really a good experience with Attitude Academy. They provided me a Very Good platform to learn and gain enough knowledge in Accounting & Taxation Course.

Anuj Raghav

testimonial
Attitude Academy support person understood our problem properly. Their service & support found quick, solution oriented. Our problem resolved perfectly. Thanks.

Pooja

testimonial
This is my first Chance to Attitude Academy. I am very happy with the solution from Attitude Academy & offcourse He provided instant support very quickly. So very thanks for him.

Sneha Saini

testimonial
Attitude Academy is Those who are using the tally, have any problem related to tally Definitely I will advice you contact Attitude Academy for tally support. Thanku very Much

Mansi

testimonial
No institute is best other than Attitude Academy for Fashion. the teaching methodology is very different from other institutions. very thanks to teacher.

Simran

testimonial
i am very much satisfy from attitude academy support. attitude system will support immediately even after office hours also. Thanks very much.

Uzma

testimonial
AttitudeTallyAcademy(ATA)is a very well respected YamunaVihar location in Delhi. ATA has been a Home away from Home for me. The Frndly attitude of the staff and their willingness to always offer a helping hand has made me feel a part of the

Rohit

testimonial
Here at ATA, you meet all the good, friendly people – from students to lecturers. You enjoy freedom to think, to express yourself and to succeed.

Krishna Verma

testimonial
With the help of ATA I have substantially improved my understanding of Information Technology . ATA is simply an example of studying in a congenial environment.

zahid hussain

testimonial
When I started thinking about attitude Tally Academy, I wanted to find an internationally respected program that balanced Accounts theory with practical skills, and provided a knowledgeable, accessible faculty. Thanku attitude academy :)

mohit kumar

testimonial
"In order to get a first class education, Attitude Academy is the most appropriate place to start!"

Rishi Anand

testimonial
"I enjoyed studying at Attitude Academy as all of my teachers were great and helpful."

Shyamanand

testimonial
"Studying at Attitude Academy has been one of my best decisions ever."

Rais Ahmad

testimonial
"While studying at Aattitude Academy, I grew as an individual, learning to interact and talk to people from different backgrounds."

Dipanshu

testimonial
"I have always felt that I was so lucky to be a student at Aattitude Tally Academy, and not at any other Academy. The thing I admire the most about Aattitude Tally Academy is the support I received from everyone at the Academy.

Sumit Gaur

testimonial
Institute services is very good ,Faculties are well qualified in this institute , I like my course very much, Rahul sharma is my teacher he has good knowledge of Web,Graphic designing

Anuradha

testimonial
Deep in the Dark forest there is a beautiful garden of knowledge , Where techie Butterflies are play around the flowers of technology. ATTITUDE just not trained for technology but it trains people for their success in their life .

Divya

testimonial
For me ATTITUDE is the best decision I ever made because it combines knowledge, virtues and creativity. For students, implied knowledge is very useful and ATTITUDE is a very good platform for career.

Bhawna Kaushik

testimonial
A life changing experience. ATTITUDE provides excellent opportunities to fresher. Those who want both good knowledge and good career in Accounts and IT sector must join ATTITUDE. I felt very glad as my dream comes true .

Muskan

testimonial
I am proud to be a part of ATTITUDE. I had a chance to do more practical things rather the just reading theory. Everybody here in ATTITUDE are very helpful .and I would like to thank Turab sir for being my teacher .

Avinash Sharma

testimonial
Deep in the Dark forest there is a beautiful garden of knowledge , Where techie Butterflies are play around the flowers of technology. ATTITUDE just not trained for technology but it trains people for their success in their life .

Jatin Goel

testimonial
A life changing experience. ATTITUDE provides excellent opportunities to fresher. Those who want both good knowledge and good career in Accounts and IT sector must join ATTITUDE. I felt very glad as my dream comes true as I got good job frm

Priya

testimonial
I Piyush student of B.Com, has done training from ATTITUDE, is grateful to this institute where I learnt, enhanced my knowledge and technical slot. This institute is the best place not only for Tally but for all accounting concepts .

Piyush

testimonial
I had a great expercience with ATTITUDE all the staff of ATTITUDE was very helpfull including teachers and hrdepartment.I would like to thanks specially Turab sir and Kanchan mam for their great support and solve my queries whenever i have

Savita Gupta

testimonial
I feel really proud of to be a part of ATTITUDE. I have had a great time. Here I came to learn so many practical things here, first of all I would like to pay my thanks to Mr. Sachin Sharma for training us so well and for creating the spark

Dheeraj Sharma

testimonial
Just a quick Note to say thanks ATTITUDE .I am proud to be part of ATTITUDE . Here every staff and Teachers are very Co-operative with Students .I Would like to thanks Mr. Puneet sir he is very kind person he Taught me IT Skills .

Nasir Malik

testimonial
I am proud to be a part of ATTITUDE. I had a chance to do more practical things rather the just reading theory. Everybody here in ATTITUDE are very helpful .and I would like to thank Turab sir for being my teacher .

Piyush Gupta

testimonial
For me ATTITUDE is the best decision I ever made because it combines knowledge, virtues and creativity. For students, implied knowledge is very useful and ATTITUDE is a very good platform for career.

Aashu Thakur

ENQUIRY NOW