PLEASE NOTE THE SUPPORTING FILE IS FREELY DOWNLOADABLE FROM 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 Hardware: Dell 24 2700 all-in-one 1tb hd 8mb RAM 23.8" touch screen Operating system:Windows 10 Visit us at : Tweet us at: