3 of 3 Remote/Hybrid Power Query Jobs in the East Midlands

Other project and commercial documentation Build formulas, data relationships, lookups, validation rules, dashboards, and reporting tools. Implement automation using advanced Excel functionality, including: Power Query Power Pivot VBA Macros (where appropriate) Dynamic Arrays Advanced Formulas and Data Linking Simplify and standardise document generation processes … reliability. Provide knowledge transfer and user training before project completion Proficiency with: Complex formulas XLOOKUP INDEX/MATCH Dynamic Arrays Pivot Tables Power Query Data Validation Conditional Formatting Experience building commercial and project management templates. Strong analytical and problem-solving skills. Ability to work independently ...

Other project and commercial documentation Build formulas, data relationships, lookups, validation rules, dashboards, and reporting tools. Implement automation using advanced Excel functionality, including: Power Query Power Pivot VBA Macros (where appropriate) Dynamic Arrays Advanced Formulas and Data Linking Simplify and standardise document generation processes … generate and populate multiple documents from a single source of data. Proficiency with: Complex formulas XLOOKUP INDEX/MATCH Dynamic Arrays Pivot Tables Power Query Data Validation Conditional Formatting Experience building commercial and project management templates. Strong analytical and problem-solving skills. Ability to work independently ...

analytics tools that provide data for use in insight generation Experience you’ll bring as our Data Analyst - Sustainability: Experience in SQL, Excel, Power Query and data visualization tools (e.g., Tableau, Power BI) Familiarity with SAP or similar PLM tools Familiarity with product analytics ...