Course Details
Home // Course Details
Advanced Excel
This Course Included
Share Course
50
Duration
2 Months
Skill Level
Advance
Language
Bilingual
Certificate
After Completed
Course Overview
The Advanced Excel Course at Indian Computer Institute is a job-oriented program that teaches Excel formulas, data analysis, pivot tables, charts, and MIS reporting. The course focuses on practical training to help students develop strong Excel skills for roles like Data Entry Operator, MIS Executive, and Office Assistant.
Course Overview
Syllabus:
- Introduction (MS Excel Window/Interface Parts, File Extension, How to Open/Exit.)
- All Definitions ( Excel, Workbook, Worksheet, Cell, Row ,Column)
- Entering and Editing Data.
- Inserting and Deleting Row or Column.
- Formatting Data
- Auto fill Lists ( Default lists & Creating new lists)
- Simple formulas (SUM, AVERAGE, PRODUCT, COUNT, QUOTIENT, MAX, MIN, ABS, ROUND, PERCENTAGE etc.)
- Sort, Filter, Adv. Filter, Subtotal, Macros, Protect Sheet, Protect Cell, Text to Columns, Name Manager, What if Analysis
- Charts (Working With Charts)
- Logical Functions (IF, AND, OR, NOT, IFERROR)
- Financial Functions (PMT, PV, RATE, FV, DB)
- Data Validation
- Conditional Formatting
- Lookup Functions (CHOOSE, HLOOKUP, VLOOKUP, XLOOKUP, INDEX, MATCH, TRANSPOSE, HYPERLINK, ROW)
- Math & Trig Functions (SUM, SUMIF, SUMIFS, RANDBETWEEN,ROMAN)
- Text Functions (CHAR, CODE, CONCATENATE, UPPER, LOWER, PROPPER, LEN, MID, SEARCH, TRIM)
- MIS Report (PIVOT TABLE, PIVOT CHART, VLOOKUP, HLOOKUP, XLOOKUP, ADV. FILTER, SLICER, SPARKLINES, CONSOLIDATE, CONVERT, ABS, SUMPRODUCT, FIND DUPLICATE, TEXT)
- Project Work
- and many more…
Who Should Join This Course?
- Students who want to learn Advanced Excel skills
- Job seekers looking for office or MIS-related jobs
- Working professionals who want to improve data analysis skills
- Accountants and office staff who work with data and reports
- Anyone who wants to improve productivity using Microsoft Excel
Why Choose Indian Computer Institute? Â Â Â Â
- Experienced and Qualified Trainers
- 100% Practical-Based Training
- Industry-Relevant Course Curriculum
- Focus on Career and Skill Development
- Professional Computer Education Environment
