Choose your training format
We offer flexible learning options to fit your needs.
Group Training
Perfect for teams of 3+ people
- Interactive team exercises
- Collaborative problem-solving
- Cost-effective for organisations
- Shared learning experience
- Custom scenarios for your industry
1:1 Personal Coaching
Tailored training for individuals
- Personalised attention and pace
- Focus on your specific challenges
- Flexible scheduling around your calendar
- Work with your actual datasets
- Follow-up support included
Course curriculum
-
Merge Data Sources
- Learn how to combine data from multiple sources into a single, cohesive dataset.
-
Append Data Sources
- Understand how to append data from different sources to create a comprehensive dataset
-
Transform Data
- Master various transformation techniques such as Fill Up, Fill Down, Replace Values, Move Columns, and Split Columns
-
Unpivot Columns
- Discover how to unpivot columns to transform your data into a more usable format
-
Create Conditional Columns
- Learn to create columns based on conditions to enhance your data analysis
-
Create Columns from Examples:
- Use examples to create new columns, simplifying the data transformation process
Who is this for?
-
Power Query would be beneficial for anyone who works with data regularly and wants to save time and effort in preparing their data for analysis
-
Once you’re comfortable working in Excel, you can learn how to use Power Query to automate and streamline your data transformation, cleansing, and loading tasks
-
This course is perfect for anyone looking to enhance their data preparation skills and improve efficiency
