Unformatted text preview: almost idiot proof, which is basically what it needs to be when dealing with general users. Tables, sorting, filtering and pivot tables are all necessary tools when dealing with records. The Excel functions dealing with databases are all valuable tools for accountants and used on a daily basis. Dealing with a database of the sheer magnitude of most companies would be an overwhelming task for an accountant without the assistance of the Excel sorting and filtering functions. These functions allow the accountant to run multiple reports based on certain criteria. These reports include a subset of records; ones that meet the criteria outlined in the filter. Management requires these reports to assess the financial standing of the company, and constantly rely on the expertise of the accountants to provide them with the necessary information in order to make informed decisions....
View Full Document
- Spring '11
- Accountant, valuable Excel tool