Excel & Modeling8 min read
Best Excel Courses for Financial Teams (2024)
“What experience do you have with Excel?” is undoubtedly a question that will be asked in some variation during the…
James Richard ·
Topic
Excel & Modeling
Formulas, functions, Power Query, Python in Excel and financial modeling technique.
88 articles
Excel & Modeling4 min read
Top 13 Excel Tips for Accounting
Here are 13 tips and features to bring more agility, functionality and usability to your Excel spreadsheets. Share this with…
James Richard ·
Excel & Modeling5 min read
The 5 Secrets to Excel’s Survival
In a couple of years, Microsoft Excel will turn 40 years old- an ancient dinosaur in terms of technology and…
James Richard ·
Excel & Modeling7 min read
Excel Accounting with Bargain Purchases
In the corporate world, the fancy term for “a steal” or just good value is “bargain purchase”. This occurs when…
James Richard ·
Budgeting & Forecasting6 min read
Leveraging What-If Analysis in Excel
‘What if’ analysis uses built-in tools for budgeting and forecasting in Excel. Financial planning and forecasting tools help your company…
James Richard ·
Excel & Modeling5 min read
What to do When Excel Doesn’t Meet Your Spreadsheet Needs
Excel is an excellent tool for processing data, but it has its limitations. If you are using overly complicated formulas,…
James Richard ·
Budgeting & Forecasting7 min read
Dear Excel, How can FP&A professionals make the most of their spreadsheets?
After (almost) 40 years, there is a reason why FP&A and accounting professionals continue to use Excel. It works. But…
James Richard ·
Excel & Modeling4 min read
The New Functions To Add To Your Excel Toolbox
In this post, we’ll take a quick look at some of the new features in Microsoft 365’s Excel and Excel…
James Richard ·
Excel & Modeling5 min read
Excel Chart & Graph Methods Every Finance Department Should Use
Although it was created decades ago, Excel is to corporate finance what the crane is to construction; you must have…
James Richard ·
Excel & Modeling4 min read
Almost 90% of Excel Spreadsheets Contain Errors: Here’s how to Avoid this Statistic
The famous statistic that 88-90% of Excel files contain errors is a pretty scary thought. Despite the advanced functions and…
James Richard ·
Excel & Modeling5 min read
Excel is not a Database!
We’ve seen the Excel is not a database memes and we know that Excel is used in almost every business,…
James Richard ·
Excel & Modeling4 min read
How Software Fills the Gaps in Excel
If you’re up to date with current affairs in the world of corporate finance, you’re likely aware of the ongoing…
James Richard ·