ADVANCED EXCEL COURSE
Fees: Rs.5500
Time: 1 month, depending on class frequency
Curriculum Overview
Advanced Excel
- Formulas and Functions
- Basic Functions: SUM, AVERAGE, IF
- Lookup Functions: VLOOKUP, HLOOKUP, XLOOKUP, INDEX/MATCH
- Other Functions: Nested IF, IFS, SUMIF, SUMIFS, COUNTIF, COUNTIFS, AVERAGEIF, AVERAGEIFS
- Data Formatting: Conditional formatting, tables, sorting, filtering
- Basic Charts: Bar, line, and pie charts
- Pivot Tables: Creating and customizing pivot tables, slicers, pivot charts
- What-If Analysis
- Goal Seek — find the input needed to hit a target output
- Data Tables (one-variable and two-variable) — sensitivity analysis across a range of inputs
- Scenario Manager — compare multiple named “what-if” scenarios (e.g., best/worst/base case)
- Financial Functions
- PMT, FV, PV — loan payments, future value, present value
- NPV, IRR — investment appraisal and capital budgeting
- RATE, NPER — solving for interest rate or number of periods
- Macros and VBA: Automating tasks with simple scripts, recording macros, editing VBA code
- Excel in Project Scheduling & Management
- Gantt charts, task timelines, dependencies, and milestone tracking
- Resource allocation and workload tracking
- Progress tracking with % complete and status flags (conditional formatting for overdue/at-risk tasks)
Contact Us
FAQ
When can I start learning Excel?
You will be able to start Excel lessons as soon as possible. All you have to do is apply and provide the syllabus and the timings.
Can I do this course both online and onsite when it is convenient?
Yes, you can access both online and onsite classes.
Will I be able to learn the Excel formulas with practical projects?
Yes, the course incorporates advanced Excel formulas that you can apply in your work.
Who is this course meant for?
It is meant for beginners, graduates, college students and those desiring to attain skills for their corporate work.
Does the course incorporate learning about the pivot table?
Yes, it does; you will be able to learn how to analyse or summarise large quantities of data.
How many months does this course take?
It generally takes a month to complete the course.
Does the course incorporate automation tasks?
Yes, it does; you are able to learn how to eliminate repetitive manual work.
