How to Create a Merger and Acquisition Model in Excel
This tutorial shows how to create a merger and acquisition financial model including synergies, debt, and valuation calculations. It starts…
Read MoreWelcome to the ChallengeJP blog!
When it comes to data, there’s always more to learn, so let’s learn together.
This is where I’ll unleash my passion for Excel and all things data-related by providing articles that help you explore Excel functions, data analytics and financial modelling.
Whether you’re looking for guidance on using spreadsheets and making sense of your data, or you share my passion for data and want to read intriguing insights into the world of data analytics, the ChallengeJP blog has something for everyone.
You’ll find Excel tips and tricks, and useful spreadsheet resources that can help you master a range of Excel functions, from the basics to more advanced formulas. So if you need to brush up on your Excel skills, or refresh your knowledge of a specific function, you may be able to find the guidance you need in one of my blog posts.
You can also become inspired to make the most of your business data and achieve data-driven success with articles that explore the business benefits of data analytics and financial modelling. If you’re keen to start making sense of your business data, you’ll find insightful articles about the process of transforming numbers into valuable, actionable insights.
If you’re ready to start discovering insights into Excel, data analytics, and financial modelling, let’s delve into data together. Here are my latest blog posts.
How to Create a Capital Investment Plan in Excel
This tutorial shows how to create a Capital Investment Plan in Excel. First, I will set up a financial model…
Read More
How to Create a Marketing Investment Plan in Excel
This tutorial will show you how to create a Marketing Investment Plan in Excel. First, I will show you how…
Read MoreHow to Create a Telecom Financial Model in Excel
This tutorial will show you how to create a Telecom Financial Model in Excel. It will start with instructions on…
Read More
How to Create a Real Estate Investment Model in Excel
This tutorial will show you how to create a Real Estate Cash Flow Model in Excel. It will first present…
Read More
How to Create a Project Finance Model in Excel
This tutorial will show you how to create a Project Finance Model and forecast Cash Flow in Excel with step-by-step…
Read MoreHow to Create a Subscription Model with Churn Calculation
This step-by-step tutorial will take you through an example of using Excel to create a Subscription Model with Churn Calculation.…
Read More
How to Visualise Data in Tableau
This tutorial will introduce you to Tableau and data visualisation. It will use an example of data downloaded from Destasis,…
Read MoreHow to Create an Excel Financial Model with Debt Financing
This step-by-step tutorial will take you through an example of using Excel to create a financial model with debt financing.…
Read MoreHow to Analyse Data in Excel with Power Query and a Pivot Table
This step-by-step tutorial will show you how to analyse data and Excel spreadsheets using Power Query and Pivot Tables. It…
Read More
How to Start a Consulting Business from Scratch
This business planning tutorial will help you start your consulting company and execute your business plan. Each section will highlight…
Read More
Learn How to Become a Self-Taught Data Analyst
In this blog, I share steps I have taken to learn data analysis, including the list of books and resources…
Read More
Your First Steps in Excel – Beginner’s Crash Tutorial
This step-by-step tutorial will give you a quick overview of Excel with examples of how to use basic calculations, formulas,…
Read MoreHow to Build a Cash Flow Forecast in Excel
A Cash Flow Forecast should be your core business tool, whether you are planning to raise equity financing for a…
Read More
How to Use Python and Pandas for Data Consolidation and Transformation
Python scripts can help you automate and improve the efficiency of your data analytics processes. Even a basic Python command…
Read MoreHow to Use Cohort Analysis to Calculate Retention and Churn Rate in Excel
Your business data contains a lot of valuable information about your customers, operations, costs and finances. And by using cohort…
Read More