MS Excel Training workshop Bangalore : DHS Informatics Pvt Ltd

[embraj]

DHS Informatics Private Limited is a training division of multi-national IT consulting and outsourcing firm Intersoft KK, which has head-quarters in Japan and branch offices in the United States, Singapore, Taiwan and an offshore development center in Bangalore, India.
DHS Informatics conducted many Corporate Training Programs in various technologies.
Course Duration : 2 days
Timing : 9.00 am to 6.00 pm (Total 16 Hrs of Training)
Advanced MS Excel Training

· Grouping of Worksheets
· Auto Fill Series-Numeric, Alphanumeric
· Creation of custom lists
· Data Validation-text,numeric
· Comments
· Conditional Formatting
· Paste Linking
· Transpose
· Named ranges
· File protection
· Basic Excel functions and introduction to Formulae
· Relative and Absolute cell referencing
· Mathematical functions-SUM,MAX,MIN,AVERAGE,COUNT ,COUNTBLANK
· COUNTIF,SUMIF-Several Scenarios
· Subtotals
· Conditional IF Statement-Simple,Nested,Multiple
· VLookup and Hlookup-Several case scenarios
· Auto Filters and Advanced Filters
· Date and Time functions and calculations
· Creating charts
· Need to represent data graphically
· Position of a chart
· Types of charts
· Guidelines on selecting a chart
· Titles, Gridlines, Legends
· Data labels and Data table
· Representing data graphically
· Choosing different types of charts
· Pivot Tables-introduction, concepts
· Using the List Function
Pivot table
· Source data for a pivot table-internal, external, internal or external
· Modifying a pivot table
· Pivot charts

Introduction to Macros

· What is a Macro?
· Three types of procedures.
· Recording a VBA Macro
· Viewing the resulting module.
· Editing a recorded macro
· Touring the Visual Basic Editor
· The Project Explorer
· The Properties Window

· The Work Area
[LIST][*]Writing your own command macro.[/LIST]
For further details contact:
Parveen - +91 98866 92401
Rajan - +91 98451 66723

DHS Informatics Private Limited,
52-53, 3rd Floor, Anam Plaza,
8th F Main, 3rd Block,
Jayanagar, Near ICICI Bank,
Bangalore-560034,
Karanataka, India.
Phone: +91 80 4130 7435 / 4130 1880

Email: parveen@dhsinformatics.com, rajan@dhsinformatics.com
Visit our website: www.dhsinformatics.com

[Guest-IJT]

Name : KANYAKUMARI SAHU
Email : nilooniloo5 AT gmail.com
Designation / Skillset : GRADUATE ENGINEER TRAINEE FRESHERS(IT)
KANYAKUMARI SAHU


Resume :

Career Objective :
To work in a reputed organization & to utilize my skills and potential to meet the challenge of growing demand.
- Computer Proficiency :
Languages : C, C++
Scripts : DATA STRUCTURES using C
Database : RDBMS
- Academic Qualification :
B.tech in INFORMATION TECHNOLOGY from Synergy Institute Of Engineering & Technology College,DHENKANAL under Biju Pattnaik University of Technology.
CGPA(UPTO 7TH SEMESTER) : 7.1.
Intermediate Science : Placed in First division with 65.0%, from JAWAHAR NAVODAYA VIDYALAYA,ANGUL(CBSE) in the year 2006.
Matriculation : Placed in first division with 83.8%, from JAWAHAR NAVODAYA VIDYALAYA ,ANGUL(CBSE) in the year 2004.
- Extra Curricular Activities :
State level kho-kho & javeline throw,
Got scholarship in primary School, I am a good singer.

- Hobbies :
Surfing the internet,Singing songs, Listening to Music.
- Strengths :
- Self confident and energetic.
- Friendly and flexible.
- Ability to quick learn and punctual.
- Declaration :
I do hereby declare that all the information furnished above is true to the best of my knowledge and belief.
Date : 01-07-2011
Place : ANGUL (KANYAKUMARI SAHU)
-------------------------------------------------------
More Information about this submission and submitter :-
___________________________________________________
Submission ID : 4335279
Date & Time : 6th Jul 2011 1:55 AM (UTC)
IP Address : 117.226.208.42
Browser Info : Mozilla/4.0 (compatible; MSIE 8.0; Windows NT 5.1; Trident/4.0; InfoPath.2)
Predicted Country : India

[Guest]

what is history of DHS Informatics pvt ltd?
When was DHS Informatics Pvt Ltd started?