Make a Stem-and-Leaf Plot in Excel – Step by Step
In this simple guide, we are going to explain how to easily build a stem and leaf plot in Excel step by step.
Calculating Factorial in Excel using FACT
In this simple guide, we are going to explain how calculate a factorial in Excel using any given number by using the built in FACT function. This guide will cover: What is a Factorial? A Factorial is a function in maths that takes a number, and then multiplies it by every whole number below it,…
Excel ANOVA function – Analysis of Variance
In this simple guide, we will run through how to perform the built in Excel ANOVA function to perform an Analysis of Variance with some examples. This guide will cover: What is Analysis of Variance (ANOVA)? Put simply – an Analysis of Variance is a common statistical technique that is used to compare separate groups…
How to use the Quick Analysis Tool in Excel
In this simple guide, we will run through how to use the Quick Analysis Tool in Excel, with some examples. This guide will cover: What is the Quick Analysis Tool? The Quick Analysis Tool in Microsoft Excel is a really handy feature that provides a whole range of functions that can be accessed with a…
How to Normalize Data in Excel With 1 Easy Formula
This guide will run through step by step how to Normalize Data with a Z-Score in Excel using the simple STANDARDIZE formula.
How to use the Excel CEILING function
In this guide, we are going to talk about the Excel CEILING function and some examples of how to use it. We will cover: What is the CEILING function in Excel? The Excel CEILING function is a formula within Excel that sits under the Math and Trigonometry category. This formula takes a number, and rounds…
SQL Aggregate Functions Explained
This tutorial is part of the SQL Made Easy series of posts. In this tutorial we will discuss: What are SQL Aggregate Functions? When working with data in SQL, there are a lot of ways we can filter down the data to bring in exactly what we are after. This could be a range of…
SQL Wildcard Characters Explained
This tutorial is part of the SQL Made Easy series of posts. In this tutorial we will discuss: What is a SQL Wildcard Character? Wildcard characters in SQL are a series of specific characters that are used within the LIKE operator as part of a WHERE filter. They are a great way to find specific…
SQL Primary Key Explained
This tutorial is part of the SQL Made Easy series of posts. When first learning about SQL and relational databases in general, one of the terms you are likely to come across when looking at the data is Primary Key. This is a really important concept to learn about early on as it will make…
SQL Operators Explained
In this simple guide, we are going to look at SQL Operators, explaining the concepts and use cases of logical, comparison and arithmetic functions that can be performed in SQL. This tutorial is part of the SQL Made Easy series of posts. In this post we will discuss: When would we use operators? When working…