Function Type: Date and Time Description: The DATE function in Excel allows you to build a date from individual year, month, and day values. It would Return the value or serial number of a particular date.

Function Type: Lookup and Reference Description: MATCH function searches for the specified lookup_value in a range or array then returns the relative location of that lookup_value in the range or array.

I am dedicated in educating people on using Excel and Google Sheets. Aside from the fact that they are used by every company, we can still utilize our excel/sheets skills by selling templates. @exceltemplate

Function Type: Lookup and Reference Description: INDEX function returns the value of a given location in a table range or array. This function is commonly used with MATCH function which give us the location

Function Type: Lookup and Reference Description: HLOOKUP is used to lookup a data and retrieve the corresponding data from a specific column. You may either lookup for the exact or approximate match. The

Function Type: Lookup and Reference Description: VLOOKUP is one of the most popular functions in Excel. It is used to lookup a data and retrieve the corresponding data from a specific column. You may either

Function Type: Logical Description: IF function specifies a logical test to perform allowing us to return one of two results. Logical test results in a TRUE or FALSE. Logical tests utilize Logical Operators.

Another frequently used function in excel and gsheets is the PRODUCT function. It is the counterpart of the mathematical formula of multiplication. Function Type: Math and Trigonometry Description: Multiplies

The easiest and most frequently used function in excel and gsheets is the SUM function. It is also the best way to introduce us the functions. SUM function is the counterpart of the Mathematical Formula

In Excel and GSheets, function is a pre-defined formula that makes calculations easier. We'll just have to input specific values in specific order known as arguments. Here is a compiled list of all functions

A range is a collection of two or more cells. It is usually adjacent, but they don't necessarily have to be next to each other to be a range. Contiguous range - cells are adjacent Non-contiguous range

In Microsoft Excel, a cell is a rectangular box that occurs at the intersection of a vertical column and a horizontal row in a worksheet. Thus, it is defined by a combination of column and row e.g., A1

One thing that makes my work in Excel faster is due to Options I selected in my Settings. This article is designated to help us navigate Excel Settings and discover what the options do. You can access

I find it crucial for aspiring excel experts to know fully well the ribbons as these are the key to having better productivity in Excel. Here is an overview of the most commonly useful ribbons available

This post is designated as a reviewer for Basic Excel trainings I conduct. Feel free to share with anyone. 😉 In teaching Excel, I find it helpful to make sure that we are on the same page with the

This post is designated as a reviewer for Basic Excel trainings I conduct. Feel free to share with anyone. 😉 In teaching Excel, I find it helpful to make sure that we are on the same page with the

Navigate excel sheets quickly with these shortcuts. Compilation of all Shortcut keys for Excel. This will be updated from time to time as Microsoft releases new shortcuts. Keys for MOVING and SCROLLING