Browsing "Older Posts"

  • Home Tab MS-Word Tutorial

    By Adhyan Guruji → Sunday, September 27, 2020

      

      

    Home Tab


    •  Clipboard

     

    Clipboard contains Copy and Cut data in the Clipboard section, if we copy different-different text and want to paste all or any single text using the clipboard area. In the Clipboard section

    o   Cut (Ctrl+ X) used for clear Selected data,

    o   Copy (Ctrl+ C) is used for copy Selected data in memory,

    o   Paste (Ctrl+ V) is used for re-print copy or cut data and

    o   Format painter Icons paste formatting from one text to another text. Cut and Copy active when Data is selected. 

     

    •   Font  

     

    Font Section contains Formatting Commands which is applied to the selected text.

    o   B (Ctrl+ B) is used for BOLD (Strong) Text,

    o   I (Ctrl+ I) is used for Italic (Slant letter to Right),

    o   U (Ctrl+ X) is used for Underline Word and there is more options for underline.

    o   Increase/Decrease the Font size Minimum 1 and Maximum 1638 size.

    o   Font Type (Calibri (Body)) Show the current font we change different Font type e.g. Arial Black, Calibri, Cambria, and Times new roman is a different font type.

    o   Font color, highlight color, Change case (Upper Case, Sentence case or Lower Case) of the word, Text effects, Strikethrough on word, SuperScript (92), and Subscript (H02) for the selected text. At last, if we want to remove/clear formatting we use the Clear all Formatting (Ctrl+ Spacebar) command.


    •            Paragraph

     


    The paragraph Section consists of Bullet and numbering Commands, Alignment Related commands, Data Orders (Ascending/Descending), Line spacingshade Color and Borders command.

    o   Text Alignment – Center (Ctrl+ E), Left (Ctrl+ L), Right (Ctrl+ R) and Justify (Both side equal) - (Ctrl+ J) Selected Data

    o   Line Spacing – Set the Paragraph line Spacing (1.15) Normal Spacing, Maximum line spacing we can set on Paragraph (1584 PT).

    o   Shade color is used to fill color in current line or selected data

    o   Borders – Using Border we can apply border for all direction on selected text, or can apply on Top/bottom/left and right- (Anyone)

    o   Bullet – Bullet arrange our selected data in unordered-list, here we can set different symbol list on selected data.

    o   Numbering – Numbering arrange our selected data in the ordered list can be in Digit, Roman, or alphabetical order.

    o   Multilevel List – if we organize Multilevel List data e.g.

    Tense and its Parts with Subparts Organize with help of increase/Decrease Indent.

    1.       Tense

    a.       Present tense

                                                                                                      i.      Present indefinite

    o   Increase/Decrease Indent – Change the indent/level of the current line or selected data using increase Indent. If decrease the level of selected text use decrease indent command.

    o   Sort - Arrange the selected data in Ascending/Descending order.

    o   Paragraph Mark - it shows the hidden data on the document.

    E.g. Hidden Tab space, Enter or Space, or any other Hidden data. If we want to hide data it can hide by using - (Ctrl+ Shift + H) Key.


    •      Style

     

    o   Using Style we can format (Color-Size-Font Type or any other font Style) our text, there are many predefined styles available in style section.

    E.g. Heading 1, Heading 2, or any other Style

    o   We can create our own Style by formatting text and select formatting data, click on Create a Style in Style Section.

    o   Style can be modified (Color/Font etc...) or can be delete if not required.


    •           Editing


    Editing section Consist Find, Replace and select commands to modifying text in our document.

    o   Find – If anyone wants to search/find any word in our document, we easily find with Navigation search, type here target word, and find related records.

    -Short Key for Find Using (Ctrl+ F)


    -Advance Find Section we can find

       

    Match case data, or Whole word only data

    Goto Command (Ctrl+ G) – Jump to another page if more than 1 page inserts in the document.


    o   






    Replace – if we replace any text in a selected or whole paragraph, we can easily replace a single word by a word or replace all word In 1 time using the Replace command (Ctrl+ H). Here is some example of replacing the word into this word.


    o   Select –

    Select ALL - if select all data click on Select All (Ctrl+ A) command it select the entire document.

     Select-Object – it is used to select any object with mouse draws from the document.

     Select Text (Similar formatting) - it select the whole data which is the same formatting found on the document.

      Selection Pane – Hide/ Show any object or image draw on the document.

























  • Word - Introduction

    By Adhyan Guruji →

     


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