Automatically translated.View original post

Let's do a dropdown using the spill range. 😁

7/17 Edited to

... Read moreการใช้ spill range ร่วมกับฟังก์ชัน UNIQUE และ VSTACK ใน Excel เป็นเทคนิคที่ช่วยให้การสร้าง dropdown list มีประสิทธิภาพและความยืดหยุ่นสูงขึ้นมาก จากประสบการณ์ที่ได้ลองใช้ พบว่าวิธีนี้ช่วยกำจัดข้อมูลซ้ำซ้อนและจัดกลุ่มข้อมูลได้อย่างชัดเจน ทำให้ dropdown ของเราสามารถอัปเดตอัตโนมัติเมื่อข้อมูลในตารางมีการเปลี่ยนแปลง ยกตัวอย่างเช่น การดึงค่าทีม สถานะ หรือประเภทสินค้า ซึ่งเดิมทีต้องใช้การปรับแต่งด้วยมือเยอะ การใช้ฟังก์ชัน UNIQUE จะช่วยคัดกรองรายการที่ไม่ซ้ำออกมาเป็น spill range โดยอัตโนมัติ และ VSTACK ยังช่วยเพิ่มหัวข้อพิเศษเช่น "ทั้งหมด" หรือ "ทุกทีม" เข้าไปในรายการ dropdown ทำให้ผู้ใช้สามารถเลือกดูข้อมูลภาพรวมได้สะดวกขึ้น นอกจากนี้ การเตรียม Helper Column ที่ประกอบด้วยสูตรเหล่านี้ ยังช่วยลดความซับซ้อนขั้นตอนการทำงาน และทำให้ไฟล์ Excel มีความเป็นมืออาชีพมากขึ้น จากที่ทดลองใช้ในโปรเจกต์งาน วิเคราะห์ยอดขายและสถานะต่างๆ พบว่า Workflow การกรองข้อมูลใน Excel ง่ายและรวดเร็วขึ้นมาก เหมาะกับคนที่ใช้ Microsoft 365 เพราะจะสามารถใช้ฟังก์ชันเหล่านี้ได้เต็มประสิทธิภาพ สรุปว่าการเรียนรู้สร้าง dropdown ด้วย spill range ร่วมกับ UNIQUE และ VSTACK เป็นการเพิ่มทักษะ Excel ที่น่าสนใจมากๆ ช่วยประหยัดเวลาและเพิ่มความแม่นยำในการจัดการข้อมูล ตัวช่วยสำหรับงาน Data Management ที่หลายๆ คนควรลอง

Related posts

A laptop screen displays Google Docs with colorful, organized notes on 'The Trial of Anne Hutchinson.' An overlay reads 'HOW TO MAKE GOOGLE DOC NOTES.'
A screenshot of Google Docs shows the 'Insert' tab menu open, with 'Drawing' and '+ New' highlighted, indicating the first step of the tutorial.
A screenshot of the Google Docs drawing tool shows the 'Shapes' menu open, with 'Rounded Rectangle' highlighted for selection.
Google Docs Notes Tutorial 📝💗
hey guys I’ve missed you! 😔🙏 college has been keeping me busy a lot of you asked me how I make my google doc notes so I’m finally dropping the tutorial 😏 📝 google docs tutorial 📝 step 1 (title): 1.) go into the insert tab and click drawing +new 2.) click on shapes and select “rounded r
juanita ☆

juanita ☆

29.5K likes

Want Thicker Thighs & Glutes? Try THIS! ✅
Combining the trap bar deadlift with the sissy squat machine is an effective way to target both the thighs and glutes in one workout. The trap bar deadlift emphasizes hip extension, engaging the glute max and hamstrings, while the neutral grip and elevated handles allow for greater knee flexion, re
Zara_Sanchi

Zara_Sanchi

131 likes

How To Make A Simple Content Planner on Your iPad
Here’s an easy way to make a content planner on your iPad to help you organize your content. This will be a simple, generic tutorial (you can customize it further). 📅 You will need to download Google Sheets from the App Store for this planner. 📅 Once you have Google Sheets installed, your fir
🌻ChromaGlitch

🌻ChromaGlitch

237 likes

An outdoor dining scene with people seated at tables, featuring the overlaid text "Freeze the Top Row in Excel." A purple glass is visible in the foreground on a black mesh table.
A light beige background with black text asking, "Do you ever have hundreds of rows of data and when scrolling down, you loose sight of the column header and forget which column/field is which?"
A light beige background with black text stating, "This is when freezing your top row is crucial! I will show you how!"
HOW I FREEZE THE TOP ROW IN EXCEL
The ability to freeze that first row of my column headers has been a lifesaver, allowing me to scroll through thousands of rows of data without losing sight of my column headers/fields. By simply selecting the row below the one you want to freeze, heading to the "View" tab, and clicking
Peyton’s Place

Peyton’s Place

105 likes

Blank EXCEL template for school nurses!
As a school nurse this isn’t perfect but I wanted to share it anyways. It is a BLANK excel template for students with health conditions. Just click and request access. Is there any other templates you’d like to have access to or need ? 1. Click my link tree in my bio!!! Click on drop down arrow
Officialtiktoknurse

Officialtiktoknurse

78 likes

A Google Sheets-based 2025 content calendar for January and February, displaying an annual summary, monthly summaries for various platforms, and a published posts breakdown, with the overlay text "effective content planning tips."
A close-up of the 2025 content calendar setup for January, overlaid with the text "1. Use answerthepublic.com to brainstorm content ideas" and a screenshot of the answerthepublic.com website showing search results for "google sheets."
A close-up of the 2025 content calendar setup for January, with the text "2. Record your ideas so you don't forget!!!" and "I use Google Sheets & this is me setting up my content calendar," showing a dropdown list of items.
How I Content Plan In Google Sheets 🤌
(and post consistently while staying motivated) When I first started posting on L8, I had tons of idea for creating content but would hit a sluggish period like having a writers block when deciding what content should I post & when. A lot of it was trial and experimenting to understand what
TheHappyPlanner

TheHappyPlanner

101 likes

A person with long braids poses under a tree branch, with text overlaying the image that reads "YOUR SHORTCUT TO LEARNING A LANGUAGE fast!".
A laptop screen displays the Lingvist website, showing a list of 11 languages available for learning, including Danish, Dutch, English, and French.
A laptop screen shows a Lingvist fill-in-the-blank exercise for German, displaying the word "das Spiel" and its English translation "game, play".
Use LingVist to Learn a Language!
For those just beginning to learn a language and who are not sure if they are ready to fully commit to a learning plan, use Lingvist to start! (FREE for 14 days, $10/month, $80/year) Choose from 11 languages – and the cool part is that you can choose which language you want as your default, so i
Anaïs D’Ottavio

Anaïs D’Ottavio

719 likes

Become a Notary Public in California
All the information to become a Notary Public in the state of California can be found on the Secretary of State's website. If you're in need of training, make sure to get your education from an approved vendor. I will share the vendor I went with in the next post. Each vendor charges di
Sushi_kitten24

Sushi_kitten24

7 likes

A laptop on a white desk with pink flowers and rose gold decor. Text overlay reads "5 FREE Online resources for STUDENTS" in blue and pink fonts.
A pink binder with "Stay Positive" text and a rose gold desk organizer. The IXL logo is displayed with text describing IXL as a personalized learning platform for students.
A pink binder and a rose gold desk organizer. Google Keep and Evernote logos are shown with text describing them as note-taking apps for organizing ideas and tasks.
5 Free Online Resources For Students ✨️
Hi, lemons! Fellow knowledge seekers! 🌟 Are you ready to dive into the digital world where learning is lit and productivity is the new cool? Let’s spill the tea on five online resources that are total game-changers for your educational glow-up. Get ready to level up your brain game with these epic
Lifestyle Babe

Lifestyle Babe

148 likes

Language Study Template (Notion) - Part 2 Tutorial
✨Perfect for Chinese learners (but work for any language too). Start your language study journey today with structure, creativity and motivation all in one place. Download now at 🛒missydizzy.gumroad.com #notiontemplate #studytemplates #chineselearning #notionstudent #learnlanguage
Missy Dizzy

Missy Dizzy

2 likes

Loungewear must haves 🌼💕
all of my favorite amazon loungewear finds! 📍 Find everything 🔗 on my amazon storefront in my bio (use dropdown links)! - 8 pack headbands, so trendy! - softest crewnecks ever, size up 1 if you want it extra comfy! - Aritzia quality cargo sweatpants, NEED in more colors - Lulu inspired mat
Katie Clark

Katie Clark

794 likes

A MacBook displays a forest wallpaper with the text '3 Must-Have Mac Tools That Instantly Boost Productivity'. A small laptop icon with a lightning bolt is shown above the illuminated keyboard.
A MacBook screen shows the App Store featuring 'Raycast', described as a powerful launcher for searching apps, running shortcuts, and controlling functions from the keyboard.
A MacBook screen displays the App Store featuring 'Notion Web Clipper', described as a digital brain for creating dashboards, tracking habits, and planning content.
Work Smarter on Your Mac with These 3 Simple APPS
My Mac used to just look good… now it works like a boss too. 🧠💻 If you’re always bouncing between tabs or just want to feel more organized, these 3 tools changed everything for me. They’re fast, simple, and feel like secret weapons I wish I knew about sooner. Let me know if you want a full set
CozyGirlMama 😎

CozyGirlMama 😎

314 likes

Struggling to find the right words when you teach
I just found this book on Etsy and honestly… it completely changed how I cue. I didn’t even realize how much I was repeating the same words until I started using it. My brain knew the exercises, but my mouth? Not always 😅 This book helped me: • find clearer words • use richer imagery • ex
Emma.cwan Pilates

Emma.cwan Pilates

0 likes

Create a dynamic colored dropdown in 30 seconds
Spice up your spreadsheets! Learn how to create dynamic colored dropdowns in Googie Sheets in 30 seconds! This easy trick adds a pop of personality and organization to your data. #googlesheets #spreadsheets #dropdown #colorcoding #productivity
SheetsbyOlan

SheetsbyOlan

5 likes

A hand holds a smartphone displaying the title slide for a tutorial: "Notion for Caregivers: A Step-by-Step Tutorial." The text "Life of Caregiver" is at the top left, and a "SWIPE" arrow is at the bottom right, indicating more content.
Three Notion mobile screens show the initial steps of a caregiver tutorial. The first covers getting started and creating a dashboard. The second details setting up a Medication & Health Tracker. The third explains setting up reminders and a Doctor Appointments & Medical Notes page.
Three Notion mobile screens continue the caregiver tutorial. The first shows details for Doctor Appointments & Medical Notes. The second outlines setting up a Daily Care Schedule using a Kanban board. The third demonstrates creating an Emergency Contacts & Important Information table.
Notion for Caregivers: A Step-by-Step Tutorial
Caring for a loved one can be overwhelming, with medications, appointments, daily routines, and emotional well-being all needing attention. Notion, a powerful and flexible organization app, can help caregivers manage responsibilities, track health updates, and stay organized. This tutorial will
GrievingGracefully | 💎4life

GrievingGracefully | 💎4life

16 likes

winter basics 🖤
Go to the dropdown link in my bio and head to the amazon storefront to shop these winter finds! All under the basics list 🫶 - most adorbs chunky sweater, wearing a size medium! - Aritzia quality cargo sweats, these are perfect for loungewear! - BOOTCUT JEANS, these are true to size and so flat
Katie Clark

Katie Clark

809 likes

Shopify menu customization tutorial
Here is how to create a dropdown menu on Shopify, this is a great method for if you’re looking for a Shopify menu customization tutorial. The Shopify theme in this video is on my page 🤍 #shopify #makemoneyfromhome #shopifytips #startabusiness #viral
McKenna Beverly

McKenna Beverly

1 like

A laptop displays aesthetic Google Docs notes about Phenobarbital, with the text "TAKING NOTES ON GOOGLE DOCS" below. The background is pink with sparkles.
A Google Docs interface shows how to customize document settings via "Page setup" and add decorative shapes using the "Drawing" tool, with a "Women's Civil Rights Movement" example.
A Google Docs interface demonstrates how to insert and customize tables using available features, including adding columns and horizontal lines to divide topics, with a floral accent.
Aesthetic Notes on Google Docs 🎀✨
Is it only me or do ya’ll also take notes on Google docs when in class/lecture ?? 📑🤍 The last pic is an old example of one of my notes!! #Lemon8Diary #studygram #notes #studytips #StudyHacks #study #aesthetic #pink #shareyourthoughts #healthylifestyle2024
L. Tatana 🤍🦢

L. Tatana 🤍🦢

4733 likes

A laptop screen displays a customized Google Docs notes page for 'Calc 3' with a pink title, class announcements, main topic, and class topics featuring colored dropdowns for understanding levels.
A laptop screen shows the Google Docs 'Page setup' menu, where the user is changing the page color to a whitish magenta, demonstrating the first step in customizing the notes page.
A laptop screen displays the Google Docs 'Drawing' tool, showing the creation of a pink, outlined 'Calc 3' title, illustrating how to make a fun title for the notes page.
Google docs custom notes page 💕
I love making these notes pages!! It really makes taking notes fun! The one thing I will say is that I do not do all my notes here, I mostly use them as keeping track of topics, announcements, and to make study schedules. The drop down menu is my favorite part; it is a must! It is super e
Sarah :)

Sarah :)

77 likes

A Google Sheets tab titled 'My Courses' displaying course codes and names, with an overlay indicating 'MY UPDATED ASSIGNMENT Master list' for academic organization.
A Google Sheets view showing a 'Course Schedule' by semester and year, alongside 'Course Progress' tracking finished assignments and completion percentages for various courses.
A Google Sheets 'Course Progress' section demonstrating auto-colored boxes (green, yellow, red) based on assignment completion percentages, with 0% completion being blank.
How to Create A Masterlist in Google Sheets
Starting template: https://docs.google.com/spreadsheets/d/1MrxXG08PumhN1c5z5-3_kUA1_H5-z9OJFzSz0c_BVUQ/edit. I recently updated my Google Sheets Masterlist and filmed a tutorial of the process a too. My Masterlist and Calendar has kept me on top of all my readings, homework, exams, and I also ad
TheHappyPlanner

TheHappyPlanner

476 likes

This image outlines electrolyte relationships, showing inverse connections like Sodium/Potassium and Calcium/Phosphate, and similar ones such as Calcium/Vitamin D and Magnesium/Calcium, with definitions for inverse and similar interactions.
This image details sodium imbalances: hypernatremia (over 145 mEq/L) and hyponatremia (under 135 mEq/L). It covers causes, signs, symptoms, interventions, and dietary advice for each, alongside sodium's normal range and bodily goals.
This image details potassium imbalances: hyperkalemia (over 5.0 mmol/L) and hypokalemia (under 3.5 mmol/L). It covers causes, signs, symptoms, interventions, and dietary advice for each, alongside potassium's normal range and bodily goals.
🔋Electrolyte Relationship You NEED to Know 🩺💉
Electrolytes play a HUGE role in maintaining body function, and understanding their relationships will help you ace your exams & care for patients effectively! 📌 Save this post for later & tag a nursing student who needs this! 🏥💙 #NCLEXTips #NursingSchool #ElectrolytesMadeEasy
Nurse Radiance

Nurse Radiance

96 likes

A pink-themed desk setup with a computer displaying the Text Blaze extension interface, showing an email template. Overlaid text reads 'SWIPE TO VIEW' and 'Use this extension to save time'.
A screenshot of the Text Blaze extension interface, demonstrating how to create and use snippets like '/emailreminder' for repetitive text, with customizable fields for an email reminder template.
A detailed view of Text Blaze's dynamic commands, showcasing various customizable features like date/time insertion, clipboard content, cursor placement, and form fields (text, paragraph, dropdown, toggle, date/time).
the ultimate time-saving extension!
‧°𐐪♡𐑂°‧₊ ✨ This chrome extension is perfect for anyone who wishes they had a quick way to write repetitive text (reminder emails, meetings, etc)! It’s called “text blaze” where you can create snippets or shortcuts to create a small/large text snippet for you! For example, if you always need to wr
peachiesuga ♡

peachiesuga ♡

155 likes

How to Stream Your Console on OBS Studio
For this I am using my Nintendo Switch but this should work for any other console as well. Step 1: Nintendo Switch & Capture Card Connection 1. Insert the HDMI cable into the Nintendo Switch Dock (where the HDMI Out port is located). 2. Connect the other end of the HDMI cable to the HDMI I
KasuallyKat

KasuallyKat

365 likes

A desk setup with a laptop and a monitor displaying a calendar interface, illustrating time blocking tips for better organization and productivity.
A screenshot of calendar settings for event notifications, demonstrating how to set up default reminders for events at 30 and 60 minutes.
A screenshot of calendar settings for time zones, illustrating how to add and display a secondary time zone, such as Pacific Time, for easier management.
Time Blocking Tips to Organize Your Calendar
Make your calendar work “for you”—not the other way around! ⏰  From setting up auto-reminders to tracking multiple time zones, these quick hacks are here to simplify your life.  Just tweak a few settings, and you'll have reminders that pop up automatically, custom views that fit your day,
Reverelia

Reverelia

169 likes

3 Reasons Why I love my Travel Dashboard
The real reason is so I can plan a trip once and look back at my itinerary when I want to visit a place again. But that aside, I’m def a type A person so I like being organized too! #travelplanner #bucketlist #travelwithme2024 #unfiltered #travelideas #heathlylifestyle2024
TheHappyPlanner

TheHappyPlanner

183 likes

A Google Sheets dashboard titled 'Cost Splitter Dashboard' with financial summaries for multiple individuals. Large text overlay reads 'GOOGLE SHEETS HOW TO ADD IMAGES'.
A Google Sheets screenshot showing the 'Insert' menu with 'Image' highlighted, demonstrating the first step to add images. The text overlay says '1. INSERT > IMAGES'.
A Google Sheets screenshot showing the 'Image' submenu with 'Insert image in cell' and 'Insert image over cells' highlighted. The text overlay says '2. INSERT IMAGE IN CELL OR INSERT IMAGE OVER CELLS'.
👇🏻How I add images in Google Sheets
First Method: 💻 1. Copy and Paste OR Second Method: 🖥️ 1. Go to Insert > Images 🖼️ 2. Insert images ✅ 3. Upload and browse for image from computer These are the steps on a laptop and steps for the Google Sheets App are slightly different but I’ll bring sharing more tips on using
TheHappyPlanner

TheHappyPlanner

286 likes

A Google Sheets bingo card template titled 'MY 2024 BINGO' with a 5x5 grid, checkboxes, and a color dropdown set to 'Coral'. Overlay text explains 'How to make A bingo card In google sheets'.
A laptop screen displaying Google Sheets, illustrating steps to create a bingo card. It shows merging 4 rows (C15 to C18) and adding a checkbox from the 'Insert' menu, with instructions to repeat for a 5x5 grid.
A laptop screen showing Google Sheets, demonstrating how to add a dropdown in cell G2 and populate it with various color names like Aqua, Coral, Green, and Teal for customization.
✨ Use Google Sheets like a Pro - goals bingo card
This is how you can create an interactive Goals Bingo Card in Google Sheets: 1. Merge 4 rows 2. Add a dropdown below it 3. Outline all 5 rows (outer edges only) 4. Add a dropdown for changing color 5. In one of the boxes, add conditioning formatting using this custom formula: =AND(G2=&#3
TheHappyPlanner

TheHappyPlanner

39 likes

Drop down chips
Drop down chip tutorial. Add drop down options to your spreadsheet like this #tutorial #googlesheets #exceltips
Excel tips at XecuteTheVision

Excel tips at XecuteTheVision

37 likes

The Aceable app's main screen, featuring its logo, the tagline 'Take State-Certified Real Estate Education. Anytime, Anywhere,' and a prominent call to action: 'Let's Pass The Real Estate Exam!'.
A screenshot from the Aceable app showing 'Your Courses,' listing 'Washington Unit 2: Real Estate Practice' and 'Washington Unit 1: Real Estate Fundamentals,' both marked as completed.
A screenshot from the Aceable app's 'Records' section, displaying certificates for 'Washington Real Estate Practice (June 2024)' and 'Washington Real Estate Fundamentals (May 2024)' ready for viewing.
Let’s Pass The Real Estate Exam!
#lemon8diarychallenge Hi there! If you’re interested in becoming a real estate agent and don’t know where to start, let me help you! First you need to make a research for the license’s requirements of the state you’re living in or the one where you want to get your license from. If you’re
✨Cuban_nextdoor

✨Cuban_nextdoor

36 likes

Day 4 of 31; 31 days to a safer you. How you can delete all your data online “Incogni” 👇🏼 Follow for more #IncogniPartner
Cybersecurity Girl

Cybersecurity Girl

865 likes

👀 Create dynamic prompts with this AI extension!
‧°𐐪♡𐑂°‧₊ 🎀 Supercharge your productivity with AI Blaze, the ultimate AI copilot for any website with certified security! Use shortcuts like /email in Gmail to craft replies, /correct to fix typos, or /edit to polish your writing. With dynamic prompts, you can translate text, make it more professi
peachiesuga ♡

peachiesuga ♡

38 likes

Homeschool materials
I’ve been asked what/how I got started with homeschooling my baby who was around 1 1/2 when we started. She’s now three and thriving in preschool. Made the highest score on her mid year assessment at school and I’m so proud 🥲🙌🏽 #homeschoollifestyle #homeschoolforbeginners #homeschoolmama
Jade Cabrya

Jade Cabrya

132 likes

A Google Sheets travel dashboard for a Bangkok trip, showing booking summary, budget overview, attractions, destination details, and an itinerary snapshot with a 191-day countdown.
A Google Sheets 'Trips' tab for travel planning, listing trip details like name, dates, estimated cost for 'Thailand 2024', and lifetime travel statistics.
A Google Sheets 'Accommodations' tab for comparing hotel stays, featuring sections for best options, a list of all stays with details, and a 'To Do's' checklist.
Google Sheets Inspo - Travel Edition ✈️
6 tabs in my Travels Dashboard that helps me decide on $3500 budget for a Thai solo trip (and why) : 1. Trips (so you can plan for multiple trips without duplicate the entire Google Sheets) 2. Accommodations (so you can compare stays - I added a filter for mine that can pull the tops 3 based
TheHappyPlanner

TheHappyPlanner

396 likes

spring/summer fashion finds 🖤
amazon fashion finds perfect for spring & summer ✨ ALL 🔗’d ON MY STOREFRONT UNDER DROPDOWN LINKS IN BIO #amazonsummerfashion #amazonfashionhaul #amazonfashionfinds #summerfashioninspo #amazonjewelry
Katie Clark

Katie Clark

1156 likes

This image illustrates the 70/20/10 budget breakdown, showing 70% for needs (housing, food, transportation), 20% for wants (daily spending, shopping), and 10% for savings (savings fund, emergency fund) based on an $18/hour income.
This image shows step 1 of the budgeting tool, where the user enters an hourly wage of $18 for 40 hours/week, resulting in an automatically calculated monthly income of $2,331 and annual income of $27,970.
This image displays step 2, where the user selects the 70/20/10 budget split from a dropdown menu, with other options like 50/30/20, 80/10/10, and 90/5/5 also visible.
How to budget using the 70/20/10 rule 💸
Most budgets are too complicated to set up, but this one actually makes sense when you're trying to save more each month. The template does all the percentage calculations automatically - you just enter your income, choose pre-tax or tax, and it tells you exactly how much to spend in each ca
Kevin’s Templates

Kevin’s Templates

593 likes

This is your sign to start planning out content
Go get the Social Media Calendar now it’s only $3.99 https://brookproducts.etsy.com/listing/1643592466 #contentcreator #contentcreatortips #newcreator #howtostartayoutubechannel #consistency #contentcreatorlemon8 #blackgirlcreator #blackgirlvlogs
Jani

Jani

1 like

A flat lay of recent Amazon purchases including folded white and brown clothing, gold hoop earrings, a gold bracelet with white clover charms, and two dark hair claw clips.
Two athletic dresses with built-in shorts, one in black and one in white, laid flat on a white textured surface.
An open jewelry box showcasing a collection of gold-colored jewelry, including necklaces, rings, bracelets, and a watch, on a light pink velvet interior.
AMZN RECENT ORDERS 🍒
recent orders for spring & summer from amazon! All are SO good! ALL 🔗’s IN BIO ON DROPDOWN LINKS! #amazonfashionfinds #amazonmusthaves #amazondeals #amazonspringfashion #amazonsummerhaul
Katie Clark

Katie Clark

2847 likes

A Google Sheets budget calendar for 2024, titled 'How to zero-based Budget for beginners w/Google Sheets', showing monthly summaries, fixed and variable bills, income, savings, and spending categories for January and February.
Four steps for setting up a budget calendar: selecting the starting weekday and month, adding incomes, bills, and spending, and ensuring all funds are allocated, displayed on a Google Sheets interface.
Illustrations of budget allocation statuses: no income added, funds remaining to allocate, overspending, and achieving zero-based budgeting, each with a 'Left to Budget/Allocate' amount.
How to 0 based budget for Beginners 🤌
1. Write it down - use paper and pen, digital journals, or Google Sheets like one I’m using here 2. Start with monthly fixed bills (rent, auto payment, student loans, phone, internet,etc) and dates 2. Next are variable bills (electricity, water, medical bills, etc) and due dates 3. Plan when y
TheHappyPlanner

TheHappyPlanner

1456 likes

Build better habits with this Notion Habit Tracker
I started using this Notion Habit Tracker to organize my daily routines, and it has made staying consistent so much easier. Instead of feeling overwhelmed by big goals, I can now: 🌿 track my habits every day 📊 see my progress visually 🎯 stay focused on what matters 💡 build routines that actu
IdeationWorks

IdeationWorks

17 likes

A laptop screen displays a completed Google Sheet schedule with due dates, class names, assignment names, and checkboxes, demonstrating an organized layout.
A laptop screen shows a Google Sheet with only due dates entered in column A, illustrating the first step of aligning due dates.
A laptop screen displays a Google Sheet with due dates in column A and class names in column B, showing the addition of class information.
Cute & Organized Schedule!
Hey college students! Here’s how I make my schedule look so cute and organized! Credit (instagram): @ missynjohnson #collegelife #aesthetic #organize #collegegirllife #greenaesthetic
Heather Battles

Heather Battles

405 likes

Reposting from my instagram for my new followers 🤍 #muslim #revertmuslim #ummah #islam
Lemon8er

Lemon8er

11 likes

Two brown throw pillows with subtle piping rest on a white textured sofa, introducing a collection of Amazon home finds.
A cream-colored stacking jewelry box with a clear lid displays various accessories, accompanied by a pearl-decorated hair claw clip on a white surface.
A tall artificial olive tree with green leaves and small olives stands in a light gray pot next to a white dresser and a window with horizontal blinds.
AMAZON HOME FINDS 🤎
amazon finds in my apartment! These are SO good & great for those on a budget!! ALL 🔗’s IN BIO IN DROPDOWN LINKS #amazondecor #amazonhomefinds #amazonapartmentfinds #neutralapartment #homedecorfinds
Katie Clark

Katie Clark

964 likes

An iPhone displaying a home screen with custom, pastel-themed app icons for apps like Netflix, Snapchat, and TikTok, under the title 'how to install icon themes on iOS!'.
A three-panel image showing how to save custom app icon images to the Photos app, by selecting multiple files from a folder and saving them.
A three-panel image demonstrating how to open the Shortcuts app, create a new shortcut by tapping '+', and add the 'Open App' action.
how to install custom icon themes on iOS ✨
I wanted to share this tutorial on how to install icon themes on your iPhone using the Shortcuts app! it’s super easy once you know the steps, and it completely transforms your home screen aesthetic. follow the steps I’ve outlined to create custom shortcuts for each app, change the icon image, a
studiocherii

studiocherii

39 likes

Google Calendar 🤝🏼 organized & optimized
I have been a planner girlie literally my entire life, whether that be a physical/digital planner, a calendar app, or literally anything else that organizes your weekly schedule. But from time to time I have struggled with finding the planning system that actually makes me feel productive and organ
Allie Marie 🧚🏻

Allie Marie 🧚🏻

50 likes

HTML5 Cheatsheet for Beginners – Essential Tags
Want to master HTML5? Here’s a quick cheatsheet covering essential HTML tags – from document structure to forms, tables, and multimedia elements! #coding #html #programming #studymotivation
Aysha

Aysha

105 likes

Checkbox and Xlookup combo
Check a box and see the info #tutorial #exceltips #googlesheetstips #spreadsheet #work #list #elearning #fyp
Excel tips at XecuteTheVision

Excel tips at XecuteTheVision

13 likes

See more