SYLLABUS Essential Office + Tally + GST
Basic Word 26 Topics
Introduction to Word
Page Setup (Margin, Orientation, Columns, Page size)
Save & open a document
Create new document
Breaks (Page Break & Column Break)
Hyphenation & Line Number
Document Formatting(Change in font, change in font size, highlighting text and change in text color)
Change case
Format Painter
Strikethrough, Double Strikethrough, Small Caps, All Caps
Bold, Italics & Underline
Subscript & Superscript
Indent & Line spacing options
Working with Tables
Bulleted and Numbered List
Change Text Direction
Find and Replace
Spell Check
Working with Text Box
Header and Footer
Draw a Shapes
Working with images in the document
Add a Drop Cap
WordArt and Watermark
Page Border and Page Color
Business Bills, Invoices and Receipts
Essential Word 13 Topics
How to insert symbols
Multi-level List
Step by Step Mail Merge Wizard
Select and Edit Recipients List
Envelopes and Labels
Hyperlink and Bookmark
Insert a SmartArt Graphics and Charts
Selection Pane
Thesaurus, Word Count, Translate and Language
How to create a cover page
Insert date and Time
Take a Screenshot
Arrangement of Objects
Basic Excel 13 Topics
Introduction to Excel
Saving Workbook and Adding / Deleting Renaming Worksheets
Basic calculations : Sum, Product, Factorial, Square Root, Average, Max, Min, Mode & Median
Basic functions like Count, Counta & Count Blank, Upper, Lower, Subtotal
Data Sorting
Format Painter
Text to Column, Text Formatting
Filter, Rand Function
Average and AverageA
Count, Counta and Countblank
How to insert and delete a cell, row and column from a worksheet
Round, Roundup, Rounddown
Date & Time Functions like Date, Day, Month, Year, Today, Hour, Minute, Second
Essential Excel 18 Topics
Charts
Multicategory Chart
Static Transpose
Find Depreciation of an Asset
Logical Functions like IF, IF-Else
Text Functions like Find, Replace, Len, Right, Left, MID, Proper, Text, Trim
Lookup
Subtotal Function
Rank Function
Rand and Randbetween
Sumproduct
Choose
Format as table
Conditional formatting
Page setup & Print
Freeze Panes
Date & Time Functions like Edate, Now, Eomonth, Workday, Weekday,
Error Handling with ISBLANK, ISTEXT, ISERROR, ISNUMBER, IFERROR functions
Basic PowerPoint 17 Topics
Introduction to PowerPoint
Create a presentation
Slide Setup
Save a presentation
Choose a slide design
Text Formatting in Slides (Change in font, change in font size and change in text color)
Text Alignment in Slides
Background formatting in slides
Working with Text box
Insert Pictures
Draw a shapes
Add Symbols
Working with Tables
Change Text Direction
Insert a Smartart & Chart
Text formatting through WordArt
Different types of Slide Layout
Essential PowerPoint 7 Topics
Create a Photo Album
Insert a Screenshot
Adding Audio and Video to your Presentation
Transitions and Animations
Create custom slideshow of slides
Date and Time & Slide Number
Different views in PowerPoint( Normal, Outline view, Slides Sorter, Notes Pages, Reading View)
Tally Prime 25 Topics
Getting Familiar with Tally Prime
Fundamentals of Tally Prime
How to create company in Tally Prime
Working with Ledgers and Groups
Recording day to day Entries in Tally Prime
Inventory Management in Tally Prime
Inventory Masters
Inventory Books & Reports
How to create Purchase & Sales Voucher
Order Processing
Reorder Levels
Maintain Bill Wise Details in Tally Prime
Debit & Credit Notes
Delivery, Receipt & Stock Rejection in Tally
Cost Center & Cost Categories
Create Budget in Tally Prime
Payment, Receipt & Contra Voucher
TDS Tax Deducted at source
TCS Tax Collected at source
Setting price list for Wholesalers, Semi-Wholesalers and Retailers
Optional or Quotation vouchers in Tally
POS (Point of Sales) method for multi-mode payments
Payroll management in Tally Prime
BOM (Bills of Material) in Tally Prime
Cost of a particular project in Tally Prime
GST (Goods & Service Tax) 18 Topics
How to create Company & Set Rate in GST
Creating Tax Ledgers
Recording GST Local Purchase
Recording GST Interstate Purchase
Recording GST Local Sales
Recording GST Interstate Sales
Record Payments and Receipts
Recording an Advance Payment to Supplier
Purchase from Unregistered Dealers
Sale of Composite and Mixed supplies under GST
GST Sales Nil Rated, Exempt, SEZ, Deemed Export and Consumer sales
Creating GST invoices for E-commerce operators
Creating GST Export Taxable invoices with currency change
Import of goods & services
Creating E-way Bills
Exporting GSTR-1, GSTR-2, GSTR-3B data to excel
Import data from Tally to Tally
GST Offline Tool
What you'll learn Essential Office + Tally + GST
- Build a solid understanding on the Basics of Microsoft Office.
- Format documents effectively using Microsoft Word Styles
- Control page formatting and flow with sections and page breaks
- Expertise in Logical Function
- Expertise in Date and Time Function
- Work confidently with Microsoft PowerPoint
- Complete Guide to Accounting & Taxation
- How to create GST Computation & Reports in Tally Prime with GST
- You will learn how to apply GST at Multiple Level
- You will learn how to compute TDS & TCS Reports.
Get Free Participation Certificate
Take a demo class & get the FREE Certificate
Upcoming Batches
-
JOIN NOW And Get 59% Scholarship
-
Friday 07-Jun-2024 -
Monday 10-Jun-2024 -
Wednesday 12-Jun-2024 -
Thursday 13-Jun-2024
About Essential Office + Tally + GST Course in
The Essential Microsoft office course is a 3-in-1 bundle that covers the intermediate-level topics regarding Microsoft Word, Microsoft Excel and Microsoft PowerPoint. The course builds on the fundamental knowledge and explores the different concepts required in the workplace.
Microsoft Office is an essential application for students, office workers, executives, finance analysts, Retail store manager and Project manager.This course helps the candidates to get started with the latest version of Microsoft Office. The course enables the candidates to acquire the necessary knowledge to efficiently use the features of Microsoft Office to achieve excellence in the daily routine tasks.
ISPL Academy bring you the comprehensive certification program in Tally Prime and GST . Whether you are a professional or a beginner in the field of accounting, our training will give you the expertise you need in a Computer Accounting Tally and Taxation in GST.
GST in India is a reality now. GST (Goods & Services Tax) is going to subsume most of the Indirect Taxes in India such as Central Excise, CST, Entry Tax, etc. and would bring in significant amount of change in way of doing business.
Exam & Certification Essential Office + Tally + GST
An online verifiable certificate of completion will be issued based on your performance from ISPL Academy. Student would go through an online examination after completion of the course to evaluate the skills gathered during the course.
Competition is tough when applying for a job, having a proof of successful completion of the course is an effective way to stand out and succeed. Your certificate will give the trust to the employers that you are dedicated and have required skills to become a suitable employee for them.
![ISPL Academy Certificate Sample](images/certificate03.jpg)
Frequently Asked Questions
What is the duration of course Essential Office + Tally GST?
Essential Office + Tally GST is a short term course of 6 months.
What is the fee of Essential Office + Tally Prime?
The fee of course Essential Office + Tally Prime is Rs.16700/-
What topics are covered in Essential Office+ Tally Prime?
This course covers Essential Word, Excel, Powerpoint, Tally Prime and GST.
What is the mode of Training?
The course is available in both online & classroom modes at the training center in Dehradun.