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