I am constantly using excel at work. As I’ve stated in my blog profile, I am considered the excel “expert” at work and there is a lot of pressure when it comes to performing a task using excel. Actually today, I was asked to create a mail merge using excel. We recently changed our system from SIMS to CUNYfirst and there were a lot a glitches with the system. I was asked to create a letter template in word and extract data from excel using various formulas adding up and subtracting numbers for student bills. I also use excel for a committee that I am on to keep track of students who file for tuition liability appeals. What I like about using excel for this particular task is that I can filter out particular data using lists, such as how many students were approved or denied for an appeal in a particular academic year, or semester. And I can filter out the percentages of approval and denials of who actual determined the appeal. I have also used excel for creating data matrix’s for payroll purposes using the sum function, what if analysis, and linking worksheets, workbooks and Microsoft word. I also use excel to create pie charts, which I love because they give the data you create a nice visual without having to strain looking at loads of numbers.
Excel Rocks!!
Anthony Garafola–
