How to do Data Analysis?

Xlookup is powerful Excel function that allows you to search tables and return desired values. The cells it creates can be dynamic based on reference ranges. In this article, I will teach you how to use Xlookup. I am using the free version of Office 365 Excel for this example,…

Excel allows you to lock cells in place and also merge them. This is often useful for adding titles to a sheet, that span multiple cells and for locking the column headers so they remain in place as you scroll down your table. In this article, I will teach you…

Excel allows you to create a drop down list for limiting the values of a column to certain predefined ones. This is considered Data Validation. In this article, I will teach you how to do this. I am using the free version of Office 365 Excel for this example, but…

Excel allows you to remove duplicates from your data very easily. In this article, I will teach you how to do this. I am using the free version of Office 365 Excel for this example, but other versions will work just the same. I am also using the Student Information…

Excel allows you to sort and filter columns of your data. In this article, I will teach you how to do both. I am using the free version of Office 365 Excel for this example, but other versions will work just the same. I am also using the Student Information…