Excel Basics – Power Query and Tables
Overview
Master Excel Faster: Power Up with Power Query & Tables!
Are you spending hours cleaning and organizing data in Excel? Do you struggle with repetitive tasks and complex spreadsheets? Our Excel Basics: Power Query and Tables session will introduce you to essential tools that streamline data management, boost efficiency, and enhance your reporting capabilities. Learn how to transform raw data into structured insights with ease—no advanced Excel skills required!
- Power Query Basics – Easily import, clean, and reshape data
- Excel Tables – Simplify sorting, filtering, and structured referencing
- Automation Tricks – Reduce manual work and streamline
This session is a high-level overview with practical examples, giving you actionable insights to apply immediately. Perfect for professionals who want quick wins in Excel—don’t miss out!
Learning Outcomes:
By the end of this 60-minute session, you will have a solid understanding of Power Query and Excel Tables, enabling you to import, clean, and organize data efficiently. You’ll learn how to automate repetitive tasks, enhance data analysis, and apply structured referencing for improved accuracy and productivity. Through real-world applications and live demonstrations, you’ll gain practical skills to streamline your workflow, reduce manual effort, and make data management in Excel faster and more effective.
Suited to:
Anyone who works with Excel
This On Demand recording Includes:
- Recording of the Live Webinar, which can be viewed multiple times, for as long as required
- Presenters contact details for follow up questions
- CPD Quiz
- CPD Certificate
- CPD Report – Logged automatically
- PowerPoint Presentation
- Verbatim Transcript, with Searchability
- Supporting Documentation
Course syllabus
3 lessons
- Video – Excel Basics – Power Query & TablesVideo
- Feedback Survey QuestionsSurvey
- Knowledge QuizTest
Your presenter
Ken PowellNexacu
, Applications Trainer
With over 14 years of experience in corporate training, Ken is a recognized expert in Excel, Power Query, and data automation. He has worked with organizations across various industries, helping professionals simplify complex data processes, improve efficiency, and make smarter business decisions. Ken’s hands-on training approach makes learning Excel’s advanced tools accessible and practical for all skill levels.