How to use Vlookup Formula in Excel
The Vlookup formula in Excel can be used to extract values in a table of data. It is a useful function that…
Kelechi Agomuo
Kelechi Agomuo
The IF Statement in Excel: Nested and IFS Function
The IF statement in Excel is one of the logical functions in Microsoft Excel. It is used to return values when used…
Kelechi Agomuo
What are Logical Functions in Excel: AND, OR, NOT, XOR?
Logical functions in Excel are used to test the conditions of an argument whether it is TRUE or FALSE. There are different…
Kelechi Agomuo
The AVERAGEIF and AVERAGEIFS Function in Excel
The AVERAGEIF and AVERAGEIFS function in Excel are predefined functions that calculate the arithmetic mean based on specified criteria. You can use…
Kelechi Agomuo
How to Use the COUNTIFS and COUNTIF Function in Excel
The COUNTIFS and COUNTIF function in Excel are predefined functions that count cells based on specified criteria. You can use either function…
Kelechi Agomuo
How to Use the SUMIF and SUMIFS in Excel
The SUMIF and SUMIFS in Excel are predefined functions that calculate totals based on specified criteria. You can either function to manipulate…
Kelechi Agomuo
Understanding How to Use Excel Formulas and Functions
This tutorial introduces how to use Excel formulas and functions. Formulas are expressions entered by a user for the purpose of calculating…
Kelechi Agomuo
What is Cell Referencing in Excel?
Cell referencing in Excel is the process of representing the value of a cell in another cell within a workbook. It is…
Kelechi Agomuo
Formatting Numbers and Worksheet in Excel
A worksheet in Excel is a collection of cells organized in columns and rows as in a table. A worksheet is a…
Kelechi Agomuo
Conditional formatting in Excel: Uses and Applications
Conditional formatting in Excel is an important tool used for effective data analysis. It is a tool that helps you identify and…
Kelechi Agomuo
Entering and formatting data in Excel: Tutorial 2
Entering data in Excel is the same as typing text and numbers into the cells in an Excel worksheet. Formatting data in…
Kelechi Agomuo
What is Microsoft Excel: Tutorial 1
Microsoft Excel is a proprietary spreadsheet application developed by Microsoft. Its first version was released for Macintosh in 1985 and later for…
Kelechi Agomuo