Master Power Query, Excel’s most powerful tool since Pivot Tables, and revolutionise the way you work with data. Learn to clean, transform, and combine data from multiple sources, automate repetitive tasks, and handle large datasets efficiently. Discover advanced techniques for reshaping data, creating custom transformations, and streamlining workflows—all without the need for complex formulas or VBA. By the end, you’ll work faster, smarter, and more confidently in Excel.
Prerequisites: Delegates should be confident using Excel and have a good understanding of formulas, worksheets and basic data management. Previous programming experience is not required.
Course Outline
During this course, participants will develop the skills to clean, transform, and automate data processes using Excel Power Query.
This course is ideal for Excel users who work with large or complex datasets and want to improve efficiency through automation. It is particularly valuable for professionals in data analysis, reporting, or operations who need to clean, combine, and transform data quickly and accurately.
Find out how we can empower your employees to harness the full potential of their potential.
Contact Us
We offer a wide range of bespoke corporate training solutions across key areas such as leadership, management development, digital skills, workplace communication, customer experience, sales performance, project delivery, team development and professional skills. Each programme can be tailored to your organisation’s objectives, your people and the practical challenges they face at work.
No. Elliott Training does not currently offer public scheduled courses for individual delegates. We specialise in private corporate training courses delivered exclusively for organisations, teams and groups who require tailored training aligned to their business needs.
Yes. Our courses can be tailored to your organisation, team and objectives. We can adapt the course content, examples, exercises, case studies and delivery style to reflect your sector, systems, processes and workplace priorities.
Yes. If you require a course that is not listed on our website, we can design a bespoke training programme around your specific requirements. This is ideal for internal projects, new systems, company initiatives, role-specific development or specialist skills training.
Course length depends on the subject, objectives and level of detail required. We can deliver bite-size sessions, half-day workshops, full-day courses, multi-day programmes or larger training projects across multiple cohorts.
Struggling find an answer to your question?
Contact UsSpeak to one of our experts and find out how we can take your learning journey to the next level.
"*" indicates required fields