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 easily.

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

Mobile : (+91) - 9811 6789 13 , 9811 599 499
Phone : 011-45717722, 011- 64673344

Click here to send query for admission dates and fees details.

Note: This is a copyright material. Please do not copy the contents of this website. If any contents found to be copied, strict legal and financial actions will be taken.