Computer & office
Windows, Internet and Email Study Book
The complete study notes, practice questions and glossary for Windows, Internet and Email
Learning path
Accounts assistant
From computer basics to keeping the books of a business in Tally, with GST.
- Who it is for
- Commerce students, shop and office staff, and business owners
- Where it ends
- Record a business’s sales, purchases and payments, keep its GST records and prepare the reports an owner or accountant asks for.
- Stages
- 5 courses, in this order
About this path
Accounts work in India runs on two things: the accounting behind every entry, and the software most offices use, Tally. This path teaches the accounting first, so the software makes sense, and uses Excel for everything Tally does not do.
Commerce students can skip the first stage if they already use a computer well. Your centre gives the schedule for each course.
Your centre gives the schedule for each stage. This page does not quote durations or fees.
The stages, in order
Stage 1: Basic computer and the internet
The computer habits accounts work needs: files and folders, email, printing and safe payments.
After this stage you can
- Create, rename, move and find files and folders
- Write a proper email and send an attachment
- Recognise UPI and OTP fraud
Course pageStudy book and practice test (student login)
Free ebooks for this stage
Computer & office
Safe UPI and Digital Payments
Pay and receive money online, and recognise the tricks fraudsters use
Computer & office
Computer Fundamentals Study Book
The complete study notes, practice questions and glossary for Computer Fundamentals
Stage 2: MS Office
Excel is the accountant’s second program, and Word writes the letters and notices.
After this stage you can
- Use formulas, relative and absolute references, SUM, IF and VLOOKUP
- Sort and filter data and make a chart
- Format and print a letter with headers and footers
Course pageStudy book and practice test (student login)Percentage and marks calculator
Free ebooks for this stage
Computer & office
Excel Formulas Workbook
Sixty formulas and functions, each with a worked example from school, shop or office
Accounting
Excel for Accounts and Office Records
Cash book, stock register, invoices and reports in Excel
Computer & office
MS Word Study Book
The complete study notes, practice questions and glossary for MS Word
Stage 3: Basic accounting and bookkeeping
The golden rules, journal, ledger and trial balance: the accounting that every Tally entry is built on.
After this stage you can
- Apply the accounting equation and the golden rules to everyday transactions
- Write journal entries, post them to ledgers and prepare a trial balance
- Prepare simple final accounts and a bank reconciliation
Course pageStudy book and practice test (student login)Interest and EMI calculator
Free ebooks for this stage
Accounting
Basics of Accounting
Debit and credit, journal, ledger, trial balance and final accounts, made simple
Accounting
Business Maths for Accounts
Percentages, profit and loss, discount, interest and ratios with shop examples
Accounting
GST Basics for Students and Small Shops
How Goods and Services Tax works, explained with simple examples
Stage 4: Tally with GST
The software itself: company, ledgers, vouchers, stock and GST in TallyPrime.
After this stage you can
- Create a company in TallyPrime and set up ledgers and groups
- Enter contra, payment, receipt, journal, sales and purchase vouchers
- Record GST, and read the Day Book, Trial Balance, Profit & Loss account and Balance Sheet
Course pageStudy book and practice test (student login)GST calculatorCareer guide: accounts assistant (Tally)
Free ebooks for this stage
Accounting
Tally with GST Study Book
The complete study notes, practice questions and glossary for Tally with GST
Accounting
Tally Practice Workbook
Forty business transactions to enter in TallyPrime, with the voucher for each
Accounting
GST Basics for Students and Small Shops
How Goods and Services Tax works, explained with simple examples
Stage 5: Advanced Excel and data analysis
Reports and reconciliations outside Tally: lookups across sheets, pivot tables and a dashboard for the owner.
After this stage you can
- Match two lists with XLOOKUP and IFERROR
- Summarise sales and expenses with SUMIFS and a pivot table
- Lay out a one-page dashboard that updates itself
Course pageStudy book and practice test (student login)
Free ebooks for this stage
Accounting
Excel for Accounts and Office Records
Cash book, stock register, invoices and reports in Excel
Computer & office
Excel Formulas Workbook
Sixty formulas and functions, each with a worked example from school, shop or office
Ready to start?
Tell the head office where you are now and they will suggest the first stage and the nearest centre.