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
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
Excel Tips
Tips from the Accounting Trenches: Try This Smoother Alternative to “Hiding” Data in Excel
When manipulating data in Excel, here’s a problem that I’m guessing many of us have experienced at one point or... View Article
2 Minute Read
February 21, 2017
Excel Tips
Excel Tips: How to Consolidate and Convert Dates to a Standard List or Pivot Table
Many times, we deal with datasets that are more granular than what we desire. Take “sales by day” as an... View Article
1 Minute Read
January 23, 2017