Power Up Excel with Power Query
Power Query aka Get & Transform in Excel, is a feature that allows you to quickly import data from multiple sources and easily clean, transform, and reshape it to suit your needs.
Join us for our “Power Up Excel with Power Query,” webinar on Thursday the 19th of October 2023 from 14:30 to 16:00 (GMT).
Let us help you transform your data in Excel!
POWER QUERY
Want to know how to easily automate boring Excel tasks with Power Query!
Power Query aka Get & Transform is a free tool built into Excel that a lot of people don’t even know exists. Amongst other things, it is used for automating repetitive tasks (without using Macros or code).
In this webinar you will be shown how to use this powerful, time-saving tool. We will demonstrate how to import, merge, rearrange, and clean data, as well as how to repeat the process with one simple click if the data changes. Discover how to split columns, unpivot data, and use joins to merge, segment, and compare datasets.
In today’s data-driven world, the ability to work with data efficiently is crucial. Traditional data preparation tasks often involve manual and time-consuming processes, leaving room for errors and inefficiencies. This is where Get & Transform shines. Here are some key reasons why you should consider using Get & Transform in Excel:
- Data Integration
- Data Cleansing
- Data Transformation
- Automation
- Error Handling
- Scalability
Topics Covered
Working with very large dataset
Connecting to multiple Data Sources
Transforming and Importing Data
Filtering & Sorting Data
Removing Duplicates
Splitting and Combining Columns
Merging Queries
Pivoting and Unpivoting Data
Introduction to Power Pivots
Date:
Thursday, 19th of October 2023
Time:
14:30 to 16:00 (GMT)
Requirements:
Basic knowledge of Excel required
Trusted by:
€ 49
per person
For further information or to book a place on this course please call Cara on 0872702405 or email: cara@investinu.ie
Please book early to avoid disappointment as places are limited.
Why should I do the course?
Unlock Excel’s hidden potential with our “Power up Excel with Power Query” webinar! Dive into the world of data transformation and automation as we show you how to effortlessly clean, shape, and connect data from various sources. Boost your productivity, create stunning visualisations, and future-proof your skills in the ever-evolving data-driven landscape. Our friendly instructors make learning interactive and enjoyable, ensuring you gain valuable skills that will set you apart.
With the advanced capabilities of Power Query, you can gain a competitive advantage by being able to handle large data sets more efficiently than your peers. Overall, taking a course in Power Query can give you a valuable skill set that can help you stay ahead of the competition and succeed in your career.
“Working with InvestinU Eoin and Cara from a client perspective felt right from our first meeting, their enthusiasm and fit with our organisation, its needs was exactly what we required.
Their positive approach and skill at imparting their expertise across the Microsoft Office suite was superb. In particular, they assisted greatly at the design stage of our programme, content and structure, pace of delivery and building rapport with staff was excellent.
Being open to recording and building a continuous learning framework with us has been hugely beneficial.”
Susan Doyle – Bord Bia
“I’ve worked with Eoin over the last couple of years both on a professional and private level, on every occasion, I leave energized and excited about the potential of the learnings. Eoin’s passion for teaching and knowledge sharing is refreshing and continuously delivers an “above and beyond” engagement.
I’m also very impressed with InvestinU’s commitment to their customers and appetite to deliver value. I would highly recommend Eoin and the team for your next business engagement.”