Question: Please share three specific examples of functions that would be of interest to professionals in your area. How can Excel be used to set up
Please share three specific examples of functions that would be of interest to professionals in your area. How can Excel be used to set up computations of these functions? ANd respond to this person. ello Everyone!
In my experience I have found the VLOOKUP function to be particularly useful. It allows for me to sift through my sheets, especially when I receive them from my fellow coworkers to locate exactly what it is that I am looking for in an efficient manner. I would also have to use this function often times when I was transcribing Data from an outdated program our organization was using.
Another function that interests me is the auto sum function. The sum formula allows for expedient computations to be made for the totals of either a cell row or column. It eliminates the need for me to have to use a calculator because the program does it automatically.
The third and another equally effective function that I find particularly use ful in my occupation is the average function. This function allows for me to determine more specifically how many hours an employee is working vs how many hours they have been scheduled to work.
Excels computations are easily inserted into a singular cell and can now even be auto filled or dragged to be repeated amongst many cells.
Thank you all for reading my response, We are almost half way through this thing keep trucking!
Hello everyone,
I dont use excel much right now, but I am sure I will use it a lot when I do finally open my own business. Some of the main functions that I would use and professionals around me might use would be the sum function, average, and vlookup. These are some of the most common that I believe are helpful when making charts and dealing with numbers. I want to eventually open my own salon so I would use excel to keep track of things like money earned monthly, supplies, and the expenses to keep my salon. The sum function is used to add the values of the cells. You can add multiple cells and the sum function will add them all. For example if you put SUMC:C then it will add the values of the cells C through C The average function is used to calculate the average of a range of numbers. To use the average function you can click on the formulas tab and click on the autosum tab and it will drop down a list of functions. The vlookup function is used to lookup data by row such as specific numbers or names. To use the vlookup function you type vlookup in the formula bar and press enter and it will highlight the row for you. All these functions will help professionals by making their work a little less stressful because these functions are simple to use. I think that once you play around with excel and learn how to use these functions they take no time to create a spreadsheet.
Step by Step Solution
There are 3 Steps involved in it
1 Expert Approved Answer
Step: 1 Unlock
Question Has Been Solved by an Expert!
Get step-by-step solutions from verified subject matter experts
Step: 2 Unlock
Step: 3 Unlock
