Thread Options Tools
#22212 - 06/28/02 10:54 AM Excel: do you use it?
Richard Insley Online
10K Club
Richard Insley
Joined: Oct 2000
Posts: 10,007
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.

Do you use MS Excel?
Yes, I use it daily.
Yes, I use it, but not very often.
No, I don't use it.


_________________________
...gone fishing.

Return to Top
General Discussion
#22213 - 06/28/02 02:07 PM Re: Excel: do you use it?
JulesB Offline
Gold Star
JulesB
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?
Strout Offline
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
#22216 - 06/28/02 02:36 PM Re: Excel: do you use it?
complyguy Offline
Gold Star
complyguy
Joined: May 2001
Posts: 494
PA
In our small, rural bank, I use Excel to track currency transactions over $3000 for suspicious activity, to retrieve wire transfer info by name or account number, to sort loan denials by gender, income, zip & reason, to track our interbank liability limits, to record Reg D excess transactions over time, and to track a variety of deposit and loan measures.

Return to Top
#22217 - 06/28/02 02:54 PM Re: Excel: do you use it?
Andy_Z Offline
10K Club
Andy_Z
Joined: Oct 2000
Posts: 27,378
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?
D2Xs Offline
Power Poster
D2Xs
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?
BrendaW Offline
100 Club
BrendaW
Joined: Jun 2001
Posts: 230
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?
Bear Collector, CRCM Offline
Diamond Poster
Bear Collector, CRCM
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?
thomasj Offline
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?
David Dickinson Offline
10K Club
David Dickinson
Joined: Nov 2000
Posts: 18,762
Central City, NE
Here is a link to Barnes and Nobles and the book that Ben recommends.
_________________________
David Dickinson
http://www.bankerscompliance.com

Return to Top
#22226 - 07/01/02 07:49 PM Re: Excel: do you use it?
SLC Offline
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?
Rick Tryon Offline
100 Club
Rick Tryon
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?
Lestie G Offline

Power Poster
Joined: May 2002
Posts: 3,605
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?
Richard Insley Online
10K Club
Richard Insley
Joined: Oct 2000
Posts: 10,007
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?
thomasj Offline
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

test

Return to Top
#22232 - 07/05/02 06:18 PM Re: Excel: do you use it?
Michele_Petry Offline

Platinum Poster
Michele_Petry
Joined: Jun 2000
Posts: 695
Louisville, KY USA
This is a test poll since we moved to the new server:




Happy 4th!
What is your favorite color?
single choice


Votes accepted starting: 01/15/04 01:48 AM
View Results
_________________________
Michele Petry
BankersOnline.com

Return to Top
#22233 - 07/05/02 07:08 PM Re: Excel: do you use it?
Al Miller Offline
Diamond Poster
Al Miller
Joined: Oct 2000
Posts: 2,416
Pleasanton CA USA
Personally, I prefer the color of a good Cabernet Sauvignon or Zinfandel. Do you want my favorite or which of these three I prefer?
_________________________
Al Miller, CRCM
Opinions expressed are my own and not necessarily shared by my employer.

Return to Top
#22234 - 07/05/02 07:30 PM Re: Excel: do you use it?
Andy_Z Offline
10K Club
Andy_Z
Joined: Oct 2000
Posts: 27,378
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


Adult Beverage Preferance
single choice


Votes accepted starting: 01/15/04 01:48 AM
View Results

Return to Top