Automatically translated.View original post

Power Query became available in * * Microsoft Excel 2010 * *

Power Query is available in * * Microsoft Excel 2010 * * and above. The details of each version are as follows:

---

# # # ✅ * * Excel 2010 / 2013 * *

* Power Query is available as an * * add-in * * that must be downloaded and installed separately from Microsoft.

* Supported in * * Excel Professional Plus * * and * * Excel Standalone * *

* Once installed, the "Power Query" tab will appear in the Ribbon.

# # # ✅ * * Excel 2016 and up * *

* Power Query is * * included in Excel automatically * *

* There is no name "Power Query" in the Ribbon, but the feature is in the tab * * "Data" > "Get & Transform Data" * *

* Easier to use and can connect multiple data sources such as Excel, CSV, SQL, Web API etc.

# # # ✅ * * Excel for Microsoft 365 / Excel 2019 / Excel 2021 * *

* Power Query has been improved to support more new features, e.g.

* Automatic Refresh Data

* Using Power Query with Dynamic Arrays

* Writing formulas in more flexible M code

---

# # # 🔒 Note

* * * Excel Online (Web version) * * * Currently * * Full Query editing is not supported * * (Partial Read)

* Some features may not work in Excel Home & Student or Excel versions without the full feature.

---

If you want to check if your Excel has Power Query:

1.Open Excel

2. Go to the tab * * "Data" * *

3.See the command group * * "Get & Transform Data" * * - If available, Power Query is available.

--------------------------

Power Query Workshop Course

https://analyst-development.net/Course/Details/powerquery

2025/11/2 Edited to

... Read morePower Query เป็นเครื่องมือที่ช่วยให้การจัดการข้อมูลใน Excel ง่ายและมีประสิทธิภาพมากขึ้น โดยเฉพาะเมื่อคุณต้องทำงานกับข้อมูลจำนวนมากหรือมาจากหลายแหล่ง เช่น ไฟล์ Excel, CSV, หรือฐานข้อมูล SQL โดยเฉพาะอย่างยิ่งใน Excel 2010 และ 2013 Power Query ยังต้องติดตั้งเป็น Add-in แยกต่างหาก ซึ่งหมายความว่าผู้ใช้งานต้องดาวน์โหลดและติดตั้งก่อนใช้ นอกจากนี้ Power Query ยังรองรับเฉพาะ Excel Professional Plus และ Excel Standalone เท่านั้น ไม่รองรับเวอร์ชัน Home & Student ที่อาจไม่มีฟีเจอร์นี้ เมื่อก้าวเข้าสู่ Excel 2016 เป็นต้นไป Power Query จะถูกผนวกรวมเข้ามาในตัวโปรแกรมโดยอัตโนมัติแล้ว ทำให้สะดวกและง่ายต่อการใช้งานมากขึ้น โดยผู้ใช้สามารถเข้าถึงฟีเจอร์นี้ผ่านแท็บ "Data" แล้วเลือกกลุ่มคำสั่ง "Get & Transform Data" ซึ่งทำให้การเชื่อมต่อกับข้อมูลหลายแหล่งเป็นเรื่องง่ายขึ้น รวมถึงการจัดการข้อมูลและการแปลงข้อมูลด้วยขั้นตอนอัตโนมัติ สำหรับ Excel เวอร์ชันล่าสุดอย่าง Microsoft 365, Excel 2019 และ Excel 2021 Power Query ได้รับการปรับปรุงให้รองรับฟีเจอร์ใหม่ ๆ เช่น การรีเฟรชข้อมูลอัตโนมัติที่ช่วยให้ข้อมูลของคุณสดใหม่เสมอ รวมถึงการทำงานร่วมกับ Dynamic Arrays และ M code ที่ยืดหยุ่นขึ้นช่วยให้คุณเขียนสูตรที่ซับซ้อนได้อย่างมีประสิทธิภาพมากขึ้น อย่างไรก็ตาม หากใช้ Excel Online บนเว็บ ปัจจุบันยังไม่รองรับการแก้ไข Query อย่างเต็มรูปแบบ แต่สามารถอ่านข้อมูลบางส่วนได้เท่านั้น ดังนั้น หากต้องการใช้ฟีเจอร์ Power Query อย่างเต็มที่ แนะนำให้ใช้งานผ่านโปรแกรม Excel บนเครื่องเดสก์ท็อป สุดท้ายนี้ หากคุณไม่แน่ใจว่า Excel ของคุณมี Power Query หรือไม่ คุณสามารถเช็คได้โดยการเปิดโปรแกรม Excel ไปที่แท็บ "Data" จากนั้นดูในกลุ่มคำสั่ง "Get & Transform Data" ถ้ามีแสดงว่า Power Query พร้อมใช้งานอยู่แล้ว ซึ่งจะช่วยให้คุณเริ่มต้นวิเคราะห์และจัดการข้อมูลได้อย่างมีประสิทธิภาพทันที หากต้องการเรียนรู้ Power Query อย่างเป็นระบบ หลักสูตรเวิร์กช็อปเฉพาะทางก็เป็นตัวเลือกที่ดี ที่จะช่วยให้คุณเชี่ยวชาญฟีเจอร์นี้และเพิ่มศักยภาพการทำงานกับข้อมูลใน Excel ได้อย่างเต็มที่

Related posts

Excel import magic
Excel magic at its finest. Import data from picture whether it’s a photo from your phone or a screenshot. #tutorial #exceltips #exceltricks #exceltraining #exceltutorial
Excel tips at XecuteTheVision

Excel tips at XecuteTheVision

363 likes

Spring Semester Setup - Step by Step 🩷
Hey loves, sorry for your extensive wait, my semester has started back and I has to of course get back into “school/focus mode”, anyways here’s the anticipated tutorial on how I setup and customized my MacBook for spring semester! 1. Download Google Chrome! YOU NEED Google chrome, no other way
Juuuuu ✨

Juuuuu ✨

2804 likes

RANDBETWEEN() Function in Excel
How to use RANDBETWEEN() Function in Excel #excel #exceltips #exceltipsandtricks #exceltutorial #microsoftexcel
DataUnleash

DataUnleash

0 likes

Free certifications that shine on your LinkedIn
1. AWS Cloud Practitioner Essentials (Free Intro Course) - What It Covers: Cloud computing basics, AWS services, and pricing models. - Why It’s Valuable: Provides foundational knowledge in cloud computing and AWS. 2. Microsoft Azure Fundamentals (Free Learning Path) - What It C
vedha | career tips (tech) 👩‍

vedha | career tips (tech) 👩‍

2185 likes

How to ace Microsoft Certifications
Hello everyone! I’ve now taken almost 4 Microsoft Certification Exams in the past year and wanted to share tips on how to ace these certifications! To excel in Microsoft certifications, a combination of Microsoft Learn and Udemy courses can be highly effective. Or, if you can find other online c
Yun Jung

Yun Jung

1778 likes

Check out this Al tool that will help you pass almost any interview. #youdotcom #aitools #wfhjobs #interviewprep #wfhjobshiring #CapCut
WFH

WFH

2610 likes

4 FREE Data Science Courses For Your Career
ლ(╹◡╹ლ) Offering free data science courses is vital for students aiming to secure internships and jobs as it democratizes access to essential skills. In today's data-driven world, proficiency in data science is highly sought after across industries. By providing these courses at no cost, educa
Anonxdata

Anonxdata

1782 likes

How to Find Cube of any Numbers in Excel
How to Find Cube of any Numbers in Excel #excel #exceltips #exceltricks #exceltutorial #microsoftexcel
DataUnleash

DataUnleash

0 likes

6 Free Online Certifications to Boost Your Resume
6 Free Online Certifications to Boost Your Resume Hi, lemons! Getting certified in in-demand skills can help you stand out in the job market and advance your career. Free online certifications allow anyone to build knowledge and credentials without expensive courses. So, let's explore 6 of t
Lifestyle Babe

Lifestyle Babe

9569 likes

Leveling up my skills!🚀
I’ve decided to take the plunge and enroll in 3 amazing courses on edX to grow both personally and professionally. 💻✨ If you’re not familiar with edX, it’s an online learning platform offering courses from top universities like Harvard, MIT, and more. You can access world-class education, earn c
Char

Char

4590 likes

Excel org chart
Tab your way to an org chart in excel #exceltricks #tutorial #exceltutorial #excel #exceltraining #fyp #spreadsheet
Excel tips at XecuteTheVision

Excel tips at XecuteTheVision

32 likes

How to Square Numbers in Excel
How to Square Numbers in Excel #exceltips #exceltutorial #exceltricks #excel #microsoftexcel
DataUnleash

DataUnleash

1 like

10 Remote Jobs You Can Do At Night 🌙
Many people are now actively engaged in legitimate online night jobs. For those of you with kids, monitoring them and being productive at work can be super hard. Finding a flexible online night job might be the ideal answer. Top Companies That Offer Flexible Online Night Jobs 1. Wordvice 📚
Pradeep M

Pradeep M

20.4K likes

Here are a few job websites for remote work outside the US. # #digitalnomads # #escapetheusa # #remotework # #workfromanywhere
Escape the USA

Escape the USA

37 likes

How to Calculate Square Root in Excel
In this video, I will be explaining how to Estimate Square Root in Excel #excel #exceltips #exceltricks #exceltutorial #microsoftexcel
DataUnleash

DataUnleash

0 likes

Senior Tier 2 (Remote)
#momsoflemon8 #jobs #fyplemon #beauty #content
WFH Remote Empire👩‍💻

WFH Remote Empire👩‍💻

32 likes

8 Free Online Certifications to Boost Your Resume
Hi, lemons! In today's competitive job market, having the right certifications can make a significant difference in showcasing your skills and expertise. Online certifications are not only convenient but also cost-effective. Here are six free online certifications that can give your resume a va
Lifestyle Babe

Lifestyle Babe

1214 likes

Excel pdf button
Add a PDF button right to your Excel file #excel #tutorial #exceltips #exceltricks #spreadsheet xecutethevision dot com
Excel tips at XecuteTheVision

Excel tips at XecuteTheVision

41 likes

I saw this and thought its a great resource to share to all of my VA residents who receive SNAP benefits the state added more certificate and degree programs you can take for free!! We all talk about having student loan debt, this is a great opportunity to get that certificate/degree WITHOUT th
Talisha Chonece

Talisha Chonece

245 likes

Immigrant Career Roadmap: Courses That Lead tojobs
Not sure what to study as an immigrant? Start here! From quick-entry jobs like IT Support and Healthcare to long-term careers in Cybersecurity, Nursing, and Tech, this roadmap shows which courses give real results. Plan smart, gain skills, and land that first job faster! #ImmigrantSuccess
NkemLifeStyle

NkemLifeStyle

0 likes

21 Microsoft Hacks for work! 🫶
Knowing some cool Microsoft hacks can seriously level up your office game. From mastering Excel shortcuts to using OneNote for quick notes, these tricks save you time and make you look like a pro. Imagine breezing through reports or creating snazzy presentations in PowerPoint with half the effort.
corporatespirit

corporatespirit

901 likes

HOW I LIST MULTIPLE LINES IN ONE CELL - EXCEL
I've discovered how to list out several items by line in a single cell by using the Alt-Enter key shortcut. I can now structure my spreadsheet in a more ideal way with this ability, and keep data that belongs together in the correct rows. I select the cell I want and type the first item. Then,
Peyton’s Place

Peyton’s Place

406 likes

How to use NOT Function in Excel
In this video, I will be explaining in details how to use NOT Function in Excel #excel #exceltips #exceltraining #exceltutorial #microsoftexcel
DataUnleash

DataUnleash

1 like

my first post 🍋
Digital products you can sell #makemoney #digitalproduct #simplesidehustle #simplesidehustles #digitalfreebie #digitalfreelancer
Sarah

Sarah

225 likes

EXCEL SHORTCUTS PART 3
As requested, here is another excel shortcut post! Discovering the power of Excel shortcuts has been a game-changer for my productivity at work. These little keystrokes might seem insignificant, but they're the key to working smarter, not harder. From navigating vast datasets quickly to instant
Peyton’s Place

Peyton’s Place

331 likes

Resume Language for the Admin Assistant girlies!
Having the right resume language is key because it’s your first impression on paper. Using the right words makes your skills and experiences stand out, showing employers you're the best fit for the job. It's like dressing up your resume in its best outfit. Clear, strong language highlights
corporatespirit

corporatespirit

1441 likes

#workfromhome #wfhjobs #nonphoneworkfromhomejobs #claims #remotejobs
Arialle Tate

Arialle Tate

14 likes

Orchid’s Query🌸
I love books where the smut adds flavor to the storyline instead of being the center of the story if you know what I mean.! And Jas B. Executes it very well each time. I enjoyed this read. Took only a day to eat it right on up 😂 Query is now apart of my list of book bae’s because honestly he almost
Fran🩷

Fran🩷

4 likes

Looking for a non-phone healthcare job that actually pays well? 👀 Signature Performance is hiring for a Patient Financial Services Specialist — full-time, remote, and paying $22/hr with outbound calls only when needed 🙌🏽 Keep watching for résumé keywords to help you land that interview 💼 #workfr
Arialle Tate

Arialle Tate

18 likes

Follow & Comment “REMOTE” & I’ll send you 10 more remote jobs like this ⬇️ #remotejob #remotejob2024 #remotejobsathome #remotejobsdaily #remotejobsearch2024 #remotejobshiring #wfhjobshiring2024 #wfhjobshiringnow #wfhjobshiring #remotejobopportunities
Remote Job Find

Remote Job Find

16 likes

5 Free Online Certifications to Boost Your Resume
Hi, lemons! In today's competitive job market, having a standout resume is crucial. Employers seek candidates with not only relevant experience but also a commitment to continuous learning. Fortunately, the digital age offers a wealth of free online certifications that can enhance your skill se
Lifestyle Babe

Lifestyle Babe

742 likes

Data entry WFH JOB
#wfh #workfromhome #workathome #workfromanywhere #remotework
TheREALWfhCali

TheREALWfhCali

97 likes

Excel meeting agenda
Whip up a meeting agenda real quick using excel #exceltips #excel #exceltricks #exceltraining #tutorial
Excel tips at XecuteTheVision

Excel tips at XecuteTheVision

27 likes

Microsoft office PowerPoint and excel classes
#lemon8diarychallenge it’s so important to have knowledge of computers. I have learned so much Yes I go to Saturday classes I will be posting a pic of all my certificates because I want to become a Medical Assistant. #freeclasses #free #nyc #education #motivation They als
Carii try’s

Carii try’s

9 likes

MICROSOFT TEAMS TIPS & TRICKS
Maximizing your productivity with Microsoft Teams goes beyond the basics. Here are some tips to elevate your Teams experience: Pinning a Message: Keep important messages at the forefront by pinning them. Simply right-click on a message and select "Pin," ensuring crucial information rem
Peyton’s Place

Peyton’s Place

479 likes

Excel File Overwritten? Get It Back in Seconds!
Accidentally saved over your spreadsheet? Relax — recovery it simpler than you think. This video shows you how to restore your Excel files. Save your important data fast! 🚀 #excel #recovery #deleted #file
TechEase

TechEase

0 likes

HOW I FREEZE THE TOP ROW IN EXCEL
The ability to freeze that first row of my column headers has been a lifesaver, allowing me to scroll through thousands of rows of data without losing sight of my column headers/fields. By simply selecting the row below the one you want to freeze, heading to the "View" tab, and clicking
Peyton’s Place

Peyton’s Place

105 likes

No Phones Remote Job Hiring Now!
This remote job with Conduent is hiring for $19-$20 per hour! To apply click the link in my bio! Follow for more remote job leads! #remotejobs #remotejob #workfromhomemom #workfromhomejob #makemoneyfromhome #hiring
Wfhdiva

Wfhdiva

516 likes

How to Convert from Gallon to Liter using Excel
In this video, I will be explaining how to convert from Gallon to Liter using Excel #exceltips #excel #exceltutorial #microsoftexcel #conversion
DataUnleash

DataUnleash

0 likes

Common Excel Errors
Comment “EXCEL” and I will DM you my Excel Shortcuts Cheat Sheet #excel #exceltips #exceltricks #microsoftexcel #spreadsheets #exceltraining #learnexcel
Grant Huang

Grant Huang

10 likes

Learn programming for free 👩‍💻
1. FreeCodeCamp - Languages: JavaScript, Python, SQL, HTML/CSS, and more. - Hands-on Projects: FreeCodeCamp is project-driven, meaning as you go through the curriculum, you'll build real-world applications like weather apps, portfolio websites, and data visualization projects. The full-
vedha | career tips (tech) 👩‍

vedha | career tips (tech) 👩‍

602 likes

Microsoft Access
Taking computer classes? let me do it for you. Microsoft Access Microsoft Word Microsoft Excel Microsoft PowerPoint #onlineclass #studyhacks #student #college #fyp
writehw

writehw

0 likes

Prompts for Excel📊
#MicrosoftExcel #ExcelTips #ExcelSkills #ExcelFormulas #DataAnalysis
POSH🌸

POSH🌸

4 likes

Top tools used as Business Analysts
Hello everyone! Business analysts rely on a variety of tools to gather, analyze, and visualize data to inform decision-making. Some top tools include SQL, Excel and Python for data manipulation and analysis, Tableau/Power BI for data visualization, and JIRA for project management and collaboration.
Yun Jung

Yun Jung

27 likes

FREE Online Certifications To Boost Your Resume!
10 BENEFITS of free online certifications: 1. Accessibility: Online certifications offer learning from anywhere with internet access 2. Flexibility: Study at one's own pace, fitting around existing commitments 3. Affordability: Often cheaper than traditional courses, making education more ac
Riyla Robinson

Riyla Robinson

3929 likes

Data analyst - what to study? 📚
Becoming a data analyst requires mastering a mix of technical, analytical, and communication skills. Here are five essential areas to study: 1. Data Analysis Tools and Software - Excel: Learn advanced features like pivot tables, VLOOKUP, and data visualization. - SQL: Master database querying t
vedha | career tips (tech) 👩‍

vedha | career tips (tech) 👩‍

1482 likes

See more