Automatically translated.View original post

25K followers

39 saved

📊 Use Excel Insert Score + Simple Outstanding Color Highlights in 3 Minutes!

📊 Use Excel to put a score + simple highlights in 3 minutes! "

Want the score table to look tighter and easier to read?

This clip teaches:

• Enter a pro score

• Use SUM formula including points

• Add Automatic Color Highlights (Conditional Formatting)

Follow simply in a minute!

# Excel teaching # Manage points # Color highlights # ExcelTips # ExcelDataMaster

2025/1/24 Edited to

ถ้าคุณกำลังหา “ตารางไฮไลท์” ใน Excel ที่ช่วยให้ตารางคะแนนอ่านง่ายขึ้นแบบเห็นแล้วเข้าใจทันที อันนี้เป็นทริคที่ผม/ฉันใช้ประจำเวลาเตรียมตารางคะแนนรายวิชา (เช่น คณิตศาสตร์ อังกฤษ สังคม) และอยากให้ไฮไลท์สีเด่นแบบอัตโนมัติ ไม่ต้องมานั่งระบายสีเองทีละช่อง 1) เตรียมตารางให้พร้อมก่อน (ช่วยให้ไฮไลท์ทำงานเนียน) - ใส่หัวตารางให้ชัด เช่น ชื่อ-สกุล / คณิตศาสตร์ / อังกฤษ / สังคม / รวม - แนะนำให้แปลงช่วงข้อมูลเป็น Table: เลือกช่วงตาราง > Ctrl+T (หรือ Insert > Table) แล้วติ๊ก “My table has headers” ข้อดีคือขยายแถวเพิ่มนักเรียนเมื่อไหร่ สูตรและการไฮไลท์จะตามให้เอง ลดงานซ้ำ 2) ตั้งรูปแบบคะแนนให้กรอกง่ายและลดความผิดพลาด - กำหนดช่วงคะแนน เช่น 0–100 ด้วย Data Validation: เลือกคอลัมน์คะแนน > Data > Data Validation > Allow: Whole number/Decimal > Between: 0 และ 100 วิธีนี้ช่วยกันกรอกเกิน/ติดลบ ทำให้ตารางคะแนนดูโปรขึ้น 3) สูตรรวมคะแนน (SUM) ที่อ่านง่าย - ถ้าคะแนนอยู่คอลัมน์ B:D ในแถวเดียวกัน ให้ใส่ที่ช่อง “รวม” เป็น =SUM(B2:D2) - ถ้าใช้ Table สูตรจะกลายเป็นแบบอ้างอิงชื่อคอลัมน์ (Structured Reference) ทำให้อ่านง่ายและลดการลากสูตรผิดช่อง 4) ทำ “ตารางไฮไลท์” ด้วย Conditional Formatting แบบที่ใช้บ่อย ก) ไฮไลท์คะแนนต่ำกว่ากำหนด (เช่น <50 ให้เป็นสีแดง) - เลือกช่วงคะแนน > Home > Conditional Formatting > Highlight Cells Rules > Less Than… > ใส่ 50 > เลือกสี ข) ไฮไลท์คะแนนสูง (เช่น >=80 ให้เป็นสีเขียว) - Highlight Cells Rules > Greater Than or Equal To… > ใส่ 80 > เลือกสี ค) ทำแถบสีไล่ระดับ (Color Scale) ให้เห็นภาพรวมทั้งตาราง - Conditional Formatting > Color Scales แล้วเลือกแบบที่ชอบ เหมาะกับตารางที่อยากเห็นว่าใครคะแนนเด่น/อ่อนในพริบตา ง) ไฮไลท์ทั้งแถวตาม “รวม” (ดูรายชื่อที่คะแนนรวมต่ำได้ทันที) - เลือกทั้งตาราง > Conditional Formatting > New Rule > Use a formula… - ตัวอย่างสูตร (สมมติคอลัมน์รวมอยู่ E): =$E2<150 - ตั้งรูปแบบ Fill สีอ่อน ๆ เพื่อไม่ให้ลายตา 5) ทริคเล็ก ๆ ที่ช่วยให้ตารางดูสะอาดและอ่านง่าย - ตั้ง Number Format เป็น 0 ตำแหน่งทศนิยมสำหรับคะแนนส่วนใหญ่ - ใช้เส้นขอบบาง ๆ (Borders) และจัดกึ่งกลางเฉพาะคะแนน แต่ให้ชื่อชิดซ้าย - เลือกสีไฮไลท์โทนอ่อนเพื่อให้ตัวเลขยังอ่านชัด ถ้าคุณทำตามนี้ “ตารางไฮไลท์” จะกลายเป็นตารางคะแนนที่ดูเป็นระบบมากขึ้น และเวลาอัปเดตคะแนนก็แค่กรอกตัวเลข สีจะช่วยสรุปให้เองทันที

Excel highlighting trick

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

26 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

320 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

64 likes

A notebook page titled "Color Coding" demonstrates highlighting systems for English, Biology, History, and Math notes using pink, orange, yellow, green, blue, and purple highlighters. Each subject shows different terms highlighted with specific colors, such as "Symbolism" in pink for English and "head topic" in yellow for Biology.

A stack of highlighters in various colors, each labeled with a specific purpose like "Questions," "Notes," "Dates/times/data," "Subheadings," "Key Ideas," "Titles," "Definitions," and "Title page." The image emphasizes labeling highlighters for organized study.

Five pastel highlighters are shown, each with a label indicating its use: "Definitions" (light purple), "Answers to questions" (yellow), "Examples" (light pink), "Key ideas / Concepts" (light blue), and "Unknown terminology" (orange). The image highlights a pastel color scheme for highlighting.

✨✍🏾 FRESHMENNN Here’s How To Highlight CORRECTLY ✍🏾✨

✨ College life isn’t just about late-night study sessions and caffeine runs, it’s about working smarter, not harder. And when it comes to highlighting (A NECESSITY), trust me, there’s a method to the madness 😌📚 Here are a few real examples I found of how to use a highlighting system that actually h

8251 likes

Bible Highlight (color coding system)💜🩷💚❤️💙💛🧡🩶🤍

180 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

1446 likes

A decorative title slide with the text 'CREATING SPARKLINES IN EXCEL' in a handwritten style, overlaid on a background of personal photos and office desk items.

A beige background with white text defining a sparkline as a compact, simplified line chart for quick visual representation of data trends without labels or axes.

An Excel screenshot showing a row of monthly sales data highlighted, with the 'Insert' tab selected and the 'Line' sparkline option within the 'Sparklines' group highlighted.

SPARKLINES IN EXCEL

What Are Sparklines? Before we dive into the "how," let's briefly touch on the "what." Sparklines are small, in-cell charts that display data trends. They're ideal for quickly visualizing information like stock prices, sales figures, or temperature fluctuations. Sparklines

69 likes

Memorize THESE Excel shortcuts = instant promotion

✨ Want to look like the Excel genius at work… without actually struggling for hours? 👀💻 I swear these little shortcuts make you go from “uhhh let me Google that…” ➡️ “oh yeah I got this 😌” ⚡ Ctrl this ⚡ Alt that ⚡ suddenly you're the coworker everyone asks for help No gatekeeping

6 likes

✨💻 The BEST Hex Codes For Pretty Digital Notes 👩🏾‍💻✨

✨Let’s be real, studying is hard enough. But when your digital notes look good? Suddenly, reviewing for that exam hits different. 😌 Whether you’re on Goodnotes, Notability, OneNote, or even just Google Docs, these aesthetic hex code combos will take your notes from “meh” to chef’s kiss. 💅✨ 🌸 Pas

227 likes

Index match tutorial

Index match tutorial #tutorials #exceltips #googlesheets #exceltraining #onlineclass #tiptok

21 likes

Full video is on tik tok or YouTube - 🌸

#blondehighlights #blondehair #hairtutorial #hairdye #hairtutorials #blonde #blondetransformation #haircolor #hairtransformation #hairtrend

145 likes

Excel signature

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

189 likes

A split image comparing high-contrast highlights with bold, distinct blonde streaks on the left, and low-contrast highlights with seamlessly blended, natural lighter tones on the right, illustrating the visual difference.

A hair color comparison guide showing a woman with dark hair and subtle highlights for dimension, and another with light blonde hair for a brightening effect, highlighting 'Rich & Bold' versus 'Soft & Glowing'.

An infographic titled 'HOW TO CHOOSE HIGHLIGHTS?' providing bullet points on selecting highlights for dimension, bold contrast, low-maintenance, sun-kissed looks, or subtle dimension for lighter hair.

How to Choose Highlights: The #1 Rule

After years in the hair industry, I've nailed it down to one formula: great highlights = the right contrast. Get this wrong, and the whole look falls flat. Get it right, and you double the impact—every single time. Here's the breakdown to help you decide: • High contrast → bold, defin

430 likes

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

1192 likes

A title slide featuring "Basic Formulas Used in Excel Part 1" with the author Anjali Viramgama, set against a textured wall background with green overlays.

An Excel screenshot demonstrating the SUM function, showing student scores in various subjects and the calculation of total marks using `=SUM()`. The text explains that SUM adds up a range of numbers.

An Excel screenshot demonstrating the MAX function, showing a list of names and formula lengths, with `=MAX(D24:D39)` in the formula bar. The text explains that MAX returns the highest value in a range.

basic formulas used in excel part 1

Microsoft Excel is a powerful spreadsheet software that offers numerous functions and formulas for various purposes. Here are 13 basic Excel formulas that can be quite handy: 1. SUM: Adds up a range of numbers. For example, `=SUM(A1:A5)` will sum the values in cells A1 through A5. 2. AVERAGE: C

60 likes

How to improve your Google Sheets Skills

(From someone who has created over 44 #googlesheets dashboards) 1. Learn by doing - my first ones are more simple compared to my current Dashboards but I need practice in order to design Dashboards that are more complex to meet my own needs 2. Add images and Icons - certain formulas also wor

969 likes

Bible Highlighting

Bible Highlighting #mycreativebible #biblejournaling #biblestudyforwomen #highlighter

136 likes

This image details the first Excel hack: "Return to the top without scrolling" by pressing Ctrl (or Command) and the up arrow twice, accompanied by a small Excel icon.

This image details the second Excel hack: "Quickly resize columns and rows" by double-clicking the dividing line between columns, accompanied by a small Excel icon.

3 Excel Hacks you need to know! 

You know what's a game-changer in the office world? Understanding Microsoft Excel! 📊 It's not just a spreadsheet software; it's your secret weapon for success. Here's why: First, it's a productivity wizard. Excel can crunch numbers, organize data, and create slick charts in a

391 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

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

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

2720 likes

Excel Trick: Color-Coded List Menu 💫 📊

✨ Welcome to Our Excel Mini-Class! ✨ Hey productivity pros! 👋 Want to make your Excel sheets not just functional but also visually stunning? Let me show you how to create a color-coded list menu that’s perfect for tracking tasks, organizing data, or making your spreadsheets pop! 💼✨ Using a co

2 likes

A laptop screen displays a Google Sheet titled 'FALL 2024 ASSIGNMENTS SPREADSHEET' with columns for Course, Assignment, Due Date, and Days Till Due, showing various college assignments.

A Google Sheet template with headers 'COURSE', 'ASSIGNMENT', 'DUE DATE', and 'DAYS TILL DUE' is shown, with text instructing to start by organizing columns with these headers.

Two Google Sheet snippets demonstrate how to populate the assignment tracker. The first shows entering a course name, and the second shows entering assignments and their corresponding due dates.

Time to organize your assignments!

I’ve been using this method to organize my assignments since I was a freshman, 2 years ago. I am now a junior and If I can say one thing is that—this is the real deal here ✔️ Using Google sheets has been a game changer for me in my college career. It keeps me on track with all my assignments,

5210 likes

Excel cheat sheet

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

14 likes

Excel sorting

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

8 likes

A notebook page displays a color-coded system for Bible highlighting, with categories like 'Satan, Sin' (orange), 'God, Jesus' (yellow-green), 'women, family' (pink), 'Prophecy, history' (light orange), 'love, kindness' (bright pink), 'faith, Obedience' (light green), 'worship, praise' (purple), and 'wisdom, teaching' (blue-green). The right page shows handwritten Bible verses from 2 Corinthians, Romans, Galatians, and Philippians.

Highlighting Code For My Bible

I wanted to change things up and add more to my highlighting code, and this works much better for me.🙂🫶 #biblecolorcode #biblehighlighters #biblestudy #christian #jesuslovesyou

163 likes

Excel sparklines

Sparklines in Excel in a new way #tutorial #excel #friday #exceltricks #exceltips #exceltipsandtricks #spreadsheet #workhack

20 likes

How to use AND Function in Excel

Here is a video explaining how to use AND Formula in Excel #excel #exceltipsandtricks #exceltips #exceltutorial #microsoftexcel

0 likes

A Google Sheets calendar for March and April, titled "How to use Google Sheets Student Edition - tracking assignments," showing class and assignment due dates, with a color key for exam and final days.

A Google Sheets master list for Spring 2024 assignments, showing status, due dates, class, assignment details, points, and grades, with instructions to record everything and auto-cross out submitted items.

A Google Sheets master list showing how to check off assignments to add them to a to-do list, record grades, and automatically calculate days until due, highlighting overdue items in red.

How to use Google Sheets ✨ student edition ✨

What I do to not miss a due date 1. Master list - I put everything in table : readings, homework, exams, labs, essays, important info, etc 2.My Calendar - Customizable for any term : fall, spring, summer and has all the dates auto added from my master list #assignments #collegestudent

3676 likes

A woman takes a mirror selfie, holding a coffee cup and phone, with text overlay 'EXCEL SHORT CUTS SAVE TIME & FRUSTRATION PART 1'. Abstract shapes frame the image.

A brown graphic slide details the Excel shortcut 'CTRL + A' which selects all data in a worksheet, accompanied by a 'SWIPE' instruction.

EXCEL SHORTCUTS

These excel short-cuts are just a few that have made my excel work take a fraction of the time and genuinely changed my work life!! Working in excel can be extremely frustrating when not using the tool efficiently. Here are some crucial shortcuts to enhance your experience with Excel. CTRL + A

2588 likes

Top secret excel tabs

Some tabs are TOP SECRET and this is how to hide them so you don’t have to delete #tutorial #excel #exceltraining #exceltricks #exceltutorial #topsecret #fyp

14 likes

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

A green and white graphic titled 'Master Simple Excel Operations', listing five basic Excel tasks: creating a workbook, entering data, adjusting column/row size, inserting/deleting cells, and using functions.

A graphic titled 'Keyboard Function Key Identification' showing a white keyboard layout and a table identifying common keys like Esc, Tab, Caps Lock, Shift, Ctrl, Alt, Enter, Backspace, Sleep, and Wake Up.

Getting Started with Excel: It's Really Simple!

We'll start with the basics, learning about Excel's interface, toolbar, cells, and other fundamental operations. Then, we'll move on to common office shortcuts, as well as some frequently used functions and formulas. #ExcelBasics #ProductivityTips #SpreadsheetSkills #Exce

40 likes

Less clicking, more doing. Excel like a pro! 📊💡 #

Shop Now at https://peakchoicemall.shop

1 like

Excel signature

Handwritten signature in Excel #tutorials #excel #excelforbeginners #exceltraining #exceltips

12 likes

$An infographic details Excel Custom Formatting, covering its definition, access methods, and syntax for positive, negative, and zero values. It illustrates various operators like numbers, colors, and symbols, alongside examples for formatting dates, conditional formatting, fractions, scientific notation, percentages, custom text, number abbreviations, and using symbols.$