Computer Training, Computer classes, Computer tutor, Computer Institute, Computer Learning

Sarita vihar, Sangam vihar, Tigri, saket, Madnpur Khdar, Aasram, new delhi, Palla, 37-sector, 91-sector, Surya vihar, Vinay Nagar, Agwanpur, Tilpat, Harkesh Colony, Pop Colony, Dheeraj nagar, Surdas Baba Colony, Sarai Faridabad.

www.scpinfotech.com 

Computer Training, Computer classes, Computer tutor, Computer Institute, Computer Learning

SCP INFOTECH INSTITUTE

Computer Training, Computer classes, Computer tutor, Computer Institute, Computer Learning,

Sarita vihar, Sangam vihar, Tigri, saket, Madnpur Khdar, Aasram, new delhi, Palla, 37-sector, 91-sector, Surya vihar, Vinay Nagar, Agwanpur, Tilpat, Harkesh Colony, Pop Colony, Dheeraj nagar, Surdas Baba Colony, Sarai Faridabad.
www.scpinfotech.com
Call- 9289714745

"SCP INFOTECH INSTITUTE"

Tilpat, Palla, Sahetpur 91-sector, surya Nagar, Faridabad.
www.scpinfotech.com

Celebrating chaath pooja

Celebrating Chhath pooja NOV 2015.
BABA SUR  Mandir, Tilpat, Faridabad NCR.

Sangam Vihar training center

Sangam Vihar training center New Delhi.
These days running paid course and gov. Projects like NDLM, PMKVP

Children day 2015

Himanshu Rawat submitted project nov 2015

"Diwali Offer" Basic Computer, Tally Erp9, DCA, DGD, DFA, ADIT, adv. Excel. SCP INFOTECH INSTITUTE Pop Colony, Tilpat, FBD.

"Diwali Offer"
Basic Computer, Tally Erp9, DCA, DGD, DFA, ADIT, adv. Excel.
SCP INFOTECH INSTITUTE
Pop Colony, Tilpat, FBD.

10% Discount Diploma course

Learning computer course

Lern computer

50% off for Girls

Neha chauhan received certificate

Tilpat Faridabad center

Computer center Tilpat Faridabad www.scpinfotech.com

Computer center

Jai Mata di

Manish kumar received certificate

Durga pooja 2015

Tilpat, Faridabad

Offer

Sarita Vihar center

Evening batches Oct 2015

Sarita Vihar center

Morning Batches

Tally ERP9

Sarita vihar, Sangam Vihar and Tilpat

More details- www.scpinfotech.com

Sarita vihar, Sangam Vihar and Tilpat

More details- www.scpinfotech.com

Advertising oct 2015

Advertising roadside

Tilpat, Faridabad center

Center opening 2015

Sarita Vihar center

Morning batches

Sarita Vihar center

Students Oct 2015

Students Oct 2015

50% Discount for girls only Oct 2015

Sarita Vihar

Offer Oct 2015

C language student Yogesh Kumar Sarita Vihar south Delhi.

Received your certificate.

Offer Oct 2015

SCP INFOTECH INSTITUTE
Sarita Vihar

Offer oct 2015

Offer navratri

Offer navratri

Course details

This course list valid for Faridabad center.

more details - www.scpinfotech.com 

Course offered

More Details - www.scpinfotech.com

Tally course details

Tally ERP9 course offered

"SCP INFOTECH INSTITUTE"

NEW DELHI-110076.

TALLY ERP 9 TRAINING
SARITA VIHAR, NEW DELHI
SANGAM VIHAR, NEW DELHI
TILPAT, FARIDABAD

CALL- 9289714745.

50 % Discount for Girls Student

Learn Computer
50% Discount for Girls

       * Diploma In Financial Accounting (DFA)        

        * Web Designing,  * ADIT  ,  

        *DGD, DCA

      

***********  Please  Contact  *************

Ph: 01129949510,   9289714745

1010/121, E-Pocket, Sarita Vihar, New Delhi-76.
www.scpinfotech.com 

Advance Excel course details

SCP INFOTECH INSTITUTE

            COURSE LIST

Advance Excel 2003 / 2007 / 2010/ 2013

This program is designed for executives who are already familiar with the basics of Microsoft Excel, and who would like to work with more advanced features of Microsoft Excel that help in improving their efficiency of working with worksheets, analyzing data, creating MIS reports, and automating various tasks.

TOPICS COVERD

Overview of the Basics

Customizing common options in Excel
Absolute and relative cells
Protecting and un-protecting worksheets and cells

Working with Functions

Writing conditional expressions (using IF)
Using logical functions (AND, OR, NOT)
Using lookup and reference functions (VLOOKUP, HLOOKUP)

Data Validations

Specifying a valid range of values for a cell
Specifying a list of valid values for a cell
Specifying custom validations based on formula for a cell

Working with Templates

Designing the structure of a template
Using templates for standardization of worksheets

Sorting and Filtering Data

Sorting tables
Using multiple-level sorting
Using custom sorting
Filtering data for selected view (AutoFilter)
Using advanced filter options

Working with Reports

Creating subtotals
Multiple-level subtotals
Creating Pivot tables
Formatting and customizing Pivot tables
Using advanced options of Pivot tables
Pivot charts
Consolidating data from multiple sheets and files using Pivot tables

More Functions

Date and time functions
Text functions
Database functions

Formatting

Using auto formatting option for worksheets
Using conditional formatting option for rows, columns and cells

Assignment & project Works

Course Duration	Fees (Indian Rs.)
20 Days	2000	1 hour p.d.