Automatically translated.View original post

Put the image in Excel.

4/17 Edited to

... Read moreผมได้ลองใช้ฟังก์ชัน IMAGE ใน Excel เพื่อใส่รูปภาพโดยตรงลงในเซลล์ และพบว่าเป็นวิธีที่รวดเร็วและมีประสิทธิภาพมาก ในการทำงานกับไฟล์ที่มีรูปจำนวนมาก ก่อนหน้านี้มักเก็บรูปภาพไว้แยกไฟล์หรือลงเป็นวัตถุรูปภาพซึ่งทำให้ไฟล์ Excel มีขนาดใหญ่และโหลดช้า การใช้สูตร =IMAGE("URL") ตัวอย่างเช่น =IMAGE("https://example.com/image.jpg") ช่วยให้รูปภาพแสดงผลในเซลล์ทันทีโดยไม่ต้องใส่ไฟล์รูปภาพลงในเอกสารโดยตรง นอกจากนี้ยังสามารถปรับขนาดรูปภาพในเซลล์ได้ด้วยการเพิ่มพารามิเตอร์ sizing, height, และ width ช่วยให้จัดวางรูปให้พอดีกับเซลล์ตามต้องการได้อย่างยืดหยุ่น ยิ่งไปกว่านั้น การใส่คีย์เวิร์ดเช่นคำอธิบายรูปภาพผ่านพารามิเตอร์ alt_text จะช่วยให้ไฟล์มีความหมายชัดเจนและช่วยเรื่องการค้นหาข้อมูลด้วย ฟังก์ชัน IMAGE นี้ช่วยลดปัญหาเรื่องขนาดไฟล์ใหญ่และทำให้ Excel ทำงานรวดเร็วขึ้น แม้ใส่รูปจำนวนมาก เหมาะมากกับคนที่ต้องจัดทำรายงาน หรือสรุปงานที่มีรูปประกอบเยอะๆ การใช้งานก็ง่ายเพียงแค่คัดลอกลิงก์รูปภาพจากเว็บ หรือแหล่งเก็บรูปออนไลน์ แล้วใส่ลงในสูตรตามขั้นตอนที่แนะนำในบทความ เท่านี้ก็ได้งานที่ดูดีเป็นมืออาชีพ พร้อมแชร์เทคนิคนี้ให้กับเพื่อนร่วมงานหรือทีมได้เลย

Related posts

Excel shortcuts every student should know! 👩🏻‍💻
Stop Wasting Time: Master These Excel Formulas for Maximum Efficiency! 🕒 If you’ve ever struggled with Excel, mastering formulas can seriously up your game. Here’s a breakdown of the essentials that’ll make you look like a pro 1.Core Calculation Formulas 🧮 These are the basics you can’t live
emilie.studygram

emilie.studygram

1175 likes

Excel vs Word
Excel formatting does the same thing as many people using Word #tutorial #exceltips #exceltricks #exceltutorial #exceltraining #worktips #alwayslearning
Excel tips at XecuteTheVision

Excel tips at XecuteTheVision

4938 likes

A laptop displays an Excel spreadsheet with charts and data, while a hand interacts with the trackpad. The image features text overlay "Excel shortcuts cheat sheet" and "SWIPE FOR MORE," indicating a guide to Excel shortcuts.
This image lists four essential Excel shortcuts: Autosize Columns (Alt + H + O + I), AutoSum (Alt + =), Display formula in cells (Ctrl + ~), and Insert Current Date (Ctrl + ;). It is part of a multi-page guide.
This image presents four more Excel shortcuts: Insert Hyperlink (Ctrl + K), Freeze Rows & Columns (Alt + W + F + F + F), Fill Down / Fill Right (Ctrl + D and Ctrl + R), and Paste Special - Values (Alt + E, S, N).
Excel shortcuts every student should know! 👩🏻‍💻
Excel shortcuts can significantly improve your efficiency and productivity when working with spreadsheets. Here are some powerful Excel shortcuts that everyone should know. These shortcuts can save you a lot of time and make working with Excel more efficient. Practice using them regularly to become
teal.days

teal.days

2718 likes

Name cells in excel
Customize and store headings in Excel #exceltips #tutorial #exceltraining #exceltricks #exceltutorial #excelforbeginners #learn Takw my Excel class xecutethevision.com#onthisday
Excel tips at XecuteTheVision

Excel tips at XecuteTheVision

31 likes

An outdoor dining scene with people seated at tables, featuring the overlaid text "Freeze the Top Row in Excel." A purple glass is visible in the foreground on a black mesh table.
A light beige background with black text asking, "Do you ever have hundreds of rows of data and when scrolling down, you loose sight of the column header and forget which column/field is which?"
A light beige background with black text stating, "This is when freezing your top row is crucial! I will show you how!"
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

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

Excel list comparison 🌸
So we have to use something called Planbook at work (Teacher). I think this will make me want to actually use it more, and I can see me changing it again before second semester begins lol. How cute is this?! I’d usually do random colors, but love the pink & green combo. #Planbook #
Hey 😁

Hey 😁

4403 likes

How to get an A in A&P
I think anatomy is such a fun class to take… but is often hated (by most) due to the amount of material that is required to learn - and memorize! - in such a short amount of time. Here are my tips and tricks that I’ve used throughout this semester that has allowed me to get 100% on all of my an
Renee 🩵🦆

Renee 🩵🦆

2833 likes

A PS5 dashboard is displayed on a monitor, with a Steam Deck and keyboard below. The image is titled "How to put your own image for your ps5 background!".
A phone screen shows "STEP 1: Download image" with a Google search for "Akame Ga Kill Wallpaper". Below, "STEP 2: Go to PS app" points to the PlayStation App icon.
A phone screen displays a chat interface. "STEP 3: Find the chat button" points to a chat icon, and "STEP 4: Send your image" points to a sent image within a conversation.
How to put your own image for your ps5 background!
I saw someone do this a while ago on TikTok but haven’t seen it mentioned much here. I figured it would be nice to share! I hope this tutorial was easy to understand but if not, feel free to ask questions down below! #tech #techtutorial #customization #ps5 #tutorial
Larissa📖🎮

Larissa📖🎮

420 likes

Excel signature
Yes a handwritten signature imported in excel #exceltips #exceltricks #exceltraining #exceltutorial #excel
Excel tips at XecuteTheVision

Excel tips at XecuteTheVision

176 likes

100 Excel Tips
100 Excel Tips The best Shortcuts, Formulas, Formatting & Advanced Tips Bookmark this, you'll save 1,000 of hours! A list of tips that all professionals need. Here is a preview: ⌨️ Shortcuts 1. How to hide a column? Ctrl + 0 2. How to hide a row? Ctrl + 9 3. How to
ExpressoSolut

ExpressoSolut

1429 likes

Excel differences in columns
Find the differences between these columns in Excel with these Excel tricks #excel #exceltraining #exceltips #excel _learning #tutorial #excel_learning #excelforbeginners #fyp
Excel tips at XecuteTheVision

Excel tips at XecuteTheVision

36 likes

100 Excel Shortcuts
#excelshortcuts #excelformulas #exceltips
LouiseAnn1960

LouiseAnn1960

744 likes

Save these Useful Excel Shortcuts!
Hey everyone! Excel shortcuts are super helpful for getting things done faster and smoother. They range from simple tricks for moving around your spreadsheet to more advanced ones for formatting and data manipulation. Mastering these shortcuts can really save you time and make you more efficient! I
Yun Jung

Yun Jung

295 likes

Count in excel
Count the number of times an item appears in a column or list in excel #tutorial #exceltricks #excel #exceltips #exceltraining #fyp #onthisday
Excel tips at XecuteTheVision

Excel tips at XecuteTheVision

32 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

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

Why use SQL/Python for Data Analysis, (not excel?)
Hello everyone! SQL and Python are favored over Excel for data analysis due to their efficiency with large datasets and automation capabilities. Python, using libraries like Pandas, ensures reproducible workflows, while SQL handles complex data manipulations with ease in relational databases. Pytho
Yun Jung

Yun Jung

90 likes

6 Free Accounting Skills to Put on Your Resume✨
These are real accounting skills you can learn for FREE and every single one deserves to be on your resume. No degree required. Just Wi-Fi and consistency. 📌 Sage Accounting Course – sageu.com 📌 QuickBooks Certification – quickbooks.intuit.com 📌 Excel Tutorials – Search “Excel accounting tuto
SJ | Corporate Girlie

SJ | Corporate Girlie

405 likes

Excel formatting tips
Excel formatting tips #tutorials #excel #excelforbeginners #exceltraining
Excel tips at XecuteTheVision

Excel tips at XecuteTheVision

153 likes

Useful Excel Formulas to save your time at work!
Hey everyone! Excel formulas are awesome for speeding up calculations and analyzing data. They range from simple math stuff to more complex tasks like searching and matching data. Learning these formulas can make your work easier and help you get more done in less time. Try out online tutorials and
Yun Jung

Yun Jung

868 likes

Project timeline using excel
Project timeline how to using excel #projectmanagement #excel #exceltricks #exceltutorial #tutorials
Excel tips at XecuteTheVision

Excel tips at XecuteTheVision

11 likes

Excel cheatsheet:5/20, one page equals a book
https://hf.datarails.com/ #excel -sheets 💅🏾🏙️📜🧐🤔🤨😀🤩💋👌🏾👄
SMARTSista™️

SMARTSista™️

2 likes

Excel Cheatsheet: 7/20:the ultimate excel shortcut
I discovered this amazing Excel Cheat Sheet that's been a game-changer for me. It's like having a secret weapon in my academic arsenal. 🧠 #excelspreadsheets #cheatsheet #dataanalytics
valder

valder

183 likes

Excel ABC
Excel shortcuts are easy to remember with cheat sheets like the ABC’s. These are some of the most common shortcuts to use. #excel #exceltraining #exceltips #exceltricks #excelpro #alwayslearning
Excel tips at XecuteTheVision

Excel tips at XecuteTheVision

33 likes

Excel interview tips
Excel interview tips #exceltips #interviewtips #exceltraining #excel #business
Excel tips at XecuteTheVision

Excel tips at XecuteTheVision

17 likes

Excel quick search tabs instead of scrolling trick
Excel quick search tabs instead of scrolling trick #tutorial #exceltips #exceltricks #excel _learning #exceltraining #learn #excelforbeginners #fyp
Excel tips at XecuteTheVision

Excel tips at XecuteTheVision

18 likes

Monthly Calendar Spreadsheet Excel & Google Sheets
Plan your entire month in one clean spreadsheet. This monthly calendar template helps you organize appointments, goals, reminders, and tasks without switching between apps. Works in Excel and Google Sheets, so you can plan wherever you prefer. Just download once, open it, and start organizing yo
Loving.Templates

Loving.Templates

0 likes

Blank EXCEL template for school nurses!
As a school nurse this isn’t perfect but I wanted to share it anyways. It is a BLANK excel template for students with health conditions. Just click and request access. Is there any other templates you’d like to have access to or need ? 1. Click my link tree in my bio!!! Click on drop down arrow
Officialtiktoknurse

Officialtiktoknurse

40 likes

Excel cheat sheet
Excel cheat sheet #excel #exceltips #exceltricks #exceltraining #tutorials #excel_learning
Excel tips at XecuteTheVision

Excel tips at XecuteTheVision

14 likes

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

DataUnleash

0 likes

Excel signature
Handwritten signature in Excel #tutorials #excel #excelforbeginners #exceltraining #exceltips
Excel tips at XecuteTheVision

Excel tips at XecuteTheVision

8 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

A computer screen displays Canva's 'Bulk Create' feature, showing how to add data to quickly generate multiple designs. The screen highlights the purpose of the tool for creating hundreds of pages from data sources.
This image illustrates the first two steps of Canva's Bulk Create: choosing a template from various Instagram post options and importing data into a table with fields like title, subtitle, and image.
The image shows the final steps of Canva's Bulk Create: linking imported data fields (title, subtitle, image) to design elements, and then generating multiple personalized designs, exemplified by two flower-themed posts.
Make multiple posts on Canva w/ 4 steps!
Hey content designers! 🎨 Did you know you can save tons of time by using Canva’s Bulk Create feature? Whether you're working on social media posts, invitations, or illustrations, this tool is a game-changer for making multiple designs with ease. Here’s how it works: 1️⃣ Choose Your Templa
Ivyhoneyhive

Ivyhoneyhive

163 likes

Excel's Most Powerful Trick-Ctrl+E
📊 Welcome to Our Excel Mini-Class! 🚀 In today’s session of the Boost Your Excel Skills series, we’re unlocking the magic of Ctrl+E—your new best friend for saving time! ⏳ Whether you’re working with big datasets or just need to clean up information, this shortcut will help you instantly fill in
WPS Office

WPS Office

150 likes

How to subtract hours and format time in excel
How to subtract hours using Excel. Format time with this excel tip. #excel #exceltips #exceltricks #tutorial #exceltraining
Excel tips at XecuteTheVision

Excel tips at XecuteTheVision

39 likes

Excel data cleaning tools
🧹🧼 Clean it up with these 3 excel data cleaning tricks #tutorial #exceltips #exceltricks #exceltutorial #excel #business
Excel tips at XecuteTheVision

Excel tips at XecuteTheVision

22 likes

Excel at the toughest premed classes! ✨
If you talk to any student who has completed their degree, with a premed major, there is a common three most difficult courses: Anatomy and physiology Organic chemistry Physics Across-the-board, these classes seem to be the ones that give students the most grief and require the most
bea_studies_PA

bea_studies_PA

28 likes

1/3: Ultimate Excel Cheatsheet You Should Know
Hey there, I've got just the right boost for your Excel game. 🌟 📝 The Journey from Junior to Senior: My Excel Cheatsheet Chronicles I've been there, struggling with the basics and wondering how to climb the Excel ladder. But fear not, because I've distilled my journey into a one-p
Valder

Valder

528 likes

Excel Spreadsheet & Google Sheets Template
Most businesses lose money and time because they forget renewals, licenses, and subscriptions. This template helps you stay fully organized: ✔ Track all expiration dates ✔ Assign renewal owners ✔ Avoid missed deadlines ✔ See everything in one dashboard Built for Excel & Google Sheets.
Loving.Templates

Loving.Templates

1 like

How to Multiply Numbers in Excel
In this video, I will be explaining how to Multiply Numbers in Excel #exceltips #exceltricks #exceltraining #exceltutorial #excel
DataUnleash

DataUnleash

0 likes

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

DataUnleash

1 like

How to use PRODUCT Function in Excel
How to use PRODUCT Function in Excel #excel #exceltips #exceltricks #exceltutorial #microsoftexcel
DataUnleash

DataUnleash

0 likes

Unlock Excel's Secret Weapon with One Shortcut! ✨
💫 Welcome to Our Excel Mini-Class! 🥳 Today's session is all about the magic of Ctrl + E ! Are you tired of manually filling in data or looking for a faster way to complete tasks? Well, I've got you covered with a quick tip that'll make you a productivity pro. 💼✨ With Ctrl + E , you
WPS Office

WPS Office

421 likes

An office cubicle desk with a computer monitor, keyboard, and various personal items, including framed photos and plants. Overlay text reads 'How to List Items within one Cell in Excel', introducing a productivity tip.
A screenshot of Microsoft Excel showing a cell with '1) hello'. Text explains that pressing 'Enter' moves to the next cell, and introduces the 'ALT - Enter' shortcut to add a new line within the same cell.
A simplified Excel view demonstrating a single cell containing a multi-line list: '1) hello', '2) Hi', '3) Howdy'. Text confirms this is the result of using 'Alt - Enter' to create a list of steps within one cell.
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

Excel drop it function
Remove columns and rows using drop in excel. #exceltips #excel #exceltutorial #businesstips #business #tutorial #boss #spreadsheet
Excel tips at XecuteTheVision

Excel tips at XecuteTheVision

20 likes

Lock excel down
BEFORE sharing excel files review which cells allow edits #exceltricks #tutorial #excel #exceltraining #fyp #exceltips #business
Excel tips at XecuteTheVision

Excel tips at XecuteTheVision

25 likes

Excel projects with a Gantt chart
Auto populate the Gantt style chart with name and color #template #excel #tutorial #friday #exceltips
Excel tips at XecuteTheVision

Excel tips at XecuteTheVision

11 likes

See more