Excel TRUE Function Tips

5 Ways To Handle Or Prevent Errors In Excel

To human is err, the same is true for excel. Whenever you are writing a formula, you are prone to commit error.

Concat VS. Concatenate VS. Textjoin

The CONCAT, CONCATENATE and TEXTJOIN functions are popular as text combining functions, which have been designed to combine a range of strings that contain parts of text, phrases or numbers.

Looking Up Number Values

There are five methods you can use to look up number values in excel. These include SUMPRODUCT, SUMIF, AGGREGATE, LOOKUP and a combination of INDEX & MATCH.

Count Values Based on Other Criteria

Counting values in Excel using criteria is common in day to day business. For example; counting the number of failed products, overdue orders, staff in a certain department etc.

How To Use IFS Function In Excel

IFS function is a new function added to Excel and only available in the latest version of Office (EXCEL 2016, Excel Online and latest mobile excel versions).

Basic Tax Rate Calculation

MS Excel has been used in many diversified areas; one of them is accounts and finance.

How To Sum Using Logical Functions - An Example Of Using AND () And OR() In Excel

MS Excel offers seven logical functions, today we will discuss how to use AND () when summing up values.

Example Vlookup

Many of the learners at Sheetzoom.com are willing to learn VLOOKUP function. It is an amazing and useful tools and learning to use it is much easier than you may think.

How To Find Text With A Formula

What formula will tell you that a specific cell contains a specific text?

Combine Data With TEXTJOIN

Included in the group of six functions released by Excel 2016 is a very valuable function; TEXTJOIN. 

Top Formulas for Analysts

If you are wondering what the top ten formulas are, then you should really consider acknowledging the fact that there is no standard list of the perfect ten formulas for each individual.

How to use Vlookup with Exact Match

Vlookup can be considered as one of the most beneficial functions offered in Microsoft Excel, which has become much useful in data analysis and data processing work.