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.
Eligibility: Basic Computer Knowledge
Duration: 4 Weeks
| S. No. | 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
