Category Excel

How To Use Flash Fill In Excel

Flash Fill is an incredibly useful and often looked over function in excel which when used properly can save a ton of time when working with large data sets. What is Flash Fill? Flash Fill is a built in feature…

How To Use Concatenate In Excel

In the context of data, concatenate typically refers to joining of two or more  strings or elements. There are a few different approaches we can take when looking to merge strings of characters together using Excel.  The built in formula…

How To Calculate Probability In Excel

Probability is the measure of the likelihood of the occurence of a particular event. It quantifies uncertainty and is a fundamental concept in fields like statistics, science, and engineering. In this guide we will run through how to perform this…

How To Get Microsoft Office For Free

Microsoft Office is one of the most widely used productivity suites, offering tools like Word, Excel, PowerPoint, and Outlook. However, it usually requires a paid license. The good news is that there are legitimate ways to get Microsoft Office for…

Master Excel Lookup Function

Microsoft Excel offers a range of functions to simplify data analysis, including the HLOOKUP, VLOOKUP, XLOOKUP,  function. This article will cover these 3 lookup functions in detail, discuss a few of its differences and provide practical examples to help you…