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)

How to Page Setup

Create Basic Shapes

Multi-Page Corel document

Corel Templates

Rulers, Grids and Guidelines

Shortcuts of Basic Commands

Freehand Tool create custom Shapes & Logos

Shape Tool, Connector, Bezier, Pen, Artistic Media, Polyline, Interactive Connector, Dimensions more tools for drawing in Freehand Tool

Blend Options Blend, Contour, Distortion, Drop Shadow, Envelope, Extrude, Transparency

Color Palette, Effects and Gradient

Objects Lock, Unlock, Grouping and Ungrouping

Weld, Trim and Intersect, Place inside Container

Text, Paragraph, Fix text to Path

Images using Powerclip

Bitmaps convert color mode

Using Layers

Layers Panel in Photoshop

Layer Blending Modes

Lock Layers

Brush & Pencil Tool

Creating and Resizing Artboards

Rectangular & Elliptical Marquee

Lasso Tool make Perfect Selection

Shapes with Pen Tool

Custom Shapes

Image filled Shapes

Quick Selection and Magic Wand

Crop images In Photoshop

Eraser, Background Eraser and Magic Eraser

History panel

Slice tool allows you to divide an image into smaller sections

Blur, smudge and sharpen tool in image

Dodge, Burn & Sponge tool to brighten darken and Increase the color

Clone and Pattern stamp tool

History and Art history brush tool

Add dust & splatters to an image & text for a grunge effect.

ACTIVITIES (change cloth, skin teeth color, website layout, design shapes with pen tool)

Introduction to HTML 5

HTML Document Structure

Best practices of Saving & Naming HTML Document

Text styling using heading, paragraph & formatting Tags

Insert Images to web page

Insert Audio & Video

Create Ordered, Unordered & Definition List

Create advance HTML Tables

Linking web pages together using Anchor Tag

Adding Forms to web page using difference input types

Using iFrame

Getting started with CSS

CSS Selectors (Class and ID)

Working with Inline, Internal & External CSS

CSS Box Model

Color & Formatting with CSS

Relative vs. Absolute position

The Box, Boxes in Boxes

Debugging with Chrome Developer Tool

Handling spacing & layouts

Create Navigation with CSS

Formatting Forms, Input

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

Why Typing Skills are important

Learn Keyboard letters from A to Z

25 Learning Lessons

MS WORD- Format documents efficiently in Word using Microsoft Word Styles

MS WORD- Create dynamic layouts using various techniques

MS WORD- Create Mailing labels and Form Letters by Performing Mail Merge

MS EXCEL- Create and manage Spreadsheet Layouts

MS EXCEL- Increase your efficiency by creating and using important Excel shortcuts

MS POWERPOINT- Make great presentations using the Conditional and Table formatting options

COREL DRAW- Create Professional Business Card Designing

COREL DRAW- Create Designer Catalogue

COREL DRAW- Create Logo

COREL DRAW- Create Covers/Packing

CORAL DRAW- Design a Pamphlet & Advertisements

CORAL DRAW- Change the color of T-SHIRT

COREL DRAW- Make a Banner

CORAL DRAW- Design Letter Heads

CORAL DRAW- Design the shapes with the Pen Tool

PHOTOSHOP- Create a creative cinematic effect

PHOTOSHOP- Create a Website Layout