The London Whale and Microsoft Excel

Costly Excel Spreadsheet Errors Imagine if one of your company’s key Microsoft Excel spreadsheets contains the wrong formulas in some cells. How will that impact your bottom line? For JPMorgan, a spreadsheet played part in the $6 billion trading loss it reported in 2012 in the “London Whale” affair. I became interested in the models[…]

What is ETL?

Do you analyze data in Excel? You have been using Excel for many years and have become quite adept at using VLOOKUP, SUMIFS and Pivot Tables. Let’s also assume you know the Data Connection ribbon and can connect to a backend system to fetch data. And your ability to do all that has earned you[…]