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

A tablet displays an Excel wedding budget spreadsheet on a desk with notes and a planner. The image is titled 'Stop Struggling with Excel Learn These Super Easy Formulas'.
This image details core Excel calculation formulas: SUM, AVERAGE, MIN, and MAX. Each function is explained with an example Excel table showing its application and purpose.
This image explains Excel's reference formulas, VLOOKUP and HLOOKUP. It provides examples with tables demonstrating how to search and retrieve data vertically and horizontally, along with usage tips.
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

1181 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

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

4948 likes

A vibrant graphic titled 'USEFUL EXCEL FORMULAS' in green, overlaid on a spreadsheet displaying various charts, data tables, and financial figures. The image includes 'Career | Lemon 8' branding and a 'SWIPE' indicator.
A laptop screen showing code, with a text box explaining the 'VLOOKUP' Excel formula. It defines its function for searching large datasets and provides a detailed example. The image is branded 'Career | Lemon 8 | Yun Jung'.
A text box on a wooden desk with a laptop, smartphone, and coffee cup, explaining 'SUMIF & SUMIFS' Excel formulas. It defines their use for adding cells based on conditions and provides a SUMIF example. The image is branded 'Career | Lemon 8 | Yun Jung'.
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

872 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 😁

4458 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📖🎮

473 likes

ANALYZE DATA - EXCEL TOOL
Excel's Analyze Data Tool is a game-changer, simplifying the way you work with data. Say goodbye to the days of laboriously creating tables and charts and struggling with formatting intricacies. This tool automates the process, making data analysis and visualization effortless. With just a f
Peyton’s Place

Peyton’s Place

252 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

100 Excel Shortcuts
#excelshortcuts #excelformulas #exceltips
LouiseAnn1960

LouiseAnn1960

746 likes

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

Excel tips at XecuteTheVision

188 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

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

72 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

372 likes

Excel vs Word #excel #exceltricks #exceltips #exceltutorial
Excel vs Word #excel #exceltricks #exceltips #exceltutorial
Excel tips at XecuteTheVision

Excel tips at XecuteTheVision

406 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

32 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

1435 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

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

296 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

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

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

Excel tips at XecuteTheVision

18 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

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

411 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

332 likes

How to Delete Rows in Excel Easily using Just your Keyboard
How to Delete Rows in Excel instantly using just your Keyboard #excel #exceltips #exceltricks #exceltutorial #microsoftexcel
DataUnleash

DataUnleash

1 like

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 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

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

DataUnleash

0 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

How to Create a Pie Chart in Excel
How to Create a Pie Chart in Excel #excel #exceltips #exceltutorial #exceltipsandtricks #microsoftexcel
DataUnleash

DataUnleash

0 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

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

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 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

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

Excel tips at XecuteTheVision

14 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

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

A Google Sheets dashboard titled 'Cost Splitter Dashboard' with financial summaries for multiple individuals. Large text overlay reads 'GOOGLE SHEETS HOW TO ADD IMAGES'.
A Google Sheets screenshot showing the 'Insert' menu with 'Image' highlighted, demonstrating the first step to add images. The text overlay says '1. INSERT > IMAGES'.
A Google Sheets screenshot showing the 'Image' submenu with 'Insert image in cell' and 'Insert image over cells' highlighted. The text overlay says '2. INSERT IMAGE IN CELL OR INSERT IMAGE OVER CELLS'.
👇🏻How I add images in Google Sheets
First Method: 💻 1. Copy and Paste OR Second Method: 🖥️ 1. Go to Insert > Images 🖼️ 2. Insert images ✅ 3. Upload and browse for image from computer These are the steps on a laptop and steps for the Google Sheets App are slightly different but I’ll bring sharing more tips on using
TheHappyPlanner

TheHappyPlanner

286 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

HOW I CREATE SPARK-LINES IN EXCEL
What is a sparkline? A sparkline is a small, simple, data-intense graphical representation typically used in line with text to show trends, variations, or patterns in data at a glance. Creating a sparkline in excel is pretty simple. I highlight a range of horizontally organized data and go into
Peyton’s Place

Peyton’s Place

319 likes

Sequence in excel or google sheets
The =SEQUENCE function in Google Sheets is a game changer for generating numbers automatically. No more typing rows manually. In this quick tutorial I’ll show you how it works and how you can use it in real projects. #googlesheets #exceltips #spreadsheettips #googlesheetstricks #datame
Sireen | Data Mentor

Sireen | Data Mentor

7 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 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

0 likes

The image displays a laptop, a lit candle, and a lamp on a bedside table, with a mirror reflecting a bed. Overlay text reads "Changing Axis Colors in Excel" and "SWIPE," indicating a tutorial.
This image presents an Excel bar chart titled "Actual" showing monthly data from May to September. The Y-axis, representing percentages, has the "5%" label highlighted in red, demonstrating a custom axis color. Text asks how to achieve this effect.
The image shows a screenshot of the Excel "Format Axis" pane, focusing on the "Number" section. It illustrates selecting "Custom" category and entering a format code like "[Red][=0.05]0%;0%;0%" to color a specific percentage value on the axis.
HOW I CHANGE AXIS COLORS IN EXCEL
In my search for more dynamic and visually impactful data representation, I found a powerful feature in Excel – the Format Axis Number Custom Format Code option. This tool allows me to not only present numerical data but also customize the display to highlight specific values. The ability to chang
Peyton’s Place

Peyton’s Place

64 likes

How to Find Cube Roots in Excel
How to Find Cube Roots in Excel #excel #exceltips #exceltricks #exceltutorial #msexcel
DataUnleash

DataUnleash

0 likes

Excel Trick:Create an Interactive Project Tracker😎
✨ Welcome to Our Excel Mini-Class! ✨ Hey Excel Pros!😉 Want to take your project management skills to the next level? Want to stay organized and on top of your projects like a true professional? Let's create a super simple yet interactive project tracker in Excel that'll keep you focused
WPS Office

WPS Office

6 likes

How to Filter in Excel
In this video, i will be explaining in detail how to Filter in Excel #excel #exceltips #exceltipsandtricks #exceltutorial #microsoftexcel
DataUnleash

DataUnleash

0 likes

See more