Банк рефератов содержит более 364 тысяч рефератов, курсовых и дипломных работ, шпаргалок и докладов по различным дисциплинам: истории, психологии, экономике, менеджменту, философии, праву, экологии. А также изложения, сочинения по литературе, отчеты по практике, топики по английскому.
Полнотекстовый поиск
Всего работ:
364139
Теги названий
Разделы
Авиация и космонавтика (304)
Административное право (123)
Арбитражный процесс (23)
Архитектура (113)
Астрология (4)
Астрономия (4814)
Банковское дело (5227)
Безопасность жизнедеятельности (2616)
Биографии (3423)
Биология (4214)
Биология и химия (1518)
Биржевое дело (68)
Ботаника и сельское хоз-во (2836)
Бухгалтерский учет и аудит (8269)
Валютные отношения (50)
Ветеринария (50)
Военная кафедра (762)
ГДЗ (2)
География (5275)
Геодезия (30)
Геология (1222)
Геополитика (43)
Государство и право (20403)
Гражданское право и процесс (465)
Делопроизводство (19)
Деньги и кредит (108)
ЕГЭ (173)
Естествознание (96)
Журналистика (899)
ЗНО (54)
Зоология (34)
Издательское дело и полиграфия (476)
Инвестиции (106)
Иностранный язык (62791)
Информатика (3562)
Информатика, программирование (6444)
Исторические личности (2165)
История (21319)
История техники (766)
Кибернетика (64)
Коммуникации и связь (3145)
Компьютерные науки (60)
Косметология (17)
Краеведение и этнография (588)
Краткое содержание произведений (1000)
Криминалистика (106)
Криминология (48)
Криптология (3)
Кулинария (1167)
Культура и искусство (8485)
Культурология (537)
Литература : зарубежная (2044)
Литература и русский язык (11657)
Логика (532)
Логистика (21)
Маркетинг (7985)
Математика (3721)
Медицина, здоровье (10549)
Медицинские науки (88)
Международное публичное право (58)
Международное частное право (36)
Международные отношения (2257)
Менеджмент (12491)
Металлургия (91)
Москвоведение (797)
Музыка (1338)
Муниципальное право (24)
Налоги, налогообложение (214)
Наука и техника (1141)
Начертательная геометрия (3)
Оккультизм и уфология (8)
Остальные рефераты (21692)
Педагогика (7850)
Политология (3801)
Право (682)
Право, юриспруденция (2881)
Предпринимательство (475)
Прикладные науки (1)
Промышленность, производство (7100)
Психология (8692)
психология, педагогика (4121)
Радиоэлектроника (443)
Реклама (952)
Религия и мифология (2967)
Риторика (23)
Сексология (748)
Социология (4876)
Статистика (95)
Страхование (107)
Строительные науки (7)
Строительство (2004)
Схемотехника (15)
Таможенная система (663)
Теория государства и права (240)
Теория организации (39)
Теплотехника (25)
Технология (624)
Товароведение (16)
Транспорт (2652)
Трудовое право (136)
Туризм (90)
Уголовное право и процесс (406)
Управление (95)
Управленческие науки (24)
Физика (3462)
Физкультура и спорт (4482)
Философия (7216)
Финансовые науки (4592)
Финансы (5386)
Фотография (3)
Химия (2244)
Хозяйственное право (23)
Цифровые устройства (29)
Экологическое право (35)
Экология (4517)
Экономика (20644)
Экономико-математическое моделирование (666)
Экономическая география (119)
Экономическая теория (2573)
Этика (889)
Юриспруденция (288)
Языковедение (148)
Языкознание, филология (1140)

Реферат: Using Macros To Get The Most Out

Название: Using Macros To Get The Most Out
Раздел: Топики по английскому языку
Тип: реферат Добавлен 21:46:16 31 октября 2010 Похожие работы
Просмотров: 1 Комментариев: 12 Оценило: 2 человек Средний балл: 5 Оценка: неизвестно     Скачать

Of Excel Essay, Research Paper

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 repeatedly when applied to new data. It can save the time of manual calculation, or a tailored spreadsheet. And it improves accuracy.

Whilst Excel enjoys the reputation as the most widely used spreadsheet application , many users (not just the accounting fraternity) do not get all the power available from this enormously flexible application because they do not venture beyond basic spreadsheets or simple macros.

A recent discussion with a banker at ANZ mortgage services revealed that bank data is being converted from active data (spreadsheets with in-built commands) to raw data to be actioned by macros.

The reasons for the change are several.

When the active sheets have data changed, this has implications for the rest of the spreadsheet. All the linked cells will need to recalculate their cell values according to their formula. This takes time to execute. It may seem like a speed of light adjustment on a state of the art computer with a simple spreadsheet, however some of the Bank’s files were as large as fifty megabytes.

Another reason; the change in the file size when storing only data and not active spreadsheets. Commands such as “vlookup” take up large amounts of memory. When the files are converted to data only the files reduced in size from fifty megabytes to only five.

The final reason is that the data only files improve the integrity of the data. If one cell reference is interfered with or some code is inadvertently changes it can throw out the entire spreadsheet. If a macro is incorrect is can be corrected and applied to the data.

Macros are written in Visual Basic for Applications (VBA code). This is a powerful language that can be difficult to learn. For the beginner, Excel has a record Macro Function. This function records the commands that an individual makes as they are working on a spreadsheet. The sequence of commands can then be stored and replayed with new data.

Below are five years results for Evans Timber Pty Ltd.

My objective is to record a macro that provides the average growth figures over the five-year period. These figures will be represented as percentages in column “J”..

The record macro function is selected, Tools, Macro, Record new Macro. Every keystroke is recorded. The recorded macro is automatically converted into VBA. Even the revisions are recorded, as evidenced below.

Notice here that the “if” command was required. This nullified the prior formula, however the code is still recorded.

After the macro is completed the work done on the spreadsheet can be deleted and the macro applied to the raw data. This is done by Tools, Macro, Play Macro.

A screen will appear as follows, and the Average Growth macro is selected. Press Run and the commands are applied to the spreadsheet.

The results are the appearance of a new data column “J’ with average growth figures expressed as a percentage.

Whilst the record macro function is easy to use, it does have limitations. Most recorded macros are designed to perform a specific task. Most designers are also the users and being under time constraints take shortcuts. This means that the macros can become so specific they will not be useful in even a slightly different situation.

In the example performed above, what happens in the next year where there are six years of trading history? The recorded macro is rendered useless. Writing a macro in VBA can provide a tailored outcome no matter what the data range as the instruction can capture the data range until “blank”, rather than be limited to a prerecorded cell range.

Attempts to change prerecorded macros can become incredibly frustrating.

There are many commands that you need to learn to program VBA, one benefit of the record macro facility is that it can become a ready reference for the 300 VBA instructions.

In all the VBA component can allow for a myriad of functions that recording macros cannot.

There are plenty of texts and courses on writing VBA code. Or for free you can surf the net at www.add-ins.com/tricks.htm. or www.excelvba.com/?source=goto www.beyondtechnology.com/tips.shtml .

In short, be more professional by being more accurate, timely and providing accurate data.

Use spreadsheeting.

Use Macro’s.

(1) Beaman I. R., Ratnatunga, J. A., Krueger, P. and Mudalige, N. (1998). Financial Modelling, 2nd Edition, Quill Press

(2) Lee, J.C., (2000), Business and Financial Statistics Using Minitab 12 and Excel 97, Singapore, River Edge.

(3) Kyd, C. W., Kinata, C., (1992),Complete Guide to Microsoft Excel Macros, Microsoft Press

(4) Kinkoph, S., (1999), The complete idiots guide to Microsoft Excel 2000, Indianapolis Ind, Que.

(5) Albright, S. C., Winston, W. L., Zappe, C., (1999), Data Analysis ans Decision Making with Microsoft Excel, Pacific Grove CA, Duxbury Press.

(6) Berk, K.N., Carey, P., (1996), Data Analysis with Microsoft Excel, Pacific Grove, Microsoft Press.

(7) Wempen, F., Payne, D., (1999), The Essential 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

Оценить/Добавить комментарий
Имя
Оценка
Комментарии:
Привет студентам) если возникают трудности с любой работой (от реферата и контрольных до диплома), можете обратиться на FAST-REFERAT.RU , я там обычно заказываю, все качественно и в срок) в любом случае попробуйте, за спрос денег не берут)
Olya03:24:20 27 августа 2019
.
.03:24:19 27 августа 2019
.
.03:24:18 27 августа 2019
.
.03:24:18 27 августа 2019
.
.03:24:17 27 августа 2019

Смотреть все комментарии (12)
Работы, похожие на Реферат: Using Macros To Get The Most Out

Назад
Меню
Главная
Рефераты
Благодарности
Опрос
Станете ли вы заказывать работу за деньги, если не найдете ее в Интернете?

Да, в любом случае.
Да, но только в случае крайней необходимости.
Возможно, в зависимости от цены.
Нет, напишу его сам.
Нет, забью.



Результаты(258417)
Комментарии (3474)
Copyright © 2005-2020 BestReferat.ru support@bestreferat.ru реклама на сайте

Рейтинг@Mail.ru