What does 8.23 billion people actually mean for decision-makers?
As of 2025, global population has reached 8.23 billion — but that headline number obscures the story. The real insight lies in where growth is happening, how fast, and what age structure sits behind it. A country growing at 3% annually looks very different from one shrinking at 0.5%, even if their current populations are similar.
This project uses Excel to clean, enrich, and analyse population data across 233 countries, answering the central question: how can country-level population data be leveraged to identify regional growth patterns, demographic risks, and strategic opportunities?
From raw data to analysis-ready dataset
The raw dataset from Kaggle contained 233 rows and 11 columns of population statistics. Before any analysis could begin, several cleaning and enrichment steps were carried out in Excel.
Reviewed all 11 columns for completeness, data types, and formatting issues. Identified encoding issues in column headers (e.g. Density (P/Km²) — a UTF-8 encoding artefact) and corrected them across the working sheet.
The raw dataset had no continent classification — only country names. A new Continent column was manually mapped and added to the Analysis sheet, enabling continental aggregation in all pivot tables. This was the most critical enrichment step, as all regional analysis depended on it.
The raw data included Yearly Change (%) as a formatted percentage string. A new % Change decimal column was calculated in the Analysis sheet for use in pivot calculations and conditional formatting:
// Net Change divided by Population to get decimal growth rate
= E2 / D2
// E2 = Net Change, D2 = Population 2025
// Formatted as percentage in the cell
Column headers were cleaned and shortened for readability in pivot tables: Fert. Rate → Fertility Rate, Median Age → Age (avg), World Share (%) → World share. Consistent naming prevents ambiguity when building pivot tables.
Using the cleaned Analysis sheet as the source, pivot tables were built across six categories — population ranking, net change leaders, average age, density, continental totals, and migration — all compiled in the Key Metrics sheet for dashboard use.
Enriching the dataset for deeper analysis
The table below shows what was present in the raw Kaggle dataset versus what was added or transformed in the Analysis sheet.
| Column | Source | Notes |
|---|---|---|
| Country | Raw data | No changes |
| NEW Continent | Manually added | Mapped each country to its continent. Essential for all regional aggregations. |
| World Share | Raw data | Reformatted from % string to decimal for pivot compatibility |
| Population 2025 | Raw data | Renamed for clarity |
| Net Change | Raw data | No changes |
| NEW % Change | Calculated | =Net Change / Population — decimal growth rate for sorting and conditional formatting |
| Fertility Rate | Raw data | Renamed from Fert. Rate |
| Age (avg) | Raw data | Renamed from Median Age |
| Density | Raw data | Header corrected (encoding fix) |
| Land Area | Raw data | Header corrected (encoding fix) |
| Migrants (net) | Raw data | No changes |
The formulas behind the analysis
Several Excel functions were used across the Analysis and Key Metrics sheets to calculate, aggregate, and rank the data.
Continental Population Totals
// Sum all population values where Continent = "Africa"
=SUMIF(B:B, "Africa", D:D)
// B:B = Continent column, D:D = Population column
// Repeated for each continent in the Key Metrics sheet
% Change Calculation
// Decimal growth rate per country
=E2/D2
// Applied down the column for all 233 countries
// Formatted as percentage with 2 decimal places
Pivot Table Aggregations
// Top 10 most populated — pivot with Population SUM
// sorted descending, top 10 filter applied
// Average Age extremes — pivot with Age (avg) field
// sorted ascending (youngest) and descending (oldest)
// Continental net change — pivot grouped by Continent
// Values: SUM of Net Change, SUM of % Change
What the data reveals about the world in 2025
Continental Population Share
| Continent | Population | World Share | Net Change |
|---|---|---|---|
| Asia | 4.84B | 58.7% | +28.4M |
| Africa | 1.55B | 18.9% | +34.7M |
| Europe | 742M | 9.0% | −674K |
| North America | 617M | 7.5% | +4.2M |
| South America | 438M | 5.3% | +2.5M |
| Oceania | 46.6M | 0.6% | +521K |
Africa is growing faster than Asia in absolute terms — adding 34.7M people vs 28.4M — despite having less than a third of Asia's population. The demographic centre of gravity is shifting south.
Aging vs Youthful Populations
Oldest Countries
Japan (49.8), Monaco (53.6), Italy (48.2), Germany (45.5). These countries face serious labour shortages and rising healthcare costs in the coming decade.
Youngest Countries
Niger (15.6), Mali (15.7), DR Congo (15.8), Chad (15.8). Enormous potential workforce — if education and employment systems can absorb it.
Declining Populations
China (−3.2M), Russia (−823K), Japan (−650K), Germany (−477K), Poland (−398K). All facing the same core challenge: low fertility meeting an aging base.
Migration as a Buffer
USA (+1.23M migrants), Canada, Germany, and Australia all use positive net migration to partially offset low birth rates — a deliberate demographic strategy.
Strategic implications for businesses & policymakers
- Prioritise Africa and South Asia for long-term market expansion. Nigeria, India, Pakistan, and Ethiopia are combining high growth rates with young populations — exactly the profile that drives consumer market expansion over the next 20 years.
- European and East Asian businesses must invest in automation and migration policy. Workforce contraction is not hypothetical — it is already happening. Countries like Germany and Japan need structural responses, not just short-term fixes.
- Match education investment to where the youth are. A median age of 15–16 across much of sub-Saharan Africa means the workforce of 2040 is in school today. The demographic dividend is only realised if those systems are built now.
- Don't equate population size with market opportunity. China is the world's second-largest population but is now shrinking. India has overtaken it in size and is still growing. Market strategies need to reflect dynamics, not snapshots.
Numbers tell a story — if you know which columns to add
This project demonstrates that raw population data on its own has limited analytical value. The real work was in enrichment: adding the Continent column, calculating growth rates, standardising headers, and building the pivot architecture that made cross-regional comparison possible.
The findings confirm that global population growth is deeply uneven. Africa is young and fast-growing. Europe and East Asia are aging and declining. Asia dominates in size but is slowing. These aren't just demographic facts — they are the conditions under which every major strategic decision over the next 30 years will be made.