In an Excel spreadsheet,
there are tasks that you need to do automatically and repeatedly with
efficiency. You can do this by writing a macro in Excel. Businesses or
non-profit organizations might need to use macros to save time and to be more effective when
they need to change a name or an address in their large dataset spreadsheet. If
they do not use macros they might miss a name or something that they
needed to change. If they did miss something it could cause a problem in
the future when the business or non-profit organization is looking at the
spreadsheet. Computer software is all the programs and applications on
your computer (Kroenke, 2014). Therefore, Excel is a type of software. People
using Excel can write their own macros to personalize their
spreadsheets to make it more productive. People write macros by
using coding. They write a source code which is "a computer code as
written by humans and that is understandable by humans" (Kroenke, 2014). Then the computer
turns the source code into machine code that humans cannot understand to
perform the functions that you want (Kroenke, 2014).
In this assignment
exercise, I wrote a macro to find a name and to replace all of those found
names to another name. Through this exercise, I learned that macros are a lot
easier to write than I thought that they would be. I also learned that they are
much more proficient in using, especially for the function we were using it
for, instead of going through and changing each name separately.
Works Cited
Kroenke, D. M. ( 2014). MIS Essentials (pp.86-99). Upper Saddle River, NJ: Pearson Education, Inc.
No comments:
Post a Comment