Duration
4 Months
Level
Level 2
Fee
₹10,000 + GST
Prerequisite
Level 1, or comfortable use of Word and basic Excel.
About this course
Level 2 turns basic office users into people who can run the numbers for a business. Advanced Excel covers the formulas and reports used in accounts and operations; Tally Prime covers real bookkeeping with GST; and HTML shows how the web pages you use every day are built.
What you will learn
- 1
Advanced Excel
- •IF, nested logic and conditional formatting
- •VLOOKUP, XLOOKUP and INDEX-MATCH
- •Pivot tables and pivot charts
- •Data validation, protection and dashboards
- 2
Tally Prime — Accounting
- •Company creation, ledgers and groups
- •Vouchers: sales, purchase, payment, receipt
- •Inventory and stock items
- •Balance sheet and profit & loss
- 3
Tally Prime — GST & Reports
- •GST setup and tax ledgers
- •GST invoices and returns data
- •Bank reconciliation
- •Reports used by accountants and auditors
- 4
HTML
- •How a web page is structured
- •Headings, text, links and images
- •Lists, tables and forms
- •Publishing a simple personal web page
Enrol
Join Advanced Excel, Tally Prime & HTML
Register for the live online pilot batch — starting soon. We’ll call you with the start date and a free demo class. No payment is taken here.
- Duration
- 4 Months
- Level
- Level 2
- Fee
- ₹10,000 + GST
SJ Global PU & Degree College student? Use the SJ Global form.