Excel Project: Dynamic Currency Converter with Formatted Excel Tables

Tobi Williams Babatunde

By Tobi Williams Babatunde

Jun 12

Dynamic Currency Converter with Formatted Excel Tables

In this project, I introduce you to the concept of formatted Excel tables and how it differs from a range of cells. You will learn how to improve your business workflows by taking advantage of formatted Excel tables, Power Query transformation capabilities and structured table referencing.

The goal is to build a Dynamic Currency Converter using a combination of formatted Excel tables, lookup (XLOOKUP) function and pivot tables. By the end of the project, you will have gained better skills in data transformation and data processing to build simple systems in Excel.

Download the dataset here.

1. Introduction to Formatted Excel Tables

2. Power Query for Pivot/Unpivot Operations

3. Applying Power Query Transformations

4. Structured Table Referencing

5. XLOOKUP and Pivot Tables

Table of contents
  1. Dynamic Currency Converter with Formatted Excel Tables
    1. 1. Introduction to Formatted Excel Tables
    2. 2. Power Query for Pivot/Unpivot Operations
    3. 3. Applying Power Query Transformations
    4. 4. Structured Table Referencing
    5. 5. XLOOKUP and Pivot Tables
resa logo

Empowering individuals and businesses with the tools to harness data, drive innovation, and achieve excellence in a digital world.

2025Resagratia (a brand of Resa Data Solutions Ltd). All Rights Reserved.