Automatically translated.View original post

EazyIT by Patrick

6960 followers

Follow

Follow

Follow

724 saved

983

7

How to Put a Wrong and Right Mark on Simple Excel

How to put the wrong check on Excel in a simple way 🤩🤩

# Excel # Excel formula # Excel the basics # exceltips # Lemon 8 Howtoo

2025/10/15 Edited to

นอกจากวิธีใส่เครื่องหมายถูก-ผิดใน Excel ที่แนะนำในบทความแล้ว ผมขอแบ่งปันประสบการณ์การใช้งานจริงที่เจอมาในการทำงานประจำวันครับ 1. ใช้สูตร CHAR(252) หรือ CHAR(251) สำหรับเครื่องหมายถูกและผิด ซึ่งเป็นเทคนิคที่สะดวกมากเวลาไม่อยากเสียเวลาวาดรูปหรือลากสัญลักษณ์ 2. คีย์ลัดเป็นตัวช่วยที่ดีมาก เช่น กด Alt ร่วมกับตัวเลขเพื่อพิมพ์สัญลักษณ์ที่ต้องการอย่างรวดเร็ว ช่วยลดเวลาการทำงาน 3. แนะนำให้ใช้ Conditional Formatting ร่วมกับฟังก์ชัน IF เพื่อแสดงเครื่องหมายถูก-ผิด ตามเงื่อนไขอัตโนมัติ เพื่อให้แถวข้อมูลดูชัดเจนและน่าอ่านมากขึ้น 4. หากต้องการเครื่องหมายถูกที่มีขนาดใหญ่ขึ้น อาจเลือกใช้ฟอนต์ Wingdings หรือ Webdings แล้วพิมพ์ตัวอักษรเฉพาะเพื่อได้สัญลักษณ์ที่โดดเด่น 5. สำหรับใครที่ใช้งาน Excel บ่อยๆ การบันทึกมาโครที่ใส่เครื่องหมายถูกผิดจะช่วยให้ทำซ้ำได้เร็วและถูกต้องตลอด หวังว่าทิปส์เหล่านี้จะช่วยให้คุณสามารถจัดการข้อมูลด้วย Excel ได้สะดวกและมืออาชีพมากยิ่งขึ้นครับ!

Related posts

An open Bible with handwritten notes and sticky notes, overlaid with the text "HOW TO START READING THE BIBLE for beginners," indicating a guide for new readers.

An open Bible with notes and an iPad displaying prayer notes, overlaid with the text "START WITH THE GOSPELS" and listing "MATTHEW MARK LUKE JOHN."

A close-up of an open Bible page with highlighted text, overlaid with the text "PAIR PSALMS & PROVERBS TO LEARN THE HEART AND WISDOM OF GOD."

How to Begin Reading Your Bible: A Simple Guide

Starting your Bible-reading journey can feel overwhelming, but it doesn’t have to be! Here’s a step-by-step guide to help you dive into Scripture and truly connect with God’s Word: 💛 Start with the Gospels (John First!) The Gospels are all about the life, teachings, death, and resurrection of

8625 likes

Excel org chart

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

32 likes

Excel cheat sheet

Excel cheat sheet #excel #exceltips #exceltricks #exceltraining #tutorials #excel_learning

14 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

363 likes

Excel highlighting trick

CTRL+ Shift + arrow to highlight cells. #exceltips #tutorials #exceltraining #exceltutorial #excel #excelpro #onthisday

26 likes

How to Create an Email ID using CONCAT in Excel

How to Create an Email ID using CONCAT Function in Excel #exceltraining #exceltricks #exceltutorial #excelsheets #msexcel

1 like

Excel formatting tips

Excel formatting tips #tutorials #excel #excelforbeginners #exceltraining

152 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

39 likes

Project timeline using excel

Project timeline how to using excel #projectmanagement #excel #exceltricks #exceltutorial #tutorials

11 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

150 likes

How to add Filter on your worksheet in Excel

How to add Filter on your worksheet in Excel #exceltricks #exceltutorial #excel #excelsheets #exceltips

2 likes

Excel pdf button

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

41 likes

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

4938 likes

How to Find Cube of any Numbers in Excel

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

0 likes

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

1174 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

31 likes

Excel search bar tutorial

Learn how to add a search bar to excel #tutorial #upskilll #educate #work #excel

9 likes

How to Find Cube Roots in Excel

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

0 likes

Excel tips and tricks #exceltricks #exceltips

Excel tips and tricks #exceltricks #exceltips

11 likes

How to Square Numbers in Excel

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

1 like

RANDBETWEEN() Function in Excel

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

0 likes

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

1429 likes

Excel permanent timestamp

Time stamps DO NOT update when you close and reopen #excel #exceltips #templates #tutorial #exceltraining

23 likes

Sorting in excel #excel #tutorials #exceltips #exceltraining #excelforbeginners

7 likes

Separate words in excel

Separating text in excel #exceltricks #exceltips #tutorials #takemyclass #fyp

21 likes

Excel drop it function

Remove columns and rows using drop in excel. #exceltips #excel #exceltutorial #businesstips #business #tutorial #boss #spreadsheet

20 likes

Let’s break these excel habits

Do you consider this proficient in Excel?? I can tell you it’s not. My office survival course is for you and can be done in as little as a weekend or during lunch for a week. #exceltraining #tutorial #excel #exceltips #exceltipsandtricks #exceltricks #onlinecourse

36 likes

Excel signature

Yes a handwritten signature imported in excel #exceltips #exceltricks #exceltraining #exceltutorial #excel

176 likes

Lock excel down

BEFORE sharing excel files review which cells allow edits #exceltricks #tutorial #excel #exceltraining #fyp #exceltips #business

25 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

1 like

Excel tip to fix row sizing 🌸

Just pause before you send a file like this. It takes 3 seconds to fix it. #exceltips #tutorial #exceltraining #exceltraining #exceltricks

54 likes

Level Up Your Excel Game with VLOOKUP Function! 📈🌟

👉 Welcome to Our Excel Mini-Class! 💡 Today's session is all about VLOOKUP Function in Excel! Ever feel like searching for specific data in a huge spreadsheet is like finding a needle in a haystack? 🧐 VLOOKUP is here to help! With a simple setup, you can make it simple to locate exactly what

8 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

18 likes

Separate tab for excel notes

Keep your notes to yourself with excel camera #tutorial #excel #exceltraining #exceltricks #business #exceltutorial #exceltips

33 likes

Excel interview tips

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

17 likes

Excel April fools trick

April fool’s #exceltricks #exceltips #excel _learning #exceltutorial #exceltraining #onthisday seriously though learn excel with me xecutethevision.com

11 likes

Excel time stamps

Yes, I said permanent time stamps #exceltips #excel #tutorial #worktips #exceltraining #exceltricks

53 likes

Master Totals in Excel: SUM, SUMIF & SUMIFS! 📊✨

✨ Welcome to Our Excel Mini-Class! 👋 In today’s quick Excel class, we’re diving into three must-know functions for fast and accurate totals! 🧮 Whether you’re summing up expenses, grades, or any data, these functions will save you serious time! ⏱️💼 Whether it's a simple question, a specific c

4 likes

3 simple tips to improve concentration📚✨

Ever had those days when your brain just won’t stop racing, and focusing feels nearly impossible? We’ve all been there. Whether it’s a pile of tasks or endless distractions, it’s easy to feel like you’re drowning in your own thoughts. But don't worry, here are a few easy tricks to clear your mi

58 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

40 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

183 likes

Excel list comparison 🌸

Excel list comparison went viral save this for when you need it #exceltraining #excel #exceltutorial #exceltips #exceltricks

128 likes

Excel tip to filter

Excel filtering tip #tutorials #exceltips #exceltraining #excelforbeginners #business

23 likes

Excel tip to remove chart backgrounds

Get rid of the background and outline on Excel charts #tutorials #excel #exceltips #exceltricks #businesstips

6 likes

Compare lists in excel

Excel list comparison help #excel #tutorials #exceltips #exceltraining #fyp

6 likes

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

32 likes

Dynamic border Excel tip

Dynamic border Excel tip #exceltips #excel #exceltricks #exceltraining #tutorials #excel_learning #learn #onthisday

17 likes

Copy paste unique only in excel trick

Copy just the unique values in excel #exceltraining #exceltips #exceltricks #tutorials #excelforbeginners

12 likes

Excel Magic: 5 Ctrl Shortcuts to Save Your Time 💫

✨ Welcome to Our Excel Mini-Class! ✨ Attention, productivity pros! 🔥 Excel isn’t just a tool; it’s your secret weapon for working smarter, not harder. Today, let’s dive into 5 essential CTRL shortcuts that will save you time and impress your coworkers! 💼✨ 💡 CTRL + 1: Bold text! 💡 CTRL + 2:

20 likes

See more