Saving Companies Money by Using Excel Functions

I wanted to showcase some of the behind the scenes functions that I use when cleaning data in Excel. Also some of the functions used to make the data more useful.

Functions I used were: -Cleaned the data, text to split columns, concatenate, Left, Right, Trim, Proper -MAX, MIN, AVG, SUM -IF statements -SUMIF -COUNTIF- -XLOOKUP -Sort & Filter -Conditional Formatting -Pivot Table with Slicer and chart