IT/Data/Scheme Events
and pensions administration systems. Advanced Excel user - including pivot tables, lookups, nested IFs, and macros. Exceptional...
and pensions administration systems. Advanced Excel user - including pivot tables, lookups, nested IFs, and macros. Exceptional...
. Must be strong in data analysis, and have excel analytical expertise, including VLOOKUP's, nested 'if' statements, pivot tables filters...
in: Building complex nested functions and mapping tables Using Power Query effectively Creating dynamic GETPIVOTDATA() functions...
(i.e. V-lookup, Index/Match, pivot tables and pivot charts, macros and VBA, complex nested formulae). Power BI is used so experience...
(pivot tables, lookups, nested formulas, data cleaning/validation);ability to structure and manipulate complex datasets...
successful candidate must have demonstrated experience in applications like: Complex formulas, functions (VLOOKUP, INDEX/MATCH, nested...