Advanced Excel
One month on the Excel that offices actually use - lookups, pivots and dashboards.
- 1 Month
- 17 topics
- IICT certificate
- 5 campuses
Best if you already use a computer and want a specific office skill quickly.
- Course code
- EXCEL
- Duration
- 1 Month
- Syllabus
- 17 topics
- Fees
- On request
What you actually learn.
17 topics, in the order they are taught.
- Lookup and logical functions
- Pivot tables and pivot charts
- Dashboard building
- Data validation and protection
- Introduction to Microsoft Excel
- Workbook and Worksheet Management
- Cell Formatting and Data Entry
- Basic Formulas and Functions
- Mathematical Functions
- Logical Functions (IF, AND, OR)
- Lookup Functions (VLOOKUP, HLOOKUP, XLOOKUP)
- Date and Time Functions
- Conditional Formatting
- Data Validation
- Sorting and Filtering
- Pivot Tables and Pivot Charts
- Dashboard Creation
- Data Analysis and Reporting
- Chart Creation and Customization
- Protecting Worksheets and Workbooks
- Printing and Page Setup
The same syllabus is taught at all 5 campuses. Batches start through the month, so ask for the next one.
Ask about the next batchHow the class runs.
- One computer per student Practice from the first class, never a shared screen.
- Small classroom batches Morning and evening timings to pick from.
- Notes and practice files Handed out topic by topic, nothing to buy outside.
- Certificate anyone can check Verified online by its number, in seconds.
Work this course is usually taken for.
- Office and MIS work
- Data analyst assistant
- Accounts and reporting support
Photographs from IICT classrooms and certificate days, taken across all 5 campuses.
Open the gallery-
Our Batches -
Certificate Day -
Motivational Sessions -
Personality Development Awards
Fees, in one message.
A fee printed on a website goes out of date quietly. We send you the current one instead, before you visit, and it is the same at all 5 campuses.
- The total fee for this course
- The amount to start with
- Instalment options, if you need them
EXCEL
Fees on request
One message and you get the full amount, with nothing kept back for the counter.
Get the fee for EXCELTaught at all 5 campuses.
Same syllabus and same certificate, whichever gate you walk through. Pick the one closest to you.
Other courses worth a look.
- 3 Months Short course Course on Computer Concepts (CCC) The CCC topic list in three months, taught on LibreOffice and digital services. See details
- 3 Months Short course Basic Computer For a complete beginner. Three months from switching on a computer to sending email. See details
- 3 Months Short course Tally Practical accounting on Tally Prime, including GST, payroll and final reports. See details
Sit in the class before you decide.
Walk in during working hours, see the computers and ask anything about EXCEL. No appointment, no fee to look.
Head Office - South Rampuri
1065 Roorkee Road, South Rampuri, Muzaffarnagar, Muzaffarnagar - 251002, Uttar Pradesh
8:00 AM to 7:00 PM