Financial Reporting & Accounting
VLOOKUP and HLOOKUP are probably the best-known formulas for getting data from another table. It is relatively simple to use... View Article
4 Minute Read
April 10, 2019
Financial Planning & Analysis
Goal Seek is a useful Excel tool that allows you to see how one data item in a formula impacts... View Article
3 Minute Read
March 28, 2019
Excel Tips
Don’t get us wrong—data is a beautiful thing. But when you have lots of it, displayed in a format that... View Article
3 Minute Read
August 15, 2017
Excel Tips
For a holistic view of your business, it is critical to integrate cross-functional business data. However, Finance and Business Intelligence... View Article
2 Minute Read
July 24, 2017
Excel Tips
As finance professionals well know, the VLOOKUP formula is among the most commonly used function in Microsoft Excel. This relatively... View Article
2 Minute Read
June 20, 2017
Excel Tips
If you are a heavy user of MS Excel, and use pivot tables on a regular basis, you know that... View Article
1 Minute Read
May 22, 2017
Excel Tips
The VLOOKUP is one of the most commonly used functions in MS Excel and serves many useful purposes. But the... View Article
2 Minute Read
May 8, 2017
Excel Tips
Ever stare at worksheets containing very large data sets of data and have no idea where to start? How do... View Article
3 Minute Read
May 1, 2017
Excel Tips
Do you need to find the sum of a subset of cells in Excel spreadsheet that has multiple variables? Here,... View Article
2 Minute Read
April 5, 2017
Excel Tips
Excel is a powerful tool that allows users to quickly manipulate and analyze key data – yet it’s not unusual... View Article
2 Minute Read
March 13, 2017