【Excel講座】PowerQueryの使い方①～カスタム列等を使い列を追加する方法～

This Excel tutorial explains "How to Use PowerQuery ① - How to Add Columns Using Custom Columns, etc." PowerQuery is a data import and transformation tool that can be used in Excel and PowerBI. PowerQuery allows you to add new columns by specifying formulas and conditions from existing columns without changing the original data, so be sure to check it out! ●Table of Contents 01:14 1. What Can You Do with Power Query? 03:57 2. What is Adding Columns in Power Query? 04:53 3-1. How to Add Various Columns - Calculated Columns 08:15 3-2. How to Add Various Columns - Conditional Columns 12:27 3-3. How to Add Various Columns - Custom Columns 14:45 3-4. How to Add Various Columns - Index Columns ●Related Videos [Using ChatGPT] Leveraging AI for Data Analysis in Power BI!    • 【ChatGPT活用】Power BIでのデータ分析でAIを活用する！   [Power BI Introduction] Explaining the Basics of Data Analysis: Data Types in 15 Minutes!    • 【Power BI入門】データ分析の基本「データ型」を15分で解説！   ●Related Sites [Excel Tutorial] A Simple Guide to Using Power Query! ~Easily Automate Data Transformation Tasks~ https://www.powerplatformknowledge.co... [Power BI Introduction] What are Database Data Types? How to Set Data Types https://www.powerplatformknowledge.co... [For Beginners] Basic Power BI Desktop Usage in 5 Steps ~Easily Edit Amazing Excel Data!~ https://www.powerplatformknowledge.co... ●Blog https://www.powerplatformknowledge.com/ I'm systematically summarizing the content I've introduced on YouTube. I'm also open to commissioned work. ●Twitter   / pawami_powerpf   I tweet about how to use Power BI, Power Apps, and Power Automate, as well as little tidbits of information I've noticed on a daily basis. ●Contact Us For inquiries about Power Platform, please use the link below! https://www.powerplatformknowledge.co... #powerquery #powerbi #pr