space
Search Courses  in 

Get CourseName COURSE FEES Instantly from BEST Training Institutes!

 

My City

I need details for

 

My Name

My Mobile Number

My Email ID

DATASAPRK Richmond Road - Excel,VBA,MS Access training at DATASPARK in Bangalore

 

DATASAPRK

 

Information

We take this opportunity to introduce ourselves as ‘DATASPARK’ a Leading name in Corporate Analytics 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 2003/2007.
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: 25hrs…
3. Advanced VBA/macros programming in Excel with project work.
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.
Timings:
We are providing classes during weekdays/ weekends (2- 4 hrs).
Training given by Real time expert.


Please contact:-
DATASPARK
#63,1st flr, opp shanthi nagar BMTC & big bazaar,
KH road(Double Road), Bangalore-27
info@dataspark.co
www.dataspark.co
Phone : 080 42076582
Mobile: +91 991690 1129


 

Course Information

MS Access,VBA,SAS,Excel,SQL

 

Contact Information

Address: DATASAPRK,
#63, KH road(Double Road)
Address2 , Bangalore , Richmond Road
PH: 08042076582 , 09916901129
Website: www.dataspark.co
Email: info@dataspark.co
TrainerDesk Training Jobs

 

JetKing Bangalore

 

IIHT Bangalore

 

Balc BangaloreHybritic Informatics

 

Training course fee & Discounts