Excel Tips
Excel Tips: The Value of SUMIFS for Multiple Criteria
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
Excel Tips
Excel Tips
Using Goal Seek in Excel: 8020 Quick Tips
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
Tips from the Finance Trenches: 2 Key Excel Functions for Organizing Data
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
Tips from the Finance Trenches: A Better Way to Use Static Reports for Cross-Functional Data Analysis
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
Tips From the Finance Trenches: Speed Up Your VLOOKUP Formulas With Automation
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
Tips from the Finance Trenches: Best Shortcut Ever! Create a Pivot Table In 3 Seconds
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
Tips from the Finance Trenches: A Smart Alternative to Lookup Functions in Excel
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
Tips from The Accounting Trenches: The Power of Pivot Tables
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
Tips from The Finance Trenches: How to Use Variables in MS Excel SUMIF Formulas
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
Tips from the Finance Trenches: How to Summarize Revenue by Region and Sales Lead
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