Chapter 9 Project 9D Recording and Assigning a Macro

In project 9D that was assigned, it provided skills that were taught throughout chapter 9 that was able to be mastered in order to complete project 9D. In this particular project we was responsible of recording/assigning a macro, being able to activate the macro in sequence , writing a set of commands, using ActiveX control buttons, and add or take away from the commands code (View Code feature). Those 3 skills was the major lesson of the entire chapter 9. This was a pretty lengthy chapter that’s full of new, interesting, and useful material.

Starting off with the first task that was being taught in chapter 9 was learning how to record a macro. Macro is a verbatim set of actions that can all be grouped into one action without the repetition of steps that’s needs to be applied. Macro has the ability to eliminate tasks such as selecting range, adding/removing columns and rows, adding the current date to a spreadsheet, and protecting /unprotecting worksheets. Without the macro feature and without fully paying attention one can become distracted and unexpectedly mess up important data collected. In order to work with macros you must select a macro security setting to enable macros when using excel, add the developer tab to the ribbon, and then saving the workbook that includes macros as an excel-macro enabled workbook type of file. After getting equipped with learning what macros are and how to record them the chapter then brought about the “Assigning a macro to a button on the quick access toolbar” task which requires you to create a button on the quick access Toolbar that will allow one to activate the macro. In order to complete task properly one must become familiar with the backstage view of the workbook and the different opti...

... middle of paper ...

...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.

Works Cited

Excel 2010 Comprehensive Workbook.

(Chapter 9, Pages 548-575 The Review, The Project pages 582-583)