Most Procurement professionals use excel on a regular basis but some functions are easier to remember than others. If you need to refresh your memory or learn new tricks check out these videos.
V Lookup in Excel
Pivot Tables in Excel
Excel Dashboard- Speedmometer Chart
Paste Special to Transpose
You’ve got a bunch of rows. You want them to be columns. Or vice versa. Copy the data, select Paste Special, check the Transpose box and paste with a different orientation.
Use the $ Sign
If you copy a formula and paste it in the next cell down, Excel will shift that referenced cell, so it would say A2 instead. To prevent shifting, use the $. So in that case, saying $A1 would prevent a shift in the column (A); A$1 prevents the shift in the row (1), and $A$1 prevents the shift change in any direction when copying a formula.