Pay Online

Important Links

Our Courses

Advance Excel

                                                Gateway Institute of I.T. & Mgt.
                                                  An ISO 9001:2001 Certified Institute
                                                    C-595, Vikas Puri, New Delhi-18
                                                       Ph. 9811599499, 9811678913




Advance Excel

Gateway Institute of IT & Management is an ISO 9001:2000 certified institute & is one of the oldest Distance Education Centre in New Delhi which provides all the Short term Computer courses.

At Gateway Institute we have specially design Advance Excel programme to make our students understand Advance Excel like a professional. To learn the Advance Excel only basic computer knowledge is required. Our especially design course for beginners and students will make you understand all the concepts from scratch and make you an expert. That is why we are the best Institute for advance excel training in Delhi.

We have specially designed practical exercises for our students to make our students understand the Advance excel very easyly.

The total programme of us, is plan-based that can reach the candidate to the uppermost level of success.

Duration: 4 Weeks

Eligibility: Basic Computer Knowledge

Contents
  • Introduction 
  • Using Excel lists
  • Creating a List
  • Sorting
  • To perform a Simple Sort
  • To Sort by Multiple Columns
  • Data Forms 
  • Adding Data Using the Data Form
  • Finding Records Using Criteria
  • Filtering Data
  • AutoFilter
  • Advanced Filters
  • Special Features for Filtered Lists
  • Totals and Subtotals Total
  • Row
  • Subtotals
  • Managing Windows
  • Multiple Windows
  • Splitting Windows
  • Freezing Panes
  • Linking Data
  • Option Menu
  • Analysis by goal seek
  • Analysis by pivot tables
  • V-Lookup
  • H-Lookup
  • DATA Consolidate
  • Insert Chart
  • Patrice Task
  • MIS
  • Scanning
  • Email Attachment & Download
  • MIS Convert into PDF
  • Password Protect
  • Theory
  • Complete Theory & Practical Training with unlimited Practice Time.
  • 24 Hrs Internet facility at no extra Charge

 Contact us for Admission :

Gateway Institute of I.T & Management
Address : C-595, Opp. PVR Cinema
Vikas Puri, New Delhi-18


Email : gateway_313@yahoo.co.in , smugateway@gmail.com

Mobile : (+91) - 9811678913 , 9811 599 499

Phone : 011-64673344, 011- 45717722

Click here to send query for Advance Excel admission and fees details.

Other Links

Graduate Courses

Postgraduate Courses

Get free prospectus worth Rs. 500/- after filling this form
Course :
Name* :
Email* :
Phone* :
Enquiry* :
Validation code:

I agree to the Terms and Privacy Policy
 
Total Visitors

free website hit counter code