Excel First

Excel Solutions

LEN function: Basic and Advanced Examples

Site White Background

LEN function type: Text

Description: Returns the number of characters in a text string
LEN is a basic function widely used, many formulas built for text processing will need this function.

Take a look at the advanced applications examples:


Read More

SUBSTITUTE function: Basic and Advanced Examples

Site White Background

SUBSTITUTE function type: Text

Description: Substitutes the old text with new text in a text stringBeyond its basic use, which is fairly simple, the SUBSTITUTE function can be very useful combined with other functions, to get your desired results. Take a look at the advanced applications examples:Applications:

Working with Excel Functions and Formulas

Site White Background (more…)

Order of Precedence

The Order of Precedence used by Excel to calculate formulas is extremely important to know when building complex formulas.

Of course, Excel will respect all mathematical rules you learned in school, there are only a few more Operators in Excel: the Range Operators, single Space Operator, Union Operator, the Concatenation Operator and the Exponentiation Operator.

Read More

Excel Reference Operators

There are 3 Reference Operators in Excel:

  1.   “:” (colon) is the Range operator, which produces one reference to all the cells between two cells references, including the cells written in the reference text, like: A11:A13
  2.  “,” (comma) is the Union operator, which combines multiple Ranges into one reference, like  A11:A13 , A11:C11 , A11 (you can refer to simple cells too, not only to ranges with multiple cells)
  3.  ” ” (space) is the Intersection operator, which returns a reference to the cell or to the range of cells found at the intersection of the ranges. In this example, only cell A11 is found in both ranges:  A11:A13  A11:C11

Read More

The Excel Learning Journey that I propose for you, is structured in such a way as to offer you the most practical way to learn Excel, free.

Start Your Free Excel Learning Journey!

Enter your email address to subscribe to this blog: