Lemon8Lifestyle community

Automatically translated.View original post

Excel Data Mast
Excel Data Mast

25.6K followers

Follow
Follow
Follow

14 saved
19

❌ Don't draw by yourself

2025/7/31 Edited to

... Read moreถ้าเป้าหมายคือ “ทำป้ายใน Excel” ให้ดูเป็นงานพรีเซนต์/รายงานแบบมืออาชีพ สิ่งที่ทำให้ดูโปรขึ้นทันทีคือการใส่โลโก้บริษัทลงไปในตาราง โดยไม่ต้องไปวาดหรือแปะรูปทีละไฟล์ค่ะ วิธีที่ฉันใช้บ่อยคือให้ Excel ดึงโลโก้มาแสดงอัตโนมัติในเซลล์ด้วยฟังก์ชัน IMAGE (บน Microsoft 365 / Excel เวอร์ชันที่รองรับ) 1) เตรียมตารางสำหรับทำป้าย - คอลัมน์ A: ชื่อบริษัท (เช่น Microsoft, Apple, Google, Facebook, Netflix, TikTok, Instagram) - คอลัมน์ B: เว็บไซต์โดเมนของบริษัท (เช่น microsoft.com, apple.com) - คอลัมน์ C: โลโก้ (ให้ Excel สร้างให้) ทริคคือ “โดเมน” จะทำให้ดึงโลโก้ได้ตรงกว่าใส่แค่ชื่อบริษัท เพราะชื่อซ้ำกันได้ 2) ใส่สูตรโลโก้แบบเร็ว (ใช้ CONCAT) ถ้าคอลัมน์ B เป็นโดเมน ให้ใส่ใน C2 ประมาณนี้: =IMAGE(CONCAT("https://logo.clearbit.com/",B2)) แล้วลากลงทั้งคอลัมน์ โลโก้จะโผล่มาเองในแต่ละแถว เหมาะมากเวลาทำรายชื่อบริษัท/ทำป้ายใน excel แบบหลายรายการ 3) ตั้งค่าขนาดให้เหมาะกับ “ป้าย” เวลาโลโก้ใหญ่/เล็กไม่เท่ากัน ฉันจะปรับความสูงแถว (Row Height) ให้เท่ากันก่อน เช่น 40–60 แล้วค่อยปรับความกว้างคอลัมน์โลโก้ให้พอดี จะทำให้ป้ายดูเป็นระเบียบขึ้นมาก 4) กันพลาดด้วย IFERROR บางบริษัทอาจดึงโลโก้ไม่ได้ (โดเมนผิด/ไม่มีโลโก้ในระบบ) แนะนำใส่สูตรแบบนี้: =IFERROR(IMAGE(CONCAT("https://logo.clearbit.com/",B2)),"-") อย่างน้อยตารางจะไม่พัง และยังพิมพ์ออกเป็นป้ายได้สวย 5) ใช้กับ “ป้ายชื่อ/บัตรผู้เข้าร่วม” ได้เลย ถ้าทำป้ายชื่อใน Excel: เพิ่มคอลัมน์ “ชื่อผู้ติดต่อ/ตำแหน่ง” แล้วใช้การจัดรูปแบบเซลล์ (เส้นขอบ, สีพื้น, ตัวหนา) ก็กลายเป็นเทมเพลตป้ายได้ทันที หรือจะเอาไปทำป้ายแนะนำบริษัทในงานประชุมก็เหมาะ สรุปคือ ถ้าคุณกำลังหาแนวทาง “ทำป้ายใน excel” และอยากได้ “โลโก้ excel” แบบไม่ต้องแปะรูปเอง วิธี IMAGE + CONCAT ช่วยประหยัดเวลามาก โดยเฉพาะงานที่มีหลายบริษัท/หลายแถว แค่เตรียมโดเมนให้ถูก ก็จบในไม่กี่วินาที

Related posts

A flat lay showing a camera with a microphone, an external hard drive, and a laptop displaying video editing software on a white bed, illustrating tools for starting a YouTube channel.
A camera on a tripod recording outdoors, with text overlay emphasizing the first tip to stop waiting and overthinking when starting a YouTube channel.
A hand holding a camera with a wide-angle lens and a furry microphone, illustrating the second tip to use available equipment when starting a YouTube channel.
don't hold yourself back any longer! youtube era 📹
Starting a youtube channel does not have to be complicated! There are people out there waiting to find someone with your value, your personality and your talent- whatever that may be. let 2024 be the year you go from thinking about doing it to actually doing it 🫶🏾📹✨ download the free content
Tiana

Tiana

1707 likes

A woman with sunglasses on her head smiles at the camera, with text overlay "Tell me about yourself" and "HOW TO ANSWER THIS COMMON INTERVIEW QUESTION WITHOUT BEING BORING" against an outdoor background with lush greenery and a building.
An interior shot with a brown leather couch and marble coffee table, featuring text overlays: "START WITH A BRIEF SUMMARY OF YOUR BACKGROUND" and "CONNECT YOUR JOURNEY TO YOUR CURRENT GOALS," providing interview advice.
A laptop rests on a white textured blanket, with text overlays: "HIGHLIGHT A UNIQUE ASPECT OF YOUR SKILL SET" and "INCORPORATE A QUICK STORY OR ANECDOTE," offering tips for interview answers.
“Tell me about yourself” without being boring ✨
If you’ve done interviews before, you know that “tell me about yourself” is usually the most common and first asked question in an interview. It can be easy to say some random career-focused information to sound smart and qualified, but this is your chance to start of the conversation tell them
hannah 💟

hannah 💟

43 likes

A young woman sits on green grass at sunset with a festival in the background, smiling. Text overlay reads, 'MAKE THEM OBSESSED ABT YOU how to be magnetic & attract people into your life.'
Two people hold hands in a car, illustrating deep attraction and strong connection. Text explains the post's goal to transform from chasing to attracting.
A woman in a floral skirt stands on a sidewalk, smiling over her shoulder. Text overlays list four tips: 'BE OBSESSED WITH YOURSELF FIRST,' 'DON'T GIVE AWAY TOO MUCH,' 'SHOW INTEREST IN THEIR LIFE,' and 'ALWAYS BE CURIOUS & PLAYFUL.'
make people OBSESSED w you (attract, don't chase)
OK -- so obsession might be a strong word (had to get your attention here ;) ) -- what I really mean by this is DEEP attraction & STRONG connection. I used to be someone who always felt like she was giving too much in relationships, only for people to take me for granted. There tips are what
Sarah Jolie 🌸

Sarah Jolie 🌸

402 likes

How to quickly get a parrot? Of course, draw one yourself.
#birdpainting #art #parrot #saspoo #drawing
SASPOO Direct

SASPOO Direct

10 likes

5 signs you’re in a toxic relationship with yourself❤️‍🩹
Toxic self-relationships feel familiar when they’re all we’ve known. But familiarity doesn’t equal truth. You don’t need to be harsh to be disciplined. You don’t need to abandon yourself to be loved. Healing starts when you notice and decide you deserve better. #relatable #mentalhealth #h
Nicole | YT & IG: theiconnic

Nicole | YT & IG: theiconnic

13 likes

Don’t Think, Just Draw With Me🤗💛
For those that get creative anxiety you may be afraid of being judged harshly or you don’t want to feel the humiliation of sharing something you are unsure of. Some feel that the artwork they produce is just not good enough. I’ve had many people who followed my art tutorials and messaged me and
Chris Whitfield

Chris Whitfield

362 likes

A large collection of diverse tarot and oracle card decks, including 'Mystical Journey,' 'The Muse Tarot,' 'Doreen Virtue Oracle Cards,' and 'Chakra Wisdom Tarot,' stacked on shelves. Overlaid text reads 'A Cards Lover' and 'one hour learning after work,' reflecting a passion for card reading.
How To Learn Tarot Card Reading By yourself?🌟
I'm a big card enthusiast, and honestly, it's mostly my intuition guiding me. I started on tarot cards,then the other types guidance cards. I never really studied it systematically.For me, I just started by myself drawn to this field naturally. Here's how I learned to work with these
🔮LemonQueen🌕

🔮LemonQueen🌕

51 likes

STOP! Take A Moment For Yourself.
It can be easy to overwhelm ourselves between 9-5s, content creation, and the many other things that make up our life. We spent a lot of time playing roles for other people and forget the roles we play for ourselves. I hope you get some time to dedicate to yourself today, friend 🪴 #Lemon8 #Lem
Karlamary

Karlamary

445 likes

what to draw when you feel stuck
When you don’t know what to draw, don’t think yourself out of it just do something. And cutting with scissors somehow feels less intimidating than a pencil sometimes… What do you do when you feel stuck?
Kylie

Kylie

3 likes

An iPad screen displays the Notability welcome page, highlighting features like secure cloud backup, cross-device access, smart study tools, and live transcripts. It also shows sign-in options via Google, Apple, Microsoft, or email.
The Notability app interface on an iPad shows the 'All Notes' section with 'Getting Started' and 'Tools Guide' notes. The sidebar lists 'Notes' and 'Subjects,' while promotional banners for 'Pro features' and 'Gift Notability' are visible.
An iPad screen shows a blank Notability note with a toolbar at the top. The phrase 'SO FAR SO GOOD' is handwritten in black ink on the digital paper, demonstrating the app's writing functionality.
What does Notability do that others don’t?
There’s something about a good notes app that makes your brain feel calmer. Clean pages. Smooth ink. Everything exactly where it should be. So today I’m doing a VERY detailed, honest review of Notability — the good, the powerful, and the “oh wait… that’s actually useful.” 🤍 This is for student
SincerelyTee

SincerelyTee

14 likes

FIND YOURSELF HERE
In today’s society, it’s easy to get lost in the opinions of other people. There’s so much to compare ourselves to, our friends, our family, social media, etc. Although fitness is something that’s been deeply embedded in my daily routine and who I am, I also find interest in the connection betwe
Gracie

Gracie

8 likes

Do you fear getting older or losing yourself?
I don’t think I fear getting older itself, I fear losing myself in the process. The version of me that used to feel alive, confident, full of purpose. Somewhere along the way, responsibilities, expectations, and time started chipping away at me. No one warns you how easy it is to disappear insi
JustSabbs

JustSabbs

8 likes

become the best version of yourself in 2025
create a monthly plan and check in on progress! give yourself a timeline to stick to, the first 6 months will be the hardest to stay consistent. after that it will become your new lifestyle!! this isn’t just about body. it’s about mindfulness, self care, learning something new, self growth, self l
sonya

sonya

77 likes

Prepare Yourself
Don’t start what you can’t finish! #neverstopdrawing #sketch #drawing
Mindrealm71

Mindrealm71

2 likes

A tablet displays the Notability welcome screen, prompting users to sign in and highlighting features like secure backups, cross-device access, smart study tools, and live transcripts.
The Notability app interface on a tablet shows the 'All Notes' section, 'Subjects' sidebar, and promotional content for 'PRO' features and 'Gift Notability,' with sample notes visible.
A tablet displays a blank Notability note with the handwritten phrase 'SO FAR SO GOOD' in black, showcasing the note-taking interface with various writing tools at the top.
What does Notability do that others don’t?
There’s something about a good notes app that makes your brain feel calmer. Clean pages. Smooth ink. Everything exactly where it should be. So today I’m doing a VERY detailed, honest review of Notability — the good, the powerful, and the “oh wait… that’s actually useful.” 🤍 This is for student
SincerelyTee

SincerelyTee

7 likes

A graphic with a gradient background of pink, orange, and white, featuring the cursive text: "It's Hard To Get in Shape Spiritually If you Only Workout on Sunday's." The bottom left corner includes "Lemon8" and "@simplykweeta".
Spiritual Fitness: Don’t Just Work Out on Sundays
Hey everyone! Today, we're diving into the concept of "Spiritual Fitness" and why it's so important to exercise our faith every single day, not just on Sundays. 💪✨ 1. Understanding Spiritual Fitness: Let's kick things off by understanding what spiritual fitness means. Just l
FaithIt2MakeIt

FaithIt2MakeIt

27 likes

A hand holds an iPad displaying a drawing app with a blue and green abstract design and "Hi :)" text. The screen shows "app for Drawing Together" and "1/11" indicating a multi-page post.
Text describes a drawing app that teaches step-by-step with instant feedback, feeling like a game. Below, various drawing course thumbnails and a cute bunny illustration are shown.
Text highlights the app's multiplayer mode for drawing with friends or strangers in public lobbies, describing it as a "cozy online art jam." The image shows the app's multiplayer interface with different drawing themes.
Draw With Friends. Or Random People. In Real Time.
I found this app called ArtWorkout, and now I can’t stop doodling. It teaches you step-by-step and gives instant feedback - but the best part? You can draw with friends or even hop into public rooms and sketch with strangers in real time. It feels like a cozy online art jam, not a boring class. 🎨
Unrealtoreal

Unrealtoreal

113 likes

Draw this when your stressed
During Christmas going into the new years it’s easy to be overwhelmed by all the presents, plans, and upcoming events. Something that can help manage that is drawing! Through creating and releasing those feelings you can calm yourself down to be able to focus better. #lemon8christmas #lemon8c
Kendal x Art

Kendal x Art

132 likes

Jesus Tempted By Satan
Matthew 4:1-10 Reflecting on the story of Jesus being tempted by Satan in the wilderness. After fasting for forty days and nights, Jesus faced immense trials, yet He stood firm in His faith and obedience to God. This powerful account reminds us of the strength we can find in scripture and prayer w
FaithIt2MakeIt

FaithIt2MakeIt

143 likes

When my mom said don’t draw attention to yourself
First post!!!
Daisy Rivera

Daisy Rivera

10 likes

A finished drawing of a red abstract flower-like design with black concentric lines, accompanied by pink and red heart cutouts and the title "How To Make An Easy Design."
A hand drawing a red blob on white paper, following "Step 1: Make 3 colorful blobs in the center of your paper," with two lighter pink blobs already drawn.
A hand drawing a small black dot in the center of a red blob on white paper, illustrating "Step 2: Make a small dot in the center" of the colorful blobs.
How To Draw An Easy Design 😃👏🏼💛
I love how creating these types of patterns gives me peaceful vibes and a calm soul. On those days when things just aren’t going as planned, or when I have a lot weighing on my mind due to daily stresses of life like taking care of my family, financial or mental anxiety, these types of patterns are
Chris Whitfield

Chris Whitfield

554 likes

A green background with the title "How To Draw" and checkboxes for Eyes, Nose, and Lips. A note says "FYI SUPER EASY TUTORIAL." A smiley face and red lip print are also present, with the Lemon8 logo and creator handle.
A step-by-step drawing tutorial showing how to draw an eye in six stages, from a simple circle to a detailed, colored eye with lashes. The image includes a "YOU GOT THIS" block and a gold heart sticker.
A step-by-step drawing tutorial showing how to draw a nose in four stages, starting with a circle and progressively adding details for the nostrils and bridge. The image includes a "YOU GOT THIS" block and a gold heart sticker.
How to Draw Eyes, Nose, & Lips 😃👏🏼
I love simple tutorials when I’m trying to learn how to draw something. I first learned how to draw lips through Alesta Art. I’m so grateful for that amazing artist and others. Now more than ever there are so many ways to learn art. You can learn online through YouTube, Instagram, TikTok, and Faceb
Chris Whitfield

Chris Whitfield

444 likes

A comprehensive list of self-care ideas categorized by occasion, including physical, mental, emotional, sensory, work-related, stress-relief, spiritual, and unique activities.
A young woman with long dark hair and a pink headband, exhaling a cloud of vapor, with green plants in the background, illustrating a 'Sunday self care' moment.
A lit candle, a vase with white flowers, and a perfume bottle on a surface, creating a warm ambiance, labeled as 'STEP 1: Set the mood'.
HOW DO YOU SHOW YOURSELF LOVE ?
November is right around the corner. let’s start this month with expectations of new blessings and prosperity. Watch my youtube video for my perspective of self love and watch me self care routine on youtube 💕 (Link in bio) https://youtu.be/wTQt961q9sE?si=MqESyKpxs4KK25xn #youtubechannel
🎀DBARBIE 🎀

🎀DBARBIE 🎀

234 likes

A hand uses a stylus on a tablet displaying a digital 2025 planner template. It features 'Goals of the Year' and 'Vision Board' sections, with cartoon dogs and colorful flowers on a green grid background. A laptop keyboard is visible in the background.
Why buying a planner when you can draw it yourself
2025 is about to look adorable with Bring Home the Bacon cuties! #lemon8diarychallenge #Lemon8Diary #illustration #plannerideas #journal
Winnie Gu

Winnie Gu

33 likes

Help! I forgot how to draw!!!! ✍️
TL;DR: I took a break and now I’m struggling to make art that I really like because I think somewhere along the way I started OVER-CATERING to algorithms and people online. I didn’t give myself time to stop and think ab what I was making in between pieces or time to really critique myself and work
✨Taya✨

✨Taya✨

11 likes

A 'How to Draw Adorable' book by Carlianne Tipsey is open next to a notebook with various cute drawings, including a baby, a mouse, a boy, a chick, a purple creature, and a cup. Drawing tools are also visible.
A hand colors a baby drawing in a notebook, while an open 'How to Draw Adorable' book displays pages on 'Cute Stuff is Pleasant to Look At' and 'Inspires Feelings' with examples of cute imagery and concepts like love and kindness.
A hand colors a pink mouse-like character in a notebook. An open 'How to Draw Adorable' book shows a page titled 'The Fundamentals of Baby Cute' with various cute animal and baby drawings, explaining how to make characters look baby-like.
How To Draw Adorable Book😃👏🏼
This is one of the most fun step-by-step drawing books that I have in my art book collection. This book from Carlianne Tipsey is for advanced artists and beginner artist to enjoy. You have to get one for yourself! . #createwhitchris #drawing #cuteandsimple #artideas #artist #art #dra
Chris Whitfield

Chris Whitfield

56 likes

The book cover 'A Heart for Christmas' by Sophie Jomain features a large red heart with festive decorations, snow, and stars on a dark blue background. It is an 'Advent Romance' with '24 chapters to open before Christmas!'.
The back cover of 'A Heart for Christmas' describes April's journey to the Alps for Christmas after a heart operation, seeking courage and finding romance with a ski instructor. It is an Advent Romance.
The book cover 'The Christmas Promise' by Donna VanLiere shows a snow-covered house with lights, surrounded by snowy trees, and a person walking in the snow, set against a winter sky.
Lose yourself
Books never fail to draw me away from the days stress
Daisy Farm

Daisy Farm

0 likes

The image is a title slide for "5 WAYS TO DRAW CLOSE TO GOD" by ASA KERSHIMA, featuring the Bible verse "Draw near to God, and He will draw near to you." - James 4:8, with a right arrow and Lemon8 branding.
The image presents the first way to draw close to God: "1. HUMBLE YOURSELF BEFORE GOD," quoting James 4:7 and explaining to surrender plans and trust God's way, with a right arrow and Lemon8 branding.
The image details the second way to draw close to God: "2. RESIST THE DEVIL," quoting James 4:7 and advising to avoid temptation and influences that pull away from God's truth, with a right arrow and Lemon8 branding.
5 ways to draw near to God.
We all want to feel closer to God. We want to hear His voice clearly, feel His presence more, and see His hand moving in our lives. But closeness with God doesn’t just “happen” — it’s something we intentionally build, step by step. In James 4, God gives us a clear roadmap to draw near to Him:
Asa Kershima

Asa Kershima

119 likes

See more