Computer & office
MS Excel Study Book
The complete study notes, practice questions and glossary for MS Excel
Gurukul Technicals InstituteProjects & kits · Computer education · RoboticsBecome a Franchise PartnerMenuHead office, Rana Pratap Bagh, Delhi
Accounting & Business Software
Recording sales, purchases, payments and stock in Tally, and keeping the GST records that invoices and returns need.
Suits: Commerce students, shop and office staff
Duration, fees and batch timings are quoted by the head office or your centre.

2 study books in this course
About the course
Tally is the accounting software most Indian offices use. The course starts with the accounting behind every entry, the golden rules, and then moves into TallyPrime: creating a company, ledgers and groups, vouchers and their function keys, stock items, and GST.
Excel is part of the course too, for the lists, calculations and reports that accounts work needs outside Tally.
Drawn from the lessons of the study books below.
Apply the golden rules of accounting to everyday transactions
Create a company in TallyPrime and set up ledgers and groups
Enter contra, payment, receipt, journal, sales and purchase vouchers with their function keys
Set up stock groups, units and stock items for inventory
Understand GSTIN, CGST, SGST, IGST and input tax credit, and record GST in TallyPrime
Read the Day Book, Trial Balance, Profit & Loss account and Balance Sheet, and use Excel formulas for accounts
What you will learn
Every lesson of the study books that come with this course in the student portal, with the key points of each lesson and exercises to try. Your centre gives you the syllabus, the duration and the fee.
Subject 1 of 2
Learn the golden rules of accounting, then keep books in TallyPrime: create a company, ledgers and stock items, enter vouchers with their function keys, record GST invoices and read the main reports.
Key points
Try this
Key points
Try this
Key points
Try this
Key points
Try this
Key points
Try this
Key points
Try this
Key points
Try this
Subject 2 of 2
Work with cells, ranges and formulas in Microsoft Excel, use functions such as SUM, IF, VLOOKUP and XLOOKUP, and sort, filter, chart and print your data.
Key points
Try this
Key points
Try this
Key points
Try this
Key points
Try this
Key points
Try this
Key points
Try this
Key points
Try this
Practice and study material
Students sign in to read the study books lesson by lesson, print them, mark lessons as done and test themselves with timed practice tests, every answer explained.
Up to 20 questions are picked at random from the subject’s question bank.
A timer counts down. When it reaches zero, your answers are sent automatically.
Skip a question, flag it, and come back to change your answer before you submit.
At the end you see the right answer and an explanation for each question.
Each study book has its lessons, key points, exercises and a glossary. Print a lesson, or mark it as done.
Your centre gives you your login when you enrol.
Real questions from this course’s question banks. Pick an answer to see the explanation.
Which report shows the closing quantity and value of every stock item?
Answer: C. Stock Summary
Stock Summary lists every stock item with its closing quantity, rate and value, grouped by stock group.
In the mixed reference A$1, which part stays fixed when the formula is copied?
Answer: C. The row number 1
The dollar sign is placed before the part that is locked. In A$1 it is before the row number.
Which report shows what a business owns and owes, its assets, liabilities and capital, on a particular date?
Answer: A. Balance Sheet
The Balance Sheet shows assets on one side and liabilities and capital on the other, and the two totals always agree.
Free ebooks
Branded PDF books to read on your phone or print: the study books of this course and more. Free for anyone, no sign-in needed.
Computer & office
The complete study notes, practice questions and glossary for MS Excel
Accounting
The complete study notes, practice questions and glossary for Tally with GST
Computer & office
Sixty formulas and functions, each with a worked example from school, shop or office
Accounting
Debit and credit, journal, ledger, trial balance and final accounts, made simple
Accounting
Forty business transactions to enter in TallyPrime, with the voucher for each
Accounting
How Goods and Services Tax works, explained with simple examples
Accounting
Percentages, profit and loss, discount, interest and ratios with shop examples
Accounting
Cash book, stock register, invoices and reports in Excel
Careers
The kind of work these skills are used for. Each guide explains what the job involves, the skills it asks for and how to get started.
Entering sales, purchases and payments, keeping GST records and preparing the reports a business owner or accountant asks for.
Typing records, letters and reports, keeping spreadsheets up to date, and handling email, files and printing in an office.
Free calculators
Free tools that go with this course. They work in your browser, on a phone or a computer.
Work out the GST on a price and the total with GST.
Work out the interest on an amount and the monthly EMI of a loan.
Work out the percentage of your marks in a test or across a whole marksheet.
How admission works
The usual steps, at the head office in Delhi or at an authorised member centre.
Call or WhatsApp the head office, or visit your nearest member centre. Ask for the duration, the fee and the batch timings in writing.
Admission forms are supplied by the head office to every centre.
Attend your batch at the centre, with the course material and study notes, and sign in to the student portal for the study books and practice tests.
The institute prefers written exams, taken in front of a teacher.
Students who pass get a Gurukul Technicals Institute certificate and marksheet. Employers can verify it with the head office.
Students above 12 years of age can take admission, at the Delhi head office or at an authorised member centre. The course suits commerce students, shop and office staff. Tell the head office or your centre what you already know, and they will suggest where to start.
The first lesson of the Tally study book covers accounting basics and the golden rules before TallyPrime is opened, so the course does not assume them. Commerce students will find that lesson a quick revision.
Duration, fees and batch timings depend on the course and the centre. Ask the head office or your nearest member centre, and get the details in writing before you pay.
At the head office in Delhi (A-10, Chief Commissioner Colony, opposite Rana Pratap Bagh) and at authorised member centres. Call or WhatsApp the head office to find the nearest centre.
A phone or a computer with an internet connection, and the login your centre gives you at enrolment. The student portal opens in an ordinary web browser, so there is nothing to install. Student login.
Sign in to the student portal and choose a subject. Each test picks up to 20 questions at random from that subject’s question bank and gives you one minute per question, with a timer that sends your answers automatically when it reaches zero. You can skip a question, flag it and come back before you submit, and at the end you see the right answer and an explanation for every question. This course has 70 practice questions across 2 subjects, and you can take the tests as often as you like.
Yes. The institute prefers written exams, taken in front of a teacher. Students who pass receive a Gurukul Technicals Institute certificate and marksheet.
On the verify certificate page, anyone can enter a certificate number and check it against the institute’s online register, which covers certificates issued through the portal. For older certificates, or if there is any doubt, send a copy to the head office by email or WhatsApp; the reply comes within 2 working days.
Yes. The 8 ebooks for this course are free PDF downloads for anyone, whether or not you join. The whole library has 100 free ebooks: browse them all.
Ask the head office for the duration, the fee, the batch timings and your nearest member centre.