#excelforall

Function Type: Lookup and Reference Description: The INDIRECT function in Excel is used to convert a text string into a valid cell reference. It can be used to dynamically reference a cell or range of

Function Type: Lookup and Reference Description: The COLUMN function in Excel or Google Sheets returns the column number of a reference. Although we see alphabet being utilized as column indicators, this

Function Type: Lookup and Reference Description: The ROW function in Excel or Google Sheets returns the row number of a reference. It would return a whole number. It is useful and frequently used combined

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.

So you are a small business owner, say a retail shop. You've got the sales going and now you want to track how your business is doing... Or you probably have 1 or 2 employees. So now you want to track

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

Hi fellow Excel fans, Recently I got to have a lot of fun with some great Excel formulas! Excel Formula Flexing One of the things that I love to do is monkey around in Excel with some data. I unfortunately