Thread Options
|
Tools
|
#22212 - 06/28/02 10:54 AM
Excel: do you use it?
|
10K Club
Joined: Oct 2000
Posts: 10,180
Toano, VA
|
Microsoft Excel is an extremely powerful tool for C/Os, yet it's friendly and forgiving. A number of Excel applications have been donated to the Bankers Tools collection, but I'd like to know the many other ways that C/Os use Excel.
For starters, how about a poll about Excel itself.
_________________________
...gone fishing.
|
Return to Top
|
|
|
|
#22213 - 06/28/02 02:07 PM
Re: Excel: do you use it?
|
Gold Star
Joined: Feb 2002
Posts: 324
A Designated Tree City in OK, ...
|
I used it regularly as a NBE with the OCC, and am now using the same spreadsheets for my compliance reviews (esp. Fair Lending). It is a great tool for doing sorts, to see if there is any potential disparate treatment when comparing any differences between the control group and the prohibited basis group.
_________________________
Responses are mine, and are no reflection of my employer.
|
Return to Top
|
|
|
|
#22214 - 06/28/02 02:18 PM
Re: Excel: do you use it?
|
100 Club
Joined: Nov 2001
Posts: 164
A beach in the USA
|
I use it to track my CRA Services, Investments and Community Development loans. I also complete my HMDA audit with an Excel spreadsheet.
_________________________
That's my story and I'm sticking to it!
|
Return to Top
|
|
|
|
#22215 - 06/28/02 02:25 PM
Re: Excel: do you use it?
|
Anonymous
Unregistered
|
I have used it to create initial escrow account disclosures and ARM program disclosures in the past. Couldn't imagine working without it.
|
Return to Top
|
|
|
|
#22217 - 06/28/02 02:54 PM
Re: Excel: do you use it?
|
10K Club
Joined: Oct 2000
Posts: 27,750
On the Net
|
Knowing about the XL basics, graphing, functions and database features allows one to truly work smarter, not harder.
_________________________
AndyZ CRCM My opinions are not necessarily my employers. R+R-R=R+R Rules and Regs minus Relationships equals Resentment and Rebellion. John Maxwell
|
Return to Top
|
|
|
|
#22218 - 06/28/02 03:28 PM
Re: Excel: do you use it?
|
Power Poster
Joined: Jan 2002
Posts: 2,706
|
I use Excel worksheets for my review monitoring. I have also created macros that take those worksheets and generate reports that show the weaknesses and strengths for ever branch we have and is rolled up into an overall report and chart that is presented to the Board of Directors every quarter. This gives us the opportunity to isolate the problems in each branch and do target training. I am constantly working on this to make it better for the next time. Eventually, the goal is to be able to determine the specific person who is having troubles.
_________________________
Beauty is only skin deep...but ugly goes all the way to the bone!
|
Return to Top
|
|
|
|
#22219 - 06/28/02 03:35 PM
Re: Excel: do you use it?
|
Anonymous
Unregistered
|
I sometimes use excel, but I use Lotus everyday...started with it in college and continue to use it. I couldn't live without my lotus spreadsheets. I think every audit I do I have worksheet templetes.
|
Return to Top
|
|
|
|
#22220 - 06/28/02 09:01 PM
Re: Excel: do you use it?
|
100 Club
Joined: Jun 2001
Posts: 231
Texas
|
How could we live without it? I would be interested in scoulte's response about the excell spreadsheets that generate reports.....would you be willing to share? My email is bwilliams@austinbank.com
_________________________
Brenda W, CRCM
|
Return to Top
|
|
|
|
#22221 - 06/29/02 12:33 AM
Re: Excel: do you use it?
|
Diamond Poster
Joined: Nov 2000
Posts: 1,830
District of Columbia
|
I don't use it, but that is because I never learned how. In September I am going to take a class in using computers in a legal setting, and I know Excel spread sheets are included as part of the class. Maybe once I get the hang of it, I'll use it.
Leslie
_________________________
Being kind is more important than being important.
|
Return to Top
|
|
|
|
#22222 - 06/29/02 01:34 AM
Re: Excel: do you use it?
|
Power Poster
Joined: Mar 2001
Posts: 5,063
Pennsylvania
|
I love Excel and use it almost everyday. I prepare a large currency transaction report everyweek to aggregate large cash transactions and make sure we have filed all of our CTRs (that's right we do not have an automated system). The spreadsheet also lets me sort a weeks worth of transactions several different ways to check for suspicous activity.
I used to be more of a "power" excel user when I worked in loan review. I created some awesome spreadsheets, graphs, and reports that are still being used today (I know because when someone messes one up they ask me to fix it!). Once you get the hang of how to create formulas and link cells it can save you a lot of work.
_________________________
Knowledge is knowing what to say. Wisdom is knowing when to say it.
|
Return to Top
|
|
|
|
#22223 - 07/01/02 05:48 PM
Re: Excel: do you use it?
|
Anonymous
Unregistered
|
Besides what everyone else has said, I use it in conjunction with databases as a report writer. I also will load whole databases in there and use the pivot table to do some easy analysis. I can't imagine doing a compliance review without it as I reguarly throw bits and pieces in Word. I also think it's Microsoft's best and most stable product. I still have one of the early promotion videos on it -"The Soul of the New Machine" which is still exciting to look at.
I would recommend a relatively new book on Excel- "Excel 2002 Formulas" by John Walkenbach. No, I don't have Excel 2002 but the section on using financial formulas is great as well as most of other parts of the book. He has one on charts and graphs coming out in the Fall
In fact I would suggest BOL have a section on favorite books - compliance books and otherwise -by the BOL users.
|
Return to Top
|
|
|
|
#22224 - 07/01/02 05:59 PM
Re: Excel: do you use it?
|
Anonymous
Unregistered
|
We have just recently revised our Loan Review Program. I would be interested in viewing the spreadsheets and graphs mentioned by ThomasJ if willing to share.
If you are willing to share, could BOL post on the tools page along with the other spreadsheet mentioned in an earlier posting?
Thanks
|
Return to Top
|
|
|
|
#22225 - 07/01/02 06:00 PM
Re: Excel: do you use it?
|
10K Club
Joined: Nov 2000
Posts: 18,762
Central City, NE
|
Here is a link to Barnes and Nobles and the book that Ben recommends.
|
Return to Top
|
|
|
|
#22226 - 07/01/02 07:49 PM
Re: Excel: do you use it?
|
100 Club
Joined: Feb 2001
Posts: 185
Texas
|
My fav Excel feature is "Filter." It is extremely useful if a bank provides me with a custom report (that I import to Excel) of all loans originated over a specified period of time. Once I enable filter, I can easily get the number of each loan type without having to sort and count.
Pivot tables are also useful for the same type of analysis. You can get a quick recap of # and $ amt of each class code, collateral code or however you want it.
|
Return to Top
|
|
|
|
#22227 - 07/01/02 08:14 PM
Re: Excel: do you use it?
|
100 Club
Joined: Mar 2002
Posts: 169
Clinton IN, USA
|
I use Excel daily. I have a couple of spreadsheets that I use as loan review checklists. I set up macros to tally the results of each file into totals for the month. I also set up drop down boxes to easily fill in cells with repetitive responses (like loan officer, type of app, purpose of loan, etc.)
_________________________
Opinions expressed here are mine, not necessarily my employers. This is not legal advice.
|
Return to Top
|
|
|
|
#22228 - 07/01/02 09:24 PM
Re: Excel: do you use it?
|
Power Poster
Joined: May 2002
Posts: 3,608
Near the Land of Enchantment
|
All these glowing testimonials! So when is Bill sending us our referral checks (or is that a violation of RESPA?)?!?!?
_________________________
Opinions my own.
|
Return to Top
|
|
|
|
#22229 - 07/01/02 10:34 PM
Re: Excel: do you use it?
|
10K Club
Joined: Oct 2000
Posts: 10,180
Toano, VA
|
Bill's doing moderately well with or without our endorsements, and I'm really not a MS groupie (just ask anyone who's advocated MSIE on this or other banker forums during the past 7 years); BUT; Excel is a killer application that has earned the admiration of its loyal users. I can't imagine being a 21st century banker without it.
_________________________
...gone fishing.
|
Return to Top
|
|
|
|
#22230 - 07/03/02 08:55 PM
Re: Excel: do you use it?
|
Power Poster
Joined: Mar 2001
Posts: 5,063
Pennsylvania
|
I just remembered a funny story. My old boss in loan review used to keep track of our loan portfolio totals on a huge sheet of paper that I nicknamed "the dead sea scrolls". It was a tatered document made of about twenty sheets of yellow legal pad paper and about a half a mile of scotch tape. He was very impressed when I took all of the info from the scrolls and put it into excel, I made him all kinds of neat graphs and stuff. But I could never get him to part with the original scrolls and to this day, I think he is still taping on new sheets of legal paper and making his quarterly entries!
_________________________
Knowledge is knowing what to say. Wisdom is knowing when to say it.
|
Return to Top
|
|
|
|
#22231 - 07/05/02 05:45 PM
Re: Excel: do you use it?
|
Anonymous
Unregistered
|
|
Return to Top
|
|
|
|
#22234 - 07/05/02 07:30 PM
Re: Excel: do you use it?
|
10K Club
Joined: Oct 2000
Posts: 27,750
On the Net
|
It is Friday, Al. My hats off to you. Its all I can do to spell Bud Lite.
_________________________
AndyZ CRCM My opinions are not necessarily my employers. R+R-R=R+R Rules and Regs minus Relationships equals Resentment and Rebellion. John Maxwell
|
Return to Top
|
|
|
|
#22235 - 07/06/02 12:20 AM
Re: Excel: do you use it?
|
Anonymous
Unregistered
|
|
Return to Top
|
|
|
|
|
|