IN India Pre-degree / Foundation

Excel for Accounts

The functions, layouts and checks that accounting work actually needs.

What the course covers

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

1. 1.1 Workbook structure for finance
2. 1.2 Formatting numbers, dates and currency
3. 1.3 Cell styles for inputs, formulas and links
4. 1.4 Protecting a working file
1. 2.1 Absolute and relative references
2. 2.2 Sum, subtotal and aggregate
3. 2.3 Rounding, and why it matters in accounts
4. 2.4 Trapping errors properly
1. 3.1 Conditions and nested logic
2. 3.2 Summing and counting on a criterion
3. 3.3 Several criteria at once
4. 3.4 Flags, checks and control totals
1. 4.1 Looking up between two ledgers
2. 4.2 Index and match
3. 4.3 Finding the difference between two lists
4. 4.4 Building a reconciliation template
1. 5.1 Importing from accounting software
2. 5.2 Cleaning text, dates and numbers
3. 5.3 Splitting and combining columns
4. 5.4 Removing duplicates safely
1. 6.1 Pivot tables on a ledger
2. 6.2 Grouping by period and by account
3. 6.3 Slicers and report filters
4. 6.4 Refreshing without breaking the links
1. 7.1 A fixed asset and depreciation schedule
2. 7.2 Accruals and prepayments schedules
3. 7.3 A simple management report pack
4. 7.4 Charts for a finance audience
1. 8.1 Auditing formulas and tracing precedents
2. 8.2 Data validation that stops bad input
3. 8.3 Version control and file naming
4. 8.4 The spreadsheet errors that cost real money

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.

Job-ready from the first module Everything here is a task you will actually be asked to do at work, not theory you will never use.

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 Pre-degree / Foundation 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.