Luckily, Excel offers handy formulas that allow you to convert text into upper case, lower case, title case, and even sentence case with minimal effort.

How to use Excel's new Cube-based functions and conversion tools to convert a PivotTable to a formula-based report.

Excel has over 475 formulas in its Functions Library, but we've selected the most popular, from date and time functions to mathematics and simple data manipulation.