Automatically translated.View original post

28.4K followers

Follow

Follow

Follow

9 saved

9

Find multiple worksheet sums with Consolidate

Let's change the way to find multiple worksheet sums from cross-worksheet addition to Consolidate. 😎💚# excelsoezy # Excel # Exceltricks # exceltips # Lemon 8 Howtoo

4/9 Edited to

ถ้าคุณเคยเจอกับปัญหาการบวกผลรวมจากหลาย Worksheet ใน Excel ด้วยการกรอกสูตรบวกทีละแผ่นจนลายตา ลองมาใช้ฟีเจอร์ Data - Consolidate ดูนะคะ ฟีเจอร์นี้จะช่วยให้เราสามารถรวบรวมข้อมูลตัวเลขจากหลายแผ่นงานให้กลายเป็นผลรวมเดียวได้โดยอัตโนมัติ ในขั้นตอนแรก ให้เปิด Worksheet ใหม่ที่จะใช้แสดงผลรวม แล้วเข้าไปที่เมนู Data จากนั้นเลือก Consolidate ในกล่องโต้ตอบที่ปรากฏขึ้น เลือกฟังก์ชัน Sum เพื่อรวมตัวเลข จากนั้นเลือกช่วงข้อมูลในแต่ละ Worksheet ที่ต้องการรวม ผลที่ได้จะเป็นผลรวมอัตโนมัติที่อัพเดตตามข้อมูลต้นทาง ไม่ต้องกังวลเรื่องการเปลี่ยนข้อมูลแล้วผลรวมไม่อัปเดตเลยค่ะ นอกจากนี้ ถ้าคุณต้องการให้ลิงก์กับข้อมูลต้นทางอัตโนมัติ ให้ติ๊กที่ "Create links to source data" ซึ่งจะทำให้ผลรวมเปลี่ยนแปลงตามข้อมูลของแผ่นงานแต่ละหน้าโดยอัตโนมัติ จากประสบการณ์ของเรา วิธีนี้ช่วยลดเวลาได้มากจริงๆ โดยเฉพาะเวลาที่ต้องทำรายงานยอดขายรายเดือนที่แยกตามสาขาหลายแห่ง ลองประยุกต์ใช้ดูนะคะ รับรองงาน Excel ของคุณจะง่ายและรวดเร็วขึ้นมาก

Related posts

-Study time: You need to take breaks to help your brain have time to actually think -Apps: YouTube is always used for anything but study. Make YouTube useful to your brain. -Sleep: I used to get 3 hours off sleep, and it wasn't healthy. take care of your mind and body. #study #studying

12.7K likes

This image illustrates tips for becoming a successful content creator, showing a woman with YouTube awards, a close-up of the awards, someone editing video on a laptop, and another person working at a desk. It highlights the creative process and recognition.

This image focuses on picking a niche for content creation, showcasing various categories like fashion, beauty, lifestyle, health, wellness, cooking, and gaming. It emphasizes choosing a specific focus for content.

This image displays essential items for content creation, including a smartphone, tripod, ring light, tablet, camera, and laptop. It also features app icons for video and photo editing, emphasizing the tools needed for quality content.

UGC/Content Creator tips you prob knew about📷

⭐️To be a successful UGC/content creator, focus on creating authentic, relatable content that resonates with your target audience. ⭐️Start by identifying your niche and showcasing your unique personality or perspective. ⭐️Consistently post high-quality content on platforms where your audien

41 likes

A tablet screen showing the Canva Gradient Generator app, demonstrating how to create custom gradient backgrounds. The interface allows users to select colors, adjust noise levels, and randomize patterns for a design titled "Social Media Templates."

A tablet screen showcasing the Canva TypeCraft app, which enables text manipulation. The image displays options for warping and outlining text, with an example of "SOCIAL MEDIA TEMPLATES" text being creatively distorted.

3 Canva Apps you have to try! 💡

Canva is already a go-to for many of us, but did you know it has some amazing apps that can take your designs to the next level? Let's talk about three of them: Gradient Generator, TypeCraft, and SmartMockups. 1. Gradient Generator 🌟 The Gradient Generator app in Canva allows users to

1192 likes

A nursing student in blue scrubs takes a mirror selfie in a bathroom, with text overlaying the image that reads: "Study tips for first semester nursing students pt.1 (From a first semester student with all A's)".

Handwritten notes on lined paper, with a pink pen resting on them. The notes discuss dysmenorrhea and include a tip: "Take notes from power-points and resources BEFORE class in one ink color-during class use another ink color to add professor remarks and highlight sections emphasized in class as well."

A partially filled concept map template for "Restrictive Cardiomyopathy" with sections for diagnostic tests, etiology, signs & symptoms, and patient education. An overlay states: "For patho, USE CONCEPT MAPS! these help memorizing manifestations and other things to know for exams. There are plenty of online templates."

Study tips from a nursing student

First semester of nursing school can feel overwhelming, but I’ve found little strategies that helped me go from stressed to successful (and yes, all A’s 🤭💙). Here are my top study tips to stay organized, focused, and confident in class + clinicals. Whether you’re just starting out or need a boost m

75 likes

Medsurg notes! Come study with me! This week we’re learning about Oncology and the different types of cancers! #nursingstudent #medsurg #oncology #cancer

93 likes

A laptop rests on a light-colored, textured sofa, with the text "part two start a career with canva" overlaid, indicating the beginning of a guide on making money with Canva.

A person's hands are shown typing on a laptop keyboard, with a white mug nearby. The image illustrates the concept of a Social Media Manager, as described in the text below it.

A child's hand points to a maze worksheet lying on a light-colored carpet. This image visually represents the role of a Worksheet Creator, as explained in the accompanying text.

Make money using Canva! (Pt 2)

Do you love working on Canva? It’s a great skill to know! You can also make ways to make money with Canva. → Social Media Manager: If you love posting on social media, then you can work on your design skills to create posts for clients. Then, use their content scheduler to upload your posts for

443 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

Daily Ritual Worksheet

Anchor your mornings, ignite your evenings—this worksheet is your ritual compass. Grab the worksheet, ignite your rhythm, and drop a 🔥 if you’re claiming your throne today. #ritual #witchcraft #worksheet #dailyroutine #dailyaffirmations @HexAppeal Portland

64 likes

there’s nothing I love more than sharing resources 🫶🫶 #therapist #therapyresources #therapysessions

67 likes

New Radiology Student Here 👋🏾☢️

Hey guys! I’m looking for other radiology students or licensed professionals in the healthcare field! I’ll be sharing tips and tricks I have & I’m happy to exchange knowledge with you guys! I’m so excited for this program and the opportunity to grow in this field! Future Rad Tech on the way! ☢️

1036 likes

Journal Prompts for Beginners

Take 10 minutes to get clear on what you want ⬇️ ⠀⠀⠀⠀⠀⠀⠀⠀⠀ These prompts will help you create clarity and intention for November. Use them as a monthly reset ritual to get focused on what you actually want this season. 🍁 ⠀⠀⠀⠀⠀⠀⠀⠀⠀ ✨ Feel stuck or unsure about what’s next?✨ ⠀⠀⠀⠀⠀⠀⠀⠀⠀ Start w

6 likes

Endocrine disorders!

Medsurg notes Diabetes Diabetes insipidus Hypothyroidism Hyperthyroidism #nursingstudent #diseasetemplate #nursingschool

29 likes

A digital notebook screen displays 'Upper GI' as the main title, followed by a list of conditions: GERD, Hiatal Hernia, Esophageal Varices, PUD, and Acute Gastritis, outlining the topics covered in the notes.

A digital notebook page details GERD, covering its definition, risk factors, expected findings, diagnostic methods, prevention, medications, therapeutic interventions, complications, and client education for nursing students.

A digital notebook page outlines Hiatal Hernia, distinguishing between sliding and paraesophageal types. It includes sections on prevention, expected findings, diagnostics, medications, complications, and therapeutic procedures like fundoplication.

The best lecture note format

Steal my medsurg notes on upper GI disorders! Nursing school can be so hard! Especially when it comes to Medsurg and learning how to study! I make my own templates for each disorder. This is my personal favorite way to learn the content! These notes helped me to earn a 89 on my exam! #studytips

27 likes

Anxiety Worksheet ✨

🌟 Hey everyone! 🌟 Taking care of our mental health is crucial, and I invite you to join me on a journey of self-reflection. 📝✨ Print out or use Goodnotes for this anxiety worksheet—it's a powerful tool for understanding and managing our emotions. 🧠💪 Once you've completed it, tag me

493 likes

Worksheet for when you are struggling with your body image

Body Appreciation Worksheet for When You are Struggling with Body Image (From my counseling website, not my mindset coaching one) The Uniquely Me, Body Appreciation, and Body Positivity worksheet helps with recognizing what our bodies do for us and what is unique about us. Think about the abi

3 likes

Affirmations to Manifest Your Best Self 🖤

The best version of you isn’t in the future — she’s already within you. ⠀⠀⠀⠀⠀⠀⠀⠀⠀ She already exists — you just need to remember her 💫 ⠀⠀⠀⠀⠀⠀⠀⠀⠀ Save these affirmations when you need to step into your best self. She’s already within you — journaling, affirming, and aligning just help you rememb

11 likes

Space Activity Pack: Moon Worksheet & Coloring Fun

Blast off into learning! 🚀 Our Moon worksheet, space color by number, and space coloring pages are the perfect add ons to the Little Astronomers: Phases of the Moon lesson. Kids can practice fine motor skills, number recognition, and creativity while exploring stars, rockets, and the moon! 🌙✨

56 likes

👫 COUPLES WORKSHEET 👫

#Couple #love #relationship #marriage #Lemon8Diary

9 likes

Therapeutic worksheets

link to the self-care studio is in my bio :) #therapists #therapistintraining #selfcareroutine #selfgrowth #therapy

4 likes

free worksheets for the kids❗️💌

I have another free find for the kids🤞🏽 I’ve decided to homeschool my daughter before she starts actual school, I love to do my research and in doing so, I’ve come across kiddoworksheets.com a website dedicated to worksheets for kids!! #homeschoolmom #free #kidseducation they have every s

33 likes

How to make the day feel less heavy ✨

You don’t need a new life. You need today to feel a little more livable. If everything feels heavy, overwhelming, or like you’re not yourself anymore, my workbook is a place to start. WHO THIS IS FOR: This is for you if you feel: * burned out or emotionally exhausted * disconnected from yo

2 likes

This budget planner stopped me from going broke

In the beginning, I was very stubborn and thought my brain could just hold everything. But having a planner only focused on budgeting, made my money and absolute priority. #budgetplanner #savingmoney #cashstuffing #moneygoals #financialfreedom

35 likes

A woman with dark, curly hair, wearing a mesh top and jeans, bending over. Text overlay reads "May Vision Board" with a pink heart emoji, representing the article's theme.

A woman taking a mirror selfie, holding a phone, a stack of notebooks, and a patterned handbag, symbolizing organization and readiness for personal growth.

A page from the article titled "CHAPTER #1: LET'S TALK: TRANSFORMING YOURSELF," discussing confidence, self-esteem, and the steps to achieve self-assurance.

Month of Self Love🥀✨🤍 {May Vision Board}

The month of may marks the start of something great. Distincing myself from toxic and negative energy I have finally came to the realization that if I had placed half of that determination and care I had placed into others on myself, I would be in a more secure and content place in life. It’s easy

201 likes

Make One Worksheet Work 3 Ways! (Parent Hack)

Tired of printing worksheet after worksheet? Let me show you how to turn ONE printable into a flexible learning tool you can reuse every day. ⸻ What You Get: A 1-page PDF showing parents how to use any worksheet in 3 fun + smart ways: 1. Dry Erase Sleeve Hack – Wipe and reuse!

6 likes

Microbiology Worksheet Book | College Study Guide

Strengthen your microbiology knowledge with this printable worksheet book designed for college students. Covers essential topics like bacteria, cells, lab concepts, and foundational microbiology principles. Great for homework support, test prep, and classroom reinforcement. Link in bio 🔗 #futu

2 likes

Meet the newest members of our homeschool + homestead journey 🐢🤎

These are Sulcata tortoises (also known as African Spurred tortoises) and they’re officially part of our real-life curriculum now ✨ Native to the dry regions of Africa, these tortoises can grow over 100 pounds and live for decades… which means this isn’t just a “pet”—this is a long-term lesson i

6 likes

Habits to get straight A’s 💌✨

These are my habits that helped me get straight A’s throughout high school and now in college !! Which habits do you guys use ?? Let me know in the comments! 🌸💞 #studygram #Lemon8Diary #healthylifestyle2024 #aesthetic #study #lemon8challenge #education #goals #Lemon8 #le

467 likes

Study Smarter: Anatomy Worksheet Digital Workbook

Make studying anatomy easier with this digital worksheet workbook 📚✨ Perfect for notes, practice, and exam prep. Instant download, printable, and super simple to use. Click link in my bio to get started ✅

2 likes

A 1st Grade Morning Work worksheet featuring sections for name, month, day of the week, date (1-31), weather (sunny, snowy, rainy, cloudy icons), and time (with A.m. and P.m. options). It includes grids for months and days, and numbered circles for the date.

1st grade morning worksheet

66 likes

Your weekend deserves a little breathing room. Teachers already carry so much during the week — lesson plans, worksheets, quizzes, rubrics, classroom activities, and all the little details that never fit neatly into the school day. Aidemia helps turn the blank page into a first draft faster,

1 like

checklist for your nervous system ✨

✨ Your nervous system was never meant to live in survival mode 24/7. I created this PATCHIES™ themed “Nervous System Check-In” worksheet for the moments when everything feels too loud, too heavy, or just… too much. 🤍 This printable was designed to help you recognize signs of: • overstimulati

9 likes

A white boat on water with lush green trees in the background, featuring the overlaid text "THERAPY DUPES."

A modern interior with a curved white sofa, a round ottoman, large windows, and the overlaid text "Local Support groups."

A long, arched hallway with warm lighting, candles lining the floor, a wooden door, and the overlaid text "Church."

Free Therapy Alternatives –Bc Therapy Ain’t Cheap!

Hello #GloGetter ! If you’re anything like me, you’re not actively in therapy simply because $60-$100 a session is not in your budget at the moment. And that’s okay! What’s NOT okay is that therapy isn’t accessible for most people in the US and around the world. But that’s a convo for anoth

60 likes

✨SMART Goals = SMART Results- SAVE FOR LATER ✨

Are you ready to crush your health and fitness goals in 2025? 🏋️‍♀️📝 I created this simple accountability worksheet to help you break down your dreams into actionable steps using the SMART method (Specific, Measurable, Achievable, Realistic/Relevant, Timely/Time-bound). ✨ Here’s how to use it:

36 likes

A stack of morning worksheets for young learners, with the top sheet featuring activities for the letter 'A', including coloring, tracing, circling items, and searching for the letter, alongside colored pencils and pens.

Two learning journal activities: one for dotting a squirrel and acorn brown, and another for gluing cotton balls onto a cloud outline, focusing on basic fine motor skills.

Two learning journal activities: one for coloring the letter 'S' and a squirrel brown, and another for matching acorn cutouts with corresponding letters, designed for fine motor development.

✏️ Morning Worksheets for Little Learners

Morning time has quickly become one of our favorite parts of the day. I like to start with a couple of simple worksheets — some focus on letters and colors, while others come from our squirrel and cloud learning journals. The journals are a little less advanced, which makes them perfect for war

62 likes

A detailed 50/30/20 budget worksheet template, featuring sections for income, needs (50%), wants (30%), and savings & debts (20%). It includes columns for budgeted and actual amounts, with a comprehensive budget summary to track financial progress.

🌸Budget Worksheet

Boss up by managing your finances. Set goals and meet them. 💰🪙💶🌱🏆 #financialtips #budget #moneysaving

3 likes

Okay so I am obsessed with worksheets, I find them, I have friends who are AMAZING teachers and they help me with worksheets as well. The kids go through them quickly and honestly have a blast. If it were up to them they would do this all day 😭 but momma needs a break too 😂 #homeschoollife #homes

19 likes

Anxiety Worksheet

📝✨ Exciting News! 🌟 Download Your Anxiety Worksheet Now! 🌈🌿 Hey, wonderful souls! 👋✨ I’m thrilled to share a little something I’ve crafted to support our journey toward mental well-being – the Anxiety Worksheet! 🧠📋 This worksheet is designed to help you navigate and understand your anxiety be

54 likes

Feminine Tips 101

These beginner feminine tips are just the start, sis 💫 If you’re ready to fully step into your soft, aligned, divine feminine era— ✨ I created something just for you. Grab your FREE “Becoming Her: Faith + Feminine Glow Up Worksheet” Designed to help you reconnect with God, pour into yourself,

4 likes

A black and white 'Alligator Math' worksheet for comparing numbers. It features alligator symbols for greater than and less than, and an equal sign. The worksheet provides examples and a grid of problems where students fill in the correct comparison symbol between pairs of numbers.

Alligator Math Worksheet | Greater Than, Less Than

Help your young learners master fundamental math concepts with our Alligator Math Worksheet! This fun, interactive activity is designed to make practicing greater than, less than, and equal to engaging and easy for kids. Featuring adorable alligator illustrations, the worksheet guides students thro

39 likes

✨Christian Worksheet Ideas✨

We usually do a coloring worksheet every now and then or a worksheet asking questions and I have him draw. In the mornings, we seem to do this while having breakfast after breakfast or during the day when eating a snack. The worksheets with questions and the ones where he has to draw our nice litt

5 likes

A detailed paycheck budget worksheet template, titled 'PAYCHECK BUDGET', with sections for income sources, various expenses (entertainment, personal, health, charity, household, childcare), bills, investments, debt payment, and savings. It includes columns for 'BUDGET' and 'ACTUAL' amounts, along with a summary section.

Budget Worksheet 🌸✨

Financial Freedom starts with a budget 💰 #FinancialPlanning

3 likes

See more