How to use the COUNTA function in Excel

Learn how to use the COUNTA function in Microsoft Excel. This tutorial demonstrates how to use Excel COUNTA with our easy to follow examples and takes you st...

How to use the CONCAT function in Excel (vs the CONCATENATE function)

Learn how to use the CONCAT function in Microsoft Excel (vs the CONCATENATE function). This tutorial demonstrates how to use Excel CONCAT to concatenate valu...

How to use the MINIFS function in Excel

Learn how to use the MINIFS function in Microsoft Excel. This tutorial demonstrates how to use Excel MINIFS with our easy to follow examples and takes you st...

How to use the Excel MAXIFS Function

Learn how to use the MAXIFS function in Microsoft Excel. This tutorial demonstrates how to use Excel MAXIFS with our easy to follow examples and takes you st...

How to use a FOR Loop in Excel VBA

Learn how to create a FOR LOOP using the For…Next statement in Microsoft Excel VBA. FOR LOOPS are used to execute code a fixed number of times and can be acc...

How to use the IF-THEN-ELSE statement in Excel VBA

Learn how to use the IF-THEN-ELSE statement in Microsoft Excel VBA. This tutorial demonstrates how to use the Visual Basic Editor in Excel to write an IF-THE...

How to use Aliases in SQL

Learn how to use aliases in SQL with easy to follow examples. This tutorial explains what an alias is and how to create an alias for a column name as well as...

How to use the COUNTIFS function in Excel

Learn how to use the COUNTIF function in Microsoft Excel. This tutorial demonstrates how to use Excel COUNTIF to count cells based on one or more criteria. W...

How to use the JavaScript findIndex (Array method)

Learn how to use the JavaScript Array method called findIndex to return the index of the first element in an array that meets a specific criteria. We'll cove...

How to highlight the top score (highest value) in an Excel table

Have you ever wanted to highlight the top score or value in an Excel table? In this tutorial, we'll show you to do this using the built-in conditional format...

How to use the MID function in Excel

Learn how to use the MID function in Microsoft Excel. This tutorial demonstrates how to use Excel MID with our easy to follow examples and takes you step-by-...

How to use the FIND function in Excel

Learn how to use the FIND function in Microsoft Excel. This tutorial demonstrates how to use Excel FIND with four easy to follow examples and takes you step-...

How to use the SQL IS NULL Condition

Learn how to use the SQL IS NULL Condition to test for a NULL value in SQL. This tutorial explains what a NULL value is and demonstrates how to write a query...

How to use the AVERAGEIF function in Excel

Learn how to use the AVERAGEIF function in Microsoft Excel. This tutorial demonstrates how to use Excel AVERAGEIF with an easy to follow example and takes yo...

How to find the closest larger number in an unordered list of values in Excel

Have you ever needed to find the closest larger number in an unordered list of values in Excel? In this tutorial, we'll show you how! This is a great formula...