Convert Values in a Spreadsheet in Excel

Convert Values in a Spreadsheet in Excel

Video • 5 minutes

Learning Objectives

  1. Perform currency conversions in Microsoft Excel and master the use of the CONVERT function.

    Lesson Description

    This lesson explores practical methods for converting data efficiently. We examine the CONVERT function in Excel, demonstrating how simple it is to switch between units.

    By following our step-by-step guide, you'll see how to seamlessly convert data and unlock the potential of the CONVERT function for various transformations, such as changing centimetres to feet, celsius to Fahrenheit or stones to kilograms.

    This lesson extends to currency conversion, showcasing another method using Microsoft 365's Data Types. We’ll guide you through creating a table, applying data types, and utilising live data to track exchange rates.