Одну секунду
Что-то сучилось. Попробуйте еще раз.
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
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 = CHAPTERS = 0:00 Intro 0:23 1 - Name the Steps 1:59 2 - Write Comments for Complex Transformations 3:54 3 - Notice and Omit the Red 7:11 4 - Parameterize and Stage the Queries 9:15 5 - Quick Access Toolbar 10:35 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!
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!
ℹ 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
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: 🤍
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 Check out more popular MS Office tutorials from Simon Sez IT: - Advanced Pivot Tables Crash Course: 🤍 - 6-Hour Microsoft Excel Crash Course: 🤍 - How to Add video to Microsoft PowerPoint: 🤍 - Learn PivotTables in One Hour: 🤍 - Microsoft Project 2016 Tutorial for Beginners: 🤍 Stay in touch! SimonSezIT.com: 🤍 StreamSkill.com: 🤍 YouTube Channel: 🤍 Subscribe to our channel: 🤍 If you enjoyed the video, please give a "thumbs up" and subscribe to the channel ;-) #simonsezit
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: 🤍
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
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 - 🤍
Lär dig hur du använder Power Query - ett verktyg för att automatisera hämtning och transformering av data. Så hämtar du ofta data från samma ställe och gör samma omvandlingar av data? Sluta med det och lär dig Power Query med denna introduktionsvideo! Besök även min hemsida för fler Excel-tips 🤍 Ladda ner Excelen som används i klippet: 🤍 Lär dig om Power Pivot här - 🤍 Lär dig om dashboards med hjälp av Pivottabeller här - 🤍 🌍 Gå min fantastiska Excel-utbildning – The Excelerator Course ⯆ 🤍 🎓 Missa inte att följa kanalen så du inte missar värdefulla tips och tricks ⯆ 🤍 🚩Följ mina sociala medier för att lära dig och skratta kopplat till Excel ⯆ TikTok: 🤍 Instagram: 🤍 Tänk Excel - Tänk Rickard
Rule #1 - DON'T BREAK THE FOLD! There is an amazing feature that lets you see where this fold was broken, and I'm guessing you didn't even know it was there! Adam shows you where to go. Query plan for Power Query (Preview) 🤍 📢 Become a member: 🤍 * Want to take your Power BI skills to the next level? We have training courses available to help you with your journey. 🎓 Guy in a Cube courses: 🤍 * LET'S CONNECT! * 🤍 🤍 🤍 🤍 🤍 🤍 *Gear* 🛠 Check out my Tools page - 🤍 #PowerBI #PowerQuery #GuyInACube
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 👍🏽 ;-)
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!
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
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
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: 🤍
Знакомство с надстройкой Excel Power Query (в Excel 2016 Получить и преобразовать данные): загрузка данных, интерфейс редактора запросов, обработка, выгрузка, обновление. Файл с примером и другие уроки о Power Query по ссылке 🤍 ► Корпоративный тренинг "Продвинутый уровень MS Excel": 🤍 ► Онлайн курс "Продвинутый уровень MS Excel": 🤍 💳 Поддержать канал деньгами 🤍 * Мой сайт об Excel и статистике * 🤍 * Странички и аккаунты в соцсетях * Facebook: 🤍 Вконтакте: 🤍 Твиттер: 🤍 Telegram: 🤍
★ Want to automate Excel? Check out our training academy ★ 🤍 ★ Check out the blog post ★ 🤍 ★ About this video ★ This video shows how to use parameters in Power Query to change the output of a query. 0:00 Introduction 1:12 Types of parameters 1:55 Scenario 4:33 Create cell parameters 7:35 Using parameters 8:16 Testing the parameters 8:58 Official Power Query parameters 11:49 Summary ★ Download 30 most useful Excel VBA Macros ebook for FREE ★ 🤍 ★ Where to find Excel Off The Grid ★ Blog: 🤍 Twitter: 🤍 #MsExcel #PowerQuery
Power Query if statements are easier to write than those in Excel. In this video I'll teach you how to write them in both Excel and Power BI using the Custom Column tool and write Power Query if and, if or, and nested if statements. 🔻 DOWNLOAD EXCEL FILE HERE: 🤍 🎓 LEARN MORE in my Power Query 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: 🤍 ⏲ TIMESTAMPS 0:00 Introduction 0:29 Power Query if statements with Conditional Column 1:42 Power Query if statements with Custom Column 2:29 Power Query if or statements 3:52 Power Query if and statements 4:53 Power Query nested if statements 6:27 File Download Link
Check Out the Complete Excel Power Query course: 🤍 Excel's Power Query can easily solve a common problem in Excel: Consolidating information from multiple Excel worksheets into one Pivot Table. This also works if you'd like to append data from multiple sheets into a single Excel table. In this video we'll combine the data from multiple Excel sheets into a single Pivot table in the same workbook. And we'll do it in a dynamic way so that when new sheets are added, we just need to press Refresh on our report. We will also apply Power Query's convenient transformations to clean and prepare the data for our report (fill up empty cells in a table) ⯆ DOWNLOAD the workbook here (scroll to the bottom of the blog post): 🤍 Power Query Playlist: 🤍 ★ My Online Excel Courses ► 🤍 ✉ Not sure which of my Excel courses fits best for you? Take the quiz: 🤍 EXCEL RESOURCES I Recommend: 🤍 Get Microsoft 365: 🤍 Microsoft Surface: 🤍 GEAR Screen recorder: 🤍 Main Camera: 🤍 Backup Camera: 🤍 Main Lens: 🤍 Zoom Lens: 🤍 Audio Recorder: 🤍 Microphone: 🤍 Lights: 🤍 More resources on my Amazon page: 🤍 Time Stamps: 00:00 Combine Data from Multiple Sheets in one PivotTable 01:48 Send data to Power Query 02:25 Send data from all sheets in one go 03:45 Apply Power Query's Data Transformations 04:58 Create Excel Pivot Table on Appended Data 05:38 Exclude End-Report as Data Source in Power Query 07:46 Refresh Report with New Data 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
CLIQUE AQUI PARA SABER MAIS SOBRE O CURSO COMPLETO EXCEL IMPRESSIONADOR: 🤍 BAIXAR O MINICURSO GRATUITO BÁSICO DE EXCEL: 🤍 - ► Para Baixar o Arquivo Utilizado na Aula, Acesse: 🤍 - Caso prefira o vídeo em formato de texto: 🤍 - Vídeos Recomendados: ► As 5 FÓRMULAS BÁSICAS do Excel que você TEM QUE APRENDER antes do PROCV 🤍 ► PROCV - Passo a Passo Completo (sem complicação) 🤍 ► Tabela Dinâmica - Como fazer Tabela Dinâmica Excel em 5 passos! 🤍 ► PLANILHA EXCEL para IMPRESSIONAR QUALQUER UM 🤍 ► Aprenda TUDO sobre como criar GRÁFICOS no EXCEL 🤍 - Fala Impressionadores! Hoje nós vamos aprender algo diferente, quero te mostrar a introdução ao Power Query Excel. Esse é um suplemento do Excel que vai te ajudar muito a aumentar sua produtividade no Excel e facilitar alguns processos repetitivos. O editor de consultas Power Query vai permitir com que você faça o tratamento de dados no Power Query e passe esses dados tratados de volta para o Excel. Isso é muito útil, pois você vai poder automatizar esse tratamento de dados e sempre que adicionar novas informações ou alterar as informações existentes basta atualizar que o Power Query vai refazer tudo o que já fez para os novos dados. Com isso você vai ter mais produtividade, pois não vai precisar repetir o procedimento sempre que tiver novas informações, basta fazer uma única vez. Depois disso basta atualizar que o programa repete todo o passo a passo de tratamento de dados que você já fez. Isso é bem interessante principalmente quando você tem uma tarefa repetitiva e bases de dados que estão bagunçadas, como é o caso de vários programas que exportam arquivos em Excel. - Hashtag Treinamentos ► Inscreva-se em nosso canal: 🤍 ► Ative as notificações (clica no sininho)! ► Curta o nosso vídeo! - Redes Sociais ► Blog: 🤍 ► YouTube: 🤍 ► Instagram: 🤍 ► Facebook: 🤍 ► Telegram: 🤍 ► Tik Tok: 🤍 Para receber conteúdo diário de Microsoft Excel, VBA e Power BI gratuitamente, entre em nosso grupo do Telegram: 🤍 Em nossos vídeos ensinamos diversas dicas excel e truques excel para que você consiga se desenvolver nessa ferramenta! - #excel #vba #hashtagtreinamentos
Get Access to My Course "Fundamentals of Financial Analysis" HERE: 🤍 In this Excel for Accounting tutorial you'll learn how to use Power Query to import messy SAP data extracts into Excel. Importing data from ERP systems like SAP or Oracle into Excel can be a pain. The data is usually very messy. You need to clean and organize the data to be able to use it in Excel reports. In this tutorial I'll show you 2 practical examples on how you can use Excel Power Query or Get and Transform in Excel to do the work for you. We also create an Excel Pivot Table to analyze the imported data. The great thing with Power Query is that the import is automatic. It's like a macro. Every time we get a new SAP data extract, we just have to refresh our Excel table and all the steps to organize the data will be automatically applied. Time Stamps 00:00 Data Cleaning with Excel for Accountants 00:40 How to Import SAP Data in Excel with Power Query 15:43 How to Create a Pivot Table from Messy Excel Data 20:02 Wrap Up LINK to more Accounting tutorials: 🤍 ★ My Online Excel Courses ► 🤍 ✉ Not sure which of my Excel courses fits best for you? Take the quiz: 🤍 EXCEL RESOURCES I Recommend: 🤍 Get Microsoft 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 #accounting #sap
✅ Kurs video Power Query: 🤍 👉 Pobierz plik do filmu: 🤍 💪 Praktyczny test wiedzy z Excela: 🤍 😃 Dołącz do moich kontaktów: 🤍 Kurs video Power Query: 🤍 Z tego odcinka dowiesz się co to jest Power Query, jakie możliwości ma to narzędzie i co możesz przy jego pomocy zrobić. Power Query to darmowy dodatek do Excela, który pozwala na podłączanie się do dowolnych źródeł danych, przekształcanie danych a następnie załadowanie ich do Excela, aby można było te dane swobodnie analizować. Użyty mechanizm: Power Query
Sign up for our Excel webinar, times added weekly: 🤍 In this video, I explain how to combine multiple Excel Tables or Worksheets with Power Query. You will learn how to fully automate this process to save you a ton of time with this common Excel task. The video covers: The prerequisites for the data and column structure. How to setup the connection queries in Power Query, plus a macro to make this faster. How to append or combine the queries to stack the data. The update and refresh process when the data changes or you get new data. How to add new tables to the append query. You can download the example file on the following page: 🤍 Additional Videos & Resources: Excel Tables for Beginners: 🤍 Power Query Overview: 🤍 How to Install Power Query:🤍 Introduction to Pivot Tables & Dashboards Video Series: 🤍 Free Webinar on The Modern Excel Power Tools: If you are new to Power Query and/or not sure how it fits into other features like Power Pivot, Power BI, pivot tables, or macros & VBA, then check out my free training webinar. It’s called the Modern Excel Blueprint and it’s running right now for a limited time. 🤍 00:00 Introduction 01:58 Power Query Setup 06:58 Updating and Refreshing Data
#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
Power query alapok 🤍ilovedata.hu #powerquery #oktatás #tanàcsadàs #SQL #Excel
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 📚📖 🤍
🔥 APRENDE A AUTOMATIZAR UN PROCESO‼️ 👉 Deja que Excel haga el trabajo por ti y deja que sólo procese y envie por correo. Quieres aprender❓ Yo te enseño ✅ Certifícate en Excel | 🤍 ⭐ Descarga el archivo y la macro | 🤍 🥇 Descarga EXCELeINFO addin | 🤍 📩 Suscríbete a mi lista de novedades | 🤍 ⏱ CAPÍTULOS ⏱ 0:00 Intro 00:51 Consolidar archivos de una carpeta 03:36 Macro para actualizar query y enviar por correo 06:05 Crear .BAT para abrir el archivo de Excel 07:59 Programar que el archivo se abra a cierta hora 10:11 Probando 👍 SÍGUEME EN TODAS LAS REDES 👍 Página web | 🤍 Facebook | 🤍 Instagram | 🤍 LinkedIn | 🤍 Telegram | 🤍 TikTok | 🤍 Twitter | 🤍 #MsExcel
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: 🤍
What is Power Query, what is it used for, where do you use Power Query? If you're asking these questions then here is a brief introduction with 3 examples of Power Query use cases. Learning Power Query could change your life for the better. It's key to better Excel reports and Power BI Power Query Playlist : 🤍 Loading 10 Million Records into the DataModel: 🤍 Follow me on LinkedIn 🤍 Twitter 🤍 Access Analytic Training 🤍
If you have time to learn just one skill in 2023, make it POWER QUERY. This single technical skill can help you make massive gains in your data analysis work. 💥 Get my Power Query mini-course - 🤍 WHAT IS POWER QUERY? Power Query is a data pre-processing engine built into Excel and Power BI. You can use it to bring data from anywhere and do pre-processing or clean-up activities with ease. It lets you automate common data tasks like removing duplicates, combining files, merging (joining) datasets, adding derived columns, splitting or extracting data and changing the shape / size of your data. HOW TO GET POWER QUERY? It is already there in Excel and Power BI. In Excel - Go to DATA Ribbon and use the "Get & Transform Data" options. In Power BI - use the "Get data" or "Transform" buttons. IS POWER QUERY BETTER THAN SQL? Power Query and SQL have largely similar capabilities. But Power Query gives you more freedom and options. Plus, it is easier to learn (in my opinion). ~ IN THIS VIDEO ⏱️👇🏼 = 0:00 - One skill you should learn in 2023 - Power Query, what is it? 2:02 - How to activate & use Power Query? 4:43 - STEP 0: Pre-cleaning the data 6:31 - STEP 1: Dealing with Blank data points 7:48 - STEP 2: Removing the duplicates 8:30 - STEP 3: Generating ID values 11:05 - STEP 4: Calculating Course Date from Registration Date 13:25 - STEP 5: Figuring out the Fee Status 15:39 - How to load the cleaned data back to Excel? 16:19 - Analyzing the Power Query data and Refreshing 📂 DOWNLOAD PRACTICE FILES = Sample raw data file - 🤍 Completed workbook (with Power Query steps) - 🤍 💻 LEARN MORE about POWER QUERY Check out below videos, playlists & articles for more on Power Query. ▶ COURSES: ▶ ▶ Get my Power Query mini-course and learn all you need in one place quickly - 🤍 ▶ ▶ Join Excel School program to learn Power Query, Power Pivot, Formulas, charting & Dashboards in one place - 🤍 ▶ VIDEOS: ▶ ▶ Data cleaning in Excel - 10 tips (Power Query, Formulas & Flashfill) - 🤍 ▶ ▶ Power Query in Excel (Beginner to ADVANCED) - 🤍 ▶ ▶ How to combine data from files (using Power Query) - 🤍 ▶ PLAYLIST: My Power Query videos playlist - 🤍 ▶ READ: What is Power Query and how to use it (with 4 examples, sample files) - 🤍 ~ Happy learning. I wish you more POWER ⚡ in 2023 #PowerQuery #excel
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
Curso de Power Query, ¿Qué es Power Query?, ¿Por qué usar Power Query?. Power query en Excel. #PowerQuery #Power #Query _ Suscríbete en mi otro canal: 🤍 🤗 Visita nuestras redes sociales: Sitio web: 🤍 🤍 Facebook: 🤍 Instagram: 🤍 🟩 Grupo de ayuda Excel: 🤍 🟦 Grupo de ayuda Word: 🤍
CLIQUE AQUI PARA SABER MAIS SOBRE O CURSO COMPLETO EXCEL IMPRESSIONADOR: 🤍 BAIXAR O MINICURSO GRATUITO BÁSICO DE EXCEL: 🤍 ACESSE A PÁGINA DA HASHTAG FREE - PÁGINA DE CONTEÚDOS GRATUITOS DA HASHTAG: 🤍 - ► Para Baixar o Arquivo Utilizado na Aula, Acesse: 🤍 - Caso prefira o vídeo em formato de texto: 🤍 - Vídeos Recomendados: ► As 5 FÓRMULAS BÁSICAS do Excel que você TEM QUE APRENDER antes do PROCV 🤍 ► PROCV - Passo a Passo Completo (sem complicação) 🤍 ► Tabela Dinâmica - Como fazer Tabela Dinâmica Excel em 5 passos! 🤍 ► PLANILHA EXCEL para IMPRESSIONAR QUALQUER UM 🤍 ► Aprenda TUDO sobre como criar GRÁFICOS no EXCEL 🤍 - Fala Impressionadores! Na aula de hoje eu quero falar sobre um assunto que gera muitas dúvidas em relação ao Excel! Qual a diferença entre Power Pivot e Power Query? Quando utilizar cada um deles? Então é isso que vamos ver na aula de hoje! São dois suplementos do Excel que são parecidos, mas tem funcionalidades diferentes. Então quando usar Power Query? Vamos utilizar o Power Query para tratamento de dados e utilizaremos o Power Pivot para analisar base de dados, ou seja, para fazer uma análise. Isso quer dizer que o Power Query vai nos retornar uma base de dados, e já o Pwoer Pivot vai retornar uma análise, podendo ser uma tabela dinâmica, uma soma, média... E aí, bora aprender quando utilizar cada um desses suplementos no Excel? Vem que eu te mostro! - Hashtag Treinamentos ► Inscreva-se em nosso canal: 🤍 ► Ative as notificações (clica no sininho)! ► Curta o nosso vídeo! - Redes Sociais ► Blog: 🤍 ► YouTube: 🤍 ► Instagram: 🤍 ► Facebook: 🤍 ► Telegram: 🤍 ► Tik Tok: 🤍 Para receber conteúdo diário de Microsoft Excel, VBA e Power BI gratuitamente, entre em nosso grupo do Telegram: 🤍 Em nossos vídeos ensinamos diversas dicas excel e truques excel para que você consiga se desenvolver nessa ferramenta! - #excel #vba #hashtagtreinamentos
Μάθετε να χρησιμοποιείτε το power query και να δημιουργείτε αναφορές δεδομένων γρήγορα και άμεσα! και πραγματικά λύστε τα χέρια σας!. Σε αυτό το βίντεο, χρησιμοποιούμε έναν φάκελο που περιέχει αρχεία-αναφορές τις οποίες ενώνουμε σε ένα κεντρικό αρχείο που θέλουμε να διαχειριζόμαστε. Εργασίες που μέχρι τώρα παίρνουν πολύ χρόνο, είναι εφικτό να τελειώνουν σε λίγα λεπτά! Αν έχετε απορίες αφήστε ένα σχόλιο! Στηρίξτε το κανάλι μας, κάνοντας εγγραφή Facebook: 🤍 URL: 🤍
This video will show you the basics of Excel "Get & Transform" (also know as Power Query) so you can get started using it. Get & Transform can help you clean up irregular data in Excel, and this video shows you how to do so. *Consider supporting Technology for Teachers and Students on Patreon*: 🤍 See my entire playlist of Excel videos: 🤍 Here is the practice file that goes with this video: 🤍 You'll find the Intermediate Guide here: 🤍 #excel #exceltutorial
Formation Power Query en ligne 🤍 Power Query est un outil de traitement des données, intégrés dans Excel et Power BI, qui vous évite des heures de codes en VBA (ou autres). Voici un exemple d'application. Voici quelques liens utiles Le fichier csv de travail : 🤍 Pourquoi avoir choisi le nom Power Query 🤍 Livre sur Power Query 🤍 Livre sur le VBA 🤍 00:00 Introduction 00:19 Inconvénient de faire des programmes en VBA 01:50 Comparer le résultat entre une macro et Power Query 02:39 Importer un fichier CSV 03:17 Permuter les colonnes 04:14 Transformation des données avec Power Query 05:58 Conclusion
בסרטון זה יש הסבר לפקודת 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")
