Data Science Tutorials
You can use the COUNTIF function to count duplicates in Excel: =COUNTIF(range, criteria) In this short post, I’ll review a simple example with the steps to count duplicates for a given dataset. Steps to Count Duplicates in Excel using COUNTIF Step 1: Prepare the data that contains the duplicates To start, let’s say that you have the following …
Continue reading “How to Count Duplicates in Excel using COUNTIF”
In this guide, I’m going to show you how to apply an IF function in Excel 2016. Note that similar principles apply to previous versions of Excel. In general, IF functions allow you to perform logical tests in Excel. So what type of logical tests are we going to see in this guide? We’ll review the …
Need to retrieve specific characters from a string in Excel? If so, in this guide, I’ll show you how to use the Excel string functions to obtain your desired characters within a string. Specifically, I will use examples to illustrate how to apply the following Excel string functions: Excel String Functions Used Description of Operation LEFT Retrieve …
Continue reading “Excel String Functions: LEFT, RIGHT, MID, LEN and FIND”
VLOOKUP is a powerful function in Excel. In this tutorial, I’m going to show you how to use VLOOKUP in Excel 2016. Specifically, I’m going to review an example with the steps needed to apply a VLOOKUP. But before we begin, let’s first review the elements of the VLOOKUP function. Elements of the VLOOKUP in …
Continue reading “How to use VLOOKUP in Excel 2016 (example included)”
Need to create a column chart in Excel? In this post, I’m going to show you the steps needed in order to create a column chart in Excel 2016. Excel 2016 offers additional features that you can use in order to create a fancy column chart. To explore those features, we will review a simple …
Continue reading “How to Create a Column Chart in Excel 2016”
Need to create a drop-down list in Excel? If so, in this post I’ll show you the steps to create a drop-down list in Excel 2016. The example To start, let’s review an example where you have 5 simple tasks that you want to track: (1) Place a purchase order to buy a computer (2) Pay …
Pivot table is a powerful tool that can help you summarize and organize your data in an efficient manner. In this tutorial, I’ll use a simple example to show you how to create a pivot table in MS Excel 2016. Example of a Pivot Table in MS Excel 2016 To start, let’s say that you have a small …
Continue reading “How to Create a Pivot Table in MS Excel 2016”