Automatically translated.View original post

28.3K followers

Follow

Follow

Follow

4 saved

5

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

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

Related posts

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

65 likes

-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.6K 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! ☢️

1035 likes

anyone else??? #teacher #teachersoftiktok #classroom #privateschool #summer

27 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

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

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

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

67 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

74 likes

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

91 likes

✏️ 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

61 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

12 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

42 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

34 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

26 likes

Therapeutic worksheets

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

4 likes

Book of Shadows Sample🪄📖

#lemon8challenge #lemon8contest #thingstodo #spillthetea #askleomon8 The Glam Book of Shadows for Every Witch: To me finding a Book of Shadows that had everything I needed and wanted, easy and fun to have and use was almost impossible. So, I have been working on and have created my own

67 likes

👫 COUPLES WORKSHEET 👫

#Couple #love #relationship #marriage #Lemon8Diary

9 likes

Facts over fiction

Regulation comes before resolution. If this resonated, comment CLARITY and I’ll send you a 1-page worksheet to help stop mental spirals in under 10 minutes. Tonemotivates.com/podcast #tonemotivates #shadesoftonepodcast #ClarityOverChaos #mindmazesjournal #motivation

1 like

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

63 likes

All abt me somethings are private btw!!

15 likes

A 2nd-grade morning worksheet featuring sections for name, date, daily date, scripture, and word of the day. It includes outline drawings for weather (sun, rain, snow, clouds) and feelings (happy, sad, angry, sleepy, loved), alongside a space to solve a math problem.

2nd grade morning worksheet

Good morning worksheet fit for 2nd graders

19 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

442 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

Endocrine disorders!

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

28 likes

Daily habit tracker

#healthylifestyle2024 #wellnesschallenge

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

1185 likes

Grain gradient effect in Illustrator 🎨 Join Learn Illustrator Basics to learn all about the essentials of this program #branddesign #logodesign #logo #branddesigner

1 like

If you want a free whole life self-assessment worksheet to where you’re out of tune, drop a 🔥 in the comments and I’ll send it to you! #mentalhealth #selfhealing

3 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

4 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

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

59 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

492 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

If you’re bored here are some cool things to try!!

Random Thoughts 💭What's on my mind:idk Current Mood:sleepy ⭐Rate:7/10

75 likes

It’s been tough, NGL but I’m still pushing. #fyp #fyppppppppppppppppppppppp #momsoftiktok #college #school

0 likes

A graphic promoting a free 'My Emotional Weather Report' SEL printable worksheet. It features sections for 'Today's Forecast' with weather icons, coping strategies, and growth mindset goals. Overlays highlight 'FREE,' 'self-awareness, emotional vocabulary, and coping strategies,' and 'NO-PREP • SEL • PRINTABLE,' with crayons visible.

FREE My Emotional Weather Report SEL worksheet!

FREE My Emotional Weather Report worksheet! SEL Spring Printable 🌱🫶 👉https://creativebrainsgrowhere.com/b/t6EhJ ✏️🦋What’s Included (Free Download):🌸🫶 * 1 printable My Emotional Weather Report worksheet * Visual weather key (sunny, partly cloudy, cloudy, rainy, stormy) * “Today’s Forecast”

0 likes

These pumpkins are the perfect way to practice making different kawaii expressions and add it to your doodles. If you know how to make a blob then you can definitely draw these charming pumpkins. Albrecht Durer Markers from @Faber-Castell USA uke Medium PITT artist pen in black. I also cr

4 likes

Como buscar las formas de IHSS en Google #fpy #foryourpage #viral #autism #autismoftiktok

0 likes

See more