NDLM certificate distribution Sarita Vihar, New Delhi. www.scpinfotech.com

NDLM certificate distribution Sarita Vihar, New Delhi. www.scpinfotech.com

Ravi kumar received certificate February 2017. www.scpinfotech.com

Ravi kumar received certificate February 2017.
www.scpinfotech.com

Evening batches February 2017. www.scpinfotech.com

Evening batches February 2017.
www.scpinfotech.com

Our Salient Features - SCP INFOTECH INSTITUTE

SCP INFOTECH INSTITUTE

Our Salient Features

 Advance computer lab with LCD monitor -

One PC per student!!!

 Complete Study Material – of Cost!!!

 English speaking classes- of cost!!!

 Fully AC computer lab – No Garmi !!

 Full Power Backup – No disturbance to lab

classes!!!

 Qualified & Well-Experienced faculties.

 Personality Development & Interview

Preparation – free of Cost!!!

 Up to date courses – Be competitive!!!

 100 % Job placement – Secured Future!!!

 Online examination system – To evaluate

student’s performance!!!

 Highly Trustworthy and stable – Running

successfully since year 2001!!!

Advance Excel & MIS Report in Sarita Vihar Training Center

Advance Excel & MIS Report

Course Contents:- 
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

Mis Report

Assignment & project Works

Duration - 1 Month

Eligibility 12th Pass

For course duration and fees please contact us: 9289714745,011-29949510.

More Details- www.scpinfotech.com 

Course Offer SCP INFOTECH INSTITUTE

With expertise in the sphere of I.T Education, we offer a wide range of courses. These courses are designed in accordance with the existing global scenario and requirements. As our courses meet international standards, theses are well received in the corporate world. Our alumni are working with some of the reputed names in the corporate world. They are applauded across the industry circle, for their spectacular knowledge and practical skills in the I.T domain.
Types of courses
Considering industry requirements and students/learners interest, we have divided our wide range of courses into following three categories:-> Certificate

 Diploma

 Advance Diploma

Diploma Course1. (DFA) Diploma In Financial Application

(DFA) Diploma In Financial ApplicationCourse Contents:-

Module - I

Computer Fundamentals, TypingMS-Word, MS-Excel, MS-Powerpoint, MS- Access Advance Excel, Hlookup, Vlookup, Match, Index FunctionDatabase, Mathmetical, Text, Logical Function, If, Sum if, etc.MIS Report & Praticale Work InternetSearching & DownloadingE-Mial, Attaching, FacebookGoogle+, Search Rail-TicketSend Mobile sms.Module - II
Tally ERP9
Concept of Financial AccountingTally ERP9, Accounting Info, Inventory Info, Laser Creation/ Altration / Deletion / Bill/ Challan/ Voucher, Accounting Voucher Inventry VoucherTally with Inventory, VAT, TDS, Service Tax, FBT, PayrollAssignment and Project Works

Duration - 6 Months
Eligibility 12th Pass

For course duration and fees please contact us: 9289714745, 011-29949510

2. DCA - Diploma In Computer Application3. DTP- Diploma In Desktop Publication4. DGD - Diploma In Graphics Designing5. ADIT - Advance Diploma In Information Technology6. ADCAF- Advance Diploma In Computer Application & Financial7. DCH - Diploma In Computer Hardware8. ADCHN - Advance Diploma in Computer Hardware & Networking9. CTTC - Computer Teachers Training CourseMore Details- www.scpinfotech.com

Diploma Course SCP INFOTECH INSTITUTE

Courses We Offer

With expertise in the sphere of I.T Education, we offer a wide range of courses. These courses are designed in accordance with the existing global scenario and requirements. As our courses meet international standards, theses are well received in the corporate world. Our alumni are working with some of the reputed names in the corporate world. They are applauded across the industry circle, for their spectacular knowledge and practical skills in the I.T domain.

Types of courses

Considering industry requirements and students/learners interest, we have divided our wide range of courses into following three categories:

-> Certificate

-> Diploma

-> Advance Diploma

Diploma Course

1. (DFA) Diploma In Financial Application

(DFA) Diploma In Financial Application

Course Contents:- 

Module - I

Computer Fundamentals, 
Typing
MS-Word, MS-Excel, MS-Powerpoint, MS- Access 
Advance Excel, Hlookup, Vlookup, Match, Index Function
Database, Mathmetical, Text, Logical Function, If, Sum if, etc.
MIS Report & Praticale Work Internet
Searching & Downloading
E-Mial, Attaching, Facebook
Google+, Search Rail-Ticket
Send Mobile sms.

Module - II

Tally ERP9

Concept of Financial Accounting
Tally ERP9, Accounting Info, Inventory Info, Laser Creation/ Altration / Deletion / Bill/ Challan/ Voucher, Accounting Voucher Inventry Voucher
Tally with Inventory, VAT, TDS, Service Tax, FBT, Payroll

Assignment and Project Works

Duration - 6 Months

Eligibility 12th Pass

For course duration and fees please contact us: 9289714745, 011-29949510

2. DCA - Diploma In Computer Application

3. DTP- Diploma In Desktop Publication

4. DGD - Diploma In Graphics Designing

5. ADIT - Advance Diploma In Information Technology

6. ADCAF- Advance Diploma In Computer Application & Financial

7. DCH - Diploma In Computer Hardware

8. ADCHN - Advance Diploma in Computer Hardware & Networking

9. CTTC - Computer Teachers Training Course

More details- www.scpinfotech.com

Courses We Offer SCP INFOTECH INSTITUTE

Courses We Offer

With expertise in the sphere of I.T Education, we offer a wide range of courses. These courses are designed in accordance with the existing global scenario and requirements. As our courses meet international standards, theses are well received in the corporate world. Our alumni are working with some of the reputed names in the corporate world. They are applauded across the industry circle, for their spectacular knowledge and practical skills in the I.T domain.

Types of courses

Considering industry requirements and students/learners interest, we have divided our wide range of courses into following three categories:

-> Certificate

-> Diploma

-> Advance Diploma

Certificate Course

1. (BCC) Basic Computer Course

This course is very helpful for the students who have not any experience with computers can learn the basics in this class. Fundamental operations and functions of the computer will be covered. Knowledge of Microsoft Office is extremely important when searching for a new job. Many employers expect job seekers to have a basic understanding of MS Word, Excel and PowerPoint. This class typically covers the basics of how to set up a document, use a spreadsheet and create a presentation or Internet brosser.

(BCC) Basic Computer Course

Course Contents:- 
Computer Fundamentals, 
Typing
MS-Word, MS-Excel, MS-Powerpoint,
Internet
Searching & Downloading
E-Mial, Attaching, Facebook
Google+, Search Rail-Ticket
Send Mobile sms.

Duration - 3 Months

Eligibility 8th Pass

For course duration and fees please contact us: 9289714745, 011-29949510. 

2. (BCC Plus)- Basic Computer Course Plus

3. (CICA) Certificate In Computer Awareness

4. (CT) Certificate in Tally ERP9

5. Advance Excel & MIS Report

6. Certificate In Java

7. Certificate In C Language

8. Certificate In C++ Language

9. Certificate In Advance Internet

Sarswati pooja 2017. SCP teem & students.

https://plus.google.com/+SCPINFOTECH/posts/iFUGvmbAWYo?_utm_source=1-2-2

Congratulations all students and our faculty Mr. Virendra or satendra for Successful completed sarswati pooja 2017. 👍🏿

http://scp-infotech-institute.tumblr.com/post/156715996845/congratulations-all-students-and-our-faculty-mr