Excel for Engineers

If you're a Mechanical Engineer, make sure you know these 10 Excel functions. Your work-life will become much easier once you learn these Excel formula combinations.

Excel IFS Function

The IF function is one of the most popular functions in Excel. But what about the IFS function? Does it really make writing nested IF functions easier? Let's find out.

MAXIFS MINIFS with Multiple Criteria

Excel MAXIFS MINIFS (MAX MIN with Multiple Criteria) Finding the largest or smallest value in a set is one of the first tasks beginning Excel users discover.  Just after the SUM function, the MAX and MIN functions quickly become one of the

Excel IF Function with PARTIAL Text Match (IF with Wildcards)

Excel IF Function with PARTIAL Text Match (IF with Wildcards) How can we look for an approximate match using wildcards with Excel’s IF Function? =IF(YouTu* THEN…) Can you use wildcards in the logical test portion of the IF Function? It seems like