Video Tutorials
Step by step guide
Step by step guide
Welcome to the NADABAS Tutorial — your gateway to mastering one of Africa’s most powerful tools for national accounts compilation. This hands-on training package is designed to empower you with the skills to build, manage, and customize your own statistical system using NADABAS. With its seamless Excel integration, intuitive design, and database connectivity, NADABAS simplifies complex workflows and transforms data into insight. This tutorial isn't just a guide — it's your launchpad to become a proficient NADABAS user. Start here, and unlock the full potential of data-driven decision-making. The NADABAS tutorial is a free training package that can be requested here.
It consist of a Training Manual, the Data set (requested) and videos below.
Content
Start by downloading file NADABAS.xlam here
Save the file NADABAS.xlam on your computer on the local C-drive.
Open the file
Select your language
Click on button “Install as Add-In” in Excel
Activate macros if asked
Restart Excel
On the ribbon, there should be a new item, NADABAS
The NADABAS manual can be downloaded here:
In this video we demonstrate how to install NADABAS.
Important Installation Notice
If you download the file as a ZIP archive, it may be blocked by your system. To proceed with installation, follow these steps:
Right-click on the downloaded ZIP file.
Select Properties from the menu.
In the General tab, look for the Security section. See below
Check the box next to Unblock (if available).
Click Apply, then OK to save the changes.
You can now extract and install the file without issues.
Following these steps ensures a smooth installation process. If you encounter any issues, please contact support.
In this video we demonstrate how to create a database in NADABAS.
In this video we demonstrate how to load the workbook “Classifications”.
In this video we demonstrate how to make the support documents, like “NADABAS error messages”, more accessible.
In this video we explain the reasoning behind the creation of the key family "Prices".
In this video we explain how to create the key family "Prices".
In this video we demonstrate how to link dimensions to their classifications
In this video we explain how to define the data areas needed to eventually link the workbook "Prices" to the database.
In this video we demonstrate how to link the workbook "Prices" to the database.
In this video we demonstrate how to register the workbook "Prices".
In this video we demonstrate how to save the data from the workbook "Prices" to the database.
In this video we explain the reasoning behind the creation of the key family "ForTrade".
In this video we explain how to create the key family "ForTrade".
In this video we link the new dimensions in the key family “ForTrade” to their classifications.
In this video we explain how to define the data areas needed to eventually link the workbook "ForTrade" to the database.
In this video we link the workbook "ForTrade" to the database.
In this video we register the workbook "ForTrade" and load the data into the database.
In this video we explain how to make a key family we can use for both Tax_VAT and Tax_Income.
In this video we demonstrate how to link the new dimensions in the key family “TaxData” to their classifications and how to define the necessary data area in the workbook "Tax_VAT".
In this video we link the workbook "Tax_VAT" to the database.
In this video we register the workbook "Tax_VAT" and load the data into the database.
In this video we explain how to define the data areas needed to eventually link the workbook "Tax_Income" to the database.
In this video we demonstrate how to link the workbook "Tax_Income" to the database.
In this video we continue to demonstrate how to link the workbook "Tax_Income" to the database.
In this video we register the workbook "Tax_Income" and load the data into the database.
In this video we explain the contents of part 3 of the NADABAS Tutorial
In this video we explain the reasoning behind the creation of the key family "Production".
In this video we explain how to create the key family "Production".
In this video we demonstrate how to link the new dimensions in the key family “Production” to their classifications and how to define the necessary data areas in the workbook "C1".
In this video we demonstrate how to link the workbook "C1" to the database
In this video we show you an example of how to process the workbooks that are very similar to workbook C1, using workbook B as an example.
In this video we guide you through the compilation of workbook F.
In this video, we show you a guiding example of how to process the majority of the remaining workbooks in part three of the NADABAS tutorial, using workbook A as an example.
In this video we guide you through the compilation of workbook K.
In this video we guide you through the compilation of the workbook "Taxes".
In this video we guide you through the compilation GDP by the production approach.
In this video we show you how to create a batch of workbooks and a batch of batches.
In this video we explain how to execute and evaluate a batch run.
In this video we demonstrate how to delimit the period.
In this video we demonstrate how to hide and un-hide templates