Ad Clicks : Ad Views : Ad Clicks : Ad Views : Ad Clicks : Ad Views : Ad Clicks : Ad Views : Ad Clicks : Ad Views : Ad Clicks : Ad Views :
Home / Inspiration / Excel For Procurement Professionals

Excel For Procurement Professionals

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 Shortcuts

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.
It is main inner container footer text
%d bloggers like this: