ERPstuff - Oracle EBS Community

MS Excel Array Functions SORT, SORTBY & Unique 1of4
https://youtu.be/j6J0xtWbyno

MS Excel Array Functions Filter 2of4
https://youtu.be/w1HU33UwDMM

MS Excel Array Functions RANDARRAY, SEQUENCE 3of4
https://youtu.be/_hXJ_3vHNgw

MS Excel Array Functions XLOOKUP 4of4
https://youtu.be/PxdMqPh3KsM

MS Excel 365 DGET Function
https://www.youtube.com/watch?v=GptSu7nAIw0

Learn how to use following important shortcut keys of MS Excel,

MS Excel Few Important Shortcut Key and their Use
Shift + Spacebar Select current row
Ctrl + Spacebar Select current Column
Alt + ; or Ctrl + G Select visible cells only
Ctrl + - Remove selected row/column
Ctrl + + Add row/column
Ctrl + Shift + L Add or removed data filters
F4 Repeat last step

Watch the youtube video,

https://youtu.be/m3yoknAFSF4