Browsing "Older Posts"

  • Word - Introduction

    By Adhyan Guruji → Sunday, September 27, 2020

     


    MS-Word (Theory)

    What is MS-Word and its use?

    MS-Word is a part of the MS-Office Package, We can Use MS-Word for making documentation, Table Work, Resume Making, Create Report, or any other Document. The latest MS-Office version is MS-Office 2019. MS-Word is advance version of WordPad. In MS-Word Maximum 32,767 Pages Insert in Single Document. Default title of page is Document1 and .DOCX is the extension of Word Document.

    MS-Word has the following important features

    ·         Style Creation

    ·         Auto correction

    ·         Spelling and grammar checking

    ·         Document Design

    ·         Compare Files

    ·         Working with images/Logo in Documentation

    ·         Review Documents

    ·         Mail-Merge (Multiple Documents creation)

    ·         Digitally signature

     

    Other useful important Keys Point in MS-Word.

    o   Status Bar

    Show the information about the total number of words, the current and total number of pages in the document, View mode (Zoom in/ Zoom out), current dictionary information (United States), and spell & Grammar Errors. Zoom view % should be between 90% to 110%. And layout in print Layout mode. It shows the bottom of the document. Here is an image of the status bar.


       

    o   Ruler (Vertical and Horizontal) and Page Margin (Top/ Bottom / Right and Left)

    It is used to measure the Page Layout in Inches also we can change the measurement setting and show it in Picas, Millimeter, Point, or centimeter in the Setting (Advance) area. In Vertical ruler we can set (Top/Bottom) Margin and In Horizontal Ruler we can set (Left and Right Margin). In Horizontal Ruler we can set the Tab Setting for Tab Key by Double click in Ruler Section, Maximum and Minimum measurement between -22 to 22. Here is an image of a Ruler.

     


      

    o   Title Bar

    Show the information about Document name, Minimize file, Restore or Maximize and close the file icon. We can set the Quick Access toolbar icon it shows the left side area which we can use in our document.




       

    o   Scroll Bar (Horizontal / Vertical)

    With the use of a Vertical Scroll bar using a mouse click, we can move the page down or up easily and if our page zoom is more than 120% then horizontal scroll bar show automatically to the scroll page left or right.  

     

     


         

    o   Working TAB

    In MS-word there is 8 Tabs for working,

    1.       Home Tab

    2.       Insert Tab

    3.       Design Tab

    4.       Page Layout Tab

    5.       Reference Tab

    6.       Mailings Tab

    7.       Review Tab

    8.       View Tab

     

    File Menu Show 1st and then 8 Default Tab, but if any Commands activate then related TAB will automatically open. E.gTable Related (Design Tab and Layout Tab), Image Related (Format Tab) etc…

    Let’s Study about File Menu and ALL other Working Tabs in MS-Word 



  • Tally ERP9 - Short Keys (Important)

    By Adhyan Guruji → Saturday, September 26, 2020

    Short-Key - Tally -ERP9

     Ãœ  From Gateway of Tally

     

    Sno.

    Keys

    Description of command

    1

    Alt + F3

    Company Info

    2

    F3

    Select company (Existing open Company)

    3

    Alt + F2

    Period change  of company

    4

    Ctrl + Q

    Exit/Close Tally

    5

    Alt + F1

    Shut Company

    6

    F11-F1

    Accounting Features

    7

    F11-F2

    Inventory Features

    8

    F11-F3

    Statutory & Taxation Features

    9

    F1

    Select/open Company

    10

    D,A,C

    Displayà Account Book à Cash-Bank Book

    11

    D,A,P

    Displayà Account Book à Purchase Register

    12

    D,S,O

    Check Outstanding Balance-Receivable/Payable

    13

    V

    Voucher Entry

    14

    A,L,C

    Ledger Creation

    15

    I,I,C

    Stock Item Creation

     

    Ãœ  Into Accounting Voucher

    Note – Some Command working when The Option is ‘Yes’ in Feature According to Description

     

    Sno.

    Keys

    Description of command

    1

    F2

    Transaction date Change

    2

    F4

    Contra Voucher

    3

    F5

    Payment Voucher

    4

    F6

    Receipt Voucher

    5

    F7

    Journal Voucher

    6

    F8

    Sales voucher

    7

    F9

    Purchase Voucher

    8

    Ctrl + F8

    Sales Return/Credit Note Voucher

    9

    Ctrl + F9

    Purchase Return/Debit Note Voucher

    10

    Ctrl + L

    Optional Voucher

    11

    Ctrl + F5

    Payroll Attendance (Employee)

    12

    Ctrl + F4

    Payroll Salary Calculation (Employee)

    13

    Alt + A

    Payroll Auto-Fill (Salary Calculation)

    14

    Alt + E

    Export Voucher in JPG,XLS,PDF format

    15.1

    Alt + P

    Print Voucher

    15.2

    Alt + I

    Item Only/Account Only

    15.3

    Alt + Z

    Zoom Voucher Preview

    16

    Alt + F7

    Stock Journal Voucher

    17

    Alt + F4

    Purchase Order

    18

    Alt + F5

    Sales Order

    19

    Alt + F9

    Receipt Note

    20

    Alt + F8

    Delivery Note

    21

    Ctrl + F6

    Rejection Inward

    22

    Alt + F6

    Rejection Outward

    23

    Alt + F1 à Alt + S

    Stock Query

    24

    Alt + C

    Short-Cut Ledger/ Item etc..Creation

    25

    Alt + M

    Mailing Voucher

    26

    Ctrl + A

    Save Voucher

    27

    Alt + D

    Delete Voucher

    28

    Ctrl + V

    Single Mode/ Invoice Mode

    29

    Ctrl + F2

    Order Voucher Show

    30

    Alt + J

    Job Work Out Order

    31

    Alt + W

    Job Work in Order

    30

    Ctrl + W

    Material in

    31

    Ctrl + J

    Material Out

     

     

    Ãœ  Into Profit/Loss Account or Balance Sheet

     

    Sno.

    Keys

    Description of command

    1

    Alt + F1

    Details/Condensed

    2

    F2

    Period changed

    3

    F9

    Inventory Report

    4

    F10

    Accounting Report

    5

    Alt + N

    Report (Month/Daily etc..)

    6

    Shift + Enter

    Show Group Details (click on Group e.g. Purchase/Sales)

    7

    Ctrl + Enter

    Modify in Ledger

    8

    Ctrl + N

    Calculator On

    9

    Ctrl + M

    Calculator Off

    10

    F12

    Configuration

     

    Ãœ  Into Ledger Creation/Group Creation/Voucher Creation

    Sno.

    Keys

    Description of command

    1

    Ctrl + G

    Goto to Group Creation

    2

    Ctrl + L

    Goto Ledger Creation

    3

    Ctrl + V

    Goto Voucher Creation

    Ãœ  Into Stock Item Creation/ Godown Creation or Any Other Inventory Info Creation

     

    Sno.

    Keys

    Description of command

    1

    Ctrl + G

    Goto to Stock Group Creation

    2

    Ctrl + U

    Goto Units of measure  Creation

    3

    Ctrl + V

    Goto Voucher Types Creation

    4

    Ctrl + C

    Goto Category Creation

    5

    Ctrl + O

    Goto Godown Creation

    6

    Ctrl + I

    Stock Item Creation

     

     

    Ãœ  Into Gateway of Tally à Banking à Cheque Register

     

    Sno.

    Keys

    Description of command

    1

    Alt + F1

    Details of Cheque instrument

    2

    F5

    Reconcile Cheque

    3

    Ctrl + S

    Quick Search

    4

    Alt + S

    Show All Cheque Details

    5

    F7

    Transaction

    6

    F6

    View Status of Check

    7

    Alt + F5

    Status Wise Check

     

    Ãœ  Into Gateway of Tally à Stock Summary

     

    Sno.

    Keys

    Description of command

    1

    F7

    Hide Profit /Show Profit

    2

    F5

    Group Wise/Item Wise

    3

    F4

    Show item group Wise

    4

    Alt + F12

    Range Check, With Amount or Name Wise

    5

    Alt + N

    Auto Column Wise Check

    Ãœ  By Pressing Alt+P (Print any Transaction)

     

    Sno.

    Keys

    Description of command

    1

    Alt + L

    Print Language

    2

    Alt + I

    Print Preview on/Off

    3

    Alt + T

    Title of page

    4

    Alt + G

    Page no Range

    5

    Alt + F

    Print Format

    6

    Alt + C

    No of Copies Print

    7

    Alt + S

    Select Printer

    8

    F12

    Print Paper Configuration

    Ãœ  Into GSTR Report

     

    Sno.

    Keys

    Description of command

    1

    Alt + V

    View Summary / Return format Report

    2

    Alt + U

    Status reconciliation

    3

    Ctrl + A

    Voucher Accept as Valid

    4

    Alt + J

    Adjustment

    5

    Alt + E

    Export Json or other Format


    Other Short Keys

     ·         Apply TDL in Tally (Keys)

    Alt + Ctrl + T then press F4 (Manage TDL)

     ·         Pre- Close order for Purchase/Sales order Report

    Ctrl + C

     ·         GST-Details in Voucher (Sales/Purchase)

    Alt+A then Alt+F1 for details

     ·         Import Statutory Master

    Alt + Ctrl + i

     ·         Import Statutory Master

    Alt + Ctrl + i

    Note

    Above Short cut key Work when (Command feature is on) whether it is inventory feature/Accounting/Taxation feature or Order voucher etc…)