Rows to Columns, Columns to RowsThere are situations where it's easier to sort if values were in columns (vertical) than rows. Learn how to do it using "paste spe
2 Ways to Reverse Number SignsEver worked with data where numbers should have been positive instead of negative or vice versa? There are 2 ways you can do it in less than
AVERAGEIFSAVERAGEIFS allows you to average a set of values that meet multiple criteria. It is useful when you need to make comparisons between differ
AVERAGEIFHad to average a set of values that met a criteria and didn't know how? AVERAGEIF is a super easy formula to use and understand. I exp
Nested IF StatementsAs things are rarely black and white, what if there is more than one condition? How will the IF statement look? Learn how to use "Nes
Flash FillWhat is “Flash Fill”? Flash fill "automatically fill in values" - Microsoft Excel. Once you've mastered it, it will save you
IF + AND“IF + AND” formulas are used to test if a value meets multiple criteria, giving one result, otherwise giving another.
IF + ORLearn how to use "IF + OR" formulas: if the value is x OR y, THEN a, ELSE b when you have more than one criteria.
Random selection from a list in 3 steps!Ever needed to perform some testing of random sampling? How did you go about selecting items at random from a list? Read on as I walk thro
Just a TRIMEver copied some text from another source and then realised it has extra spaces either before or after the word? Learn how to use TRIM to s
