IN India Bachelor's Degree

Advanced Excel for Finance

Lookups, pivots, scenarios and models that do not break when data changes.

What the course covers

8 modules, 32 topics. Open any one to see what sits inside it.

1. 1.1 The Finance Professional's Excel Setup
2. 1.2 Efficient Navigation and Keyboard Shortcuts
3. 1.3 Cell References: Relative, Absolute and Mixed
4. 1.4 Named Ranges and Workbook Structure
1. 2.1 Logical Functions: IF, AND, OR, IFS
2. 2.2 Lookup Functions: VLOOKUP, INDEX-MATCH, XLOOKUP
3. 2.3 Text and Date Functions
4. 2.4 Error Handling and Formula Auditing
1. 3.1 Importing and Structuring Data
2. 3.2 Sorting, Filtering and Advanced Filters
3. 3.3 Removing Duplicates and Cleaning Messy Data
4. 3.4 Data Validation and Input Controls
1. 4.1 Excel Tables and Structured References
2. 4.2 PivotTables for Financial Analysis
3. 4.3 PivotCharts and Slicers
4. 4.4 Conditional Formatting for Insight
1. 5.1 Time Value of Money: PV, FV, PMT
2. 5.2 Investment Appraisal: NPV, IRR, XIRR
3. 5.3 Loan, Amortisation and Depreciation Functions
4. 5.4 Statistical Functions for Finance
1. 6.1 Principles of a Well-Built Model
2. 6.2 Building the Three Financial Statements
3. 6.3 Assumptions, Drivers and Linking Schedules
4. 6.4 Model Checks, Error-Proofing and Documentation
1. 7.1 What-If Analysis and Data Tables
2. 7.2 Goal Seek and Solver
3. 7.3 Scenario Manager and Toggles
4. 7.4 Sensitivity Tables and Break-Even Analysis
1. 8.1 Charts for Financial Reporting
2. 8.2 Dashboards and KPI Reporting
3. 8.3 Introduction to Power Query
4. 8.4 Macros, Automation and Sharing Workbooks

By the end of this course you will be able to explain and apply:

Two hours, not two months Eight short modules. Finish in a day, or do one module a night for a week.

Skills your degree does not cover Employers ask for practical tools alongside the qualification. This fills that gap while you study.

Built for a phone Watch on the bus, pause mid-module, pick up where you stopped. No download, no lab.

A certificate that can be checked Every certificate carries an ID your college or an employer can verify on our site.

About two hours in total — eight modules of roughly fifteen minutes. You can do it in one sitting or spread it across a week. Your place is saved either way.
No. There is no prerequisite course and no software to install. A phone, tablet or computer with an internet connection is enough.
Yes. This course is placed at Bachelor's Degree for India, and the content is written for that level. If you are at a different stage, change your level at the top of the page and the courses will change with it.
A certificate for the course, carrying an ID that your college or an employer can check on our verification page. You keep access to the material afterwards.
Yes — ₹450 for this course on its own, or ₹1,450 for all five in this set, which works out cheaper if you want more than one.
There is a short quiz at the end of each module so you can check what stuck. It is not timed and you can retake it.
Change your country using the picker at the top. Level names, degree names and prices all switch to that country, and the courses adjust to its education system.

Wording shown for India. Pick a different country at the top and the terms, currency and programme names change with it.