Power query excel смотреть последние обновления за сегодня на .
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
Learn Power Query in just 10 minutes to merge multiples Excel files, clean up data, and analyse it. 🔥Take our Power BI for Business Analytics course: 🤍 🆓 DOWNLOAD Free Excel file for this video: 🤍 LEARN: 🔥Power BI for Business Analytics: 🤍 📈 The Complete Finance & Valuation Course: 🤍 👉 Excel for Business & Finance Course: 🤍 🚀 All our courses: 🤍 PowerQuery is one of the most powerful tools that you can use for Excel and Power BI. In this tutorial, we teach you how to use it from scratch. First, we learn how to import multiple excel files into one for further analysis. Then, we learn how to clean up data in Power Query which is much faster than Excel. Finally, once the data is clean up, we upload it onto excel for further analysis using Pivot Tables. We also see how adding new data affects the analysis. SOCIALS: 🎬 My Company YouTube Channel: 🤍 📸 Instagram - 🤍 🤳 TikTok - 🤍 🧑💻 LinkedIn - 🤍 ▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬ Chapters: 0:00 - Intro 0:22 - Combining Multiple Excel Files 2:08 - Cleaning up the Data 6:28 - Analysing the Data with Pivot Tables 7:25 - Adding more Data Disclaimer: I may receive a small commission on some of the links provided at no extra cost to you.
✅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 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!
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: 🤍
Advanced Excel Power Query | Introduction | Tutorialspoint Advanced Excel Power Query Online Training. In this Power Query tutorial, the trainer will give a brief Introduction to Advanced Excel Power Query and the advantages of using power query in Excel. Get Certified in Advanced Excel (Power Query):🤍 Use coupon "YOUTUBE12" to get ‘’FLAT 12%’’ OFF at Checkout. Quality Learning to UPSKILL yourself only at TutorialsPoint. Explore & Learn the top trending courses curated by the best trainers in the Industry 🤍tutorialspoint: Your go-to Learning Solution. Power Query is a powerful tool given by Microsoft. Power Query combines different software(SQL, Excel, VBA). With our Trainer, You learn: - Introduction to Advanced Excel Power Query - Excel Installation - Advanced Excel Power Query Text Functions - Date Function- Calculate Age in 2 button clicks - Merge Queries from two Excel Files - Append 100 Excel Tables - 99+ Excel functions can be replaced by button clicks - M Function for Date - 700 M functions to reduce tasks - Merge Queries - No VLOOKUP. - How to Clean Financial Data with Power Query. Upskill your career by training on the best-TRENDING Courses in the Market. Premium Packs with Lifetime Access: 🤍 Trending Courses: 🤍 Check out Ebooks on the Latest Technology: 🤍 Microsoft Excel is a spreadsheet tool capable of performing calculations, analyzing data, and integrating information from different programs. This Power Query training has been designed for users who want to learn Advanced Excel Power Query in easy and simple steps. It will be highly useful for those learners who do not have prior exposure to Microsoft applications. Watch more Related Videos Advanced Excel Power Query- 🤍 MS Excel for Beginner- 🤍 Excel VBA Macro- 🤍 Tutorialspoint, a leading ed-tech platform, offers Simply Easy Learning at affordable prices. We offer the best quality certification courses designed by global experts in top fields like Development, IT, Networking, Data Science, Artificial Intelligence, Machine Learning, Cyber Security, Business, Marketing, Office productivity, and Lifestyle. Those interested in learning from the basics to advanced levels of a particular topic can opt for our Prime Packs. We cater to the needs of 40 million learners per month with our 7000+ courses and 5000+ eBooks. Subscribe to our Channel to get more related updates and turn on the notification: 🤍 #tutorialspoint #Excel #advancedexcelpowerquery #powerquery #exceltutorial
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: 🤍
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 👍🏽 ;-)
Ein leicht verständliches Tutorial für Anfänger aus dem Bereich: Excel In diesem Tutorial zeige ich Euch wie Ihr Power Query in Excel anwenden könnt. Hier handelt es sich um ein relativ einfaches Beispiel. In diesem Tutorial benutze ich 3 Tabellen die miteinander verbunden werden. Wir fügen zusätzlich eine Benutzerdefinierte Spalte hinzu und werden auch eine einfache Berechnung in dieser Spalte vornehmen. Viele weitere Tutorials und Downloads findest Du auch auf meiner Website: 🤍 Diese Anleitung / Lernvideo ist in deutsch / german.
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
Benvenuto nel mio canale, prendi nota dei link qui sotto potrebbero esserti utili 😉 *DOWNLOAD* Se vuoi scaricare tutti i file dei miei video bisogna avere un abbonamento o fare una libera donazione, trovi i link qui sotto. Scrivimi su 📧 tuttosuexcel🤍gmail.com 📧 e ti invierò tutti i file *SUPPORTA* ☑ Aiuta il canale a rimanere gratuito per tutti con Carta di Credito o PayPal 🤍 ☑ Abbonati a questo canale per accedere ai vantaggi: 🤍 SEGUIMI! * ✔ Instagram 🤍 ✔ Linkedin 🤍 I MIEI LIBRI* 📌 Excel e Office VBA di Gianni Giaccaglini 🤍 📌 Microsoft Excel 2016 Macro e VBA di Alessandra Selvaggio 🤍 📌 Slaying Excel Dragons di Mike Girvin (ENGLISH) 🤍 *ATTREZZATURE* 🛒Mouse Logitech MX Anywhere 3 (nuovo 2021) 🤍 🛒Tastiera Logitech MK270 🤍 🛒 Webcam Logitech C920 HD Pro Webcam, Videochiamata Full HD 1080p/30fps 🤍 🛒Cuffie Audio Technica ATH-M30x 🤍 🛒Microfono Blue Yeti USB 🤍 🛒Rode PSA1 Braccio Portamicrofono 🤍 🛒Monitor principale AOC AGON AG271QG da 27" IPS, QHD, 2560 x 144, 165 Hz 🤍 🛒 Secondo Monitor HP 27w Monitor, Schermo 27 Pollici IPS Full HD, Risoluzione 1920 x 1080 🤍 🛒Elgato Key Light Air Pannello LED 🤍 🛒HP LaserJet Pro M15a Stampante Mono funzione Bianco e Nero, Solo USB, 🤍 🛒 PC assemblato (dal 2021) Corsair ONE i145s, PC Gaming Compatto Intel Core i7-9700K, NVIDIA GeForce RTX 2080 🤍 #GerardoZuccalà #PowerQuery #Excel_Vba
Power Query es una herramienta de Microsoft que se utiliza para realizar transformaciones y cargar datos en una hoja de cálculo o un informe. Está diseñada para facilitar el proceso de obtención y limpieza de datos de diversas fuentes, como bases de datos, archivos de texto o tablas en línea. Con Power Query, puedes seleccionar y filtrar los datos que necesitas, combinar y agregar columnas, y aplicar funciones y fórmulas para limpiar y transformar los datos de acuerdo a tus necesidades. Además, puedes crear consultas y cargar los resultados en una hoja de cálculo de Excel o en un informe de Power BI, donde puedes visualizar y analizar los datos de manera más eficiente. Una de las principales ventajas de Power Query es que puedes realizar estas transformaciones de manera rápida y sencilla, sin necesidad de escribir código o tener conocimientos avanzados de programación. Además, las consultas que crees con Power Query se pueden reutilizar y compartir con otros usuarios, lo que facilita la colaboración y el trabajo en equipo. En resumen, Power Query es una herramienta útil para aquellos que necesitan trabajar con datos de diversas fuentes y realizar transformaciones y limpieza de datos de manera rápida y sencilla.
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
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
Hoje trago uma super dica que vai te ajudar a economizar muito, mas muito tempo mesmo de trabalho com planilhas do Microsoft Excel. Você aprenderá a combinar várias abas do Excel em uma única aba. Para isso, não será necessária uma única linha de código VBA. Faremos isso usando o editor do Power Query. Saber como combinar (juntar) os dados de diferentes abas do Excel irá te poupar muita energia. Se gostou desse conteúdo, se inscreva para mais dicas avançadas de Excel. #Planilhas #PowerQuery #Excel
Power query è una funzione di Excel (e Power BI) che permette di caricare e modificare dati da un file sorgente (Excel, CRM, ERP, etc). Power query fa risparmiare ore ed ore di lavoro perché automatizza il caricamento e la gestione dei dati (data shaping), eliminando le colonne che non ci servono, creando delle colonne calcolate, modificando il tipo di dato, etc. E' una funzione ancora poco conosciuta, ma fondamentale per tutti coloro che lavorano con l'importazione di dati che devono essere aggiornati di frequente. In questo video vedrete un tutorial su power query in italiano. Pochi minuti che vi faranno risparmiare ore quando dovrete importare dei dati e aggiornare dei dati in Excel.
Here are seven mind-blowing Power Query tricks - Promoting headers without a promoted headers step, Extracting any Intermediary Step, Dynamically Expanding Tables, Projections, Sections Keyword, Is Keyword, and '&' Keyword! Imke's Blog Link - 🤍 = 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!
#excel #ileriexcel #msexcel #excelvideo #1dkdaexcel #çaprazara Power Query Modülüne Giriş. Power Query nedir? Nasıl ve Nerede Kullanılır? Power Query, çözümleme gereksinimlerinizi karşılamak üzere veri kaynaklarını bulmanıza, bağlanmanıza, birleştirmenize ve kapsamını daraltmanıza olanak sağlayan bir veri bağlantısı teknolojisidir. Power Query 'deki Özellikler Excel ve Power BI Masaüstü 'nde kullanılabilir. Power Query ile yapabilecekleriniz başında farklı veri kaynaklarına bağlanmak gelir. Bu bağlantıları sağlayan sorgular ardından elde edilen sorgulama verileri üzerinde Pivot tablolar oluşturulabilir. Video paylaşım motivasyonumuz için kanalımıza abone olmayı ve gönderinin altına fikirlerinizi yorum olarak yapmayı unutmayın :) Kanalımıza abone olmak için linke tıklayın: 🤍 Instagram sayfamız için tıklayın: 🤍 Sıfırdan İleri Seviye Excel Udemy kursumuza indirimli (29,99 TL) kayıt olmak için linke tıklayın: 🤍 Excel İle Hızlı ve Verimli Çalışmak kitabımızın e-kitap versiyonunu (PDF kitap) 9,90 TL'ye satın alabilirsiniz. Kitabımız konusunda Türkiye'de bir ilk'dir. Her konunun altında ilgili konunun yer aldığı video linki mevcuttur. Ödemeyi yaptıktan sonrakayıt esnasında belirttiğiniz mail adresinize PDF kitap gönderilecektir. Kitabı 9,90 TL 'ye satın almak için tıklayın: 🤍
Знакомство с надстройкой Excel Power Query (в Excel 2016 Получить и преобразовать данные): загрузка данных, интерфейс редактора запросов, обработка, выгрузка, обновление. Файл с примером и другие уроки о Power Query по ссылке 🤍 ► Корпоративный тренинг "Продвинутый уровень MS Excel": 🤍 ► Онлайн курс "Продвинутый уровень MS Excel": 🤍 💳 Поддержать канал деньгами 🤍 * Мой сайт об Excel и статистике * 🤍 * Странички и аккаунты в соцсетях * Facebook: 🤍 Вконтакте: 🤍 Твиттер: 🤍 Telegram: 🤍
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
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
🚫 Chega de perder oportunidades por não ser eficiente ao trabalhar com planilhas do Excel. 🚀 Faça o meu curso de Excel on-line e acelere a sua carreira: 🌐 Clique aqui e saiba mais: 🤍 #excelbr #powerquery #planilhas
A quick overview of the difference between Power Query's Pivot and Unpivot Feature
Advanced Excel Power Query | Merge Queries - No V LOOKUP | Tutorialspoint Advanced Excel Power Query Online Training. In this power query tutorial, you will learn about Merge Tables in power query in a new file. Get Certified in Advanced Excel (Power Query):🤍 Use coupon "YOUTUBE12" to get ‘’FLAT 12%’’ OFF at Checkout. Quality Learning to UPSKILL yourself only at TutorialsPoint. Explore & Learn the top trending courses curated by the best trainers in the Industry 🤍tutorialspoint: Your go-to Learning Solution. Power Query is a powerful tool given by Microsoft. Power Query combines different software(SQL, Excel, VBA). With our Trainer, You learn: - Introduction to Advanced Excel Power Query - Excel Installation - Advanced Excel Power Query Text Functions - Date Function- Calculate Age in 2 button clicks - Merge Queries from two Excel Files - Append 100 Excel Tables - 99+ Excel functions can be replaced by button clicks - M Function for Date - 700 M functions to reduce tasks - Merge Queries - No VLOOKUP. - How to Clean Financial Data with Power Query. Upskill your career by training on the best-TRENDING Courses in the Market. Premium Packs with Lifetime Access: 🤍 Trending Courses: 🤍 Check out Ebooks on the Latest Technology: 🤍 Microsoft Excel is a spreadsheet tool capable of performing calculations, analyzing data, and integrating information from different programs. This Power Query training has been designed for users who want to learn Advanced Excel Power Query in easy and simple steps. It will be highly useful for those learners who do not have prior exposure to Microsoft applications. Watch more Related Videos Advanced Excel Power Query- 🤍 MS Excel for Beginner- 🤍 Excel VBA Macro- 🤍 Tutorialspoint, a leading ed-tech platform, offers Simply Easy Learning at affordable prices. We offer the best quality certification courses designed by global experts in top fields like Development, IT, Networking, Data Science, Artificial Intelligence, Machine Learning, Cyber Security, Business, Marketing, Office productivity, and Lifestyle. Those interested in learning from the basics to advanced levels of a particular topic can opt for our Prime Packs. We cater to the needs of 40 million learners per month with our 7000+ courses and 5000+ eBooks. Subscribe to our Channel to get more related updates and turn on the notification: 🤍 #tutorialspoint #Excel #advancedexcelpowerquery #powerquery #exceltutorial
Data spread across multiple sheets is an Excel crime! Thankfully Power Query can easily merge data from multiple sheets into one table. Get written instructions and download the Excel file here: 🤍 View my comprehensive courses: 🤍 Connect with me on LinkedIn: 🤍
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
Power Query Editor in Excel #excel #exceltips #exceltutorial #msexcel #microsoftexcel #developer #shorts Inbuilt Data Entry in Excel Data Entry Form in Excel YEARFRAC Formula in excel WEEKNUM Formula in excel REPLACE Formula in excel MOD Functoin in Excel SQRT formula in excel SQRT function in excel Consolidate in excel 3D Sum in excel Running Total in Excel SMALL formula in excel SMALL function in excel LARGE formula in excel LARGE function in excel Rank formula in excel How use rank formula in excel how use rank function in excel rank function in excel SUMIF formula in excel SUMIF function in excel REPT formula in excel REPT function in excel Char formula in excel Char function in excel Date function in excel Date formula in excel Time formula in excel Time function in Excel Filter formula in excel Advanced Filter formula in excel MAX formula in excel MAX function in excel MIN formula in excel MIN function in excel XLOOKUP formula in excel XLOOKUP function in excel Filter in excel Advanced Filter in excel ISTEXT formula in excel ISTEXT function in excel Random formula in excel Random function in excel Randbetween formula in excel Randbetween function in excel Choose formula in excel Choose function in excel MATCH formula in excel MATCH function inexcel TRUE formula in excel TRUE function in excel ISNUMBER function in excel ISNUMBER in formula in excel INDEX formula in excel INDEX function in excel Paste Special in Excel Paste Special in ms Excel IFERROR Formula in excel IFERROR Function in excel LEN formula in excel Substitute formula in excel SUMPRODUCT formula in excel LEN function in excel Substitute function in excel SUMPRODUCT function in excel LEN formula in ms excel Substitute formula in ms excel SUMPRODUCT formula in ms excel LEN function in ms excel Substitute function in ms excel SUMPRODUCT function in ms excel count formula in excel count function in ms excel excel excel shorts excel tutoring excel formula ms excel vlookup in excel excel formula for job interview ms excel number format excel tricks developer excel excel tips and tricks data entry sparklines in excel data entry work in excel excel data entry work in hindi excel shortcuts and tricks excel for fresher excel shortcut keys hlookup in excel ms excel full course in hindi paste special in excel advanced excel formula freeze in excel ms excel shorts advance excel excel formula hacks excel tutorial excel vlookup print titles in excel short excel conditional formatting in excxel countif formula in excel data entry interview questions data tab drop down list in excel excel formulas excel shortcut excel tricks and tips excel vlookup formula excel tricks and tips shorts excel vlookup formula excel world format painter in excel google sheet index formula in excel learn more pivot table excel in hindi shortcut key for excel use of excel in computer computer class vlook up vlookup vlookup formula in excel xlookup in excel advanced excel advanced excel course advanced excel full course advanced excel jobs advanced filter excel basic computer computer excel computer knowledge computer shortcut keys computer xl work concatenate excel data clearing data entry operator ky hota hai data manipulation data representation data tab in excel data table data validation in excel data visualization in excel excel all formulas and functions in hindi excel border formatting excel calendar 2022 excel chart excel column formatting excel count excel data model excel formula number excel formulas and functions excel full playlist in hindi excel function excel header and footer excel hlookup excel in English excel keyboard shortcuts excel me home tab excel multiply formula excel paste special excel print page setup excel series number tricks excel short video excel shortcut keys in mobile excel shortcuts excel sum formula excel sumif formula excel video exel flash fill flash fill in excel forecast in excel freeze panes in excel column and row google sheets tutorial how to calculate time in excel Microsoft excel microsoft office word ms excel formula ms excel full course ms excel eme marksheet banana ms excel tricks pivot pivot table excel data entry work excel full course in hindi excel me salary sheet kaise banaya excel me table kaise banaye excel row and column functions excel test for job interview 2022 excel working excel world hindi
In this video, Allison goes into Power Query in Excel and in Power BI and shows how you can do some basic transformations in the Power Query program in both excel and in Power BI. She goes over what is the same and the differences between the way you access the program in both programs. She then goes through the interface and shows all of the buttons as options. Allison also shows how to remove columns as well as to add new ones in with Column From Example. 👍 If you enjoy this video and are interested in formal training on Microsoft Teams, Power BI, Power Apps, Azure, or other Microsoft products you can use my code "Allison30" at check out when purchasing our On-Demand Learning classes to get an extra 30% off - 🤍 - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - Next step on your journey: 👉 On-Demand Learning - Start With The FREE Community Plan: 🤍 🔗Pragmatic Works On-Demand Learning Packages: 🤍 🔗Pragmatic Works Boot Camps: 🤍 🔗Pragmatic Works Hackathons: 🤍 🔗Pragmatic Works Virtual Mentoring: 🤍 🔗Pragmatic Works Enterprise Private Training: 🤍 🔗Pragmatic Works Blog: 🤍 Let's connect: ✔️Twitter: 🤍 ✔️Facebook: 🤍 ✔️Instagram: 🤍 ✔️LinkedIn: 🤍 ✔️YouTube: 🤍 Pragmatic Works 7175 Hwy 17, Suite 2 Fleming Island, FL 32003 Phone: (904) 638-5743 Email: training🤍pragmaticworks.com #PragmaticWorks #AllisonGonzalez
البور كويري هي إضافة مجانية تأتي مع الإكسل تساعدك بشكل كبير في عمل التقارير وتحليل البيانات، متوفرة في نسخة اكسل 2016 و مابعدها و بالتأكيد متوفرة لمشتركي اكسل 365 في هذا الفيديو ستعرف المزيد عنها لينكات الفيديوهات المذكورة في هذا الفيديو 🔖ما هو قانون باريتو؟ وما علاقته في زيادة الانتاجية؟ 🤍 🔖مثال على تحويل البيانات Data Transformation في الـبور كويري Power Query في الإكسل 🤍 🔖تجميع البيانات من مجموعة ملفات منفصلة في الاكسل بشكل آلي و عمل تقارير عليها باستخدام ال Power Query 🤍 اتمنى لكم دائما و ابدأ المتعة و الفائدة 🌍 زوروا موقع اشرح للتعليم الالكتروني 🤍 نشكر كل من احب دعمنا، نفضل الدعم من خلال شراء دوراتنا للاستفادة منها و من احب ان يدعمنا على باي بال فاليكم اللينك: PayPal: 🤍 ✉ اكرم العبوة Akram Abwa akram🤍eshra7.com ✋ تابعونا على مواقع التواصل الاجتماعي 😀 Facebook: 🤍 LinkedIn: 🤍 Twitter: 🤍 لا تنسونا من صالح دعائكم * كلمات مفتاحية : #Eshra7 #Akram_Abwa #Excel_Power_Query *
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: 🤍
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 (🤍).
Usa il codice MENO10 per avere il 10% di sconto su #Xcamp, il corso pratico per imparare davvero Excel: 🤍 Vuoi imparare ad utilizzare al meglio POWER QUERY su Excel? Facile! Tutti i tutorial li trovate nella Playlist EXCEL Power Query - #EXCELoltreognilimite (🤍 In questo video tutorial vediamo come andare a creare una #tabellapivot che punta su più intervalli di dati all'interno della stessa cartella di lavoro di #Excel. Andremo ad utilizzare #PowerQuery, ma utilizziamo una funzione che ci premettere da un lato di importare in automatico anche nuove tabelle inserite nella cartella di lavoro e, dall'altro, di non dover modificare i passaggi nel caso una tabella dovesse essere eliminata. Questo ci permette di semplificare molto l'aggiornamento della tabella pivot, evitando interventi manuali sulla query. Curiosi? Buona visione! Puoi scaricare il file Excel utilizzato in questo video se sei abbonato al canale o hai acquistato il corso pratico di Xcamp: 🤍 Utilizza il modulo di contatto su 🤍 per fornirci i tuoi dati e ti abiliteremo al download. Grazie! Grazie a tutti per il supporto! Lasciate un commento se vi va! :) e soprattutto ISCRIVETEVI al canale per non perdervi i prossimi trucchi!!! Sostieni il nostro canale con una donazione 🤍 Ecco alcuni titoli interessanti: ITA - Mi chiamo Excel risolvo i problemi (flessibile) 🤍 ITA - Mi chiamo Excel risolvo i problemi (kindle) 🤍 ENG - Power Pivot and Power BI: The Excel User's Guide to DAX 🤍 ENG - The Definitive Guide to DAX 🤍 ENG - Analyzing Data with Power BI and Power Pivot for Excel 🤍 ENG - Power Query for Power BI and Excel 🤍 ENG – dal 17/05/2022 – Excel 365 Bible 🤍 #EXCELoltreognilimite #EXCELoltreognilimiteTRUCCHIeSEGRETI #EXCELPowerQuery #emmanuelevietti autore: Emmanuele Vietti Video realizzato con: Camtasia Studio v.9.2.1 Software: Microsoft Office 365 Excel all rights reserved: © 2021 Experta Business Solutions srl ATTREZZATURA: Microsoft 365 Family - 🤍 Microsoft 365 Business - 🤍 Webcam - 🤍 Supporto webcam - 🤍 Luci led da tavolo - 🤍 Green screen - 🤍 Green screen e luci - 🤍 Tavoletta grafica - 🤍 LINKEDIN: Gruppo Utilizzo professionale di Microsoft Excel (🤍 FACEBOOK: Pagina Utilizzo professionale di Microsoft Excel (🤍 TELEGRAM: Gruppo Utilizzo professionale di Microsoft Office (🤍 TIKTOK: Profilo upmsexcel (🤍 INSTAGRAM: Profilo upmsexcel (🤍 Se questo video vi è piaciuto mettete un «mi piace», date uno sguardo agli altri contenuti ed iscrivetevi al nostro canale. Se avete suggerimenti su nuovi contributi da realizzare, inseriteli nella sezione commenti oppure compilate il modulo contatti sul nostro sito 🤍experta-bs.it e cercheremo di soddisfare le vostre richieste. La vostra soddisfazione: il nostro miglior risultato.
Que tal uma aula de PowerQuery para iniciantes ou o Editor de Consultas do Excel, vamos mostrar para quem quer dar seus primeiros passos ou matar a curiosidade em aprender sobre PowerQuery no Excel. O Microsoft Power Query para Excel é um suplemento que aperfeiçoa a experiência de business intelligence de autoatendimento no Excel por meio da simplificação da descoberta de dados, do acesso e da colaboração. Vamos aprender EXCEL do ZERO passo a passo, em: 🤍 Para baixar o PowerQuery segue o link: 🤍 WHATSAPP DO CANAL : 🤍 FALE COMIGO : 🤍 CONTEÚDO DO CURSO : 🤍 Nosso Curso de Excel OnLine é uma formação completa, você tem os seguintes módulos: 01 - Básico ao Avançado 02 - Dashboards 03 - PowerView 04 - Power BI 05 - VBA 06 - Planilhas Profissionais 07 - Aulas Ao Vivo 08 - Infográficos para Apresentação 09 - Gráficos Dinâmicos 10 - Access 11 - PowerQuery + PowerPivot 12 - PowerPoint 13 - Word Curso com certificado reconhecido, faça já sua formação conosco! 🤍 Visite meus sites: Facebook.: 🤍 Youtube..: 🤍 Instagram: 🤍 Site..........: 🤍 #cursodeexceloficial #cursodeexcel #michelfabiano #excel #microsoftexcel #auladeexcel #focoemexcel #cursodeexcelonline
✅ 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
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: 🤍
Как быстро и с автоматическим обновлением собрать данные из нескольких файлов Excel в один с помощью Power Query. Файл-пример можно скачать тут 🤍 Заходите в гости ↓↓↓ Мои книги 🤍 Мои онлайн-курсы 🤍 Моя надстройка PLEX (+150 новых функций для вашего Excel) 🤍 Twitter 🤍 Facebook 🤍 Instagram 🤍
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
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: 🤍