4.7 Upto 6 Month
English / हिंदी में सीखें

Essential Office + Tally + GST

Learn essential skills of MS Office, Tally Accounting and GST to take your career to next level or to better manage your business accounts.

Rs.16700 59% off Rs.40500

Free Essential Courses Demo Class Complimentary class with Certificate

Duration

Essential Office + Tally + GST is upto 6 Month Course

Instructor Led

Interact with real trainers to clear your doubts

Real Life Assignment

Learn-by-doing model for real-life problem-solving skills

Expert Faculties

Get trained by industry experts for in-depth learning experience

Certification

Get Digital and Physical course completion certificate

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

  • 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

  • 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

  • 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

  • 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

  • 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)

  • 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

  • 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 01-Nov-2024

    Upto 6 Month

    Classroom / Online

    Weekdays

  • Monday 04-Nov-2024

    Upto 6 Month

    Classroom / Online

    Weekdays

  • Thursday 07-Nov-2024

    Upto 6 Month

    Classroom / Online

    Weekdays

  • Friday 08-Nov-2024

    Upto 6 Month

    Classroom / Online

    Weekdays

About Essential Office + Tally + GST Course in faq

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

Frequently Asked Questions

Essential Office + Tally GST is a short term course of 6 months.

The fee of course Essential Office + Tally Prime is Rs.16700/-

This course covers Essential Word, Excel, Powerpoint, Tally Prime and GST.

The course is available in both online & classroom modes at the training center in Dehradun.

Bulk Training for Corporates, Government and Institutions

Classroom Learning

GMS Road Dehradun 99974-11884

Tilak RoadDehradun 99974-11885

Start your own centre Become a Partner