Excel 2007 Online Training - Certified Trainer

Mindstream Infosolutions
Aishwarya Arcade, #599, 12th A Cross
8th Main Road, J P Nagar 2nd Phase,
(Dessault Systems)
080 – 4120 9586 / 99869 82401/
Mindstream Infosolutions trains students in advanced technology and involve them in their Real Time project development with the help of development teams. This training provides students in getting the real time project work in MNC Company and provides placement assistance for the students.

Training: Corporate training given relevant to the project by our Instructor.
Title: List would be provided to the students and they can select of their own choice.
Project Type: complete project according to student’s requirement
Project report: Student will be guided to prepare project report by the guide..
Duration: 1-6 Months according to the convenience of the students.
Certification: Project completion certificate and On the Job Trainee certificate.
Placement: On successfully completing the project. (Reference provided from last year placed students).
Requirement: An authentication certificate from the respective Institution

Hi I am a Microsoft Certified Trainer for MS Office and MS Excel. For any training requirement I am reachable at 9820435736 or 022-2032 7559, pradippardeshi@gmail.com

MS Excel 2010 Training @GITS Academy

We take this opportunity to introduce ourselves as ‘GITS Academy’ 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.

For more details please contact us at. 9632240775
Or mail us at –
Please contact:-
GITS ACADEMY
#16,3rd floor, 10th cross, Sampige Road
Above Vijaya bank, Malleswaram, Bangalore=560003.
Contact: 080-23467842, 9632240775
Gits Academy
Mail: ,