Find and Select
This tutorial is going to review the Find & Select button in the Home section of the ribbon. Let’s say that you have the following list of names. […]
Excel
Learning Excel has never been easier. Review hundreds of Excel tutorials geared towards beginners all the way to experts.
Find and Replace in Excel
Learn how to use the Find and Replace feature in Excel. This handy tool can save you a ton of time and is very easy to use. Please
Find and Replace in Excel Read More »
Data Validation Techniques in Excel
We are going to cover Data validation techniques in Excel. Data validation is a very important feature of Excel document. This feature helps to prevent user from entering
Data Validation Techniques in Excel Read More »
Pivot Tables
Overview: Pivot tables are one of the most versatile and powerful tools available in Excel. They allow you to display data in a table format with multiple filters,
DATEVALUE Function
The Excel DATEVALUE function is used to convert a date in Excel to text. =DATEVALUE (date_text) date_text – Date in text format. In the example below, we convert
DATEVALUE Function Read More »
COUNTIF Function
The COUNTIF Function in Excel is extremely useful when dealing with large data sets. Here is a basic example of house to use this function. Below we are