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
| S. No. | Topics | Details |
|---|---|---|
| 1 | Introduction | Using Excel Lists |
| 2 | Creating a List | Sorting Data |
| 3 | Sorting Techniques | Simple Sort & Multiple Column Sort |
| 4 | Data Forms | Adding Data Using Data Forms |
| 5 | Finding Records | Finding Records Using Criteria |
| 6 | Filtering Data | AutoFilter & Advanced Filters |
| 7 | Filtered List Features | Special Features for Filtered Lists |
| 8 | Totals & Subtotals | Total Row & Subtotals |
| 9 | Window Management | Managing Multiple Windows |
| 10 | Splitting & Freezing | Splitting Windows & Freezing Panes |
| 11 | Linking Data | Option Menu Usage |
| 12 | Data Analysis | Goal Seek & Pivot Tables |
| 13 | Lookup Functions | VLOOKUP & HLOOKUP |
| 14 | Data Consolidation | Data Consolidation & Insert Charts |
| 15 | Practical Tasks | Practice Tasks & MIS Reports |
| 16 | Office Utilities | Scanning, Email Attachment & Download |
| 17 | Security | MIS Conversion to PDF & Password Protection |
| 18 | Theory & Practice | Complete Theory & Practical Training with Unlimited Practice Time |
+919811599499
