After years of wrestling with messy spreadsheets, I've discovered four Excel functions that save me hours every week by automating tedious tasks most people do manually. I stopped using VLOOKUP years ...

The SORT and SORTBY functions let you extract certain columns and rows from a dataset and sort them in a certain order, all while preserving the source data. Even though they work in similar ways, ...

How to split a column using an IF() function in Excel Your email has been sent We all inherit Microsoft Excel sheets that don’t suit our working routine. If it’s a simple tracking sheet of some sort, ...

Power users love to talk about how powerful and awesome Excel is, what with its Pivot Tables, nested formulas, and Boolean logic. But many of us barely know how to find the Autosum feature, let alone ...

Excel has built-in functions for sine and cosine, the two core trigonometric functions, and for hyperbolic sine and hyperbolic cosine, their hyperbolic counterparts. It also has built-in functions for ...

How to turn complex formulas into easy-to-use custom functions using LAMBDA() in Excel Your email has been sent LAMBDA functions are new to Microsoft Excel. With LAMBDA functions, you can turn a ...

Cells in Excel are referred to using relative or absolute references. A formula with relative references changes when the cell's position does. If, for example, a cell has a formula "=A1" and you copy ...

Q. How do the TEXTBEFORE and TEXTAFTER functions in Excel work? A. Excel’s TEXTBEFORE and TEXTAFTER functions allow users to quickly split up text in ways that used to require combinations of ...