How to Make Pie Charts in Excel: Bar and Line Charts
Available charts in Excel will allow you to represent data in a variety of ways. You can choose between column, line, pie,…
Kelechi Agomuo
Kelechi Agomuo
How to use PivotTable in Excel 2016
PivotTable in Excel is an advanced tool that allows you to organize and analyze large data set. Using pivot tables, you can…
Kelechi Agomuo
INDEX MATCH Function with Multiple Criteria In Excel
The INDEX MATCH function is used to perform a two-way lookup to extract values from a data table. It is used as…
Kelechi Agomuo
What is Xlookup Function: Easy Vlookup Multiple Criteria
Vlookup and Xlookup functions are used to extract values in a table of data in Excel. Both are used to query a…
Kelechi Agomuo
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
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