Discover Waves Communities

Topics

excelforall

#excelforall
Global

Trending
Hot
New
Payout
Muted
Promoted

Discover communities

Explore communities

Create your community

latest #excelforall created topics - older | Ecency

#excelforall

Follow to get notified about new posts with this tag

excelsheets

4y

INDIRECT function

INDIRECT function

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

$ 3.292

65

excelsheets

4y

COLUMN function

COLUMN function

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

$ 0.238

34

excelsheets

4y

ROW function

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

excelsheets

4y

DATE function

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.

exceltemplate

4y

Basic Inventory Tracker Excel Template for Retail Business: Upgraded

Basic Inventory Tracker Excel Template for Retail Business: Upgraded

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

excelsheets

4y

MATCH function

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.

excelsheets

4y

What excel templates are selling for passive income?

What excel templates are selling for passive income?

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

excelsheets

4y

INDEX function

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

excelsheets

4y

HLOOKUP function

HLOOKUP function

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

excelsheets

4y

VLOOKUP Function

VLOOKUP Function

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

excelsheets

4y

IF Function

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.

excelsheets

4y

PRODUCT function

PRODUCT function

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

excelsheets

4y

SUM function

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

excelsheets

4y

Excel and GSheet Functions Compilation

Excel and GSheet Functions Compilation

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

excelsheets

4y

Excel Range

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

excelsheets

4y

Excel Cells

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

excelsheets

4y

Excel Settings Overview

Excel Settings Overview

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

excelsheets

4y

Excel Ribbons Overview

Excel Ribbons Overview

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

excelsheets

4y

Excel Layout Overview

Excel Layout Overview

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

cmplxty

5y

Excel Formula Flexing!

Excel Formula Flexing!

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

← Latest Older →