Excel Consulting in Banking

Banking is all about numbers, and so all about Excel. If you work in a bank and are looking for an American Excel specialist, it is likely that you are already an intermediate or advanced user of the software. Your spreadsheets may be full of formulas and, if you are a trader, you may be drawing data from a third party terminal such as Bloomberg. Our Excel consultants can support you in all your spreadsheet ambitions and, although the exact nature of requests can be very diverse, most involve the analysis or simplification of data.

Data Analysis

The banking industry is built around profiting from financial transactions. Profits are made by buying low and selling high. The skill of buying low is in finding assets or opportunities that are undervalued.

Finding or creating these opportunities can be like searching for a needle in a haystack. Once upon a time, that was a euphemism for time wasting. Since the advent of computerization, it has simply become a matter of using the right tools.

Banks have to develop bespoke applications for shared data analysis and storage. However, Excel is usually the best tool for creating smaller, individual applications as it already has a front end. Our consultants can use Visual Basic programming to automatically sift through thousands of rows of data and separate out the information you need.

Rationalization of Formulas

Excel spreadsheets are normally developed in response to a changing business enviornment e.g. you need to solve a certain problem. Where a spreadsheet has been good at solving a simple problem, it is often developed further to solve a more complex problem. In a banking environment full of intermediate and advanced Excel users, this can very quickly create a very complex spreadsheet full of inpenetrable formulas.

Unfortunately these important spreadsheets become slow, inflexible and they can require a large amount of user training. There comes a point when the sheet's use has evolved to the point where it could be replaced by a newer, simpler spreadsheet.

Our experts can write macros to replace in-sheet logic and formulas. We can also migrate data across from an older version of a file. Our Excel consultants can rationalize any spreadsheet, which means making it faster, without compromising on data integrity.

What our clients say

 Tim Hill
 Sean Murphy
 Elaine Petkovsek

"I AM IN AWE!!!! This is a dream come true when it comes to tenant reporting! Absolutely beautiful...if an Excel file can be beautiful!"
Dawn Rowan - Zaremba Group