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 instructions, practical examples to download and the calculation of Equity…
Read More 
How 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. First, it will show you how to forecast customer acquisition…
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, Germany’s Federal Statistical Office, to visualise Germany’s 2020 International Trading…
Read More How 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. First, it will show you how to calculate and forecast…
Read More 
How 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 will use an example of a data set to examine…
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 the risks you should address while building a new business.…
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 that helped me along the way. Find out about why…
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, and Pivot Tables. Download a sample Excel file for practical…
Read More 
How 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 new venture or need to prepare financial projections 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 will accelerate your work with data and Excel spreadsheets. In…
Read More