– Fundamentals to Computer

– Software and Hardware Definition

– Input & Output Devices

– Parts of computers and their functions

– Secondary Storage Devices (CD, DVD, Pen Drive etc.)

– Mail Merge

– Macro

– Hyperlink

– Bookmark

– Password

– Macro

– Footnote–Endnote

– Track Changes

– Table Formats

– Document Protection

– PDF Creation

– 5 Types Tabs

– Speed Checking

– Many Short Commands

– Heading Styles

– Letter Paid

– Resume

– Project Report

– Cover Pages

– Introduction to Excel                                                      

– Concept of Sheet and Workbook

– Advanced Page Setup

– Print Settings(Advanced)

– Freeze

– Sort & Filter

– Styles

– Basic Formulas and Functions

– Charts (Graphs)

– Office Use Formats

– Photo Album

– Business Presentation

– Animation Show

– Custom Show

– Project Presentation

– Time Table

– Information Board

– Co. Profile

– Training Presentation etc.

– Many Short Keys to work Smartly

– Calculator

– Defragmenter

– Scan disk

– Antivirus Scan

– What is Turn off & Log off

– Character Map

– Disk Cleanup

– Devices Formatting

– Fonts Installation

– Printer Installation

– Software Uninstallation

– Why computer speed go slow & than what will You do etc.

– Theory of Internet 
– E-mailing 
– Downloading
– You Tube 
– Attachments
– On Line Form Filling 
– SMS sending
– Result Searching 
– Chatting 
– E-mail ID creation 
– Video Conferencing
– Searching 
– Save data on mail Address
– Attachments 
– Skype
– Team Viewer 
– Face Book 
– E Ticketing 
– E- Cards 
– Password Changing 
– Google Earth etc.
– Google Map
– Online Mobile Recharge
– Govt. Sites etc.

Kundli Pro

Windows Explorer

WinZip

Scanning

• Workbooks (File) & Worksheet Handling

        Excel Limitation

        Excel Shortcut use and benefits

        Excel Setting and Custom List Creation

        Excel Tamplate and File Location System

        Advanced Paste Special

        Calulation with Paste Special

        Link Data range as Picture Link

        Loopkup Picture in Excel Worksheet

• Advanced Formating for Reports and Dashboard

        Formatting Triks

        Date & Time For Trinks

        Advanced Custom Formating (Number Format using Code)

        Condtional Formatting

        Advanced Conditional Formatting using Formulas

        File,Sheets or Cells Protection Method

        Benefits of Data Table or Cells Style

1. Data Handle and Data Analysis

        Data Fill and Selection Method

        Advanced Sorting and Filter Trinks

         Data Summerization with Pivot Table

         Calculation with Pivot table

        Extranal Data Pivot Table

        Relationship and Slicer in Pivot Table

        Power Pivot in Excel 2016

        Use SQL Query in Pivot Table

• Page Setting and Form Creation

        Drow Form in Excel Sheet

        Hyperlink in Excel

        Text and Symbol

         Page Setup

        Manage View

        Sheets Option and Arrange

• Calculation (more then 200 Formulas)

        Mathameticals Calculation in Excel

        Logical Formulas (IF, and, Or, Xor, IfError Formulas)

         Nested If Formulas ( Multi Condition in If,and,or )

         Text and Advanced Text Formulas

        Date and Time Calculation using Data Time Formulas

        Ref# Formulas and VLookup

        Lookup Method(VLookup,HLookup,Match,Index,Offset)

        Advanced VLookup and VLookup Listing

        Math & trico. Formulas

        Data Summerization Formulas (AVERAGEIF,AVERAGEIFS,COUNTIF,COUNTIFS,LARGE,SMALL and more)

        Database and list managment Formulas

        Information Formulass

        Financial Formulas

• Advanced Formulas

        Advanced Array Formulas

        Complicated Large Formulas Creation

         Advanced Naming Method with Formulas

         Report Automation with Formulas

         Live Automation Projeact

        Use Formulas in Conditional Formatting

        New Formulas Creation with VBA Programming

• Databse and Other Application Conectvity

        MS Access Database Conectvity

        Notepad and Webdata Connectvity

         Embed Other Application

         SQL or Oracle Connectvity

         SQL Query in MS Excel 2016

         File & Folder Directory Access

• Dashboard Report Automation

        Chart Creation

        Chart Triks

         use Button on chart

         Dynamic Chart with Offset Formulas

         Dashboard Example

         Live Project

– Basics of Accounting

– About The Tally

– Tally Installation

– Company Creation  & Basics  Settings of Tally

– Ledger Creation

– Voucher Type (Use of Function Keys)

– Journal Entries

– Multiple Ledger Creation             

– Deleting of Ledgers, Groups, Vouchers etc.

– Security System

– Balance Sheet, Trial Balance, Profit & Loss

–Ratio Analysis, Invoice (Bill) Printing all Type Reports

– Voucher Mode/ Invoice Mode

– Single Entry Mode 

– Practical Problem Solutions (Tips)

– Backup Cos. / Restore Cos.

– Company Deleting

– Financial Year Changing

– CD/ DVD Writing / Calculator

– Group creation

–  Bill By Bill Details

– Control Buttons (F11 & F12)

– Inventory (Stock Control)

– Zero Values Entries

– Units of Measure Simple &  Compound

– Godowns / Location

– Stock Journal / Physical Stock

– Bill of Materials (BOM)

– Company Examples

– Payment Advice

– Confirmation Letter

– Reminder Letter

– Split Companies

– Groups of Companies

– Short Cut Keys (To do work Smartly)

– Budget & Credit Limits

– Cost Center  & Cost Categories

– Post Dated Entries

–Banking & Auto Bank Reconciliation etc. 

– Scenario Management

– Optional & Reversing Journal Entries

– Sales Order & Purchase Order

– Quotation, Performa Invoice

– Reorder Level 

– Debit Note & Credit Note

– Batchwise Details

– Stock  Ageing Analysis

– Import data  Lower version to Higher Version

– Data Export in Excel

-GST (Goods & Services Tax)

– TDS (Tax Deduction at Sources)

– TCS (Tax Collect at Sources) 

– Point of Sales

– Service Tax (For Professionals) 

– CST (Central Sale Tax)

– Interest Calculator

– Multi Price Level (For Dealers, Retailers etc.) 

– Multi Currency

– Scheme Entries Etc.

– Multi Colour Designing 
– Office Stationery 
– Visiting Cards 
– Posters, Brochures
– Wedding Cards, Advertisements
– Letter Heads, Calendar 
– Banners, Bill Book
– Multi Layer Designs 
– Logo Designs, Greeting Cards 
– Tools etc.

– Image Editing 
– Photo Mixing 
– Multiple Photos Programme 
– Boarder Creation 
– Marriage Photos
– Karizma Album
– Tools, Special Effects, Cards 
– Short Commands 
(To do Work Smartly)
– Jewellery Effects, Pagadi, Shuits etc.
– Black & White Photo to Color Photo
– Modeling Photo
– Digital Ball
– Clouds Effects
– Rainbow
– Realistic Water Reflection Fire
– Sparkle Trail
– Realistic Water Drop
– Light Through Blinds, 
– Hair Color
– Water Reflection etc.

-Introduction To Adobe Photoshop 
-Resizing & Cropping Images
-Masking & Clipping 
-Working With Basic Selections 
-Getting Started With Layers 
-Painting In Photoshop 
-Photo Retouching 
-Introduction To Color Correction 
-Using Quick Mask Mode 
-Working With The Pen Tool 
-Animation
-Creating Special Effects 
-Exporting Your Work

– Book Composition 
– Thesis Work 
– Project & Other Reports
– Office Stationery
– Bio Data, Posters, Folders, Resume 
– Banners, News Papers 
– Multi Layer Designs, Tools 
– Letter Heads 
– Calendar 
– All type of DTP Work.

Principles and basics of print media, Designing layouts 

with vector and raster graphics using Adobe InDesign

 This course offers the following modules:

• Module 1: Getting Started
• Module 2: Creating and Viewing a Document
• Module 3: Managing Pages and Books
• Module 4: Managing Text
• Module 5: Formatting Text
• Module 6: Placing and working with Graphics
• Module 7: Working with Objects
• Module 8: Managing and Transforming Objects
• Module 9: Applying and Managing Color
• Module 10: Working with Tables
• Module 11: Working with Styles
• Module 12: Finalizing Documents
• Module 13: Exporting a Document
• Module 14: Printing and Outputting a Document
• Module 15: Setting Preferences

• 2D:-
• INTRODUCTION
• CREATING DRAWINGS BY DRAW COMMANDS.
• MODIFICATIONS OF DRAWINGS BY USING MODIFY COMMANDS.
• CREATING ARRAY.
• DRAFTING SETTINGS.
• DIFFERENT SELECTION METHODS.
• ADD ANNOTATIONS TO THE DRAWINGS LIKE-(TEXT,DIMENSIONS,MULTILEADER,TABLES)
• STYLING OF TEXT, DIMENSIONS, MULTILEADER, TABLES.
• HOW TO WORK WITH LAYERS.
• AREA CALCULATIONS.
• HOW TO DRAW PROJECTIONS TO CREATE SECTIONS AND ELEVATIONS (FRONT, SIDE VIEW ETC). 

PT:-

• ADVANCE SELECTION METHODS.
• CREATING GROUPS.
• DESIGN CENTER
• BLOCKS AND DYNAMIC BLOCKS.
• CREATING REUSABLE CONTENTS.
• CREATING TOOLPALATTES.
• CREATING TEMPLATES.
• CREATING ATTRIBUTES.
• HYPERLINK, DATA EXTRACTIONS, DATA LINKING, OLE OBJECT.
• EXTERNAL REFERENCES.
• HOW TO CREATE 2D PARAMETRIC DESIGN.
• PLOTING AND PUBLISHING.
• PRINTING BY LAYOUT.
• MANAGE SHEETS BY SHEETSET MANAGER.
• SCRIPTING.
• EXPRESS TOOLS. 

3D:-

• SOLID PRIMITIVES.
• EXTRUSION OF 2D OBJECTS.
• BOOLEAN OPERATIONS.
• CREATIONS OF 3D SOLIDS BY USING SWEEP AND LOFT.
• SOLID EDITING COMMANDS.
• CREATING 3D ARRAY.
• CREATE 3D OBJECTS BY REVOVLING 2D SHAPES.
• CREATING SURFACES.
• MESH MODELING.
• CREATING 3D SECTIONS.
• APPLY BACKGROUND TO 3D MODELS.
• APPLY LIGHTING EFFECTS.
• APPLY MATERIAL TO 3D OBJECTS.
• RENDER.
• MOTION PATH ANIMATION (WALK THROUGHS).

1. Introduction of Keyboard
   2. Shortcut Keys for Special Charters
   3. Practical Training
   4. The Movements of Fingers
   5. Instructions of Typewriting
   6. Speed Practice
   7. Letters Typing
   8. Tables Typing
   9. Manuscripts Typing Etc.
   & Get Free Typing Book.