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)
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.
what needs to be worked on in training. It can be very useful as areas
1. You want to insert a cell into your worksheet. Which command do you use?
As this was a review of the chapter before our test, students overall did a good job applying the skills we have learned throughout this chapter. Every single one of my students can correctly identify a number based on the tens and ones, and can find the tens and ones of any given two digit number. I did not have any student fail to identify if a number was greater than or less than another number. In retrospect, I realized that during this lesson I placed very little emphasis on the greater than and less than signs themselves, but this was a large component of the independent practice work. Overall, I have been impressed with the learning progress my students made during this chapter. It was a quick chapter with only 5 lessons, but students moved quickly and comfortably through the content.
properly in the given setting and as a student in a DPT program develops this skill and uses it
and I will be working form this. The spread sheet is reliable as it is
I was assigned to search for a number of suspects and had to make sure that all of their criminal history was compiled even if their name or birthday was incorrect in the records. I trained in more detailed use of Microsoft Excel by my supervisor Robert Broughton. Through the training I learned about how the Crime Analysis Unit utilizes Pivot Tables and formulas in their projects. I was assigned tasks to reinforce this training that allowed me to see firsthand how useful these skills were. I also had basic training in Microsoft Access where I learned how to layer spreadsheets and connect the data contained within the
I develop multiple skills and abilities from various experiences, especially leadership and communication skills. When I took the accounting information system class, I was the leader of the group project, which was to lead and assign group
Zavadszky, Andrea. "New Accounting Needs Data and Analysis Skills." Classified Post. N.p., 30 Nov. 2013. Web. 18 Mar. 2014. .
...ithms, and the ability of the algorithm to reliably complete the task for which it was designed. Refining my computer knowledge and skills by taking such classes will ensure that I have the skills and knowledge to succeed in an engineering environment.
There some positives that come from choosing Excel that can be guaranteed, such as: profitability, a strong relationship and have access to a 4PL. The case information has provided;...
I find a similar pleasure in seeing the numbers "come out right." When I first entered the work force, starting out in the actuarial area, the areas of my day-to-day work that I most enjoyed were researching and analyzing data so that I could logically apply the information to the business opportunity at hand. Consequently, I realized that the most prudent path to accomplishing this would be to further my education in the advanced studies of statistics and I have been preparing myself by taking a year of higher-level math and statistics courses at Ohio State. I've maintained a 4.0 GPA, and am confident that pursuing a Ph.D. and later entering a career in statistical consulting or teaching is the right step for me.
I expected to learn the mathematical skills required for designing the control of a program from “Logic”. It included the logic required for programmes such as use of logical operators (&&, ||), mathematics involved in programming etcetera. I had expected to learn spreadsheet and database management from “Problem Solving in IT”. During the first semester, I expected to see myself become better at working with a group. Also I hoped to get better at technical writing. I expected “Study Skills for
Many of the talents and skills they regularly use on a daily basis will transfer to the project tasks that they may to be assigned.
engage different learning styles, provide hands-on opportunities for use of specialist tools or equipment, reinforcing learning, supporting and motivating individual learning, fostering independent learning through extended learning.