The Formula Tool


In this course you’ll learn how to improve your analytic capabilities in Alteryx using formulas. You’ll learn how to use the formula tool to perform calculations to manipulate data and facilitate further analysis. You’ll see how to deal with common types of data, like dates, times and text. You’ll apply key concepts through case-study style learning.  This course was created & customized for Chartered Accountants Ireland by

Venue details:  
Online EU, ,
Start date & time:  
01 January 2021 00:00
End date & time:  
01 January 2022 00:00
By registering for this course you have accepted the terms and conditions
Training ticket cost:  
3.00 Training Tickets accepted
CPD hours:  
Speaker details
No speakers have been associated with this event.


Product type:  
CPD online course
Kubicle, Technology and data

Who Should Attend?

This course is suited to intermediate learners who have a basic general familiarity with using Alteryx. This course will be of interest to any business professionals, such as accountants, management consultants and analysts who want to learn how to analyze data using formulas in Alteryx.

Course Overview

This Kubicle course contains 16 lessons, 3 exercises and 1 Exam. It covers the following topics:

  • Conditional Expressions and Conversions
  • Date and Time Basics
  • Converting Two Digit Years
  • Converting Serial Numbers to Date
  • Converting Serial Numbers to Time
  • The Multi-Field Tool
  • The Multi-Row Tool
  • Parsing Text Using the Formula Tool
  • Separating Text with Formulas

Key Outcomes

Once you’ve completed this course, you’ll understand how to create formulas using the formula tool. You’ll be able to deal with common data types, and you’ll know how to use the standard expressions provided by Alteryx to create formulas that will generate insights from your data. By applying the skills you’ll learn in this course, you’ll improve your ability to analyze and understand your data using Alteryx.