Automatically translated.View original post

ใช้ Mac ก็เทพ EXCEL ได้

1814 followers

Follow

Follow

Follow

22 saved

20

Know GROUPBY Function

It is used to group and summarize data, automating updates as source data changes dynamic array.# ExcelMacTips

# ExcelTips # LearnExcel # OfficeSkills # IT should know

2025/10/6 Edited to

การใช้ฟังก์ชัน GROUPBY ใน Excel ช่วยให้เราสามารถจัดกลุ่มข้อมูลและคำนวณสรุปยอดต่าง ๆ ได้อย่างมีประสิทธิภาพ โดยเฉพาะเมื่อทำงานกับข้อมูลขนาดใหญ่และต้องการผลลัพธ์ที่อัปเดตแบบเรียลไทม์ ซึ่งเหมาะมากสำหรับงานวิเคราะห์หรือจัดทำรายงาน จากที่ได้ลองใช้ GROUPBY ในโปรเจคจริง พบว่าสิ่งสำคัญคือการวางโครงสร้างข้อมูลต้นทางให้ชัดเจน เช่น มีคอลัมน์สำหรับชื่อ, สาขาหรือแผนก (Division) และยอดขาย เพื่อให้การจัดกลุ่มและการคำนวณผลรวมทำได้อย่างถูกต้อง นอกจากนี้ ฟังก์ชั่นนี้ยังรองรับ Dynamic Array ทำให้ผลลัพธ์ที่ได้จะแสดงออกมาต่อเนื่องอัตโนมัติ โดยไม่ต้องคัดลอกสูตรไปตามเซลล์ต่างๆ จึงทำให้การจัดการข้อมูลง่ายขึ้นมาก สำหรับผู้ที่ใช้งาน Excel บน Mac แนะนำให้ตรวจสอบเวอร์ชันให้รองรับฟังก์ชันนี้ด้วย เพื่อใช้ประโยชน์จากฟีเจอร์ใหม่ๆ ที่ช่วยให้การวิเคราะห์ข้อมูลเป็นไปอย่างราบรื่น สุดท้ายขอแนะนำให้ลองสร้างตารางข้อมูลตัวอย่างและใช้ GROUPBY ควบคู่กับฟังก์ชันอื่นๆ เช่น SUM, AVERAGE เพื่อพัฒนาทักษะและต่อยอดการใช้งานให้หลากหลายยิ่งขึ้น

Related posts

A hand holds a camera with a lens, set against a blurred natural background of green foliage and mountains. The image features the text overlay "HOW TO GET START IN PHOTOGRAPHY" in yellow.

A diagram titled "Photography Basic Framework" outlines a 7-day learning sequence for beginners, covering camera familiarization, basic knowledge, lighting, composition, color, aesthetics, and post-processing.

An infographic explains the three elements of exposure: Aperture, Shutter, and ISO. It illustrates how different values for each setting affect image brightness, background blur, motion clarity, and image quality.

Learn this by heart📸your photography will levelsUp

Hello everyone~ ☺️ Today I’m going to share with you the learning sequence for beginner photography, so that you can also learn photography well!🥳 💡Have questions? Message me on comment! #beginner photography #photographytip #photography #photographyideas #photographytipsforbeginner

1540 likes

GROUPBY Function in Excel Explained

How to use GROUPBY Function in Excel #exceltips #excelformulas #excel #exceltutorial #excelhacks

1 like

A woman with curly hair and glasses, holding a microphone, with text overlays 'SQL Windows Function Explained' and 'Mad Key'.

A bookshelf background with 'SQL Windows Function Explained' and a quote defining a window function as viewing a 'slice' of data while seeing the bigger picture.

A SQL code example using a window function (RANK() OVER) to rank sales, showing output with individual sales records and their ranks, maintaining detail.

SQL: Windows Function Explained

One thing I've discovered is that when working with data, Normal SQL (GROUP BY) helps summarize data but sacrifices row-level detail in the process. On the other hand, Window Functions allow you to perform calculations across rows while maintaining each row’s detail. This key difference m

57 likes

Pediatric Endocrine Disorders & Must Know!🩺👶

The endocrine system plays a HUGE role in growth, metabolism, and hormone regulation in kids! Here are the key disorders, signs, and management tips you need to know for Peds Endocrine 🏥📚 ⸻ 🛑 1. Type 1 Diabetes (T1D) - “Insulin-Dependent Diabetes” ✅ Cause: Autoimmune destruction of pancrea

93 likes

A pair of white sneakers, black dumbbells, and a water bottle on a dark surface, framed by flames and snowflakes. The title "How to Properly WarmUp & Cool Down" is prominently displayed with a lemon icon.

Text outlines warm-up and cool-down routines for walking, including dynamic and static stretches. A smartwatch displays a "Time to Walk Dolly Parton" workout, indicating a 25-minute duration.

Text details warm-up and cool-down routines for running, listing dynamic and static stretches. A smartwatch shows "Outdoor Walk" and "Outdoor Run" workout options with open goals.

Get the MOST Out of Your Workouts by Warming Up❤️‍🔥❄️

If you're looking to get the most out of your workouts and avoid unnecessary injuries, you've got to nail your warm-up and cool-down routines. Trust me, these steps are non-negotiable if you want to stay in the game and feel great. Let me break it down for you in a simple, no-BS way. ‼️W

846 likes

Learning app all students should know 🥰🫶

This is an application that has helped me a lot. 📝📝When I first studied abroad, I wasn’t really good at English 🥹🥹 but luckily I had it, I could listen attentively to the lecture and it would take notes for me. I can study any time and any where I want. 💻💻 Later when I went to work, I used

96 likes

This is my function🖤

This is my function (aka an everything shower, clean room, dark romance book) #relatab #girlhood #girlproblems #girltherapy #aestheticvibes

1892 likes

Suspect is too gay to function

#wlw #nonbinary #lgbtq🌈 #gettoknowme Los Angeles

23 likes

A modern kitchen with white and grey cabinets, stainless steel appliances, and a kitchen island. A laptop, a white tumbler, and a vase with green flowers are on the island. The image has a text overlay that reads "CLEAN GIRL KITCHEN AESTHETIC."

A close-up of a kitchen counter featuring a black electric stove with a stainless steel kettle. To the left, a wooden cutting board, wooden utensils, and salt and pepper shakers are visible. Text overlays indicate "Salt & Pepper" and "kettle."

A kitchen sink area with a stainless steel sink, a faucet, and a white soap dispenser. A small green plant and a black bowl filled with green decorative balls are on the counter. Text asks, "What's one kitchen item you can't function without?"

What’s one kitchen item U can’t function without?🤔

Ladies let’s chat. There are some items in my kitchen that I use everything single day. As for me I love a clean kitchen so I make sure to have all my cleaning essentials ready to go at all time. Some items I can’t go without including my air fryer because I use it almost every single day. I al

173 likes

Enhance kidney function and boost energy! 🥰

#taichi #exercises #practice #healthylifestyle #kidney

27 likes

Relieve back pain and enhance kidney function

#taichi #chineseculture #exercises #healthylifestyle #backpain

2127 likes

A desk setup with a laptop, smartphone, drink, and notebooks, featuring the title 'How I Built My Second Brain,' indicating a guide to personal knowledge management.

An open notebook page illustrating five digital note-taking apps: Notion, Apple Notes, Obsidian, Evernote, and CollaNote, with brief descriptions of their key features for building a 'digital home.'

An open notebook page detailing the P.A.R.A. method for organizing information into four categories: Projects, Areas, Resources, and Archive, with examples and small illustrative photos.

My Step-by-Step Guide to Building a Second Brain

1. Pick Your Digital Home Base 🏡 First, commit to one single app so you aren't searching for notes everywhere. The "best" app is the one you'll actually use, but here are my takes on five popular choices: ● Notion: My personal favorite; it's like digital LEGOs for building

271 likes

What to know in psychology

#psychologytips #psychology #psychologymajor #brain

26 likes

does anyone know this tip? #excel #HelloLemon8 #exceltip #excelspreadsheets

0 likes

A graphic titled "Steal My Group Therapy" with "Session Outline: Healthy Coping Skills & Traumatization." It features an illustration of six diverse individuals sitting in a circle, engaged in discussion, representing a group therapy session. The background is a blue-to-yellow gradient.

A text document outlining a group therapy session on "Healthy Coping Skills and Traumatization." It details objectives, an icebreaker, session overview, and psychoeducation on trauma types (acute, chronic, complex) and its effects on the brain (amygdala, hippocampus, prefrontal cortex) and body.

A continuation of the group therapy session outline, detailing common reactions to trauma, identifying unhealthy coping mechanisms, and introducing healthy coping skills like grounding, breathing, and journaling. It includes a "Coping Toolbox" activity, a grounding exercise, and closing reflection questions.

steal my group therapy session outline! 🤍

use these for a group therapy session, or apply them to yourself lovebugs! 💌🤍 please share your thoughts! this outline provides much more psycho education that i utilized to reassure my participants that trauma is not something we can literally “just get over”, it can literally affect your brain an

68 likes

EPITHELIAL TISSUE: Classification & Function

~Epithelial tissue is characterized according to the shape of its cells and number of layers. ~Squamous cells are thin, flat cells that look like fish scales and are found in the tissue that forms the surface of the skin, the lining of the hollow organs of the body, and the lining of the respira

50 likes

Canva Shortcuts You Should Know

I could not function without @canva! I've used this platform for the last 4 years to create: 🍒Content for social media marketing clients 🍒ebooks 🍒Portfolios 🍒Presentations 🍒Thumbnails 🍒Planners 🍒Business cards 🍒Flyers 🍒Templates You name it , and I probably have it in my projects!

1791 likes

A handwritten nursing note titled "STEAL MY VITAMINS & MINERALS Nutrition Notes" on lined paper. It details antioxidants, Vitamin A's impact on vision, deficiency symptoms like night blindness, and its roles in disease prevention, skin health, immunity, growth, and reproduction.

A handwritten nursing note on lined paper detailing Vitamin A sources (preformed and provitamin A carotenoids), toxicity risks (3000 micrograms daily), and the initial information on Vitamin D, including its nature as a hormone and its forms.

A handwritten nursing note on lined paper discussing Vitamin D. It covers dietary and sun sources, its primary functions in calcium regulation and bone metabolism, and deficiency conditions like rickets in children and osteomalacia in adults.

Steal my Nursing Notes: Vitamins You Need to Know

Breaking down vitamins and minerals one note at a time! ✨ Understanding micronutrients is essential for nursing—especially when it comes to patient education and overall health. Clear, organized notes make it so much easier to remember key functions, sources, and deficiencies! Extra points for thos

36 likes

The image displays a table titled 'Collective Nouns (For People)', listing various groups and their corresponding collective nouns. Examples include 'Squad' for security, 'Cast' for actors, 'Team' for athletes, 'Committee' for decision-makers, and 'Audience' for listeners, illustrating how different groups are named.

Collective Nouns: How We Group🔑ℹ️⬇️

Understanding collective nouns helps us see the diverse ways we group people or things. Each term reflects the nature of the group it describes, adding a layer of meaning to our language. Deep Dive: Collective nouns are used to refer to a group of individuals or items as a single entity. These

7 likes

The image displays a 'Digital Decluttering Checklist' with app icons organized by color into distinct groups, each accompanied by a matching emoji. It visually demonstrates how to declutter and organize digital life by categorizing apps based on their dominant icon color, set against a starry night sky with aurora borealis.

❤️🧡💛💚💙💜 Organize apps by color? Guide and Tips

Organizing your phone apps by color might seem unusual, but it can be a surprisingly effective and visually appealing method! Here's how to do it: 1. Choose Your Color Scheme: * Basic Colors: Create folders for red, orange, yellow, green, blue, purple, black, white, and gray. * Rainbow

46 likes

Does anyone know this excel function?

#hellolemon8 #excel #exceltips #excelx #excelhacks

1 like

Function Of Beauty Restock!✨🌸

Had to stop by Sephora and do a little restock before traveling this summer!🤍🤭 #lemon8diary #organizedbeauty #makeuprestock #lemon8hair #lemon8haircare #Hair #haircare #haircareroutine #travel @

792 likes

Know the difference 💭

Maximus, Medius, Minimus Cable Kickbacks: Perfecting Glute Activation! 🏋️‍♂️ ••• 🧠Understand the Difference🧠 ✏️Medius: A 45-degree angle kickback mainly targets the gluteus medius by engaging both hip extension and abduction. This exercise helps to strengthen and stabilize the gluteus medius,

7 likes

Thyroid Function & Your Liver: The Connection…

Your thyroid needs specific nutrients to make hormones, and your liver to activate them. 🗝️The 4 Key Nutrients Your Thyroid Runs On: ✅Iodine – builds thyroid hormones (T4 & T3) Food/Herb sources: sea vegetables (kelp, nori), cranberries, potatoes, strawberries, iodized salt (moderate use

184 likes

function of beauty

my hair is a major part of my outfits, and I’m changing it all the time. This means I need hair care that changes with me! That’s why I go to target and grab what I need from function of beauty to make custom hair care on a budget! I love that it’s at target because I don’t have to wait for it to b

10 likes

How to use IF & ISBLANK Function in Excel

How to use IF & ISBLANK Function in Excel #excel #exceltips #exceltricks #exceltutorial #learnexcel

2 likes

How does Elon Musk even function?

Ok, I can’t stand Elon Musk most days, but I’ve gotta admit I’m genuinely curious: how does this man have so much energy? Like… according to his biography he barely sleeps, eats terribly, never works out, is under insane stress 24/7, AND he’s neurodivergent. By all logic, he should’ve crashed and

180 likes

Optimal Rest | Immune Function

Daily Vitamins - Night Magnesium: - reduce anxiety - calms nervous system - regulates circadian rhythm - relaxes muscles Probiotics: (at night it provides a better environment for the probiotic bacteria to settle and colonize in your gut) - balanced gut microbiome - immune support -

58 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

Enhance kidney function and improve back pain

#taichi #chineseculture #exercises #healthylifestyle #back

2 likes

A clear crystal ball containing a vibrant purple and pink nebula, resembling a galaxy. It sits on an intricately designed, antique-style metallic stand with hanging decorative elements, suggesting its use for divination and spiritual practices.

What is a crystal ball and its function

A crystal ball is a smooth, spherical object—traditionally made of clear quartz or glass—used as a tool for divination, meditation, and spiritual insight. ⸻ Brief Description: In divination, crystal balls are most commonly used for scrying, a practice where the seer gazes into the ball to

22 likes

Too Fluffy to Function ☁️💗✨

Serving strawberry marshmallow vibes with a whipped pink twist… This scent stack is sweet, soft, and way too cute to handle ☁️💖 Think strawberry milk, cotton candy skies, and vanilla dream energy Let’s get into this Fluffy in Pink Mood… ✨ Scent Stack: ✨Tree Hut Cotton Candy Scrub 🍭 ✨Bodycol

113 likes

A person takes a mirror selfie in a gym, with text overlay stating "YOUR GYM CHOICE CAN MAKE OR BREAK YOUR GAINZ" and arrows pointing to their glutes.

White text on a purple background discusses the importance of gym hygiene and safety, citing studies on bacteria on equipment and the risk of infections.

White text on a purple background explains how gym atmosphere, motivation, and psychology impact workout consistency and self-efficacy, with a Reddit anecdote.

How to MAXIMIZE Ur GAINZ by Choosing the RIGHT Gym

Ranking 10 Popular Gyms by What Really Matters We’ve all heard it: “It doesn’t matter what gym you go to, it’s about how you work out.” But after training in garage gyms, budget chains, bougie studios, and everything in between, I can confidently say: the gym you choose matters more than you thi

29 likes

A hand holds a black bottle of creatine gummies with a pink label. The label describes it as a creatine monohydrate supplement in pink lemonade flavor, supporting muscle growth, strength, and recovery.

Creatine Helps with Cognitive Function

Creatine is essential for cognitive function of the brain. It has also been shown to help with traumatic brain injuries. That is enough for me to take 5 mg daily of Creatine. I take Legion Creatine gummies because I am still a kid at heart. I am not getting paid by them for this post. I am just

0 likes

Just creating function 😮‍💨😗

84 likes

Financial Freedom is a function of your mindset

A day in the life of a trader (my side hustle) and a fashion brand owner 😎 If you know how to use your time and money properly, you’ll eventually never trade again #fashiontips #Lemon8Diary #moneymanagement #financetips #letschat

0 likes

Where calm meets function ✨

Natural textures & cozy vibes #calmandcozy #fresh and cozy #retailtherapy

545 likes

A set of Function of Beauty hair care products for curly hair, including pink bottles of shampoo with chia extract and conditioner with shea butter, alongside yellow and pink boxes of #HAIRGOAL BOOSTER SHOTS for strengthen and curl definition.

Function of beauty hair care

So I picked up the function of beauty hair care for curly hair line and I’m excited to use them. I have curly hair and right now it definitely needs some tlc so I’m hoping this will help. If anyone has any experiences with this brand I’d love to hear it! I’m definitely interested on how these will

16 likes

Function & Fashion In One Bag

It’s time to design your own customizable Apolis bag! These bags are fashion and function all in one and allows you to express your individuality by being able to customize. My collection is 15 bags and growing. They are the perfect everyday tote! Visit apolisglobal.com and design yours today!

8 likes

A bottle of Indole-3-Butyric Acid (IBA) solution, a liquid plant growth regulator, for use as auxins in tissue culture. It shows the chemical formula C12H13NO2, 100ml size, and 1mg/1ml concentration.

Role and Function of IBA in Plant Tissue Culture

**Indole-3-Butyric Acid (IBA)** is a synthetic plant hormone in the auxin family, widely used in plant tissue culture due to its effectiveness in promoting root formation. Here are the key aspects of its role: 1. **Root Induction and Development** IBA is primarily used to stimulate root growth

0 likes

A scary monster with sharp teeth and claws emerges from under a bed, while a person hides under the covers, looking terrified. This illustrates the feeling of trying to sleep at the Ian Function.

A close-up of a tired man with a beard and dark circles under his eyes, looking distressed. This image conveys the exhaustion of staying awake at the Ian Function.

A man holding a spiked baseball bat stands with his back to the viewer, facing a group of people in a dark, tense outdoor scene. This depicts Ian's Brother walking in.

#real #relatable #friendgroup #ianfunction #tiktok

3 likes

A woman (Gabby) and a couch in an office setting. Text asks if you are 'Hyper Independent? Overachiever? Burnt TF Out?' and states 'Here's How Group Therapy Can Help' for women. Includes 'Therapy By Gabby' branding.

A woman (Gabby) and a couch in an office setting. Text explains group therapy helps hyper-independent overachievers find community. Includes 'Therapy By Gabby GROUP THERAPY FOR WOMEN' branding.

A woman (Gabby) and a couch in an office setting. Text describes group therapy as a space to practice vulnerability and process inner experiences for emotional intimacy. Includes 'Therapy By Gabby GROUP THERAPY FOR WOMEN' branding.

F*ck I Need Help: Group Therapy For Women

#grouptherapy #womenshealth #womensupportingwomen #wisconsintherapist #floridatherapist

1 like

How type 1 diabetes and muscle function

Struggling with strength or recovery as a type 1 diabetic? 💪 Learn how Type 1 diabetes impacts your muscles and what you can do to stay strong, active, and in control. Full breakdown now on my Movement Mentor Substack. #type1diabetic #type1diabetes #diabetesawareness #diabadass #t1

1 like

A person outlined in pink takes a selfie outdoors, holding a cup. Text overlay reads: 'signs and symptoms that you're not eating enough for your body to function optimally'.

for your body to function optimally

214 likes

☕️ I can’t function without caffeine ☕️

My Go-To Coffee Order ☕ ☕️McDonald’s Medium Coffee 4 & 4 ☕️Starbucks Medium Roast - Pike Place Roast 4 sugars & a splash of whole milk • • • #caffeinequeen #coffee girl 🥰 #coffeequeen #makeup #softglammakeup

20 likes

A woman in a grey top and orange skirt interacts with a child in an indoor setting, with the overlay text "HOW I FUNCTION AS AN ADHD MOM" and "Swipe »".

How I function as an ✨ADHD✨ mom & person

Having ADHD is hard, trying to function with ADHD as a mom is incredibly challenging, but we do it! I had a late ADHD diagnosis at 23 and since then I’ve done everything I can to learn more about it, myself, and the best ways to keep going. Worth adhd and especially with late diagnosis, an array of

13 likes

the vibes i bring to the function

such a fun way to get to know me! do we have any stuff in common?? #thevibesibringtothefunction #chaoticlife #gettoknowme

29 likes

See more