Bütün Rapor Süreçlerinizi Otomatize Edin (Excel Power Query)
Master data analysis with Power Query, ETL, and Excel. Learn to extract data from web, PDFs, and databases for powerful reporting and project insights.
Course Content
Bütün Rapor Süreçlerinizi Otomatize Edin (Excel Power Query) is an all-levels Udemy course taught by Salih HOCAOĞLU. It runs 7h 11m, is taught in Turkish, and includes a certificate of completion. Learners rate it 4.7 out of 5 from 247 reviews, with 1,529 students enrolled. It is a paid course, first published January 2022.
Excel Power Query: Automate Your Data Reporting & Analysis
Are you tired of repetitive data reporting tasks in Excel? Do you spend countless hours manually compiling data from various sources? Excel Power Query is your solution! This comprehensive course empowers you to automate your data workflows, saving you time and reducing errors.
This course is perfect for:
- Anyone who regularly works with data in Excel.
- Users who need to consolidate data from multiple sources.
- Those seeking to automate reporting processes.
- Individuals looking to improve data accuracy and efficiency.
What you'll learn:
This in-depth course covers Power Query from beginner to advanced levels, enabling you to:
- Extract Data: Connect to and retrieve data from a wide variety of sources, including:
- Excel files (multiple files)
- CSV files
- Text files
- Databases (Access)
- PDF files
- Websites (including real-time data like exchange rates and COVID-19 case counts)
- Folders
- Transform Data: Clean, reshape, and enrich your data with powerful transformation tools:
- Table Manipulation: Grouping, sorting, reversing rows, and more.
- Column Operations: Renaming, data type conversion, filling, summarizing, and extracting specific parts of text.
- Data Cleaning: Removing duplicates, handling errors, and standardizing data.
- Calculations: Performing arithmetic, scientific, trigonometric, and statistical calculations.
- Date & Time Manipulation: Transforming and extracting data from date and time columns.
- Adding Custom Columns: Creating new columns based on formulas, conditional logic, and external data.
- Load Data: Import your transformed data into Excel in various formats:
- Tables
- Pivot Tables
- Pivot Charts
- Connections (without loading data)
- Master the M Formula Language: Understand and utilize the M formula language for advanced data manipulation and automation.
- Automate Reporting: Create fully automated data pipelines to generate reports with minimal manual intervention.
Course Curriculum:
- Module 1: Power Query Fundamentals
- Introduction to Power Query & its benefits
- Understanding the ETL (Extract, Transform, Load) process
- Extracting data from various sources (Excel, CSV, Text, Databases, PDF, Web)
- Module 2: Power Query Editor Interface
- Navigating the Power Query Editor
- Understanding the Ribbon and its features
- Module 3: Extract Data – Source Specific Techniques
- Detailed guides on extracting data from Excel, CSV, Text, Databases (Access), PDF, Web (Exchange Rates, COVID-19 Data)
- Module 4: Transform Data – Column & Table Manipulation
- Grouping, sorting, reversing rows
- Renaming columns, changing data types
- Filling, summarizing, extracting text
- Module 5: Transform Data – Advanced Data Cleaning & Enrichment
- Conditional column creation
- Adding custom columns with formulas
- Data type conversions (text, number, date/time)
- Splitting and merging columns
- Module 6: Transform Data – Calculations & Data Shaping
- Arithmetic, scientific, trigonometric, and statistical calculations
- Date and time manipulation
- Expanding and filtering data
- Module 7: Load Data – Importing into Excel
- Loading data as tables, pivot tables, and pivot charts
- Creating data connections
- Module 8: M Formula Language
- Introduction to the M language
- Basic M functions and components
- Creating custom functions
- Module 9: Projects – Real-World Applications
- Automating data extraction and integration from multiple sources.
- Creating dynamic dashboards with real-time data.
- Building automated data pipelines for efficient reporting.
Start automating your data workflows today! Enroll now and unlock the power of Excel Power Query.
Need a web app built? Hire the team behind TutorialSearch.io
We ship fast, production-grade full-stack apps (Next.js, React, edge infra) — the same stack that powers this site.