Ourselves as ‘GITS Academy’ a Leading name in Corporate Business Analytics and Services.
Learn Advanced Excel, VBA macros & SQL Server 2012 by Real Time Experts
The demand for These Courses- professionals is growing at very high
pace throughout the world in all Domains like MIS Executive, Macros Programmer & SQL Server Developer…. etc.
We at GITS Academy, provide training for Excel Advance, VBA Macros- Basics & Advanced & SQL Server-2012.
We offer a wide range of advanced courses in the fields of Business these training programs are also available to those professionals looking to obtain additional Skills to their profile.
Analytics is the science of examining raw data with the purpose of drawing conclusions about that information. It is used in all industries to allow companies and organization to make better business decisions and in the sciences to verify or disprove existing models or theories...
• Special Guidance for Certification.
• Real Time consultants
• Trainer’s profile: More than 5 years industry expert.
• Training Methodology: Completely hands on training with real time examples
• Feel free to call me for any clarification. Please find training agenda in
Advanced Excel -2007/2010
We cater to Excel training needs with special focus on advanced excel that would include MIS Reporting Tools Like Pivot tables & Reports, Goal seek, Solver function, index and match, Scenarios, Data Management & different kind of functions Look up, Finance Statistics & all 24 Types of Mathematics
Advanced Filters, Data validations, grouping, using macros in Excel,
Array operations and a host of other excel operations and many more.
• MIS Reporting Tools
• Advanced Functions-Lookup, Statistics, Finance & Mathematics
• Forecasting Data’s
• Formulas & Conditions
• Macros Introductions
• VBA Intermediate
• VBA Advanced
VBA Intermediate-Introduction to VBA, VBA Procedures, User Forms, Creating Multiple Pivot Table, Modifying Pivot Table, Excel’s Events, Interacting with Other Applications, Controlling Program Flow and Making Decisions IF, If Else, Else if, Select...While Error-Handling Techniques, Bug Extermination Techniques Etc. Duration: 20hrs…
Advanced VBA-Primer in Excel VBA, Workbooks and Worksheets, Using Ranges, Using Names, Data Lists, PivotTables, Charts, Event Procedures, Adding Controls, Text Files and File Dialog, User Forms , Ribbon X, Interacting with Other Office Applications, Data Access with ADO, Managing External Data, Programming the VBE,…. Duration: 30hrs…
SQL Server 2012 Training
Microsoft SQL Server 2012 is an application used to create computer databases for the Microsoft Windows family of server operating systems. Microsoft SQL Server provides an environment used to generate databases that can be accessed from workstations, the Internet, or other media such as a personal digital assistant (PDA). Database and Relational Database Management systems, Data Types, Creating, altering and manipulating tables, Data Manipulation language: using select, insert, update and delete commands, Using filter clauses, operators and SQL functions, Column & table alias joins, Queries and indexes triggers, stored procedures, Etc. Duration: 24hrs…
We are providing very flexible timings (Mon-Friday/2 Hrs Per day) Weekends (Saturday OR Sundays/4 Hrs Per day)
For More information on Course Details, batch schedules, fee structure
and Registration Please contact: 080-23467842 OR 9632240775
#16,3rd floor, 10th cross, Sampige Road
Above Vijaya bank, Malleswaram, Bangalore-560003.
Contact: 080-23467842 OR 9632240775
719/a, 53-2, JK Towers, 4th Floor,
46th Cross, Jayanagar 8th Block,
Bangalore, Karnataka 560082.
“BEST UPCOMING Business Analytics Training Institute in North Bangalore”