Excel Tips and Tutorials

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.

How To Calculate Weighted Average In Excel

The average value of number of cells or a data range in Excel can easily be calculated using AVERAGE() formula.

How To Use MINIFS Function In Excel

The MINIFS function is an advanced statistical function, which is only available in the latest version of Office (EXCEL 2016, Excel Online and latest mobile excel versions).

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).

How To Quickly Delete Blank Rows In Excel

Deleting rows are usually done by two methods as explained below.

Total Count  : 191