EXCEL/Access/SQL Training For Corporate @ GITS Technologies Bangalore

  • Location: Jayanagar 8th Block, Bangalore, Karnataka, India
Contact This Owner Share This Page

We take this opportunity to introduce ourselves as ‘GITS Technologies’ a Leading name in Corporate IT Training.
We provide training for analytical software like Advance Excel and SAS for Analytics.
Our Advance Excel Training Includes:

1.Advanced Data analysis and Data Management using Excel 2007/2010.

A) Advanced Data Analysis: - Pivot tables & Reports, Goal seek, Solver function, Scenarios, Data tables Data Analysis, Data validation, Formatting and conditional formatting
B) Data Management: - Organizing Data, Sorting and Filtering, Grouping and outlining data, Data subtotaling, Subtotaling, grouping and filtering data, advanced functions in Excel, Lookup functions, Mathematical functions, Text, database functions and Data consolidation, macros writing in Excel/VBA. Duration: 20hrs….

2. VBA/macros programming in Excel.

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…

3. Advanced VBA/macros programming in Excel.

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 , RibbonX, Interacting with Other Office Applications, Data Access with ADO, Managing External Data, Programming the VBE,…. Duration: 30hrs…

4. MS Access.

OOPS, Advanced programming Concepts, Active X Controls, Conversions, Automations, ActiveX Data Objects, Set Forms Reports, Properties, Criteria Statements, Error Codes, Functions Etc.

5. SQL Server Training2008:

Microsoft SQL Server 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 Etc.


TIMINGS:

We are providing classes during weekdays/ weekends (2-3 hrs)
Training given by Real time expert.

Workshop Inquiry / Corporate Training Inquiry/ Class room / Online Training Please Contact us:
GITS Technologies

Mobile:- +91 8792590942, 9632240775,9591498683
Email.id- [email protected]

Corporate office: - # 16 3rd Floor, 10th cross, Sampige Road, Malleswaram Bangalore-560003 Landmark: Above Vijay a Bank.

Jayanagar Branch-No.719/A, 4th Floor, J K Towers, No.53-2, 46th Cross, Sang am Circle, Jayanagar 8th Block, Bangalore – 560082

Sponsored Links

Useful information

  • Avoid scams by acting locally or paying with PayPal
  • Never pay with Western Union, Moneygram or other anonymous payment services
  • Don't buy or sell outside of your country. Don't accept cashier cheques from outside your country
  • This advertisement belongs to third party advertiser.
  • You expressly acknowledge and agree that use of this advertisement and this service is entirely at your own risk.
  • No warranties or representations about the accuracy or completeness of the website's content or of any third party websites linked to this advertisement
  • This site is never involved in any transaction, and does not handle payments, shipping, guarantee transactions, provide escrow services, or offer "buyer protection" or "seller certification"
  • For Further disclamier policy http://pearlweb.in/disclaimer-policy-p29
  • For Safety policy http://pearlweb.in/safety-tips-p30

Related listings

  • CAD CAM Training Courses
    Professional & Short Term Courses New York (New York)

    Get to know about the important CAD/CAM software and also learn the skills and techniques of designing and manufacturing numerous products using CAD/CAM. Enroll yourself in a good ...

  • Training and Seminar
    Professional & Short Term Courses Parañaque (NCR)

    TRAINING: Early Childhood Education Computer Training English Proficiency Foreign Language For more information, Visit or Contact us: Linxprovi8-Parañaque Branch MILESTONE LEARNING...

  • Salesforce (Admin + Developer) Online Certification Training
    Professional & Short Term Courses New York (New York)

    Gain the knowledge required to manage CRM through marketing and management by enrolling yourself in an online training in Salesforce. Joining a training in Salesforce Combo (Admin+...

  • Online Software Testing Course
    Professional & Short Term Courses New York (New York)

    Learn the techniques required to validate and verify computer programs by joining an online training on any of the several software testing courses. This training enlightens the ca...

  • Java Training Institute in Velachery
    Professional & Short Term Courses Chennai (Tamil Nadu)

    AllTechZ Solutions (ATS) provides No.1 Java Training Institute in Chennai. ATS can proudly say that a trainee and candidates trained at our institute has very good response on the ...