Reflect on any Excel data manipulation techniques you may have done in the past, and explain how you think Excel 2016 will help you better manipulate data. Give a specific example of one function that you think will improve your data manipulation.
Over the years, I have had the opportunity to create several documents at work that included graphs and tables. As a supervisor in charge of the department’s Electronic Control Devices, also known by their brand name, TASER, I was required to maintain documents displaying who had which device(s). The same document also had the serial number, firmware version, and the operator’s last training date.
Serial numbers are important for warranty and repair tracking. In addition, each device has its own memory tracking usage that the operator cannot access or edit. Whenever there was a complaint involving an alleged TASER activation, I would be able to access the unit’s memory by the listed serial number. I was then able to confirm if the device had or had not been used. An important feature within Excel that I used often would be to check the entire document’s list of serial number against activation lists via the FIND command. Within seconds of entering the activated list of numbers against the list of in-service devices, Excel would return matches.
Another feature I used most-often was the auto-populate feature. Because I maintained over 80 Electronic Control Devices, the vast majority have the same warranty dates and firmware versions. The auto-population feature would eliminate the need for me to type the same information over and over again when only a handful of the devices had differing values. These two features, while simple and not overly demanding, saved me countless hours of typing the same information in several cells all over the form(s).
Place an Order
Plagiarism Free!
Create an Account
Create an account at Top Tutor Online
- Allows you to track orders.
- Receive personal messages.
- Send messages to a tutor.
Post a Question/ Assignment
Post your specific assignment
- Tutors will be notified of your assignment.
- Review your question and include all the details.
- A payment Link will be sent to you.
Wait for your Answer!
Make payment and wait for your answer
- Make payment in accordance with the number of pages to be written.
- Wait for your Answer as a professional works on your paper.
- You will be notified when your Answer is ready.