Posts

Showing posts from January, 2022

Tally Prime Learning - Create Company, Ledger, Stock & more)

Image
Tally Prime is today amongst the most important softwares an accountant uses to do all his accounting work. Here, you will learn step by step procedure of passing various accounting entries in different Vouchers of  Tally Prime to generate Trial Balance, Profit & Loss A/c & Balance Sheet in Tally Prime. Ledger:-  It is created to make an accounting entry. Ledger is Debited or Credited in any Accounting Voucher. Without creating ledger we cannot make any entry in Tally Prime. While creating Ledger, Ledger Group is selected to put it under that Ledger Group. Ledger Group:-  We have to select any ledger Group while creating a new Ledger. We can select from default Groups or we can created a new ledger Group. Accounting Voucher:-  In this Ledgers are debited and credited to make accounting entries. Create a New Company in Tally Prime    To create a new company in Tally Prime: Go to   Gateway of Tally , then Press  Alt + K , and select " C...

Microsoft Word Learning - Make a document in MS & more

Image
  MS Word is a software programme in which we can make any document. We can maintain text, picture, excel sheet and many more things in MS Word. It is mainly used for making documents such as letters, reports, etc. Learn some basic short cut keys which is useful in MS Word. To open MS Word:  Press Window+R to and type "winword" and press enter. To Copy: Ctrl+C To Paste: Ctrl+V To Cut: Ctrl+X To find anything: Ctrl+F To Find & Replace: Ctrl+G To Save document: Ctrl+S There are 7 types of Tab in MS word which is used to create a document. 1.  Home:  Here we can change  font styles  (size, colour, design, etc.) , copy, paste, find replace, text alignment, etc. 2.  Insert:  Here we can insert pictures, tables, word arts, charts , etc. 3.  Page Layout:  Here we can set page margins, orientation (landscape / portrait), insert watermark, page colour, page borders, indent & spacing, etc. 4.  References:  Here we can make table ...

Microsoft Excel Learning & Useful Formulae in MS Excel

In Microsoft Excel, we maintain various types of data and analyse them. We can calculate our data and keep our data in the way we want. We type data in various cells of the excel sheet. Total No. of Rows: 1048576 Total No. of Columns: 16384 So, in excel we have total of 17179869184 Cells to enter data. We can maintain huge data in MS Excel.   Calculation of values are done in MS Excel with the help of Formulae. To open MS Excel:  Press Window+R to and type "excel" and press enter. Let's learn some basic useful MS Excel Formulae: For Addition of cell A1 and A2:     =A1+A2 For Addition of cell A1 and A2:    =A1-A2 For Multiplication of cell A1 and A2:    =A1*A2 For Division of cell A1 and A2:    =A1/A2 To add many cells in a row or column:    =sum(cells range) To find out Maximum Value  in a row or column:      =max(cells range) To find out Minimum Value in a row or column:  ...

Learn Accounting Basics - Rules of Debit & Credit & More

  Accounting is the process of recording, summarizing, analysing and reporting financial transactions of a business. It is done in accounting softwares such as Tally Prime or others. An accountant maintains day to day business transactions on accounting software and also maintain physical records of these transactions i.e., sales files, purchases files, bank statements, etc. Accounting transactions are recorded in Accounting Voucher by debiting and crediting Ledgers. Example: Purchases A/c ............. Dr.  20000                    [debit] To Mr. Ram                              20000         [credit] Accounting Voucher here is :  Purchases   Purchases A/c & Mr. Ram is: Accounting  Ledgers This is called journal entry. In any accounting voucher total ...