Combo of Excel & Accounts Ka Badshah by CA Tushar Makkar

EXCEL KA CHAMP

Course Curriculum

Basic excel formula

Time: 35 min 9 sec

If, Left, Right, And, Mid, Text and explained Home TAB of header

Sessions: 1 | Time: 51 min 2 sec
Sheet till lecture 2

Vlookup, Xlookup, Hlookup, Match

Time: 23 min 28 sec

Index, Pivot, Sumifs, Charts, Substitute, Replace

Time: 31 min 57 sec

Macro or VBA coding in excel | Expert level in excel

Sessions: 3 | Time: 12 min 3 sec
Final Income tax calculator_V1
Final Excel
Excel tips to make you pro

ACCOUNTS KA BADSHAH

Course Curriculum

Introduction of Accounts ka Badshah

Time: 7 min 57 sec

Be a Pro in Accounts - Part 1

Sessions: 3 | Time: 1 hour 2 min 33
Be a Pro in Accounts - Part 2 27 min 27 sec
Practice questions_accounting (3 pages)

Set up and creation of company in Tally Prime

Sessions: 1 | Time: 10 min 11 sec
Tally data_R & S

Gateway of tally prime

Time: 23 min 28 sec

Create Masters- Ledger , Group, Voucher type, Stock Group, Stock Category, TDS setup etc.

Time: 26 min 3 sec

Record transactions in Tally Prime - Sales, Purchase, Journal, Receipt, Payment, Production, BRS Part 1

Sessions: 1 | Time: 50 min 29 sec
Record transactions in Tally Prime - Sales, Purchase, Journal, Receipt, Payment, Production, BRS Part 2 24 min 58 sec

GST & TDS Basics with Tally Prime feature

Sessions: 2 | Time: 1 hour 7 min 36 sec
TDS Basics with Tally Prime Feature 26 min 2 sec
10004_TDS tally

Financial statement preparation - Balance sheet, Profit and loss, Cash flow statement, notes to accounts etc. - As per ICAI Recommended format Part 1

Sessions: 5 | Time: 46 min 52 sec
Financial statement preparation - Balance sheet, Profit and loss, Cash flow statement, notes to accounts etc. - As per ICAI Recommended format Part 2 23 min 14 sec
R & S Company Financial statement
ICAI recommended Financial statement format
Pwc_Illustratative FS_Schedule III_Applicable on Ind AS Corporate (201 pages)
Schedule III AS_Applicable on Corporate

Interview Questions and answers discussion

Sessions: 3 | Time: 25 min 42 sec
Interview questions and answers discussion 25 min 42 sec
All about tally & Important Shortcuts and many more (90 pages)
Interview questions discussed in video

Meet Your Instructor

CA Tushar Makkar

CA Tushar Makkar, with over 9 years of audit experience, has led large teams. Known for sharing practical audit knowledge, earned immense appreciation and over 110k followers across multiple platforms. He has the largest audit community in India. His expertise encompasses Internal Financial Control, Statutory and Internal Audit, and Bookkeeping, with a particular focus on IND AS, US GAAP & IFRS. As the founder of his own venture, he has catered to diverse global clientele, including US and beyond