Scientific notation, also known as scientific form, is a way of representing numbers visually in a shortened format through the use of decimals and exponents. It is a really useful way of displaying a lot of very large numbers alongside each other easily, even when the actual values may differ significantly. In this simple guide,…
In this simple guide, we will run through how to use the Excel CHOOSE function, with examples. We will cover: What is the CHOOSE function in Excel? CHOOSE is a relatively simple function on the surface that let’s users enter a list of values, characters, phrases and so on, and allow the user to literally…
One of the more confusing aspects of Excel is the way that dates and times are stored. This can get even more odd in the way formulas are then applied to them and formatting is set up. In this guide, we are going to provide two quick and easy ways on how to combine date…
While Excel is a popular tool for basic data analysis thanks to its ease of use and formulas, it is also a surprisingly powerful tool for statistical analysis – including multiple regression. In this guide, we are going to run through an overview and steps taken to perform multiple regression in Excel. We will cover:…
In this guide, we will run through 2 easy methods on how to alphabetize in Excel. We will cover: Let’s start with the first option. Alphabetize in Excel using sort Let’s say we have a list of names in a single column, and we want to quickly and easily sort them in alphabetical order. In…
In this simple guide, we will run through how to use the Excel FLOOR function. We will cover: What does the FLOOR function mean? Put simply, the Excel FLOOR function takes a specified number, and rounds it down to the nearest specified multiple. That’s it! One quick caveat however, is that if the number we…
In this simple guide, we will run through how to find outliers in Excel using a few different methods. We will cover: Why we should find outliers in our data Excel can be a very powerful tool for data analysis. While using databases with tools such as SQL, R or Python is generally preferred for…
In this simple guide, we will run through how to combine first and last name in Excel, using a couple of quick and easy formulas. Before we get started, it is also worth noting that Excel also easily allows us to do the exact opposite of this! If we for any reason had a dataset…
In this simple guide, we are going to run through how to use the NOW function in Excel, along with some examples of the outputs. We will cover: What is the NOW function in Excel? The NOW function in excel, is a relatively simple formula that outputs the current date and time. As it literally…
In this simple guide, we are going to run through the benefits, and steps to group worksheets in excel. Also known as tabs, this guide will explain how to turn multiple sheets into a single one for the purposes of editing. We will cover: Advantages of grouping worksheets When you are working with a lot…