Microsoft Excel has many wonderful features to offer the small business user. Excel is most widely known for its spreadsheet function, though it has numerous other uses. Spreadsheets are useful to any type of small business. For example, a spreadsheet can be used as an accountant’s ledger or a professor’s grade book. Invoices and budgets can be prepared with Excel and one might use it to balance a checkbook as well. Spreadsheets are extremely useful in the decision making process and the Goal seek command can even be used to return user specific results. Another popular function of Excel is the ability to prepare and maintain lists such as vendor, customer or employee lists. The user can then use the Filter or Sort commands to produce results that meet a specific criteria. For instance, a tax preparation service might use these commands to return a list of customers who have not used their services for two years or more. They could then market specifically to those customers and perhaps offer them a discount in order to reacquire their business. Lists created in Excel can be converted to pivot tables and pivot charts to summarize the data. What’s exceptional about pivot charts and tables is the ability
Moustafa Azmi