Create The Journal and Journal Entry with Excel (Part 2)

In part 1, you have study how to create a current date and dropdown list of posting reference identifying the number of the account posted. Now we will study how to link Account Tittle  column with Posting Reference column. If you are beginner in excel, maybe you will need more times to practice this method.

Read More

Create The Journal and Journal Entry with Excel (Part 1)

A journal includes all accounting transactions and is considered the historical record for a business entity. All transactions must be recorded through a journal entry that provides specific instructions in a line-by-line sequence. In this post, I will show you How to create the Journal and journal entry with Excel. 

Read More

How to Label Your Account in Excel

In making financial reports, the first thing you should consider is how you manage your account groups. If you are wrong in a group set up an account, then in the making of general ledger or trial balance, you will have trouble. Grouping of accounts will accelerate and simplify the processing financial journal reports at any time.

In this post, I will introduce the basics of classifying and labeling an account with excel for beginners.

Read More

How to Measure the Area of ​​the Polygon With Excel

Measure the area of ​​a polygon that is known only corner points is not an easy job. If you find that the actual polygon composed of some form, then you will try to divide the polygon into several small pieces to be a square or triangle so you can easily calculated and combines all the small parts area. Of course it is not a practical way. 

Read More

Tips: How to Copy a Column That Contains a Formula

In working in Microsoft Excel, sometimes we want to copy a column that contains numbers, where the numbers are the result of a calculation of the other columns. When we tried to copy it to the other columns, it does not appear the original, but a row contains of zeros.

Read More