Data Preparation Using Functions

Develop your Microsoft Excel skills for preparing, analyzing, and working with business data.

In this course, you will learn to use text functions to clean and standardize inconsistent data, date and time functions to create timelines and calculate time-based metrics, and logical functions to automate decisions and generate new information within datasets. Through practical business scenarios, you will apply functions such as IF, IFS, AND, and OR to transform data and support more reliable analysis. By the end of the course, you will be able to use Excel functions to improve data quality, create time-based calculations, and automate logic-driven tasks in spreadsheets.

Privacy Overview

This website uses cookies so that we can provide you with the best user experience possible. Cookie information is stored in your browser and performs functions such as recognising you when you return to our website and helping our team to understand which sections of the website you find most interesting and useful.