Advanced Excel job test application - how to prepare for the major subjects

PLEASE NOTE THE SUPPORTING FILE IS FREELY DOWNLOADABLE FROM WWW.UNITEDCOMPUTERCONSULTANTS.COM/TESTSFILES AND LOOK FOR THE FILE "ADVANCED EXCEL"
This video covers the main procedures asked in a job test application involving Advanced Excel techniques.
Pivot Tables, Concatenate, IF with embedded And, Indirect, Index with Match,naming cells, SUMIFS, conditional formatting, basic Macros

Screen recording software: Camtasia for Windows 18.00
Hardware: Dell 24 2700 all-in-one 1tb hd 8mb RAM 23.8" touch screen
Operating system:Windows 10

Visit us at : http://unitedcomputerconsultants.com
Tweet us at: http://twitter.com/geoffhudson7

Видео Advanced Excel job test application - how to prepare for the major subjects канала United Computers