Excel & Modeling3 min read
Excel vs Google Sheets: Why Excel Is Better
Spreadsheets are extremely useful business tools. They are used to list, manipulate, and calculate a variety of corporate processes, such…
James Richard ·
Topic
Excel & Modeling
Formulas, functions, Power Query, Python in Excel and financial modeling technique.
88 articles
Excel & Modeling5 min read
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…
James Richard ·
Excel & Modeling7 min read
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…
James Richard ·
Excel & Modeling4 min read
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…
James Richard ·
Excel & Modeling4 min read
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…
James Richard ·
Budgeting & Forecasting5 min read
5 Questions To Consider About Strategic Budgeting and Forecasting
While spreadsheets have long served as the foundation for many organizations’ budgeting and forecasting, the shortcomings of this legacy, siloed…
James Richard ·
Excel & Modeling3 min read
Microsoft Excel Vs. Apple’s Numbers: Who is Superior?
Microsoft Excel was the first successful spreadsheet (an interactive computer application program for organization and analysis of data in tabular…
James Richard ·
Excel & Modeling5 min read
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….
James Richard ·
Excel & Modeling5 min read
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…
James Richard ·
Excel & Modeling3 min read
How to Use Microsoft’s “Money in Excel” to Manage Your Finances
Important: As of June 30, 2023, Money in Excel will no longer be supported. Please see their FAQ. By connecting your…
James Richard ·
Budgeting & Forecasting3 min read
Common FP&A Problems With Excel & How to Fix Them
Decades after the creation of Microsoft Excel, many FP&A professionals today continue to use this 34 year old application. Excel…
James Richard ·
Excel & Modeling5 min read
6 Excel Skills Every Finance Professional Should Know
If you’re like most finance professionals, you are accustomed to using Excel. It is a tool that has been around…
James Richard ·