Category: Tips and Tricks
Excel Champs shares 7 ways to convert numbers from negative to positive.
Access Analytic shows how to generate random numbers in Excel with the RAND and RANDBETWEEN formulas.
Get Digital Help shows you how to use the PHI function to calculate Density.
u/ValueBasedPugs provides a quick workaround to a question on adding cell descriptions over at r/Excel.
Excel is Fun shows you how to use conditional formatting to find duplicated rows of data.
Access Analytic is here with a quick tip on using OFFSET to make sure your formulas work they way they’re intended.
Excel Solutions walks you through the TEXTJOIN formula, a new improved version of CONCATENATE!
My Online Training Hub takes it to the next level, by creating a custom add-in to show Real Time Data!
Reddit is always there to help! u/idiotsgyde helps out with a question on how to combine IF and IFERROR over at r/Excel.