Automatically translated.View original post

28.4K followers

Follow

Follow

Follow

1 saved

4

Conditionap Formatting - Below Average

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

2/13 Edited to

นอกจากการใช้ฟังก์ชัน Below Average ใน Conditional Formatting ที่ช่วยเน้นข้อมูลค่าต่ำกว่าค่าเฉลี่ยแล้ว ผมอยากแชร์เคล็ดลับเล็ก ๆ ที่ลองใช้กับงานจริงแล้วได้ผลดี คือการตั้งสีพื้นหลังให้เป็นเทาอ่อน และตั้งฟอนต์เป็นตัวหนาพร้อมเปลี่ยนสีตัวอักษรเป็นสีเขียว วิธีนี้จะช่วยให้ข้อมูลที่ถูกไฮไลต์ดูโดดเด่น แต่ไม่แย่งความสนใจจากข้อมูลอื่น ๆ นอกจากนี้ หากต้องการให้สะดวกขึ้นเวลาคัดกรองข้อมูลตัวเลข คุณอาจเลือกใช้คำสั่ง Top/Bottom Rules ร่วมกับ Below Average เพื่อดูภาพรวมของกลุ่มข้อมูลที่ต่ำกว่าค่าเฉลี่ยและกลุ่มที่สูงกว่า เพื่อการวิเคราะห์และตัดสินใจได้แม่นยำกว่าเดิม ผมเองก็ใช้วิธีนี้ช่วยแบ่งแยกข้อมูลในรายงานต่าง ๆ ทำให้การตรวจสอบข้อมูลและรายงานผลทำได้เร็วยิ่งขึ้น น่าสนใจตรงที่คุณไม่จำเป็นต้องเขียนสูตร AVERAGE เอง เนื่องจากฟีเจอร์นี้ใน Excel จะคำนวณค่าเฉลี่ยให้โดยอัตโนมัติ และคุณยังปรับแต่งรูปแบบการเน้นสีได้ตามความชอบของคุณ ลองปรับแต่งดูแล้วจะเห็นว่า Excel ช่วยลดเวลาที่คุณต้องเสียไปกับการมองหาค่าที่ต่ำกว่าค่าเฉลี่ยในชุดข้อมูลขนาดใหญ่ได้เยอะครับ!

Related posts

A gloved hand uses a stethoscope on a baby's chest, with a pacifier and thermometer nearby. Text overlay reads "BECOME A Pediatric Nurse," promoting careers in pediatric healthcare.

A hospital hallway background with text describing a Pediatric Oncology Nurse's role: caring for children with cancer, administering chemotherapy, and providing support, with an average salary of $65,000-$90,000.

A newborn in an incubator with gloved hands nearby. Text describes a NICU Nurse's role: caring for premature or critically ill newborns, with an average salary of $70,000-$95,000.

2 Careers in Pediatric Nursing 👶🏻🧸🩺

Hey Girls🩷✨ This is for those who are more interested in the pediatric side of Healthcare! I decided to put together some nursing careers that are focused on the health of children and may interest you. 👧🏻🫀Pediatric Oncology Nurse What They Do: Pediatric oncology nurses specialize in cari

2244 likes

A supermarket aisle filled with various vitamin and supplement products. Overlay text reads "VITAMINS 101 How to Pick the Right Vitamins for You?" with a bottle of orange pills and scattered pills.

Text explaining the benefits of taking vitamins and supplements, including support for eyes, hair, teeth and bones, skin, gut, heart, mind, immune system, metabolism, blood health, and reproductive health. A bottle of orange pills is shown.

Text outlining how to read supplement labels, covering serving size, amount per serving, percent daily value (%DV), ingredients list, quality certifications, and dosage. A bottle of orange pills is shown.

Look & Feel Better: What Vitamins You Should Take💊

In today’s fast-paced world, it’s common to look for quick fixes for health concerns. Vitamins and supplements can play a crucial role in maintaining overall wellness, improving specific areas like skin texture, hair health, and immune function. However, with the myriad of options available, it

3080 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

Part 1: #drama #storytime #story #foryoupage

75 likes

A calculator screen displays '91.37' and the text 'My notes that got me a 91% in patho'. It shows various scientific calculator functions like sin, cos, tan, log, and basic arithmetic operations.

Handwritten notes titled 'Final Exam Review - Diabetes', covering Type 1, Type 2, Diabetic Ketoacidosis, the 3 P's, Labs/Tests, and Gestational Diabetes, with key characteristics and risks highlighted.

Handwritten notes on STIs, including Chlamydia, Gonorrhea, Syphilis (stages 1-3), and Trichomoniasis, detailing their causes, symptoms, complications, and treatments like antibiotics.

My notes that got me a 91% in patho✨

Enjoy lolz IM FREE FROM PATHO (I actually loved this class sm) #school notes #pathophysiology #pathophysiologymadeeasy #nursingschoolstudytips #nursingschoolnotes

28 likes

A medical examination room features a Welch Allyn Spot Vital Signs 4400 monitor on a stand, alongside a stainless steel cabinet with a sink and medical supplies. The image is captioned 'Vital Signs you should know'.

A close-up of a Welch Allyn Spot Vital Signs 4400 monitor displays blood pressure readings of 116/80 and a pulse rate of 73. Text notes that normal adult blood pressure is 120/80 or less, subject to fluctuations.

A hand holds a pink pulse oximeter on a finger, showing readings of 99% oxygen saturation and a pulse of 72 BPM. Accompanying text explains normal oxygen and heart rate ranges, noting potential variations.

Important Vital Signs 🩺

As an outpatient nurse, one of my main duties is taking patients’ vital signs and reporting any abnormal values to the provider. When I first started in nursing school/ my first job, I was super nervous to get vitals and now it’s just a normal thing for me! It’s important to remember that each pers

1716 likes

A study desk scene featuring an open laptop displaying images, an open textbook, and a spiral notebook with handwritten notes. A potted plant is on the windowsill, and overlay text reads "Studymaxxing Science Backed Methods to Get High Grades."

Studymaxxing 𓆩♡𓆪

Hey girls! As we’re returning from winter break, I thought it would be helpful to share two study methods that have been proven to be effective. These methods work for both high school and college courses! For general studying: 1. PREPARATION PHASE • Set Clear Goals: Determine what you want

1486 likes

Oh God,I can’t bear to see him like this.Please protect my Lumajang.I hope the eruption of Mount Semeru ends soon. #praylumajang #semeru #erupsisemeruhariini #fyp

403 likes

Don't be average

Don't be average

28 likes

tips for getting textbooks for university classes

Getting textbooks for classes can get sooooo expensive so fast, but also having textbooks can sometimes be a game changer, so here are my tips!! ☑go to class to see how the professor plans on using the textbook to determine how realistically necessary it will be ☑double check the edition the

196 likes

8 Free Online Certifications to Boost Your Resume

Hi, lemons! In today's competitive job market, having the right certifications can make a significant difference in showcasing your skills and expertise. Online certifications are not only convenient but also cost-effective. Here are six free online certifications that can give your resume a va

1214 likes

Tips for formatting dialogue in your book 📚

Does your WIP follow these rules? 🙂 #writingtips #writinginspiration #WIP #writersoflemon8 #writersoflemon

890 likes

👉🏼 Save this for future and lmk in the comments if you want me to build a specific routine for a skin type or a skin condition. ✨You don't need all of these steps. As a matter of fact most mornings I only do 3 of them. But if you like skincare and want more layers, this is the order. Remember,

1134 likes

A flat lay image featuring a pink notebook, gold heart-shaped dish with paperclips, and a gold pen, alongside a keyboard and pink flowers. The text overlay reads "5 FREE ONLINE CERTIFICATIONS to Boost YOUR RESUME."

5 Free Online Certifications to Boost Your Resume

Hi, lemons! In today's competitive job market, having a standout resume is crucial. Employers seek candidates with not only relevant experience but also a commitment to continuous learning. Fortunately, the digital age offers a wealth of free online certifications that can enhance your skill se

742 likes

A person in gym attire takes a selfie, with an Apple Watch displaying various fitness app icons. The image is titled "Apps Every Gym Girlie Needs!" and includes a phone and a peach emoji.

Screens from the WaterMinder app show water intake history, daily reminders to drink water, and current hydration levels on both a smartphone and an Apple Watch.

Screens from the Lifesum app display meal tracking, calorie counting, recipe suggestions, and a detailed breakdown of daily intake for carbs, fat, and protein.

17 Game-Changing Apps for a Healthier You!⌚️🍑

You know your Apple Watch is already an amazing tool for staying on top of your health, but did you know it can do even more with the right apps? Here are 17 wellness apps I absolutely love and you need to download ASAP to take your fitness game and health to the next level: ℹ️(If you don’t

3733 likes

Excel formatting tips

Excel formatting tips #tutorials #excel #excelforbeginners #exceltraining

153 likes

A blue basket filled with medical tubes, with a hand and a glove box in the background. The text overlay reads "Yearly Labs Broken Down Nurse-Style Are you ready?" introducing a guide for nurses on essential lab tests.

A blue basket with medical tubes, featuring text explaining CBC (Complete Blood Count) components like WBC, RBC, Hgb, Hct, Platelets, and CMP (Comprehensive Metabolic Panel) components like Electrolytes, Kidneys, Liver, and Glucose.

A blue basket containing medical tubes, overlaid with text detailing the Lipid Panel (cholesterol, triglycerides), A1C (3-month blood sugar), and Vitamin D (common deficiency, symptoms) for nurses.

Yearly Labs Every Nurse Should Know!

From CBCs to A1Cs, these are the labs you’ll see on almost every patient chart. Know what they mean. Know what to flag. 📲 Save this breakdown for your next shift! #NurseLife #LabValues #NursingSchoolTips #NewGradNurse #ClinicalReady #NurseTok #HealthcareHeroes

455 likes

Recover Files After Formatting - Done in Seconds

Losing important files due to accidental formatting can be frustrating. In this complete guide, we’ll show you how to recover data after formatting on Windows. #recovery #file #format #data

1 like

A study setup with a laptop displaying Google, a water bottle, and an open notebook with the text "KAPLAN's MCAT Quicksheets Physics" overlaid, indicating study materials.

A page from Kaplan MCAT Quicksheets covering Physics and Math topics like Kinematics, Work and Energy, Newton's Laws, and Thermodynamics, with formulas and diagrams.

A page from Kaplan MCAT Quicksheets detailing Hydrostatics & Fluid Dynamics, Electrostatics, and Circuits, including formulas for density, pressure, electric fields, and circuit laws.

MCAT PHYSICS📒

Kaplan Physics quick sheets #premed #MCAT #college #lemon8bookclub #studies #Lemon8Diary #doctor

24 likes

Story 😍 #twohottakes #redditstories #twohottakespodcast #reddit_tiktok #podcast #podcastclips

6 likes

1 like

A nursing study guide page titled 'VITAL SIGNS' defining body temperature, pulse, blood pressure, respiration, and pulse oximetry. It outlines when vital signs assessments are done, highlights critical alterations, and lists normal ranges for pulse, BP, O2 saturation, temperature, and respirations.

A nursing study guide page titled 'Temperature' detailing normal ranges, average temperature ranges by site, and definitions of febrile/afebrile. It covers nursing diagnoses, factors affecting temperature, symptoms associated with fevers, and interventions for fever management.

A nursing study guide page titled 'Pulse' defining pulse and its normal rate (60-100 bpm). It lists various assessment sites, explains tachycardia, bradycardia, pulse deficit, and pulse intensity. Factors affecting pulse and an anatomical diagram are also included.

Aspiring notes to start your semester for nurses 🩺🎓 #nursingschool #nurselife #nurse #examtips #examprep

77 likes

3 Resume Tips for College Students

How do you make your resume stand out as a student who has similar experience as all the other students applying to the same roles you are? Well, sometimes formatting is what makes the most difference! Small things like putting your education first and using / highlighting results from each o

42 likes

5 resume DOs💡

💼 these resume tips are game-changers to start your career off strong! 1. consistent formatting is SO important because it’s one of the most obvious errors you can make, and a recruiter will notice! be sure double check your fonts, spacing, and spelling! 2. the smallest font size you should u

276 likes

Prompts for high demand skills in 2025

Want to earn more in 2025? Master the right skills with AI-powered learning plans! Here are some prompts “What are the most in-demand skills for [specific industry] in 2025? “ And “Create a 6-month learning plan for mastering [specific skill].” #highincomeskills #learnwithai #chatgpttips

28 likes

Formatting Google Docs For Your Book

I am deep into writing my new fiction book series and one thing I wish I knew before I started was how to format Google Docs! 🤿 Take it from me, learn this before you go any further! 🛑✋ Here's my step-by-step guide to help you format your Google Docs document for a standard manuscript, al

13 likes

Part 2800 | How Long Do You Shower Debate? #youshouldknowpodcast #yskpodcast #youshouldknow

0 likes

College Resume Tips and Examples 📝💻✍🏼🎓

Creating a college resume is essential for applying to colleges, internships, scholarships, and jobs. A strong resume highlights your achievements,skills, and experiences in a clear and organized manner. Here’s a step-by-step guide on how to write an effective college resume: ✍🏼 Start with a Str

475 likes

Let’s talk about overweight pets!

I might post a part two with horses since I couldn’t fit everything #cat #dog #pets #petsoflemon8 #fatcat

110 likes

I know it’s late on a Sunday, but maybe this’ll go somewhere 🥹👩🏻‍💻🤝 #resumeredesign #tagafriend #graphicdesign

14 likes

Are you prioritizing sleep? (VC: @danchizi_ ) #sleep #sleepdeprived #doctorexplains #health

2 likes

Apartment finds under $6!! 🛍🫧🦋🌿✨🫶🌸

🛍Store: 5 below 💰Price: $5-5.55 👍Pros: super cheap, trendy, cute 🤔Cons: quality can vary edit: these are all my own edits & pictures are from the 5 below website! the formatting is kind of funky due to having to ss them and remake the slideshow a few times due to issues in editing.

21 likes

#translationservices

1 like

#car #consumerreports #forvou

2 likes

A young woman applies makeup in a cafe with laptops and a camera on the table, while text overlays introduce "UNHINGED study tips for ur academic comeback" from an Oxford astrophysics student.

An empty Pilates studio with reformer machines serves as the background for text detailing a study schedule inspired by Kobe Bryant, involving multiple high-focus sessions throughout the day.

Two young women in sunglasses pose outdoors, accompanying text that advises deleting social media and changing iCloud passwords for a week to reset focus.

unhinged study tips for ur academic comeback

It's not over till it's over. Here's how I saved my failing semester so u can too🤝📚 #studytok #studytips #studywithme #studyhack #studytools

4 likes

5 Things I Wish I Knew About Publishing📚✍🏻✨

Follow for more author advice #authoradvice #authortips #writingmyfirstbook #readingaesthetic

0 likes

The most expensive ride at Disney… the ambulance 😳 #storytime #svt #disney #grwm

20 likes

May is Cystic Fibrosis Awareness Month 💜 There’s about 40,000 people in the US with Cystic Fibrosis—a genetic condition that affects the lungs and digestive system. CF isn’t always visible, but it can take a significant toll on those living with it. Many CF patients experience hours of treatmen

322 likes

A dark, grayscale cover image with the title "Formatting a book using ADOBE INDESIGN" in a white box. The background features bullets, a hummingbird, and a globe, with "lemon8" and "@raemwrites" at the bottom.

Formatting a Book using Adobe InDesign!

For those who have been here with me before the merge, you would know that I wrote my book Fatalities of Us Against the World. As of right now, I have completed the final manuscript, got it back from my editor and now have to format. • If you have ever opened the software, the amount of things y

41 likes

A woman in an orange sweater and black leggings takes a mirror selfie, with text overlaying 'Lazy girl side hustles I TRIED + HOW MUCH I MADE'. Decorative autumn elements like a leaf and pumpkin are also visible.

A hand holds an ice cream cone, with text listing '1. Sell stock photos ($0.25-$1 per download)', '2. Freelance writing ($50-$200 per article)', and '3. Social media manager ($15-$25 per hour)'.

A hand holds a glass with a yellow drink against a water background. Text overlays detail '4. Virtual assistant ($15-$30 per hour)' and '5. Sell things online ($10-$50 per item)'.

Easy side hustle for my lazy girls 🫶💗🌸

1. 📸 Sell Stock Photos I take photos of everyday things and upload them to stock photo sites like Shutterstock or Adobe Stock. Pay depends on how many downloads my photos get. Average pay: $0.25 – $1 per download. Over time, it adds up to nice passive income! 2. 💻 Freelance Writing Writing

199 likes

Energy without jitters or crash!

This stuff is amazing for getting clean energy that doesn’t give you the jitters or crash afterwards! It also helps so many other things! Hydrogen water is great!

0 likes

#chinesemandarin

1 like

Replying to @sugarmomma Y’all flooded the comments asking about Camp No Counselors so here’s everything you need to know: It’s a real adults-only summer camp — yes, seriously. Think all-inclusive weekend with cabins, campfires, lake time, camp Olympics, and theme parties (costumes encouraged). Loca

2 likes

our home isn’t Pinterest-perfect… but it’s functional and full of love ❤️ you'll find ✨ burp cloths on every surface ✨ stacks of half finished books ✨ toys in places they don’t belong and that's okay! motherhood isn’t always aesthetically pleasing, but it’s real, raw, and a gift. if your home

2 likes

14 likes

A guide on Discord spoilers, explaining how to create image spoilers by renaming files, text spoilers by wrapping text in double bars, and URL spoilers similarly. An example of a spoiler message is shown.

A Discord text formatting guide detailing syntax for italics, bold, bold italics, underline, strikethrough, headers (large, medium, smallest), and masked links. The instructions are presented in a table format.

Discord Tips & Tricks: Spoilers & Text Formatting

Hej du! 🤍✨ I hope this finds some one well, I found these all from the official discord website and tested them myself! 🎀 Female Only discord, DM me if you want to join 🎀 For the wholesome gamers or artist! I make guides like this in my discord, and way more. My apologies for any delayed

1162 likes

5 Misconceptions About the Air Force!

As an Air Force recruiter, I hear some crazy things that people think the Air Force does or is about. So, I decided to put together a list of things that hear most often in hopes to clear the air! 1. “Everyone’s a pilot”: only 5% of the Air Force actually flys planes! If you’re scared to fly or

292 likes

A student wearing a 'Club Monaco' sweatshirt writes in a notebook with a pen, next to an open textbook and keyboard. The image has a text overlay: 'Pt1 WRITING AN A+ ESSAY Student guide'.

A student writes in a notebook. A text overlay on a gradient square advises: 'MAKE SURE YOU READ ALL INSTRUCTION S CLEARLY. Ask questions if necessary'.

A student writes in a notebook. A text overlay on a gradient square advises: 'PAY ATTENTION TO WORD COUNT, WRITING STYLE, AND PAPER OUTLINE MLA, APA, etc.'.

How to make essay writing easier ✍️

The dread of every student is writing an essay it seems. But it can honestly be enjoyable if you do it the right way! Make sure to choose a topic you care about!! One you would enjoy learning more about! Also give yourself enough time to write a quality essay! You know yourself best, don’t wait unt

667 likes

When the Handyman Goes Rogue- A No-Filter Eviction You Won’t Believe!

0 likes

Do you like books with pretty formatting?

📚: Come Out, Come Out is a paranormal dark romance & these are the vibes: 🖤 he falls first/ man obsessed 🖤touch her and I’ll haunt you 🖤 plus size fmc 🖤broody and possessive ghost mmc 🖤he’s 🪦, she wants to be 🖤hide and seek is their thing✨ 🖤tattooed mmc 🖤depression rep 🖤they’re

1009 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

2015 Mercedes-Benz C250 BlueTec LOW KMS !! For Sale: 2015 Mercedes-Benz C250 Turbo BlueTec This stunning ride has super low kilometers at just 73,000 km and has been a fantastic car. The 2.1L turbo diesel engine boasts impressive fuel consumption of only 4.5L per 100 km, giving you an average ran

12 likes

1 like

See more