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

• Writing your own command macro.

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