Microsoft Excel - Power Query
Learn Power Query: Access and transform data from various sources. Master data extraction and preparation for analysis.
Course Content
Microsoft Excel - Power Query is an advanced Udemy course taught by Osvaldo Carpina. It runs 4h 47m, is taught in Italian, and includes a certificate of completion. Learners rate it 5.0 out of 5 from 2 reviews, with 12 students enrolled. It is a paid course, first published August 2025.
Power Query for Excel: Master Data Transformation & Analysis
Unlock the power of data with this comprehensive Power Query course for Microsoft Excel! Excel is a fundamental skill for modern businesses, and mastering its capabilities gives you a significant advantage. From budget creation and price list management to production control and deadline tracking, Excel is essential for a wide range of business operations. Even for personal use, Excel helps manage finances, organize schedules, and create presentations.
This course focuses on working with data inside and outside of Excel. Learn to connect to and transform data from various sources, including:
- Excel Tables: Efficiently manage and manipulate data within Excel.
- Text Files: Import and clean data from plain text files.
- CSV Files: Work with comma-separated value files, a common data format.
- PDF Files: Extract data automatically from PDF documents.
- Databases (Access, SQL & more): Connect to and retrieve data from various database systems.
Important Note: Some features require Excel versions higher than 2010, with Office 365 being recommended. Please ensure you have a compatible version before purchasing to fully utilize the course content and practice the new functionalities.
What you'll learn:
- Power Query Fundamentals: Build unique lists from diverse data sources.
- Alternative to "Text to Columns": Learn a powerful Power Query approach to data parsing.
- Data Merging & Appending: Combine data from multiple queries or files.
- UNPIVOT Function: Master the UNPIVOT function for reshaping data.
- Consolidating Excel Sheets: Create a single, comprehensive summary sheet from multiple Excel files.
- Custom Functions with M Language: Develop personalized functions to enhance your data manipulation capabilities.
- Data Extraction from PDFs: Automate data retrieval from PDF documents.
This course provides practical exercises to help you access, reshape, and automatically update tables from various file types. Boost your data analysis skills and become a Power Query expert!
Want AI in your product? Hire the team behind TutorialSearch.io
LLM features, RAG, agents and automation wired into a real product — built by the devs who shipped this site.