Excel Tips

best-fpa-excel

Best FP&A Software Solutions for Excel Users

FP&A software solutions come in many shapes and sizes. There are simple Excel plug-ins, complex and expensive software for large enterprises, and everything in between. Some companies upgrade their FP&A…

The Latest Excel Insights, straight to your inbox

1294dd_ea2aa9666b134f4582e1a46dec090a85~mv2

The Excel User’s Guide to Data Accuracy

In today’s corporate finance environment, there’s a lot of buzz regarding the relevance of Excel. There are many today who…

37ff2e_36c49892d5554d7cbb79e3ea72f8dcc3~mv2

The Wall of Shame for the Worst Excel Errors

Microsoft Excel was one of the ground-breaking inventions of data science, and is still used today by over 60% of…

1294dd_8dd178dbfdc14d7cb65a6a16ef5368bd~mv2

The Most Powerful Excel Functions You Aren’t Using

If you’re reading this, you likely work in corporate finance and it is certain to say that you possess some…

37ff2e_f5f314f86fff405bada25214d9c383a6~mv2

10 Important Excel Web and Desktop Updates

Excel is constantly implementing upgrades in order to improve the usability and efficiency of its software. These are 10 of…

1294dd_23d050bad356491d8c0c264fef14ad63~mv2

Analyzing large datasets with the power pivot in Excel

The context for Power Pivot… If you are a frequent Excel user, then you are probably familiar with pivot tables….

1294dd_c3cdf9aa61e34d23aed0d4fedfcdbfba~mv2

How to use VLOOKUP, HLOOKUP and INDEX MATCH in Excel

Say you have a table of data and you want Excel to look up a certain value and return a…

Facebook Linkedin