susan silva
|
|
« on: May 19, 2013, 01:45:45 am » |
|
Do you use Excel in your job, if so what features do you use? How advanced are your skills? Does any one's skills go past charts?
|
|
|
Logged
|
|
|
|
Atlanta Z3
|
|
« Reply #1 on: May 20, 2013, 02:15:51 pm » |
|
I put myself at intermediate excel. In previous jobs I used pivot tables and many functions. I used excel to create a template to decommission company sites. Each tab autofilled the basic info from the master and was a page that could be emailed to a specific vendor to discontinue services on a national account for example. Now in legal my excel skills are a little rusty, just the basic formulas although I use the filter command quite a bit on large storage inventory sheets.
|
|
|
Logged
|
|
|
|
msmarieh
|
|
« Reply #2 on: May 20, 2013, 08:34:19 pm » |
|
I love Excel and consider myself an advanced user (though always happy to learn more!). I've used visual basic, pivot tables and pivot charts, filtering, data consolidation and more. So much flexibility in this program.
|
|
|
Logged
|
|
|
|
countrigal
|
|
« Reply #3 on: June 05, 2013, 03:13:13 pm » |
|
I use excel extensively in my job, though the rest of my co-workers use minimally. I adapted an excel "program" to determine retired pay withholdings for claims we work, which requires look-up tables, embedded if statements, tons of hidden coding in the documents, which means that I have a fairly higher-than-normal skill level with excel. Once I get these queries, statements, formulas, etc updated for each cost of living increase, then the rest of the workforce only has to know how to click on a cell, enter a date or data, and wait for the behind-the-scenes math to be done (working from mulitple source tables) and then take the answers from the Excel document to our awards program. I happen to love Excel, only surpassed by my love of Access, for the functionality and depth of the program, while not requiring a HUGE amount of knowledge by the user to access that functionality. I find both very intuitive. But it may just be my mind....
|
|
|
Logged
|
|
|
|
|