Today I am going to explain about microsoft excel and its purpose of use, now let's start.
Introduction
Excel program was created by microsoft company and this program is basically used for accountant purpose. First version was released in 1985 and from time to time update versions are still coming.
Daily petty cash book, bank and other entries can be done in one workbook by inserting different spreadsheets for separate work's.
All calculations are done by using automatic and manual formulas by selecting rows and columns numbers. There are lots of formulas used by professionals.
There is different currency sign options to select according to regions. But it can be used according to requirement. Otherwise only numeric numbers can be used for single currency.
Excel program is not limited to calculations only but other professional work can also be done by creating pivot tables for data statistics and so on.
Data can be manage in ascending order, it can remove duplicate contents and can also replace text at once. Separate data in rows and columns can be merged and split into parts by using formulas.
Data can also be calculated from two separate sheets into one, it just required manual formulas to add. Other functions are also used to correct text data like uppercase to lowercase and so on.
There are more tools that can be used for job done in excel. But here i am going to teach beginners how to use basic formulas for calculating numbers from different row, column and some others works from time to time.
Many companies now a days use ERP (Enterprise Resource Planning) system to manage all accounts. But still in other hand excel program is really important to learn because some small companies do not use ERP (Enterprise Resource Planning) but we have to manage all accounts in excel sheets.
I am going to start my first lesson in other topic, so get ready to learn.
