Одну секунду
Что-то сучилось. Попробуйте еще раз.
Power Query смотреть последние обновления за сегодня на .
In this step-by-step tutorial, learn how you can use Microsoft Power Query to get and clean up data in both Microsoft Excel and Microsoft Power BI. Power Query is the easiest way to connect, extract, transform and load data from a wide range of sources. 👋 Additional resources: - Sample files: 🤍 - Download Power Query for Excel 2010 or 2013: 🤍 ⌚ Timestamps 00:00 Introduction 00:59 Sample data 2:14 How to get Power Query 2:31 Get data 3:35 Combine data 5:26 Main Power Query interface 7:00 Transform data 11:21 Applied steps 12:06 Close & Load 12:33 Data imported into Excel 13:34 Insert pivot table & chart 14:46 Importing additional data 16:00 Wrap up 📃 Watch related playlists and videos - Pivot Table tutorial: 🤍 - Excel: 🤍 - Power BI: 🤍 🚩 Connect with me on social: - LinkedIn: 🤍 - Twitter: 🤍 - Facebook: 🤍 🔔 Subscribe to my YouTube channel 🤍 🎬 Want to watch again? Navigate back to my YouTube channel quickly 🤍 🛍 Support me with your Amazon purchases: 🤍 ⚖ As full disclosure, I use affiliate links above. Purchasing through these links gives me a small commission to support videos on this channel the price to you is the same.
Join 300,000+ professionals in our courses: 🤍 Power Query is like an Instant Miracle Cure to your difficult data analysis problems. ★ Get the Official XelPlus MERCH: 🤍 Here's the problem... Excel Power Query has been a part of Excel since Excel 2016! It's in the Data tab under Get and Transform. Unfortunately many people haven't explored what it has to offer! They continue doing things the old "manual" way, Or the "complex" way with difficult formulas. And something else you may not know ... Generally, when you learn something, the more effort you put in, the more you get out. But it's NOT the same with learning Power Query! If you just put in a little effort, you get SO much in return! This is the difference with learning Power Query to learning other skills like VBA. And that’s why I created this course! To give you the tools to really make a difference at your workplace. I’m going to take you from Power Query Beginner to Pro! Check out the full article: 🤍 ★ My Online Excel Courses ► 🤍 ✉ Not sure which of my Excel courses fits best for you? Take the quiz: 🤍 EXCEL RESOURCES I Recommend: 🤍 GEAR I use: 🤍 More resources on my Amazon page: 🤍 Let’s connect on social: Instagram: 🤍 Twitter: 🤍 LinkedIn: 🤍 Note: This description contains affiliate links, which means at no additional cost to you, we will receive a small commission if you make a purchase using the links. This helps support the channel and allows us to continue to make videos like this. Thank you for your support! #MsExcel #powerquery
ℹ Extra informatie 🤍 ⏱ Onderdelen in de video 00:00 Introductie 01:04 Power Query locatie 01:31 Data opties 02:32 Inladen gegevens 04:08 Power Query rondleiding 05:15 Gegevens transformeren 11:17 BELANGRIJK 11:43 Gegevens transformeren 12:32 Stappen bijhouden 14:11 Inladen Power Query 15:35 Draaitabel 17:06 Nieuwe dataset toevoegen 20:50 Voordeel Power Query 22:00 Outro 🎬 Bekijk een gerelateerde video's of playlists - Playlist met al mijn video's over Excel:🤍 - Deel 1 starten met Excel: 🤍 - Deel 2 Formules en functies: 🤍 - Deel 3 Draaitabellen: 🤍 - Deel 5 Power Query 1: 🤍 - Deel 6 Power Query 2: 📚 Oefen documenten en informatie 🤍 💻Volg mij op Social Media - LinkedIn: 🤍 - YouTube community: 🤍 💌 Abonneer je gratis op mijn YouTube kanaal of wordt lid voor slechts €3,99 per maand en ervaar vele voordelen zoals extra video's, webinars en meer. #OnlineTechTips 🤍onlinetechtips.nl
Power Query can automate the boring and laborious tasks of getting and cleaning data, reducing time spent on these tasks down to the click of a button! 🔻 DOWNLOAD files for this lesson here: 🤍 🎓 LEARN MORE Power Query here: 🤍 Or view my comprehensive courses: 🤍 🔔 SUBSCRIBE if you’d like more tips and tutorials like this. 💬 Please leave me a COMMENT. I read them all! 🧟♀️ CONNECT with Mynda on LinkedIn: 🤍 🎁 SHARE this video and spread the Excel love. Or if you’re short of time, please click the 👍 💬 EXCEL QUESTIONS: Get help on our Excel Forum: 🤍 POWER QUERY ADD-IN Excel 2010 & 2013 users download the free Power Query add-in here: 🤍 ⏲ TIMESTAMPS 0:00 Introduction 0:27 Where to find Power Query 1:14 Why should you use Power Query 3:44 Power Query example - get files from a folder 6:04 Power Query Editor - cleaning the data 13:37 Close & Load Options 14:27 Building PivotTables from Power Query data 15:37 Updating with new data with one click!
In this video, we will learn about some best practices that can help us to be more efficient & smart working on Power Query! Additionally Helpful Video Links: 🤍 🤍 Join this channel to get access to perks: 🤍 = ONLINE COURSES = ✔️ Mastering DAX in Power BI - 🤍 ✔️ Power Query Course- 🤍 ✔️ Master Excel Step by Step- 🤍 ✔️ Business Intelligence Dashboards- 🤍 = LINKS 🔗 = Blog 📰 - 🤍 Corporate Training 👨🏫 - 🤍 Need my help on a Project 💻- 🤍 Download File ⬇️ - 🤍 = CONTACT 🌐 = Twitter - 🤍 LinkedIn - 🤍 Email - goodly.wordpress🤍gmail.com = WHO AM I? = A lot of people think that my name is Goodly, it's NOT ;) My name is Chandeep. Goodly is my full-time venture where I share what I learn about Excel and Power BI. Please browse around, you'd find a ton of interesting videos that I have created :) Cheers!
✅Download the demo files and follow along here ➡️🤍 In this Power Query tutorial, we introduce you to Power Query, get you familiar with the Power Query Editor, teach you how to import multiple files and data sources into Power Query, how to combine data, merge queries and so much more. Power Query in Excel can open up a world of data analyzing possibilities. In this Power Query course, we assume that you are an intermediate to advanced Excel user, but that you haven't used Power Query in Excel before. This Power Query tutorial was put together using videos from our full, Power Query, Power Pivot & DAX course ➡️ 🤍 ✅Become a Simon Sez IT Member to get access to the full course ➡️🤍 ✅Try Simon Sez IT for free, and get your hands on 4, introductory courses here ➡️ 🤍 📝Tutorial Markers: 0:00:00 - Welcome and Overview 0:03:09 - What is Power Query 0:08:34 - What is Power Pivot 0:12:17 - Exploring the Power Query Editor 0:18:47 - Common Power Query Transformations 0:27:46 - Editing an Existing Query 0:37:42 - Import Multiple Files from a Folder 0:48:48 - Connect to Data in Another Excel Workbook 0:58:26 - Checking the Location of your Query's Source 1:02:00 - Unpivoting Columns 1:07:33 - Combine Data from Multiple Tables with Merge Queries 1:13:44 - Use Merge Queries to Compare Two Tables 1:18:48 - Stack Data into One Table with Append Queries 1:24:51 - Duplicating and Referencing Queries 1:34:01 - Grouping and Aggregating Data 1:41:54 - Conditional Columns in Power Query 💻Watch more free popular training tutorials from Simon Sez IT: ✅Check out our FREE 300+ hour training course playlist here 👉 🤍 ✅Data Visualization playlist here 👉🤍 ✅Excel 2021 Tutorials for Beginners playlist 👉🤍 ✅Power BI Tutorials for Beginners. Master Power BI! playlist 👉🤍 ✅Alteryx for Beginners playlist 👉🤍 💬Stay in touch! ✅SimonSezIT.com: 👉🤍 ✅StreamSkill.com: 👉🤍 ✅YouTube Channel: 👉🤍 ✅LinkedIn: 👉🤍 🔔Subscribe to our channel: 🤍 If you enjoyed the video, please give a "thumbs up" and subscribe to the channel 👍🏽 ;-)
Power Query (Get & Transform data in Excel) is a true game changer 💥. It can simplify and automate various data activities. In this in-depth video tutorial, learn all about this powerful time-saving technology. You will learn: * What is Power Query and how to launch it from Excel or Power BI? * How to connect and load data from any type of sources - excel files, CSVs, text files, web pages, PDF, folders etc. * How to perform common data cleansing activities with Power Query * Adding columns using rules * Automating data collection, clean-up and publishing processes with Power Query * Web scraping with Power Query * SQL style Joins, merges, appends and unions with Power Query * Consolidating data in a folder * Data load, save & publish process * Tips & tricks on using Power Query efficiently For sample datasets, completed workbook and mind-map PDF, visit: = 🤍 Timestamps: 0:00 - Introduction to Power Query 3:34 - Power Query as a mind-map 24:10 - Example 1 - Employee data load, clean-up and analysis 47:09 - Example 2 - Web scraping with Power Query 58:48 - Example 3 - Consolidating a folder of files with Power Query 1:09:08 - Example 4 - Merging, joining and appending datasets with Power Query 1:22:43 - Closing remarks - how to learn more, books & website recommendations Recommended book: Combine, collect & transform data with Power Query by Gil Raviv - 🤍 Recommended course: Excel School program - data cleansing, analysis and visualization course by Chandoo - 🤍 #PowerQuery #Excel #PowerBI
Many people are confused about the difference between Power Query and Power Pivot. In this video I demystify the differences so you know how these amazing tools can help you. Versions of Excel supporting Power Query: 🤍 Versions of Excel supporting Power Pivot: 🤍 🎓 LEARN MORE in my courses: Power Query Course: 🤍 Power Pivot Course: 🤍 Power BI Course: 🤍 🔔 SUBSCRIBE if you’d like more tips and tutorials like this. 💬 Please leave me a COMMENT. I read them all! 🧟♀️ CONNECT with Mynda on LinkedIn: 🤍 🎁 SHARE this video and spread the Excel love. Or if you’re short of time, please click the 👍 💬 EXCEL QUESTIONS: Get help on our Excel Forum: 🤍
Join this channel to get access to perks: 🤍 Download Files - 🤍 = ONLINE COURSES = ✔️ Mastering DAX in Power BI - 🤍 ✔️ Power Query Course- 🤍 ✔️ Master Excel Step by Step- 🤍 ✔️ Business Intelligence Dashboards- 🤍 = LINKS 🔗 = Blog 📰 - 🤍 Corporate Training 👨🏫 - 🤍 Need my help on a Project 💻- 🤍 = CONTACT 🌐 = Twitter - 🤍 LinkedIn - 🤍 Email - goodly.wordpress🤍gmail.com = WHO AM I? = A lot of people think that my name is Goodly, it's NOT ;) My name is Chandeep. Goodly is my full-time venture where I share what I learn about Excel and Power BI. Please browse around, you'd find a ton of interesting videos that I have created :) Cheers!
In this Power Pivot and Power Query tutorial from Simon Sez IT, Excel expert, Deb Ashby, teaches you how to get started with the Power Pivot and Power Query tools in Excel. ✅Download the Excel file we use in this Power Pivot tutorial here: ➡️🤍 🔥Sign up for our full Power Pivot, Power Query, and DAX course here 👉🤍 In this Advanced Microsoft Excel tutorial, she looks at the following: - Pivot Tables - a quick reminder ;-) - Importing data into Excel from multiple sources - Cleaning data using Power Query - Creating a Power Pivot table - Creating relationships using Power Pivot - Using Measure and KPIs in Power Pivot - Displaying data in a Pivot Chart If you are new to Power Pivot in Excel or Power Query in Excel, this tutorial is a great place to start. 🌍 Get unlimited training with Simon Sez IT’s 150+ courses ⏩ 🤍 🚀 Level up your skills with a free 30-day trial to our complete training library of 8,500+ videos ⏩ 🤍 💻 Watch more free popular training tutorials from Simon Sez IT: 🔥Check out our FREE 300+ hour training course playlist here ➡️ 🤍 ✅ Check out our free video playlist for Excel beginners 👉🤍 ✅ Excel 2021 Tutorials for Intermediate Users here 👉🤍 ✅ Microsoft Excel Tips and Tricks 👉🤍 ✅ Microsoft Office 2021 and Office 365 Training here 👉🤍 💬Stay in touch! SimonSezIT.com: 🤍 LinkedIn: 🤍 FaceBook: 🤍 🔔 Subscribe to our channel: 🤍 If you enjoyed the video, please give a thumbs up 👍🏽 ;-)
Learn the basics of data transformation and how Power Query can help you solve your data transformation problems. Take the complete Power Query Course by CFI: 🤍
Advanced Excel Power Query - Introduction This is an introduction video to Power Query helping you to understand why you should switch to Power Query and what are the benefits Watch more Videos at 🤍 Lecture By: Mr.Pavan Lalwani, Tutorials Point India Private Limited To download tutorix app - 🤍 To buy full Course, please follow the links given below:- For Advance Excel - 🤍 For Excel - 🤍 For Tableau - 🤍
Sign up for our Excel webinar, times added weekly: 🤍 Learn how to use Power Query, which is a data automation tool that allows us to import, transform, and cleanse data in Excel or Power BI. In the video I share an overview of the Power Query workflow and then go into a hands on demo. You will learn how to combine multiple CSV files, clean up the data, and automate the entire process for when you get new/updated data. This video is an introduction for beginners. If you have tried to use Power Query, but are confused by the process or user interface, then this training is for you. Power Query is a tool that can save you a ton of time with your work by automating common data processes like: ✔ Remove columns, rows, blanks ✔ Convert data types - text, numbers, dates ✔ Split or merge columns ✔ Sort & filter columns ✔ Add calculated columns ✔ Aggregate or summarize data ✔ Find & replace text ✔ Unpivot data to use for pivot tables ✔ Merge (join) data tables together ✔ Combine (append) data tables, sheets, and workbooks Free Webinar on The Modern Exvel Blueprint: 🤍 Additional Resources: Read the companion article on an Overview of Power Query: 🤍 Complete Guide to Installing Power Query: 🤍 How to Unpivot Data with Power Query: 🤍 How to Fix Date Errors in Power Query: 🤍 00:00 Introduction 02:43 Demo 11:01 Updating and Refreshing
البور كويري هي إضافة مجانية تأتي مع الإكسل تساعدك بشكل كبير في عمل التقارير وتحليل البيانات، متوفرة في نسخة اكسل 2016 و مابعدها و بالتأكيد متوفرة لمشتركي اكسل 365 في هذا الفيديو ستعرف المزيد عنها لينكات الفيديوهات المذكورة في هذا الفيديو 🔖ما هو قانون باريتو؟ وما علاقته في زيادة الانتاجية؟ 🤍 🔖مثال على تحويل البيانات Data Transformation في الـبور كويري Power Query في الإكسل 🤍 🔖تجميع البيانات من مجموعة ملفات منفصلة في الاكسل بشكل آلي و عمل تقارير عليها باستخدام ال Power Query 🤍 اتمنى لكم دائما و ابدأ المتعة و الفائدة 🌍 زوروا موقع اشرح للتعليم الالكتروني 🤍 نشكر كل من احب دعمنا، نفضل الدعم من خلال شراء دوراتنا للاستفادة منها و من احب ان يدعمنا على باي بال فاليكم اللينك: PayPal: 🤍 ✉ اكرم العبوة Akram Abwa akram🤍eshra7.com ✋ تابعونا على مواقع التواصل الاجتماعي 😀 Facebook: 🤍 LinkedIn: 🤍 Twitter: 🤍 لا تنسونا من صالح دعائكم * كلمات مفتاحية : #Eshra7 #Akram_Abwa #Excel_Power_Query *
= LIVE TRAINING = Register Here ➜ 🤍 = ONLINE COURSES = ✔️ Mastering DAX in Power BI - 🤍 ✔️ Power Query Course- 🤍 ✔️ Master Excel Step by Step- 🤍 ✔️ Business Intelligence Dashboards- 🤍 = LINKS 🔗 = Blog 📰 - 🤍 Corporate Training 👨🏫 - 🤍 Need my help on a Project 💻- 🤍 = CONTACT 🌐 = Twitter - 🤍 LinkedIn - 🤍 Email - goodly.wordpress🤍gmail.com = CHAPTERS = 0:00 Intro 0:19 Live Training 1:22 Group By - Concatenate values of a List 8:55 Group By - Find a Max Value Year 13:33 Live Training = WHO AM I? = A lot of people think that my name is Goodly, it's NOT ;) My name is Chandeep. Goodly is my full-time venture where I share what I learn about Excel and Power BI. Please browse around, you'd find a ton of interesting videos that I have created :) Cheers! - - - - - Music By: "After The Fall" Track Name: "Tears Of Gaia" Published by: Chill Out Records - Source: 🤍 Official After The Fall YouTube Channel Below 🤍 License: Creative Commons Attribution-ShareAlike 4.0 International (CC BY-SA 4.0) Full license here: 🤍
0:00 Intro - 3:27 PQB01: Introduction "Get & Transform" Automate Data Transformation To download excel workbook: 🤍 - 17:04 PQB02: Extract data from current workbook, and create dynamic unique list To download excel workbook: Start: ttps://docs.google.com/spreadsheets/d/1G1dA8JJxVWUCDiQutMX53MSWn1Y4HFpe/edit?usp=sharing&ouid=110580770751308536617&rtpof=true&sd=true Finish: 🤍 - 29:47 PQB03:Extract from excel workbook & consolidate multiple worksheets in 1 pivot table Excel file: 🤍 Data file: 🤍 - 42:28 PQB04:Extract data from a folder contains “CSV files” automatically update new data Excel file: 🤍 CSV files: 🤍 🤍 🤍 - 58:41 PQB05: Extract data from Access Database and load to excel data model Excel file: 🤍 Access database: 🤍 - 1:19:35 PQB05.5: Power Query in Power BI. from access database to an interactive dashboard Access database: 🤍 Power BI file: 🤍 - 1:46:45 PQB06: Connect to the web with power Query Excel file: 🤍 - 1:58:05 PQB07: Split Column to Rows - Automate & Organize Chaotic Input Data Excel file: 🤍 - 2:12:05 PQB08: Append data from 3 different Tables Excel file: 🤍 - 2:26:07 PQB09: Merge Queries: V-lookup in Power Query CSV: 🤍 Excel: 🤍 2:40:28 PQB10: Merge Queries: Compare between 2 tables Excel file: 🤍 2:58:00 PQB11: Merge Queries: Left Outer - Solve duplicate issues Excel file: 🤍 - 3:10:10 PQB12: Merge Queries: Replace Sum-if Excel file: 🤍 - 3:20:01 PQB13: Merge Queries: 2D search using Formulas (V-lookup + Match) & Power Query Excel file: 🤍 - 3:40:44 PQB14: Excel.CurrentWorkbook() to extract data & “Group by” to Summarize data Start file: 🤍 End file: 🤍 Additional data: 🤍 - 4:06:20 PQB15: Dynamic Filter with PQ, criteria input from excel & customized refresh button Working files: 🤍 - 4:30:49 PQB16: Manage Queries: Duplicate, Reference or Append Working files: 🤍 - To subscribe: 🤍
Download Zipped Folder with All Files: 🤍 This video is a comprehensive lesson in Power Query M Code in Excel & Power BI. This full free Microsoft 365 Excel & Power BI class is taught by Excel MVP and Highline College Professor and can be found here: 🤍 This video covers. 1. (00:00) Introduction 2. (00:26) Define M Code 3. (03:05) Power Query and M Code are in Both Excel and Power BI Desktop 4. (05:08) Advanced Editor button in Excel & Power BI Desktop 5. (05:39) Power BI Desktop “Enable Load” 6. (06:22) M Code Basics, tour of Power Query Editor and the three locations to view and change M Code. We use a Group By Query to learn about the basics of M Code. 7. (10:23) M Code Identifiers and spaces. 8. (14:21) let expression definition and structure. 9. (16:32) Expressions 10. (18:20) Insert or Delete Query (let expression) Steps: 2 possibilities. 11. (24:45) #shared to show Standard Library in Power Query 12. (26:32) Learn about 15 M Code Values: Null, Logical, Text, Number, Time, Date, DateTime, DateTimeZone, Duration, Table, Record, List, Binary, Function, Type 13. (33:15) IF function and AND Function in M Code 14. (36:23) Compare Excel Close & Load to Power BI Desktop Close & Apply 15. (38:45) Copy and Paste Tables into Power BI Desktop. 16. (39:35) Power Query Date and Duration Examples 17. (46:32) Table Values 18. (51:08) Record Values 19. (53:37) List Values 20. (59:05) Binary, Function and Type M Code Values 21. (59:40) Data Types 22. (59:40) Values Vs. Data Types 23. (01:01:38) M Code Lookup: Two-way Lookup, Column Lookup, Row (or Record) lookup. Also know as: Projection (lookup column) and Selection (lookup row) 24. (01:03:19) Diagrams for M Code Lookup 25. (01:06:04) Row Index Lookup 26. (01:07:15) Key Match Lookup 27. (01:08:55) Drill Down, Primary Keys and Lookup 28. (01:13:33) Custom Functions (5 examples to learn basics) 29. (01:17:50) Build reusable function. 30. (01:22:08) Build Custom Function as a Query Step. 31. (01:27:04) each and Underscore. 32. (01:29:47) Approximate Match Lookup M Code Custom Function (4 examples) 33. (01:39:13) Full Video Summary and Conclusions 34. (01:40:32) Closing and Video Links Song in video: Rock Intro 3 by Audionautix is licensed under a Creative Commons Attribution 4.0 license. 🤍 . Artist: 🤍 #Girvin #excelisfun #M365 #MECS #Microsoft #MCode #PowerQuery #PowerBI #DataMashup #LearnMCode #FreeMCodeClass #LearnMCodeFast #MCodeMadeEasy #MCodeLanguage #CustomFunctions #MCodeCustomFunctions #PowerQueryLookup #MCodeLookup #MCodeSpecifications #datascience #PowerQueryMCode #DataAnalysis #MicrosoftDataAnalytics #PowerQueryMCode #PowerBIMCode #McodeAndDAX #datacleaning #datatransformation #ETL #advancedexcel #mcode #powerbi #excel #businessintelligence #businessanalystcourse #mcodetutorial #mlanguage #mlanguagetutorial #powerbitutorial #powerquerytutorial
This intermediate Microsoft Excel tutorial focuses on learning Power Query. In this step-by-step Excel Power Query tutorial, we'll show you how to use Microsoft Excel's powerful data transformation tool. Power Query can help you quickly clean, consolidate, and analyze data from multiple sources. If you're new to Power Query, this tutorial is perfect for you. We'll start with an introduction to the Power Query interface and walk you through connecting to various data sources such as Excel files, text files, and databases. We'll then demonstrate how to use Power Query's features, such as merging, filtering, and pivoting, to transform and refine your data. This tutorial provides easy-to-follow instructions, so you can practice using Power Query along with us. By the end of this video, you'll have a solid understanding of Power Query and how to use it to streamline your data analysis. Watch this Excel Power Query tutorial for beginners and start taking your data analysis to the next level. Don't forget to hit the like button and subscribe to our channel for more Excel tutorials! Power Query Practice File: 🤍 0:00 Introduction to Power Query in Excel 0:45 What is Power Query? 2:34 Where do you find Power Query? 3:05 How to import data from the web with Power Query 8:40 How to import data from a range or table in Power Query 9:50 Power Query Editor layout 14:25 Make changes to your headers 16:42 Examining the applied steps 17:06 How to convert data types in the Power Query Editor 18:36 Remove unwanted rows (filtering) 20:39 How to split columns in Power Query 22:45 Create a new column 24:33 Create a new column to find a value 28:33 Rounding and moving column 29:39 How to merge queries and join tables in Power Query 34:21 Add new data, then refresh your query Intermediate Excel Lesson 1: 🤍 Learn how to use Power Query in Power BI: 🤍
Have you come across Value.Is ? You can you use to replicate the Excel function IF ( ISNUMBER Did you know we run training in Perth, Australia and surrounding regions? 🤍 Did you know I've written a beginners guide to Power BI "Power BI for the Excel Analyst"? 🤍 Connect with me 🤍 🤍
Μάθετε να χρησιμοποιείτε το power query και να δημιουργείτε αναφορές δεδομένων γρήγορα και άμεσα! και πραγματικά λύστε τα χέρια σας!. Σε αυτό το βίντεο, χρησιμοποιούμε έναν φάκελο που περιέχει αρχεία-αναφορές τις οποίες ενώνουμε σε ένα κεντρικό αρχείο που θέλουμε να διαχειριζόμαστε. Εργασίες που μέχρι τώρα παίρνουν πολύ χρόνο, είναι εφικτό να τελειώνουν σε λίγα λεπτά! Αν έχετε απορίες αφήστε ένα σχόλιο! Στηρίξτε το κανάλι μας, κάνοντας εγγραφή Facebook: 🤍 URL: 🤍
Join 300,000+ professionals in our courses: 🤍 Prepare to be amazed! This is the easiest way to combine multiple Excel files from a folder into one Workbook and create a table or a a pivot table report based on the consolidated data. ★ My Online Excel Courses ► 🤍 00:00 Consolidate Data from Multiple Excel Files 01:28 Get & Transform Data From Multiple Files in a Folder 02:37 Merge and Append Data in Power Query 05:55 Clean Data in Power Query 07:10 Load Data as PivotTable to Excel 09:21 Load Data as Table to Excel 09:53 Wrap Up Many of us send out templates to colleagues and are later faced with the challenge to somehow consolidate multiple Excel files. To append the data into a single Excel workbook can be quite a troublesome and lengthy process. Sure, a solution for this has always been Excel VBA. But learning VBA takes time and it can be too difficult for a lot Excel users. In this tutorial, I'll show you a much easier approach! We'll use Excel Get and Transform aka Power Query to combine data from multiple Excel workbooks. We will directly connect to a folder that contains the files and use the feature Combine Files in Power Query. Any time you drop an Excel file in that folder, the data will be appended and consolidated with the rest. You can then create one Excel table for the appended data or create a pivot table from the multiple Excel files. The best part about using Power Query to merge data from Excel files is that you don't need to write any code! You just need to click a few buttons to append the data from the files. Read the article: 🤍 Power Query Playlist: 🤍 ✉ Not sure which of my Excel courses fits best for you? Take the quiz: 🤍 EXCEL RESOURCES I Recommend: 🤍 Get Office 365: 🤍 Microsoft Surface: 🤍 GEAR Screen recorder: 🤍 Main Camera: 🤍 Backup Camera: 🤍 Main Lens: 🤍 Zoom Lens: 🤍 Audio Recorder: 🤍 Microphone: 🤍 Lights: 🤍 More resources on my Amazon page: 🤍 Let’s connect on social: Instagram: 🤍 Twitter: 🤍 LinkedIn: 🤍 Note: This description contains affiliate links, which means at no additional cost to you, we will receive a small commission if you make a purchase using the links. This helps support the channel and allows us to continue to make videos like this. Thank you for your support! #MsExcel
تجميع عدة ملفات في ملف واحد بطريقة Combine Data بالبور كويري Combine Data using Power Query تحميل ملفات العمل: 🤍 = التسلسل الزمني للشرح: 00:00 مقدمة 01:09 تجميع الملفات 04:34 تحديث الملف بعد تعديل البيانات 05:25 إضافة ملفات للمجلد وتحديثها على الملف 06:27 مشكلة العناوين ليست في الصف الأول للبيانات 07:27 حل مشكلة أن العناوين ليست في الصف الأول 10:38 مشكلة وجود ملفات مختلفة داخل المجلد 11:43 حل مشكلة وجود ملفات مختلفة داخل المجلد 13:33 الخلاصة النهائية = تابعونا على موقعنا الإلكتروني 🤍BePro.training وتابعونا أيضاً على مواقع التواصل الاجتماعي: فيس بوك: 🤍 تويتر: 🤍 لنكد ان: 🤍 ـ+ــ+ــ+ــ+ــ+ــ+ــ+ــ+ــ+ــ+ــ+ صفحة كن محترفاَ - BePro: 🤍 تلغرام: 🤍 تويتر: 🤍
How can you create a date table with monthly intervals? This technique achieves it with ease. WRITTEN ARTICLE 🤍 ABOUT BI Gorilla: BI Gorilla shares videos and articles on Power BI and Excel to help you improve your skills. Website: 🤍 SUBSCRIBE TO MY CHANNEL 🤍 LET'S CONNECT: Blog: 🤍 Facebook: 🤍 Twitter: 🤍 LinkedIn: 🤍 Thank you for your support! #DateTable #powerquery #bigorilla
Знакомство с надстройкой Excel Power Query (в Excel 2016 Получить и преобразовать данные): загрузка данных, интерфейс редактора запросов, обработка, выгрузка, обновление. Файл с примером и другие уроки о Power Query по ссылке 🤍 ► Корпоративный тренинг "Продвинутый уровень MS Excel": 🤍 ► Онлайн курс "Продвинутый уровень MS Excel": 🤍 💳 Поддержать канал деньгами 🤍 * Мой сайт об Excel и статистике * 🤍 * Странички и аккаунты в соцсетях * Facebook: 🤍 Вконтакте: 🤍 Твиттер: 🤍 Telegram: 🤍
In this step-by-step tutorial, learn how to use Power Pivot in Microsoft Excel. Power Pivot is a data modeling technology that lets you create data models, establish relationships, and create calculations. With Power Pivot you can work with large data sets, build extensive relationships, and create complex (or simple) calculations, all in a high-performance environment, and all within the familiar experience of Excel. 👋 Additional resources: - Sample files to follow along: 🤍 - In-depth Pivot Table tutorial: 🤍 - Learn the fundamentals of Excel in just 2 hours: 🤍 ⌚ Timestamps 0:00 Introduction 1:23 Enable Power Pivot add-in 3:05 Sample files overview 4:06 Create data model 8:55 Define relationships 12:13 Calculations 16:02 Measures 21:24 Insert PivotTable from data model 24:49 Key Performance Indicators (KPIs) 27:06 Insert PivotChart 28:16 Slicers 29:34 Wrap up 📃 Watch related playlists and videos - Playlist with all my videos on Excel: 🤍 🚩 Connect with me on social: - LinkedIn: 🤍 - Discord: 🤍 - Twitter: 🤍 - Facebook: 🤍 - TikTok: 🤍 - Instagram: 🤍 🔔 Subscribe to my YouTube channel 🤍 🎬 Want to watch again? Navigate back to my YouTube channel quickly 🤍 🛍 Support me with your Amazon purchases: 🤍 ⚖ As full disclosure, I use affiliate links above. Purchasing through these links gives me a small commission to support videos on this channel the price to you is the same. #stratvert
In this series we will be walking through the basics of Microsoft Power BI. In this video we will be walking through how to use the Power Query Editor in Power BI. Download Microsoft Power BI: 🤍 Download Apocalypse Dataset: 🤍 Favorite Power BI Courses: Power BI for Business Intelligence - 🤍 Power BI A-Z - 🤍 SUBSCRIBE! Do you want to become a Data Analyst? That's what this channel is all about! My goal is to help you learn everything you need in order to start your career or even switch your career into Data Analytics. Be sure to subscribe to not miss out on any content! RESOURCES: Coursera Courses: 📖Google Data Analyst Certification: 🤍 📖Data Analysis with Python - 🤍 📖IBM Data Analysis Specialization - 🤍 📖Tableau Data Visualization - 🤍 Udemy Courses: 📖Python for Data Analysis and Visualization- 🤍 📖Statistics for Data Science - 🤍 📖SQL for Data Analysts (SSMS) - 🤍 📖Tableau A-Z - 🤍 *Please note I may earn a small commission for any purchase through these links - Thanks for supporting the channel!* SUPPORT MY CHANNEL - PATREON/MERCH 🙌Patreon Page - 🤍 💻Alex The Analyst Shop - 🤍 Websites: 💻Website: AlexTheAnalyst.com 💾GitHub: 🤍 📱Instagram: 🤍Alex_The_Analyst 0:00 Intro 0:29 Looking at the Data 1:45 Load data into Power Query 2:32 Power Query UI 5:26 Removing Rows 6:17 Changing the Headers 6:49 Changing Data Types 8:00 Removing Rows with "x" Value 8:58 Removing Columns 9:25 Pivoting/Unpivoting 12:15 Saving Transformation 12:44 Outro *All opinions or statements in this video are my own and do not reflect the opinion of the company I work for or have ever worked for*
How to import multiple files containing multiple sheets with Power Query, even if the data isn’t formatted in an Excel Table. 🔻 DOWNLOAD the Excel file & see step by step written instructions here: 🤍 🎓 LEARN MORE: view my comprehensive courses: 🤍 🔔 SUBSCRIBE if you’d like more tips and tutorials like this. 💬 Please leave me a COMMENT. I read them all! 🧟♀️ CONNECT with Mynda on LinkedIn: 🤍 🎁 SHARE this video and spread the Excel love. Or if you’re short of time, please click the 👍 💬 EXCEL QUESTIONS: Get help on our Excel Forum: 🤍
Power Query e acea unealta din Excel care te poate ajuta sa automatizezi transformarile repetitive pe care le faci pe datele tale. Te poate ajuta sa aduci acel raport din forma A in forma B cu un simplu click dreapta / refresh. Acest video face parte dintr-un curs online despre Excel de nivel avansat - Ninja in Excel. Afla mai multe aici: 🤍 Cursuri online Office si Google Workspace: 🤍 Tutoriale Excel: 🤍
#Shorts | Excel Power Query का पावर💪सिख लो | How to Separate Numeric Value From Text About Video Namaskar Dosto aaj aap is shorts video ke madhyam se sikhne ja rahe hai excel power query ka use karke aap kaise numeric value to separate kar sakte ho text mein se bahoot hi simple hai aur aapko ye excel ki tips jaroor pasend aayegi Follow me 👇 Instagram id:-🤍 Telegram:-t.me/abhijeetjitechnical4m Pivot Table Basic To Advance 👇 🤍 Advance Excel Formulas 👇 Vlookup Formula Part 1 🤍 Vlookup formula part 2 🤍 Subtotal Formula 🤍 Countifs Formula 🤍 Aggregate Formula 🤍 Sumproduct Formula 🤍 Sumifs Formula 🤍 Replace Formula 🤍 All the images & back ground music use in this video only for education purpose and all credit goes to owner Disclaimer: Note: Copyright Disclaimer Under Section 107 of the Copyright Act 1976 allowance is made for "fair use" for purposes such as criticism comment news reporting teaching scholar ship and research. Fair use is a use permitted by copyright statute that might otherwise be infringing. Non-profit, educational or personal use tips the balance in favor of fair use.... Aasha karta hoon dosto aapko humare video pasend aaya hoga agar video aachha laga ho to humare channel ko subscribe karke bell icon ko press kar lijiyega kyonki hum apne channle per is type ki video lekar aate rahte hai #shorts #powerquery #abhijeetjitechnical4m
Using the functions IF, AND, OR in Power Query is a little different to Excel. Sample Data sets 🤍 00:00 Intro 00:16 Sample Data Sets 01:20 Fixing US Date 02:23 IF 03:00 AND 04:32 OR Connect with me via the following link 🤍 Access Analytic 🤍
Looking for the IN Operator equivalent in Power Query? This video shows you exactly what you need. WRITTEN ARTICLE: 🤍 CONTENT 00:00 Introduction 01:41 IN operator single column 03:54 Reference Table Values 05:34 IN Operator multiple columns ABOUT BI Gorilla: BI Gorilla shares videos and articles on Power BI and Excel to help you improve your skills. Website: 🤍 SUBSCRIBE TO MY CHANNEL 🤍 LET'S CONNECT: Blog: 🤍 Facebook: 🤍 Twitter: 🤍 LinkedIn: 🤍 Thank you for your support! #INoperator #powerquery #bigorilla
Dans cette vidéo nous allons abordé des exemples avancés de l'outil Regrouper Par de Power Query. Les manipulations sont effectuées avec Excel mais elles sont identiques si vous utilisez Power BI Desktop lien vers le fichier Excel / Power Query : 🤍 Abonnez vous pour plus de vidéos Excel et Power Query: 🤍 Si mon travail vous intéresse, j'ai écrit plusieurs ouvrages publiés aux éditions Eni sur la business intelligence avec Excel (Power BI) : 🤍 L'analyse de données pour le marketing : 🤍 et un autre sur la modélisation financière avec Excel : 🤍 Vous pouvez aussi me retrouver sur mon site : 🤍 Ou sur LinkedIn : 🤍 Un tutoriel en français proposé par Wise Cat Noro Boris 00:00 introduction 00:35 % du total général 03:05 classer les ex aequo 05:47 trier par catégorie #MsExcel #PowerQuery #PowerBI
Как быстро и с автоматическим обновлением собрать данные из нескольких файлов Excel в один с помощью Power Query. Файл-пример можно скачать тут 🤍 Заходите в гости ↓↓↓ Мои книги 🤍 Мои онлайн-курсы 🤍 Моя надстройка PLEX (+150 новых функций для вашего Excel) 🤍 Twitter 🤍 Facebook 🤍 Instagram 🤍
This FULL course in Power Query, In this video will cover how to write Power query in power bi development. We go through Creating a data transformations, handling data, query folding , data preview and many more concepts. #PowerBI #PowerBIDesktop #PowerBITutorials ▬▬▬▬▬▬▬▬ Power BI - POWER QUERY- Tutorials - FULL COURSE ▬▬▬▬▬▬▬▬ 1) 03:44 - Introduction Power Query VS Power Pivot VS Power View 2) 12:37 - Excel Transformation Remove Headers, Rows Fill gaps, Unpivot Data Types 3) 25:02 - Common Transformation Split, derive a Column , remove Column 4) 37:32 - SQL Equivalent Transformation Append Union / Union All Merge Left/ Right/ Inner Join Group By 5) 59:12 - Business Scenarios Sort by month, Derive Age, Stored in Enter data, Reading Multiple Excels, Split the delimited value into rows, 6) 01:41:58 - Data Preview Options 7) 01:49:04 - Handling nulls or blanks 8) 01:57:53 - Query Folding in Power BI 9) 02:09:17 - Power Query Tips & Tricks Column From Examples Reference vs Duplicate in Power Query Query Dependency Change Connection source / Source Type Source Files: 1) Excel Transformation : 🤍 2) Append: 🤍 🤍 3) Merge 🤍 4) Excel Automation / Reading Multiple Excel Files 🤍 🤍 🤍 🤍 🤍 🤍 ✉ Business Queries / Analytics Consulting ✉ : analyticswithnags🤍gmail.com 💬 For Learners Post queries and Interact 💬 Telegram Channel - 🤍 Linkedin Page - 🤍 Complete Playlists Power BI Tutorials - Complete Playlist 📚📖 🤍 Power BI Desktop Tips and Tricks 📚📖 🤍 Power BI DAX - Complete Playlist 📚📖 🤍 Power BI Services Playlist 📚📖 🤍 Power BI Project Dashboards - Power BI Realtime Projects - Playlist 📚📖 🤍 Data Warehouse Tutorials 📚📖 🤍 SQL Full Course | SQL Tutorial For Beginners 📚📖 🤍 SSAS Tutorials - SQL Server Analysis Services 📚📖 🤍 SSIS Tutorials - SQL Server Integration Services 📚📖 🤍 Power BI Interview Topics 📚📖 🤍 MSBI (SSIS,SSAS,SSRS) Interview Topics 📚📖 🤍 Excel for Data Analysis 📚📖 🤍 Power BI + R 📚📖 🤍 Azure for Analytics - Complete Tutorials 📚📖 🤍 Catch with Nags 📚📖 🤍 Nags Checklist 📚📖 🤍 Visuals with Nags 📚📖 🤍
شرح اداة البور كويري في الاكسل | power query للحصول على الملف المستخدم 🤍
Introduction à Power Query dans Excel s'adressant aux professionnels utilisant Excel dans le cadre de leur travail, et qui ont besoin de manipuler et transformer des données. Power Query permet d'automatiser les transformations aux données, et permet aussi de répéter ces transformations sur plusieurs sources de données. Capsule présentée par musoft (🤍).
ExcelTown.com Power Query se věnujeme, mimo jiné, na těchto kurzech: 🤍 🤍
Finally, the most requested video is here. I'll discuss the nuances of 'each' & '_' keywords in Power Query. = ONLINE COURSES = ✔️ Mastering DAX in Power BI - 🤍 ✔️ Power Query Course- 🤍 ✔️ Master Excel Step by Step- 🤍 ✔️ Business Intelligence Dashboards- 🤍 = LINKS 🔗 = Blog 📰 - 🤍 Corporate Training 👨🏫 - 🤍 Need my help on a Project 💻- 🤍 Download File - 🤍 = CONTACT 🌐 = Twitter - 🤍 LinkedIn - 🤍 Email - goodly.wordpress🤍gmail.com = CHAPTERS = 0:00 Intro 0:16 Understanding 'each' & Underscore_ in a Context of a Table 2:45 Understanding 'each' & Underscore_ in a Context of a List 4:27 Alternate to 'each' & Underscore_ in a Table 7:05 Alternate to 'each' & Underscore_ in a List 8:48 My Courses = WHO AM I? = A lot of people think that my name is Goodly, it's NOT ;) My name is Chandeep. Goodly is my full-time venture where I share what I learn about Excel and Power BI. Please browse around, you'd find a ton of interesting videos that I have created :) Cheers! - - - - - Music By: "After The Fall" Track Name: "Tears Of Gaia" Published by: Chill Out Records - Source: 🤍 Official After The Fall YouTube Channel Below 🤍 License: Creative Commons Attribution-ShareAlike 4.0 International (CC BY-SA 4.0) Full license here: 🤍
Reconcile & consolidate data from multiple worksheets automatically using this amazingly simple Excel trick. You can set up a repeatable process so that every month Excel automatically combines the data for you. ⏱ In this video 👉 0:00 - Introduction to the combine sheets problem 1:01 - New file to consolidate the data 2:05 - Updating "power query" steps 3:07 - Cleaning up the combined data 5:35 - Loading data to Excel 5:58 - Testing with new data 6:48 - More Power Query Sample files 📗📗👇 Download the sample clinic data here - 🤍 Combined workbook with query - 🤍 Article on how to use Power Query - 🤍 Learn Power Query (complete tutorial): = If you are new to Power Query then watch this complete tutorial (80 minutes) to understand it fully. 🤍 Want more? Get my Power Query mini-course here 👉 🤍 My Power Query tips & tricks playlist: Here is a playlist of all my PQ tips & tricks. Binge responsibly ;) 🤍 Have a beautiful day 😀🌼🌞 #PowerQuery #Excel
בסרטון זה יש הסבר לפקודת APPEND הנמצאת בתוך ה POWER QUERY ומיועדת לחיבור טבלאות זו לזו; ה APPEND מאפשר לצרף טבלאות בעלות אותו מבנה לטבלה אחת ארוכה ובכך ליצור טבלה הניתנת לניתוח עם PIVOT TABLES. למאות ערכים נוספים של אקסל עם הסברים מפורטים הכנסו לאתר אקסל-פדיה - האנציקלופדיה לאקסל: 🤍
.svg){kind=small}
![[[ 3 HOURS ]] Complete Power Query End to End - PowerBI Tutorial { End to End } Full Course Beginner](https://i.ytimg.com/vi/VO-MyVMKUC4/mqdefault.jpg "[[ 3 HOURS ]] Complete Power Query End to End - PowerBI Tutorial { End to End } Full Course Beginner")
