Automatically translated.View original post

28.4K followers

Follow

Follow

Follow

1 saved

4

Conditional Formatting - Above Average

Practice using simple Conditional Formatting without a formula. Follow now. 😎💚# excelsoezy # Exceltricks # exceltips # Excel # Lemon 8 Howtoo

2/13 Edited to

ถ้าคุณต้องการเน้นเซลล์ที่มีค่ามากกว่า 100 ใน Excel โดยไม่ต้องเขียนสูตรเอง ฟีเจอร์ Conditional Formatting คือเครื่องมือที่ช่วยได้ดีมากครับ โดยวิธีที่ผมมักใช้ คือเลือกช่วงข้อมูลที่ต้องการ แล้วไปที่ Conditional Formatting > Top/Bottom Rules > Above Average ซึ่งจะสั่งให้อัตโนมัติเน้นแค่เซลล์ที่มีค่ามากกว่าค่าเฉลี่ยของช่วงนั้นๆ แต่ถ้าต้องการเน้นค่าที่มากกว่าจำนวนนิ่ง เช่นมากกว่า 100 จริงๆ ให้เลือก Conditional Formatting > Highlight Cell Rules > Greater Than จากนั้นกรอกค่า 100 เท่านี้เซลล์เหล่านั้นก็จะถูกเน้นสีทันที ผมลองใช้ฟีเจอร์นี้ในการวิเคราะห์คะแนนของนักเรียน ช่วยให้เห็นว่าคะแนนไหนที่โดดเด่นกว่าค่าเฉลี่ย ทำให้การจัดลำดับและสรุปผลข้อมูลสะดวกมากขึ้น โดยเฉพาะงานที่ต้องรีวิวข้อมูลจำนวนมากแบบรวดเร็ว นอกจากนี้ ข้อดีของฟีเจอร์นี้คือไม่ต้องจำสูตรซับซ้อน และยังสามารถปรับแต่งสีหรือรูปแบบการเน้นได้ตามต้องการ ทำให้ข้อมูลดูสวยงามและเข้าใจง่าย ช่วยประหยัดเวลาในการทำงานได้เยอะเลยครับ

Related posts

Cross off that list

Make check boxes cross off your to do list in excel with this conditional formatting trick. #tutorial #excel #template #projectmanagement #exceltips

7 likes

Excel conditional formatting

HR & People tool practical Excel application of conditional formatting #tutorials #template #excel #exceltricks #exceltraining

9 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

1175 likes

Excel projects with a Gantt chart

Auto populate the Gantt style chart with name and color #template #excel #tutorial #friday #exceltips

11 likes

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

4938 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

5 likes

Auto Rows Highlighter

📊 Welcome to Our Excel Mini-Class! 🚀 In today’s session of the Boost Your Excel Skills series, we’re introducing the Auto Rows Highlighter—the ultimate trick to visually organize your data like a pro! 👀✨ With just a few clicks, you’ll be able to highlight entire rows automatically, making your s

1 like

Excel check box

#onthisday check boxes in excel are way easier than they used to be #tutorial #tutorials #excel #excelpro #exceltricks #spreadsheet

17 likes

Excel class #excelmastery #class #education #excel

31 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

6 Signs Someone Actually Sees You

This kind of recognition might feel uncomfortable at first because it's so different from conditional love. When someone sees your full humanity, not just your function, it can feel vulnerable and foreign. But this is what healthy relationship actually looks like. You deserve to be

113 likes

Excel Custom Formatting

This is my favorite Excel trick 😎 Custom Formatting Custom Formatting is even cooler…allowing you to change the way your cell values appear in a cell. Here...let me show you a few example… but first: ➡️ How do you open up to Custom Formatting dialogue box? A few ways: 1️⃣ Hit CT

184 likes

A digitally altered image shows a bruised and bloodied man resembling Donald Trump, with text stating Iran accepted Trump's two-week ceasefire and Trump accepted Iran's 10 conditions.

US & Iran Agree to Two-Week Conditional Ceasefire! Oops it's already broken!

NOW WHAT? *The publicly available Iranian plan demands: U.S. end all primary and secondary sanctions against Tehran! *Iran receive full control over the Strait of Hormuz. *The plan demands an end to U.S. attacks on Iran and its allies. *Withdrawal of U.S. forces from the Middle East. *Release

64 likes

✨ Welcome to Our Excel Mini-Class! 🐶 In this session, we’re diving into essential Excel functions that will save you tons of time! ⌛ From quick calculations to powerful data organization, these functions do the work for you—no more repetitive tasks! 🔄🔍 These go-to functions will boost your produ

3 likes

asian americans have a history of being SILENT or saying “we are also oppressed/marginalized” without realizing that same silence is reproducing racial hierarchies. STAND THE FUCK UP. that argument is weak and disgusting. #eunnurilee #asianamerican #koreanamerican #grwm

16 likes

Excel interview tips

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

17 likes

Excel tip to remove grid lines

Fill white is NOT the way to remove grid lines in excel. It will take forever and possibly cover other data. Go to the view menu and uncheck the grid line box anytime you have a dashboard or any other reason they aren’t needed. #tutorial #excel #exceltips #exceltricks #exceltraining

11 likes

A laptop screen displays "5 FREE MUST HAVE Online RESOURCES FOR STUDENTS" with pink flowers and desk organizers in the foreground. The image highlights essential online tools for students.

5 Free Online Must-Have Resources for Students ✨

Hi, lemons! In your student era, as a student navigating the academic landscape, having the right tools at your disposal can significantly glow up your productivity, creativity, and overall learning experience. In this comprehensive guide, I'll spoil the tea on six free and powerful resources t

337 likes

Pay attention #rays369method inbox me if you need help

7 likes

he got low smh if you don’t have any snacks eddie not fwy

5 likes

Scannable barcodes

Use excel to create barcodes #excelformulas #excelshortcuts #excelmastery

21 likes

Excel tips and tricks

Who is in both columns? Find out which items are on both lists. #exceltips #excel #tutorial #exceltricks #templates

36 likes

Secure Your Excel Data Like a Pro: Set Password 🔒✨

💥 Welcome to Our Excel Mini-Class! 📈 Today's session is all about how to secure your excel data. Do you deal with sensitive data in Excel and want to keep it safe from prying eyes? 🔍 Whether you're a student, professional, or just love staying organized, learning how to set passwords o

7 likes

Excel cheat sheet

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

14 likes

EASY ASSIGNMENT TRACKER! 📚✏️📓

I’ve used this assignment tracker for over a year now and I absolutely love it! It’s super easy to make and you can edit it whenever new assignments get added to your schedule. To order assignments by due date: highlight all assignments -> data -> sort range. #college #collegestudent

133 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

36 likes

A laptop displays a Google Sheet with a green header, alongside a tablet showing a calendar. The image features text overlay: 'Hack How to create a Notion-like header in Google Sheets'.

A Google Sheet interface demonstrates steps to 'Add 6 Rows' and 'Change Row 1 to height of 300', with a pop-up window for specifying row height to 300 pixels.

A Google Sheet interface shows instructions to 'Change Rows 2-5 to height of 40' and 'Change Row 6 to height of 30', with respective pop-up windows for resizing rows.

Google Sheets Hack - Adding a Notion Like Header

I recently updated my Masterlist with a header! Colors I Used: 1. Dark Green - 0b8043 2. Light Green -ccd5ae Full YT Tutorial is in my profile! #assignments #collegestudent #techfinds #studymotivation #googlesheetscalendar #googlesheets #organization #masterlist

312 likes

Don’t #miss it #rays369method

3 likes

What does a “Conditional Approval” mean? 🤔

Heres an explanation on what it means to be conditionally approved when applying to an apartment complex. You’re one step closer to being fully approved! #apartments #apartmentapproval #money #creditscore #foryoupage

76 likes

Replying to @laticiamccaskill1 good luck ! #rays369method

5 likes

A promotional image featuring a woman with text overlay that reads: 'Ultimate office software Cheat Sheet can leverage your career. Get PDF from valder.org'. The image also includes 'lemon8 @wuvalder' branding.

A 'Custom Guide Microsoft® Excel 2021 Basic Quick Reference Guide' cheat sheet, detailing the Excel program screen, keyboard shortcuts, general navigation, getting started, editing, and formatting options.

A 'Custom Guide Microsoft® Excel 2021 Intermediate Quick Reference Guide' cheat sheet, illustrating chart elements, chart options, various chart types, and instructions for creating, modifying, printing, and distributing charts.

my ultimate office software cheatsheet

Let me tell you a little secret: I used to be that person who Googled every single Excel formula, struggled with PowerPoint layouts, and spent way too much time formatting Word documents. Sound familiar? 😅 But then, I decided to take control. I printed out these Ultimate Cheat Sheets for Excel, Po

59 likes

Dynamic border Excel tip

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

17 likes

resume DON’Ts ❌

💼 here is what you should NOT do when it comes to creating your resume! 1. including unnecessary information takes away the opportunity to highlight the most relevant parts of yourself or your experience. you have limited space, so use it wisely! 2. your resume should not be over 1 page, so a

35 likes

Life as a Catholic woman

All Jesus wants is everything you are. Jesus has never walked away. His love is not conditional and He does not shy away from your brokenness. He does not ask you to preform in order to earn His mercy and His love. In this world, we get used to the model of “I’ll scratch your back you scratch mine.

10 likes

Write a 2000-Word Essay in 6 Hours (Score 80+)

"Today I'm sharing my tried-and-tested method for writing quality essays under pressure. This strategy helped me score 80+ consistently! Let's break it down... 🎯 1. Read the Assignment Brief (30 mins) ⏰ First things first: Highlight the deadline in red Bold all assessment criteria

34 likes

REMINDERS FOR PRIDE MONTH

it’s almost june !! don’t forget these key things 🏳️‍🌈⭐️ #lgbt #lgbtq #pridemonth #queer #trans #transgender #ftm

512 likes

Excel percent format issue trick

Excel percent format issue trick. Fix percentage issues. #tutorial #exceltips #excel #excelpro #exceltricks #exceltutorial #exceltraining

12 likes

Day 16 - Flexibility

UP Week - Unconditional Progress Week. Basically a “do what you want” week. This calendar model allows for the final week to be what I want it to be - whether it be nothing or a few workouts. The core of the workouts happened in the first 3 weeks - consider this a “recovery week.” This form

1 like

Protect Your Data: Set a Password in Excel! 🔒✨

🕵️‍♂️ Welcome to Our Excel Mini-Class! 👋 Today’s tip is all about keeping your data safe in Excel! 🚀 Whether you’re sharing sensitive info or just want an extra layer of protection, setting a password is a quick and easy solution! 🔐 Let's add a password in seconds to prevent unauthorized acc

3 likes

If your seeing this your #lucky #rays369method #payattention

4 likes

📊Google Sheets Chart Hack: Show All Months on You

Want to visually track completed tasks or items in your Google Sheet? This quick tutorial shows you how to use conditional formatting to automatically cross out an entire row when a checkbox is checked! This simple trick is perfect for: * To-do lists * Project trackers * Inventory manageme

3 likes

Excel list comparison 🌸

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

129 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

PRESS ON UPDATE

I love them & you can’t tell me I didn’t go to the nailshop🥰 The length, the shape, the French tips….🔥 Edit: these and some of my favorites are linked in my bio under the “for my press on gworls” #Lemon8 #press ons #dailyinspo #budgetfriendlyoptions

739 likes

Guys, bookmark this NOW!

As someone who used to think “VLOOKUP” was a yoga pose, this guide saved my sanity. It breaks down EVERYTHING: ✅ Must-know functions (not just =SUM, but =XLOOKUP, =INDEX/MATCH). ✅ Shortcuts that’ll make you 10x faster (Ctrl+Shift+L for filters? Life-changing). ✅ Data validation, conditiona

862 likes

Love Should Not Be Conditional

Feeling loved but not fully safe? This message is for anyone experiencing conditional love, controlling behavior, manipulation, or being treated well only when productive. A reminder that you do not have to perform to be loved and real support never keeps score. #BelovedSira #ProtectYourPeace

3 likes

Excel drop it function

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

20 likes

See more