Virtual
Power Query & Power Apps
Build practical skills to clean, transform and connect data with Power Query, and create workplace applications using Power Apps.
A practical online training programme focused on data connectivity, data cleaning, transformation workflows, Canvas Apps, forms, galleries, controls, validation rules and business workflow integration.
The Programme
Programme Overview
Introduction
Course Overview
Business teams often spend significant time cleaning inconsistent data, combining files, formatting columns, preparing reports and managing routine data-entry or tracking activities manually. Without structured tools, these tasks can become repetitive, error-prone and difficult to refresh or scale.
This programme introduces participants to Power Query and Power Apps for practical workplace use. Participants learn how to connect data from Excel, CSV, folders and other common sources, clean and transform data, create reusable refreshable workflows, build Canvas Apps, connect apps with data sources, design screens and forms, and integrate Power Query and Power Apps into business workflows.
Outcomes
What You Will Learn
- Understand Power Query and its business applications.
- Connect data from Excel, CSV, folders and other common sources.
- Navigate the Power Query Editor.
- Understand queries, applied steps and data types.
- Clean inconsistent, incomplete and duplicate data.
- Split, merge and format columns.
- Combine multiple files using Append and Merge.
- Create reusable and refreshable data-transformation workflows.
- Understand Power Apps and its workplace use cases.
- Create, test, publish and share practical workplace applications.
Methodology
How We Teach
- Practical walkthrough of Power Query and data connectivity.
- Hands-on data cleaning and transformation practice.
- Exercises on splitting, merging, formatting, appending and merging data.
- Application-based learning on reusable and refreshable transformation workflows.
- Canvas App creation using templates and blank layouts.
- Practice on screens, forms, galleries, navigation, formulas, controls and validation rules.
- Discussion on integrating Power Query and Power Apps into business workflows.
The Outcome
Impact & Audience
For the Organization
Organizational Impact
- Reduce manual effort in data cleaning, consolidation and transformation.
- Improve consistency and accuracy in handling Excel, CSV, folder-based and other common data sources.
- Create reusable and refreshable data-transformation workflows.
- Enable teams to build simple business applications for data entry, approvals and tracking.
- Improve workplace productivity through better forms, galleries, navigation and validation-based applications.
- Support smoother integration of data preparation and business application workflows.
For the Individual
Personal Impact
- Build confidence in using Power Query for data connectivity and transformation.
- Learn how to clean and consolidate business data more efficiently.
- Understand how to create refreshable workflows for repeated data tasks.
- Gain practical exposure to creating Canvas Apps.
- Learn how to design screens, forms, galleries and navigation.
- Develop the ability to create simple data-entry, approval and tracking applications.
Audience
Who Should Attend
- Business Professionals: To clean, combine and manage data more effectively.
- Excel Users: To move beyond manual data cleaning and create reusable transformation workflows.
- MIS and Reporting Teams: To connect, prepare and consolidate data from multiple sources.
- Operations Teams: To create simple data-entry, approval and tracking applications.
- HR, Finance and Admin Teams: To improve routine data handling and workflow-based tasks.
- Team Leaders and Managers: To understand how Power Query and Power Apps can support business workflow improvement.
Curriculum
Course Outline
Session 1: Introduction to Power Query and Data Connectivity
- Understand Power Query and its business applications.
- Connect data from Excel sources.
- Connect data from CSV files and folders.
- Connect data from other common business sources.
- Navigate the Power Query Editor.
- Understand queries, applied steps and data types.
Session 2: Data Cleaning, Transformation and Consolidation
- Clean inconsistent data using Power Query.
- Handle incomplete data more effectively.
- Identify and remove duplicate data.
- Split, merge and format columns.
- Combine multiple files using Append and Merge.
- Create reusable and refreshable data-transformation workflows.
Session 3: Building Business Applications with Power Apps
- Understand Power Apps and its workplace use cases.
- Create a Canvas App using templates.
- Create a Canvas App using blank layouts.
- Connect apps with Excel data sources.
- Connect apps with SharePoint and other data sources.
- Design screens, forms, galleries and navigation.
Session 4: Developing and Deploying Practical Power Apps
- Use formulas while developing Power Apps.
- Work with controls in Power Apps.
- Apply validation rules for better data entry.
- Create data-entry, approval and tracking applications.
- Test, publish and share an application.
- Integrate Power Query and Power Apps into business workflows.
Faculty & Inclusions
Your Trainer
Faculty
Instructors Details
The programme is designed to be led by instructors with practical knowledge of Power Query, data connectivity, Power Query Editor, data cleaning, transformation workflows, Append and Merge, Power Apps, Canvas Apps, Excel, SharePoint, forms, galleries, controls, validation rules and practical business workflow integration.
What's Included
Certificates & Inclusions
- Certificate and inclusions to be confirmed as per programme format.
- Practical learning on Power Query and Power Apps.
- Hands-on data cleaning, transformation and consolidation practice.
- Canvas App creation using templates and blank layouts.
- Practice on data-entry, approval and tracking applications.
Registration
Reserve Your Seat
Need assistance? Our programme advisors are here to help.
Get in TouchNeed Assistance?
Talk to a Programme Advisor
Have questions about your specific industry, or want to enquire about group discounts? Reach out to our programme coordinators directly.
Or register by e-mail
register@princetonacademy.co.inFor Teams
Corporate In-House Training
Have a large HR and Finance team? Standardize your compliance across all locations by training your entire team at once.
Request a Custom In-House ProposalSchedule
Upcoming Power Query & Power Apps Sessions
20261119
Online
Questions
Frequently Asked Questions
The programme focuses on Power Query for data connectivity, cleaning, transformation and consolidation, along with Power Apps for building practical workplace applications.
Yes. Participants learn Power Query business applications, connecting data from Excel, CSV, folders and common sources, navigating the Power Query Editor, queries, applied steps and data types.
Yes. The programme covers cleaning inconsistent, incomplete and duplicate data, splitting, merging and formatting columns, and combining multiple files using Append and Merge.
Yes. Participants learn Power Apps workplace use cases, Canvas App creation, connecting apps with Excel, SharePoint and other data sources, and designing screens, forms, galleries and navigation.
Yes. The programme covers formulas, controls, validation rules, data-entry applications, approval applications, tracking applications, testing, publishing and sharing an application.
