MS WORD INSERT TAB: Step-by-Step complete Guide

 MS WORD INSERT TAB: Step-by-Step complete Guide

Introduction:

                   Microsoft Office application software includes MS Word Editor which can help you to create effective pages with various contents in it. You can’t imagine designing a page without using command sets of Insert Tab of MS WORD. The article “MS WORD INSERT TAB: Step-by-Step complete Guide” will guide you properly regarding creating page, inserting table and images, inserting links between two file, inserting header & Footer, placing designed text and symbols and many more.

 

Insert Tab:

Ms Word menu bar contains insert tab and this tab displays some command sets within ribbon like pages, Tables, Illustrations, Links, Header & Footer, Text and Symbols. There are some sub commands under each command set. We will study about all command sets with definition and application methods.

 

 

Pages:

Ø Cover page: These are the fully predesigned pages used to create cover page of a document. You just fill the blank columns or place holders shown in page.

Ø Blank page: Using this option user can insert one new blank page to your present document.

Ø Page Break: You can break the page from the current position of cursor on the page.

 

Note: once you insert cover page, you will see two additional command tabs on menu bar named “Table Tool (Design & Layout)” where you can find many commands. Those commands are used to edit pages as you like.

 

 

Tables:

Ø Insert Table: You can insert table specifying number of rows and columns you want in your table.

Ø Draw Table: You can draw a table using pencil tool as you want. You can design table sales according to your requirement. You can apply colourful border as well.

Ø Quick Table: There you can find predefined and predesigned table formats. You can insert one of those and fill the contents as you like.

Ø Excel Spread sheet: You can insert part of excel sheet in a table format and you can type data into it.  

 

Note: When you insert or draw table or select inserted table, you can see additional command tabs named “DESIGN” and “LAYOUT” on menu bar where you can find command sets to edit table. Use those tools to edit effectively inserted table.  

 

 

Illustrations:

Ø Picture: Under this option you can insert pictures from your computer to the open document. You can resize, and edit pictures with some limited features.

Ø Clip Art: These are the inbuilt sketches and images of computer. You can insert by searching from search bar.

Ø Shapes: Here you can find number of ready-made blank shapes (place holders) in different shapes like rectangle, square, oval, circle, stars, flowcharts, arrows, and many more, that you can insert on your document. These shapes are editable. That means you can colour it, resize it, and design it.

Ø SmartArt: There user can find diagrams, charts and graphs of all types that can be inserted as well as can be filled up with data in it. Also you can edit those smart arts slightly.

Ø Charts: Here, user can insert different types of charts according to suitablity of data. These charts can be of various category like pie, area, bar, column, line and stock etc.

Ø Screenshot: Using this command you can take screenshot of any page then crop it and insert wherever you want on your document. Press “Print Screen” key on your keyboard then paste it on Ms Paint file. Than crop or keep the original image and save it in png mode to insert in your document.      

 

Note: When you insert picture, clip art, shapes, smart art, chart and screen shot on your document, you can see additional command tab named “FORMAT” on menu bar, where you can find many command sets to edit inserted object as you wish.  

 

Links:

Ø Hyperlink: It is a type of link of text or image with a file, webpage or email address etc. inside the same document. Ctrl + K to insert hyper link. Follow the instructions to insert link.

Ø Book Mark: You can set name to a certain paragraph or portion of page or document using this command. Then you can access directly to that portion using book mark option whenever you want. For this purpose you have to select the name and click.

Ø Cross-Reference: It helps to insert reference between text and image, image and table, text and table, text and figure, heading and table etc. It is used for better explanation of anything else.

 Ms Word Home Tab

Header & Footer:

Ø Header: Using this command you can edit header position of a page. It means you can insert Text and Design it which will than appear in header position of each page of the same document. It is printable.

Ø Footer: Use this command to edit footer position of a page. Where you can place quotations, page numbers etc. And that will continuously appear in all subsequent pages of the same document. It is also printable.

Ø Page Number: You can insert serial page number starting from 1 to end page of the document. There are many formats of page number, you can choose that suits your page. They page numbers can be inserted on top, on bottom, and on margin of the page.

 

 

Note: Once you insert heard, footer and page number, you can see “DESIGN” tab that you can use to edit your text, image and number etc.

 

Text:

Ø Text Box: Using this command you can insert predesigned text boxes where you can type your contents and edit it.

Ø Quick Parts: You can use this command to insert reusable contents like Auto texts, fields etc.

Ø WordArt: Using this command you can insert decorative text on your page as well as you can edit it as you like. After inserting WordArt, you will be prompt “Format” tab where you can find number of command to edit your text inside WordArt text box.

Ø Drop Cap: It helps to create a large capital letter at the beginning of a paragraph. It should be the first letter of first row in a paragraph. You can increase the size of Capital letter up to covering height of two to three or more lines. But it should look attractive, keep in mind. These are specially used in News Paper and Magazines to attract attention of reader.

Ø Signature Line: You can insert a blank signature line with the designation of the person just below it.

Ø Date & Time: Use this command to insert current date and time at the cursor position.

Ø Object: you can insert OLE object like image or text file from any source of your computer directly to the cursor position.

 

Symbols:

ØEquations: Insert common mathematical equations and write your own equation and make necessary changes as well. It covers wide range of equations that is almost used in mathematics.

ØSymbols: Insert special symbols that do not appear on your keyboard. Like copyright symbol, trademark symbol etc.

 Ms Word Basics   

Conclusion:

We can conclude by reading the article “MS WORD INSERT TAB: Step-by-Step complete Guide” that Insert Tab is very useful for user to insert various images, tables, designed text etc. So you must learn it carefully to improve your skill in computer application. Thank You.

Ms Excel Basics 

 

   

 

MS Word Home Menu Explained: Basic Formatting & Editing Tools//How to Use the MS Word Home Menu (Step-by-Step Tutorial)

MS Word Home Menu Explained: Basic Formatting & Editing Tools

Introduction:

Microsoft Word is one of the best Text editors in application software list. You can learn the use of Home Menu of Ms Word in detail by reading the article “MS Word Home Menu Explained: Basic Formatting & Editing Tools”. The article will acquaint about all command tabs and their command sets under Home Menu with simple explanation.  

 

Command Tabs or Menus:

Each menu under menu bar is called Command Tab. Home menu of menu bar is also a command tab which comprises many command sets like Clipboard, Font, Paragraph, Styles, Change Styles and Editing. Let us discuss all command sets and their uses with short cut keys.

 

Clipboard:

This tab contains cut, copy, paste, and format painter option. To perform any of these commands, the user must select the required text at first.

Ø Cut: It is used to remove or delete text from source; (Ctrl + X).

Ø Copy: It is used to copy selected text but doesn’t delete text of source; (Ctrl + C)

Ø Paste: It is used to paste copied text at the location of cursor; (Ctrl + V)

Ø  Format painter: It copies format (designs like colour, size, and type of font) only and then applies to other type text; (Ctrl + Shift + C/V)

 

Font:

Font tab is a very crucial command sets which have commands for font editing like type of font, size of font, colour of font, background of font etc. The font command set is one of the frequently used commands of Ms Word application software. To apply all the commands on text, user must select the text at beginning.

Ø Font Type: To change font as you require; like Times New Roman, Book Antique etc. (Ctrl + Shift + P)

Ø Grow Font: To increase the size of font; (Ctrl + shift + >) / (Ctrl + ])

Ø Shrink Font: To decrease the size of font; (Ctrl + Shift + <) / (Ctrl + [ )

Ø Font Type: To select predefined size of font like 20, 22, 24 etc.

Ø Font Case: To change case appearance of text like UPPER Case, lower case, Title Case etc.

Ø  Clear formatting: To clear all format applied selected text.

Ø Bold: To change the typed text into bold. (Ctrl + b)

Ø Italic: To change the typed text into italic design. (Ctrl + i)

Ø Underline: To place underline below text. (Ctrl + u)

Ø Strikethrough: To draw a horizontally line through the middle of text.

Ø Subscript: To make a letter smaller in size and appear below next to a normal text like in H₂O, 2 is in subscript form. (Ctrl +=)

Ø Superscript: To make a letter smaller and appear above next to a normal letter like in X². 2 is in superscript form. (Ctrl + Shift + +)

Ø Text Effect: It is a set of predefined designs like Outline, Shadow, Reflection and Glow.

·      Outline: It helps to changer colour, thickness and dashes of outline of selected text.

·      Shadow: It helps to apply shadow type you want to apply on text.

·      Reflection: It helps to apply reflection look on selected text.

·      Glow: It helps to apply glow feature to make text more attractive.

Ø Text Highlight Colour: To highlight selected text background with different colour, select this option.

Ø Font colour: To change font colour as you want.

 

Paragraph:

This command set brings us amazing features like bullet setting, numbering, multilevel list, text alignment, line spacing, placing boarder around text etc.

Ø Bullet setting: To place bullets (Symbols) at the beginning of each sentence.

Ø Number list: To place serial number to make a list of items.

Ø Multilevel list: To place multilevel number to make list

Ø Decrease Indent: To decrease the indent level of paragraph from left margin. It means moving the paragraph far from left toward right margin.

Ø Increase indent: To increase indent level of paragraph towards left margin. It means expanding paragraph toward left close to left margin.

Ø Sort: To sort alphabetical data or to sort in ascending or descending order.

Ø Show / Hide: To display hidden formatting or hide formatted text.

Ø Align Left: To align text to left side. (Ctrl + L)

Ø Align Right: To align text to right side. (Ctrl + R)

Ø Align Centre: To align text at centre of page. (Ctrl + E)

Ø Align Justify: To align text to each side of margin of paper adjusting gaps between words. (Ctrl + J)

Ø  Line and Paragraph Spacing: It allows you to insert space between rows of a paragraph as well as allow inserting space between two paragraphs horizontally.

Ø Shading: To colour the background of selected text of paragraph.

Ø Text or Paragraph Boarder: It allows to place border from different points of view like border at below, side, around etc. example: left border, right border, bottom border etc.

Ø Line and page breaks: It will help you to break pages in to many parts.

 

Styles:

These are the predefined text designs for heading rows of paragraph. These options are mostly used to insert Table of Contents in Ms Word.

Change Style:

You can change and save some new styles from this option to modify text.

 

Editing:

This is one of the review features of word editing software. Here you can use options like Find, Replace, and Select etc.

Ø Find: It is used to find a certain text or word or phrase in a paragraph throughout the whole document.( Ctrl + F)

Ø Replace: It allows you to find a particular word or phrase then replace it with a new word or phrase as you want. (Ctrl + H)

Ø Select: To select all press (Ctrl + A), To select a portion ( Shift + use arrow mark).

 

Conclusion:

In the article “MS Word Home Menu Explained: Basic Formatting & Editing Tools” we come to know how the home tab is helpful to us for text editing. If you want to improve your skill, please practice all shortcut keys mentioned in this article. Thank you.

How to Create a GST Bill in Tally Prime: Step-by-Step Guide/ Tally Prime GST Invoicing: Step-by-step complete Tutorial

 

How to Create a GST Bill in Tally Prime: Step-by-Step Guide

 

Introduction

GST is known as the Goods and Service Tax. It is a type of indirect tax in India which has replaced many indirect taxes such as excise duty, VAT, service tax, etc. The Goods and Service Tax came into effect on 1^st July, 2017 in India. It is a consumption tax that is used in India on the supply of goods and services. GST is a single indirect tax for entire country. In the article “How to Create a GST Bill in Tally Prime: Step-by-Step Guide” you will get to know how to enter Purchase voucher and Sales voucher with GST applied on it.

 

 

 How to Create a GST Bill in Tally Prime: Step-by-Step Guide

 

Concept of GST

The GST is just one tax with three components CGST, SGST and IGST. When the supply of goods or services happens within a state called intra-state transaction, then the CGST (Central GST) and SGST (State GST) will be collected. Whereas if the supply of goods and services happens between the states called as inter-state transactions, then only IGST (Integrated GST) will be collected.

 

The following indirect taxes have been covered by GST.

·       Central Excise Duty

·       Additional Duties of Excise

·       Special Additional Duty of Customs

·       Cess

·       State VAT

·       Central Sales Tax

·       Purchase Tax

·       Luxury Tax

·       Entertainment Tax

·       Entry Tax

·       Taxes on advertisements

·       Taxes on lotteries, betting and gambling

 

The following taxes have not been covered by GST.

·       Alcoholic liquor for human consumption

·       Petroleum crude

·       High-speed diesel

·       Motor spirit (commonly known as petrol)

·       Natural gas

·       Aviation turbine fuel etc.

 

GST Registration

The GST regime, a business whose turnover is more than Rs.40 lakhs is required to register as a normal taxable person. But Rs.10 lakhs for North East states and hill states are required for same. If any organization carries on business without registering under GST, it will be an offence under GST and heavy penalties will apply. The following documents are required for GST Registration.

·       PAN card and Aadhaar card of the applicant.

·       Proof of business registration or incorporation certificate.

·       Identity and address proof of promoters or director with photograph.

·       Address proof of the place of business.

·       Bank Account statement/ cancelled cheque.

·       Digital signature

·       Letter of authorization/Board Resolution for Authorized Signatory.

 

Format of GSTIN

 

 

What is GST BILL?

When purchase or sale bill is prepared with GST applied on it is called GST Bill. Before passing bill you should enable GST in Tally Prime.

 

Enabling GST option in Tally Prime:

To use GST features in Tally Prime, you need to activate the GST Feature. Once activated, GST related features are activated in ledger, stock item, transactions and GST returns. To activate GST features, Press F11 key and set Enable Goods and Service Tax (GST) option to Yes. Now GST details screen will be displays. Set the options as per given below. You must do it before entering any voucher for transaction at the beginning.

 

Process of Purchase and Sales Bill with GST in Tally Prime.

Before doing purchase and sales voucher entry with GST, the user needs to prepare some ledger accounts. Such as Ledger or Account creation for GST Bill like Sundry Creditor, Sundry Debtor, CGST, SGST and IGST.

 

Stock Item creation with GST

GST rates are mainly applied according to stock items, so calculations of taxes in GST ledgers are as per stock items. Before transactions in Tally Prime, you must set the GST Rates in stock items. To set the GST Rates in stock items, select stock item from create menu. Now stock item creation screen will be displayed. Set the options as per given below.

 

 

 As per GST rules, HSN code of each stock item must be written on invoice, if HSN/SAC field does not displays on GST Details screen, than press F12 key and set Allow HSN/SAC Details options to Yes.

 

In GST details screen, select appropriate classification in classification field. All tax details are filling automatically according to the selection of GST Classification. If you want to enter the tax details manually, then select Undefined in classification field. Select on Value option in calculation type field.

Select On item rate to calculate tax on the basis of item rate.

Select Taxable if you buy and sale taxable goods.

 

Stock item creation using GST Classification

·       Name: Type AC-LG 1.5 Ton in it

·       Under: Select Primary in it.

·       Unit: Select Nos. in it

·       GST applicable: Select Applicable in it.

·       Set/Alter GST Details (GST Rate and Related Details): Select GST @28% in classification field.

·       Types of supply: Select Goods in it.

 

Creating GST ledgers (IGST, CGST, SGST, CESS)

IGST Ledger creation:

It is the main tax head of GST. When a trader exchanges their goods or services with merchants from one state to other states, the related tax is managed in integrated tax. Integrated tax is also known as IGST.

 

Create an integrated (IGST) tax ledger as follow.

·       Name: Enter Integrated Tax in this field

·       Under: Select Duties & Taxes

·       Type of Duty/Tax: Select GST

·       Tax Type: Integrated Tax

·       Percentage of calculation: Enter 0 (Zero)

·       Rounding method: Not applicable

 

 

Create a Central (CGST) tax ledger as follow.

·       Name: Enter Central Tax in this field

·       Under: Select Duties & Taxes

·       Type of Duty/Tax: Select GST

·       Tax Type: Central Tax

·       Percentage of calculation: Enter 0 (Zero)

·       Rounding method: Not applicable

 

Create State GST (SGST) tax ledger as follow.

·       Name: Enter State Tax in this field

·       Under: Select Duties & Taxes

·       Type of Duty/Tax: Select GST

·       Tax Type: State Tax

·       Percentage of calculation: Enter 0 (Zero)

·       Rounding method: Not applicable

 

Create CESS tax ledger as follow.

·       Name: Enter Cess in this field

·       Under: Select Duties & Taxes

·       Type of Duty/Tax: Select GST

·       Tax Type: Cess

·       Percentage of calculation: Enter 0 (Zero)

·       Rounding method: Not applicable

 

Recording Local Purchase

Example: Company has purchased 2 AC-LG 1.5 Ton @27500 and 2 UPS@3200 from Manoj Traders Jaipur and received a total bill of Rs.77952 from the party. This includes central Tax of Rs.8276 and State Tax of Rs.8276. the GST rate on ups is 18% and on AC is 28%.

 

·       Go to voucher from gateway of Tally and click F9: Purchase button.

1)  Now press F12 key and set the following options

2)  Provide supplier details: No

3)  Select common ledger account for item allocation: yes

4)  Use default bill-wise for bill allocation: yes

5)  Provide supplier invoice details: yes

6)  Modify tax rate details for GST: yes

·       Create or Select Manoj Traders account under sundry creditor.

·       Select or create Purchase a/c under purchase

·       Create or select stock item with GST applied on it

·       Create or select CGST ledger and SGST ledger

·       Type narration and finish.

 

 

 

Recording Local Sales

Example: the company has sold 2 AC@38500 and 2 UPS@4500 to Entertain Media House, Jaipur and issued a bill of Rs.109180 including central tax off 11590 and state tax of 11590.

 

1.   Go to voucher and click F8: Sales button

2.   Press F12 for configuration

3.   Set provide buyers details: No

4.   Provide Dispatch, order and export /Import Details: No

5.   Select common ledger account for item allocation: Yes

·       Create a new ledger as name of Entertain Media House, Jaipur under Sundry Debtors. Or select if you have already created.

·       Create or select sales ledger under sales account

 

      

To print invoice after purchase and sale follow these steps:

·       Gate way of Tally

·       Open Display Column

·       Click on Day Book

·       Select the certain Bill

·       Use shortcut Ctrl+P or select P:Print option on screen

·       Select Preview or Print

 

Work sheet:

Purchase Bill:-

Company has purchased 10 Ceiling Fan@1200 and 20 Table Fan@1500 from Blue Star Company Lucknow, and received a total bill of Rs.47040. This bill also includes Integrated Tax of Rs.5040. The GST rate is 12% is applicable on Ceiling Fan and Table Fan.

 Sales Bill:-

Company has sold 3 Table Fan@2200 and 2 Ceiling Fan@1800 to Bharat Enterprises, Lucknow and issue a sales bill of Rs.11424 including an integrated Tax of Rs.1224.

 

Conclusion:

This article “How to Create a GST Bill in Tally Prime: Step-by-Step Guide” must have given you clear cut idea of GST purchase and GST sales billing. It a small part of GST concept used in Tally Prime. There are much more to learn about it. So our team will update with new information as soon as possible. Thank you.