Using Macros to Get the Most Out of Excel

974 Words2 Pages
bulb-icon

Recommended: Manual and computerized auditing

Using Macros to Get the Most Out of Excel

As accounting professionals, accuracy in financial calculations and the integrity of the raw data are vital to producing useful information. Our clients prevail upon us to be more accurate and more thorough in less time. The tremendous advances in information technology are apparent across most industries. Accountants can gain much from this revolution through advances in spreadsheeting.

Microsoft Excel is an application that can produce an almost infinite number of financial calculations. A way to orchestrate a manipulation of data is to use spreadsheeting. Another more efficient way of manipulating or extrapolating data is by playing a macro.

A macro is a stored sequence of commands that can be imposed on data. Playing the macro initiates the sequence. When the macro is finished playing, the final manipulation or extrapolation is produced. This could be for example the production of a summary report.

An example of this is to view the information in a spreadsheet as raw data. (We must assume the data is all accurate otherwise rubbish in rubbish out). The data is strewn all over the spreadsheet. The macro can be seen as a filter. As we apply the macro to the data, it is like we pour the data through a filter. The information we need is collected in the filter.

Macros are more than just filters however. Using a real world example; an accountant is required to prepare a report showing the changes profit and loss figures over time for interpretation. The macro will not collect any existing data. It will manipulate the data and prepare a report showing percentages and ratios relevant to turnover and gross profit margins etc.

The macro provides this function repe...

... middle of paper ...

...ial Excel 2000 Book, Rocklin CA, Prima Tech

(8) Perry, G., (1999), Excel 2000 Answers!, Berkley, CA, Osbourne.

(9) Walkenbach, J., (1999), Excel 2000 Programming for Dummies, Foster City CA, Transworld.

(10) http://support.microsoft.com/support/kb/articles/q177/7/60.asp

(11) http://www.surfer.ch/opendir/Top/Computers/Software/Spreadsheets/Excel

(12) http://www.oclc.org/oclc/ill_mgmt_stats/reportmc.htm

(13) http://support.microsoft.com/support/kb/articles/q177/7/60.asp

(14) http://www.add-ins.com/online.htm

(15) http://press.oreilly.com/excel.html

(16) http://directory.google.com/alpha/Top/Computers/Software/Spreadsheets/Excel

(17) http://www.oreilly.com/

(18) http://www.accountingadvisors.com/

(19) http://www.hqda.army.mil/AAAWEB/auditinfo.htm

(20) http://www.mctc.commnet.edu/staff/kelly/ac105.html

(21) http://www.npo.net/itrc/courses/spreadsheet.html

Show More
Related

  • M3 : Compare Different Technology Methods

    709 Words  | 2 Pages

    In MOD’s excel workbook I have used many macros to create shortcuts to different sheets and also macros to perform various tasks. Overall using macros will speed up how fast the end user can use and navigate the sheet and also make it easier to use. I have also used auto-sum, this automatically entered in a certain formula that I had chosen. By using auto-sum I saved time by not having to enter in long formulas. I have also used an automated filter tool, this tool filters out any data that the user decides is unneeded, which will help the user as it does not show data that useless to them or is unneeded.

    Read More

  • IRS and Tax Regulations

    1635 Words  | 4 Pages

    The majorities of financial advisers do not have a formal accounting or tax background and thus have some challenges to overcome when reading tax returns of their clients. However they are still asked to help their clients in future planning. Since most accounting is to be done based on compliance with GAAP it would make sense to think that tax accounting should also be done this way, however both the IRS and the courts have stated that compliance with GAAP is of little significance when dealing with the objectives of tax accounting. The objectives of both accounting methods are simply different, because the primary goal of financial accounting is to provide useful information to all stakeholders and the primary goal of the income tax system is the equitable collection of revenue. Because of these differences it can be said that the users of accounting information are different for both methods. The assumption for financial accounting is the going-concern and the tax accounting system ignores this assumption. These differences give us the concept of timing differences and permanent differences. Understanding...

    Read More

  • Chapter 9 Project 9D Recording and Assigning a Macro

    760 Words  | 2 Pages

    ...er what career field you may enter. The data has to be collected properly without it being so time consuming ,and it’s not only the functions that was collected in chapter 9 but the concepts that the entire Microsoft excel workbook is teaching can impact ones career effectively in a positive way. Excel creates a way for individuals to be on top information that is highly needed, without excel calculating this data will then become time consuming and then inaccurate, be smart about it and know what is what when dealing with different types data that’s needed depending on your career. It doesn’t if you’re a teacher, doctor, contractor, musician, or any other profession out there. Collect data the smart way. Be your own boss, and know what it takes.

    Read More

  • Nt1330 Unit 1 Assignment

    3492 Words  | 7 Pages

    In accounting we had to do balance sheets at home we were allowed to use the computer and I used excel because it lets you draw things up in charts easy and look at your data as a whole clearly it also saves time by not making you do calculations yourself because you can get it to add up all the figure in a column or row.

    Read More

  • Advantages And Disadvantages Of Forensic Anthropology

    1594 Words  | 4 Pages

    policies as well as practices. It enables authorities to make informed decisions based on the

    Read More

  • XBRL Extensible Business Reporting Language

    1121 Words  | 3 Pages

    XBRL, the eXtensible Business Reporting Language, is an open standards-based reporting system built to accommodate the electronic preparation and exchange of business reports around the world. XBRL started back in 1999 with 12 organizations as the founding members. There are now in excess of 450 organizations worldwide in over 30 countries involved in its development. It provides major benefits in the preparation, analysis and communication of business information. It offers cost savings, greater efficiency and improved accuracy and reliability to all those involved in supplying or using financial data. The idea behind XBRL, eXtensible Business Reporting Language, is simple. Instead of treating financial information as a block of text - as in a standard internet page or a printed document - it provides an identifying tag for each individual item of data. This is computer readable. For example, company net profit has its own unique tag. The introduction of XBRL tags enables automated processing of business information by computer software, cutting out laborious and costly processes of manual re-entry and comparison. Computers can treat XBRL data "intelligently" as they can recognize the information in a XBRL document, select it, analyze it, store it, exchange it with other computers and present it automatically in a variety of ways for users. XBRL greatly increases the speed of handling of financial data, reduces the chance of error and permits automatic checking of information. Companies can use XBRL to save costs and streamline their processes for collecting and reporting financial information. Consumers of financial data, including investors, analysts, financial institutions and regulators, can receive, find, ...

    Read More

  • Budget Analysis

    1842 Words  | 4 Pages

    Marshall, M.H., McManus, W.W., Viele, V.F. (2003). Accounting: What the Numbers Mean. 6th ed. New York: McGraw-Hill Companies.

    Read More

  • Quickbooks Accounting Software

    1583 Words  | 4 Pages

    Accounting/Finance application systems like Peachtree, Net Suite and QuickBooks let you manage your business with a little or no experience. All three application systems allow the users to manage the companies' capital including bookkeeping, inventory, non-inventory & service items, sales orders, purchase orders, and reports. It allows the companies to keep tracking of the financial assets and at the same time have the information the accountant needs. Using the accounting/finance application system, makes it easier to enter and process the data rather than manually enter and process the data.

    Read More

  • Financial vs. Managerial Accounting

    1091 Words  | 3 Pages

    ... and managerial accounting is the types of reports prepared. Internal reports are tailored to meet the need of management and may vary from business to business. External reports however, follow certain standards and guidelines and are thus more uniformed among companies. (Albrecht, Stice, Stice, & Skousen, 2002) No government regulator or auditor is going to insist that a company implement a good management accounting system. (Garrison, Noreen, & Brewer, 2010) The choice of how to collect and utilize information in a company is strictly management’s decision and is a part of the company’s competitive strategy.

    Read More

  • A Critical Component Of Any Accounting Theory Course

    1218 Words  | 3 Pages

    One of the most debatable topics in the accounting industry today is the extent in which we should make the financial statements understandable to the general population. The FASB currently gears its reporting standards toward...

    Read More

  • Financial Ratio Analysis

    1415 Words  | 3 Pages

    Marshall, D. H., McManus, W. W, & Viele, D. (2002). Accounting: What the Numbers Mean. 5th ed. San Francisco: Irwin/McGraw-Hill.

    Read More

  • Accounting Education: The Future Of The Accounting Future

    1883 Words  | 4 Pages

    Change is inevitable. Yogi Berra once said “The future ain’t what it used to be.” It is clear that the future of the accounting profession ain’t what it used to be (Gormon and Hargadon 1). The changes occurring are happening fast, they are dynamic and they are completely and undeniably real. Since the world around the accountant is changing, the accountant has no option but to change as well. The field of accounting has always been one to know change and to know adjustment, but within the recent past and certainly within the next few decades, the changes that are occurring and will occur absolutely are the most dramatic and exponential yet. Obvious changes lie in the expanding scope of services performed by accountants, the increased use of

    Read More

  • Pursuing a Career as an Accountant

    1072 Words  | 3 Pages

    "Accountants." WISCareers. University Of Wisconsin System Board of Regents, 2009. Web. 20 Nov. 2009. .

    Read More

  • Role Of Accounting Information System

    1065 Words  | 3 Pages

    An Accounting Information System (AIS) can be defined as software that helps accountants to collect data and process it to create information ((Bagranoff, Simkin and Norman 2010)

    Read More

  • Microsoft Excel Essay

    828 Words  | 2 Pages

    As Miss White needed help to keep track of monthly payments made by the 10 pupils in her group and to keep a monthly record of individual payments, a running total for each pupil, the overall total collected each month and the average amount per pupil collected each month. The overall cost of the trip is £500 per pupil between the months of October to March excluding December. Choice of Application Used To do this I needed to use the software Microsoft Excel 2003 as it was easier to use than other software products. As well Microsoft Excel can perform more useful functions such as Absolute Cell Reference, Functions (MIN, MAX and AVERAGE),Conditional Formatting and many more.

    Read More

More about Using Macros to Get the Most Out of Excel

Open Document