What is the major concepts Excel VBA Training teaches?

Asked by Last Modified  

18 Answers

Follow 0
Answer

Please enter your answer

G Venkat Reddy

Oracle, Hindi, C++, C, MS Office, VBScript,JavaScript,Spoken English etc with 32 years of experience

- Macro programming - The Basics of vba - Variables,constants - Data types - User defined types - Working with operators - Reserved words - Control flow statements (if if else multiple else if select case statement) - Loops (for next for each do loop while wend statement) - Modules, functions,...
read more
- Macro programming - The Basics of vba - Variables,constants - Data types - User defined types - Working with operators - Reserved words - Control flow statements (if if else multiple else if select case statement) - Loops (for next for each do loop while wend statement) - Modules, functions, subroutines - Programming basics decisions and looping - Arrays – single multi dimensional - Strings and functions and message boxes - Degbugging - Error and the errors functions - Dialogs - Introduction to forms and various controls - Forms, label, textbox, combo box, listbox, command button , option button, check box, frame, image, - scrollbar, spin button controls methods and events. - Active sheets - How to work with other applications like ms word, ms power point, oracle read less
Comments
Dislike Bookmark

Post graduate

My personal view: if you are confining VBA only till excel..then you must learn excel first..I know there are a lot of people, who say they know excel coz they know vlookups, pivots..and other functions...but they do not know to use the functions efficiently..and to me it is all intermediate
Comments
Dislike Bookmark

Professional Tutor with 15 years of experience.

create user friendly environment and to make work easy
Comments
Dislike Bookmark

Software Professional Trainer with 26+ years of Experience in Software Design and Development

Basic like Variables, Constants, Branching and Decision making, Loops, Array, Procedure type and procedure calling, Object oriented programming, Object Properities and methods, Error Handling, Interaction with Database, Interaction with other application and more....
Comments
Dislike Bookmark

Training Centre

progamming
Comments
Dislike Bookmark

Tutor

Automating Excel Operations is the main objective of Excel VBA. It teaches programming for Excel using VBA to achieve the said objective.
Comments
Dislike Bookmark

Microsoft advance Excel, macros, VBA, Professional courses

VBA properties, Loops, and FSO
Comments
Dislike Bookmark

Collections, Objects, Methods, Properties, Loops and Decision instructions like if, if-else. These are the basic and major concepts. If you know these concepts in depth, later you can study remaining topics on your own.
Comments
Dislike Bookmark

MS Excel Expert

Looping and manipulating objects are the major concepts in VBA
Comments
Dislike Bookmark

Our Complete Course Package is: Introduction to Excel Introduction to MS Excel, quick review on excel options Navigating spreadsheets and Often-Used Terminology Basic data manipulation Working with worksheet- Edit, move/copy and delete worksheet. Formatting and processing data Advance function...
read more
Our Complete Course Package is: Introduction to Excel Introduction to MS Excel, quick review on excel options Navigating spreadsheets and Often-Used Terminology Basic data manipulation Working with worksheet- Edit, move/copy and delete worksheet. Formatting and processing data Advance function and formulas: Logical functions: AND, OR, NOT, IF, IFERROR, ISERROR, TRUE, FASE etc. Lookup and reference functions: lookup, vlookup, hlookup, index, match, offset, transpose, row, column etc. All date and time function Text manipulating functions Subtotal and data validation Text functions: Left, right, trim, mid, lower, upper, trim, trunc, convert, concatenate, dollar etc. Pivot tables and Pivot chart Creating Pivot table and pivot chart Type of pivot chart and their usages Changing and updating data range, pivot data filter, group-ungroup pivot data Formatting pivot table and pivot chart and making dynamic pivot tables and charts. Analyzing data with Excel Sorting Data: A-Z, Z-A, advance sort Filter: Use filter to sort data and advance filtering options What-if Analysis Consolidating data and worksheets Conditional formatting with multiple cell rules Statistical and mathematical functions: Match function: Sum, count, sumifs, countifs, sumproduct, round, random etc. State functions: stdev, ttest, correl, median, average, averageifs etc. Other analytics functions: rank, quartile, decile, percentile etc. Charts and graphs Simple chart Pie chart, bar chart, line chart, scatter plot, doughnut Curve fitting and distribution For VBA we cover following topics: Create a Macro Message Box Workbook and Worksheet Object Range Object Variables If Then Statement Loop Macro Errors String Manipulation Date and Time Events driven programming Arrays Function and Sub Application Object ActiveX Controls User form Interacting with Other Office Applications via Excel VBA Excel Dashboards After covering the above topics you will have fairly good knowledge of Excel/VBA for working in any company/Job. read less
Comments
Dislike Bookmark

View 16 more Answers

Related Questions

Make A Excel Software Challenge: To Track Time Records To Enhance Daily Output Of Staff
Through Time Sheets
Bikram Jeet
0 0
7
I have got over ten years in customer service. Currently working as a team leader in an MLM company. Will doing VBA course help me get a better package I am having CTC of 7 lakhs hoping to touch 8 to 9 lakhs CTC.
As you are a Team Leader, Learning VBA is not going to help you. You just need Basic Excel Knowledge to manage your team. VBA is for programmers who need to develop softwares. Learning VBA is like -...
Francis
0 0
5
How do you deal with large data sets in Excel?
if data rows are greater than 10L then u will use MS. Access
Ajay
0 0
5
What should I learn other than excel VBA training?
Excel VBA is a Very vast topic. Once you will start working on real life projects you will find your knowledge is always short. You can always learn VBA with Excel, Word, Powerpoint, Access, AutoCad, Soldiworks....
Vishal
Which course can be related to MIS executives, Since I have past experience in data base related job I want to try for MIS profile. So kindly suggest me which course suits me for the same profile.
Hi, You can check our course - Analyse and Visualize with Excel. Excel is the most popular tools used by analyst and MIS manager for getting insights from data. Create powerful Dashboards to enable data driven decision making.
Martin

Now ask question in any of the 1000+ Categories, and get Answers from Tutors and Trainers on UrbanPro.com

Ask a Question

Related Lessons

Why Option Explicit is Required in the VBA Editor
Hi Folks,Do you know Excel VBA Editor has functionality where you don't need to declare a variable in memory (DIM).But what will happen if you write a program without declaring a variable nothing happens?Then...

Kumar S

0 0
0
Generate Employee Payslip using Excel & VBA Macros
yes we can generate the Payslips for each employee from a huge data in the excel. We can generate a separate Excel sheet for each employee and also can create Payslip Excel files with the names of the...

Venkata Seshasai Kanuru

1 0
1
Excel Conditional Formatting
In this video, learn about Conditional Formatting, Creating Conditional Formatting Rules, Use Conditional Formatting Presets, Managing & Removing Conditional Formatting.

Mukesh Chopra

0 0
0
How Lookup function to replace Nested If statement
Nested If statements are complicated to type down and include many parameters. The best method to replace them is to use the lookup function. Using the lookup function shortens the formula at a considerable...

Kaustubh Chavan

0 0
0
Hidden Gems of MS Excel - New Window
You are working on 2 Worksheets in Same Workbook. To complete Your task, You have to frequently navigate between the Worksheets.Understandably, to frequently navigate between the Worksheets is inconvenient,...

Ankur Sharma

2 0
0

Recommended Articles

Why Should you Learn Microsoft Office

Microsoft Office is a very popular tool amongst students and C-Suite. Today, approximately 1.2 billion people across 140 countries use the office programme. It is used at home, schools and offices on a daily basis for organizing, handling and presenting data and information. Microsoft Office Suite offers programs that can...

Read full article >

Why Should you Become an IT Consultant

Information technology consultancy or Information technology consulting is a specialized field in which one can set their focus on providing advisory services to business firms on finding ways to use innovations in information technology to further their business and meet the objectives of the business. Not only does...

Read full article >

8 Hottest IT Careers of 2014!

Whether it was the Internet Era of 90s or the Big Data Era of today, Information Technology (IT) has given birth to several lucrative career options for many. Though there will not be a “significant" increase in demand for IT professionals in 2014 as compared to 2013, a “steady” demand for IT professionals is rest assured...

Read full article >

Make a Career in Mobile Application Programming

Almost all of us, inside the pocket, bag or on the table have a mobile phone, out of which 90% of us have a smartphone. The technology is advancing rapidly. When it comes to mobile phones, people today want much more than just making phone calls and playing games on the go. People now want instant access to all their business...

Read full article >

Find Microsoft Excel Training classes near you
Microsoft Excel Training classes in Bangalore
Microsoft Excel Training classes in Delhi
Microsoft Excel Training classes in Mumbai
Microsoft Excel Training classes in Hyderabad
Microsoft Excel Training classes in Chennai
Microsoft Excel Training classes in Pune
Microsoft Excel Training classes in Gurgaon
Microsoft Excel Training classes in Kolkata
Microsoft Excel Training classes in Noida
Microsoft Excel Training classes in Ghaziabad

Looking for Microsoft Excel Training classes?

Learn from the Best Tutors on UrbanPro

Are you a Tutor or Training Institute?

Join UrbanPro Today to find students near you