Automatically translated.View original post

ゆい｜仕事がラクになるExcel術

384 followers

Follow

Follow

Follow

188 saved

70

[Excel utilization] Manual NG! A moment with God's work! Saturday and Sunday coloring ✨

Other posts from here 💁‍♀️

@ yui _ exel _ work

Saturday and Sunday color painting, can be automated 🔖

─ ─ ─ ─ ─ ─ ─ ─ ─ ─ ─ ─ ─ ─ ─ ─ ─ ─ ─ ─ ─ ─ ─ ─ ─ ─ ─ ─ ─ ─ ─ ─ ─ ─ ─

◆ How to automatically color-code Saturdays and Sundays with conditional formatting ◆

① Select the range you want to color

② Open "Conditional Format" - > "New Rule"

Select "Use a formula to determine the cells to format."

④ Enter "= $C6 =" soil "" in the format setting field

⑤ Select your favorite background color from "Format" and click "OK"

⑥ Do ① to ③ for Sunday, enter "= $C6 =" day "" in ④ and go to ⑤

◇ point ◇

Change the "C6" part to match the cell containing the day of the week ☺️

─ ─ ─ ─ ─ ─ ─ ─ ─ ─ ─ ─ ─ ─ ─ ─ ─ ─ ─ ─ ─ ─ ─ ─ ─ ─ ─ ─ ─ ─ ─ ─ ─ ─ ─

Please "Like ❤️" and "Save 🔖" if you like 😊

Please feel free to comment and DM 🌸

Excel technique to make work a little easier 📊

Follow here → @ yui _ exel _ work

# excel # Excel # excel _ time # Excel Time Shortener # excel _ beginner

5/28 Edited to

普段からExcelを使ってスケジュール管理や予定表作成をしていると、土日を手動で色分けするのは意外と時間がかかって面倒ですよね。そんな時に条件付き書式を活用すると、一度設定すれば日ごとに色を自動で変更できるので、作業効率が格段にアップします。私も最初は手動でひとつずつ色を付けていたのですが、毎週繰り返す作業に疲れてしまい、この方法を取り入れてからは大幅に作業時間を短縮できました。特に、曜日が記載されたセルの列を指定し、土曜日と日曜日それぞれに数式を設定することで確実に色が反映されるので、おすすめです。注意点としては、曜日情報が入ったセルの位置（例えば上記の「C6」など）が異なると、数式内のセル参照も変更する必要があるため、設定前にシートの構成をしっかり確認してください。また、背景色はお好きな色にカスタマイズ可能なので、カレンダーのデザインに合わせて調整するのが良いでしょう。さらに時短を追求する場合、色の設定を複数のシートや共有ファイルに適用する際は条件付き書式のルールをコピー＆ペーストすると便利です。Excelの色分けを活用して、デスクワークの効率化をぜひ試してみてください！

Related posts

How to Do a Successful Manual Blood Pressure! 🩺✨

Taking a manual blood pressure reading can be stressful but with practice and good knowledge, you can excel with these tips and techniques! I used to feel the same way but the more I did it, the more comfortable it became. These tips that I just revealed has helped me immensely in my career

1590 likes

A person in blue shorts and a sports bra holds a dumbbell, with various food items like meat, eggs, peas, shrimp, yogurt, and tofu floating around them. The text overlay reads 'Foods For Glute Growth What to Eat for Muscle Growth & Recovery'.

A chart titled 'PROTEIN SOURCES CHART' displays various foods like chicken breast, eggs, cottage cheese, salmon, lentils, tofu, shrimp, and bison, along with their protein content per 100g.

An infographic titled 'Top 5 Foods for Recovery' features images and descriptions of chocolate milk, tart cherry juice, peanut butter and banana sandwich, yogurt and granola, and a fruit smoothie.

Foods & Drinks I eat to Grow BIG & Strong GLUTES🍑

Muscle-building foods I use to fuel my fitness goals, along with some meal ideas I often to incorporate into my diet: 🥚Eggs: ✅Breakfast: Veggie omelette with eggs, spinach, onion, chicken sausage, and tomatoes. ✅Lunch: Egg salad sandwich on whole grain bread. ✅Dinner: Quiche with eggs, cheese

3579 likes

A collage featuring four different supplement containers: apple cider vinegar gummies, green tea extract, protein powder, and L-carnitine. The image is overlaid with the prominent text "TOP SUPPLEMENTS FOR WEIGHT LOSS".

A bottle of green tea extract supplement. Overlay text describes its benefits for boosting metabolism and fat burning, recommended daily dosage, and its use for enhancing fat oxidation during workouts.

A container of protein powder. Overlay text explains its importance for muscle repair, satiety, and metabolism, suggesting its use in smoothies or oatmeal to curb hunger and maintain muscle.

Best Fitness Supplements for Weight Loss 💪

Looking to support your weight loss journey with the right supplements? Here’s a breakdown of top-rated, effective options that can complement your diet and exercise routine. Remember: no supplement is a magic pill—pair these with healthy habits for the best results! 🌱💪 1️⃣ Green Tea Extract 🍵

3007 likes

Excel time stamps

Yes, I said permanent time stamps #exceltips #excel #tutorial #worktips #exceltraining #exceltricks

54 likes

A study desk with an iPad, highlighter, textbook, and notes, featuring the title "How to get a 4.00 GPA Based on your Major" and "All majors included!".

Strategies for Business & Management Majors (Business Management, Accounting, Finance, Economics), including Active Participation, Case Study Analysis, Practice Financial Modeling, and Utilize Study Groups, with mentions of MarketingSherpa and GroupMe.

Strategies for Communications & Education Majors (Communications, Education), including Create Multimedia Presentations, Peer Teaching, Reflective Journaling, and Attend Workshops, with mentions of Canva and Notion.

Major-Specific Strategies to Achieve a ✨4.0 GPA✨🎓🧠

🎓1. Business & Management Majors (Business Management, Accounting, Finance, Economics) ✅Active Participation: Example: In a Marketing class, when discussing a case study like Coca-Cola’s rebranding, share your analysis of the marketing mix (4Ps). This not only engages you in the materi

7045 likes

12 Financial Habits You Need to Master

1. Create a Budget Creating a budget is the foundation of financial success. It helps you track where your money is going and ensures that you’re spending within your means. To create an effective budget, start by listing your monthly income, then outline your fixed and variable expenses. Alloca

4085 likes

A MacBook Air screen shows a resume with red annotations highlighting common errors like wrong tense, typos, passive voice, and inconsistent punctuation. Overlaid text advises starting with a professional summary and using action verbs.

Resume secrets from a FAANG employee

✨ Facebook Apple Amazon Netflix and Google (FAANG) can be some of the hardest companies to break into! ✨ If you're applying to competitive roles, these tweaks actually make a difference 👇 1️⃣ Start with a professional summary Let recruiters know who you are and what you bring to the table

146 likes

Excel Power Trick: The Magic of Ctrl + Shift! 💡🔥

✨Welcome to Our Excel Mini-Class! 📈 In this session, we’re unlocking the magic of Ctrl + Shift combo to supercharge your Excel workflow! 🚀 Ever found yourself needing to quickly format time, date, currency and percentage? 🙋‍♀️ Ctrl + Shift is your secret weapon! With just a few simple keys, you

5 likes

Secure Your Excel Data Like a Pro: Set Password 🔒✨

💥 Welcome to Our Excel Mini-Class! 📈 Today's session is all about how to secure your excel data. Do you deal with sensitive data in Excel and want to keep it safe from prying eyes? 🔍 Whether you're a student, professional, or just love staying organized, learning how to set passwords o

7 likes

Excel cheat sheet

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

14 likes

#great book #good book #bookquotes

6 likes

Becoming Her: Finance Edition

✨ Financial confidence is a form of self-care. You deserve to feel secure, stable, and in control, because becoming the woman you want to be includes financial wellness too. 📌 Save this post & share with your girls—financial freedom is a lifestyle! I’ve created a free budgeting worksheet

1826 likes

How I Ruined My Credit at 19 😭 (and Fixed It)

When I was 19, I got my first credit card with a $525 limit… and I treated it like free money 😭. I was buying little “treats” here and there — coffee, skincare, random Target runs — thinking minimum payments were no big deal. Then the interest hit. Then the late fees. My balance felt impossible

605 likes

Must-Know Excel Tip for Busy Days! ⏰ 🥰

✨ Welcome to Our Excel Mini-Class! 📈 In this session, we’re unveiling the magic of Text to Columns! 🤓 Have you ever had a long list of data all in one cell and wished you could separate it into neat, organized columns? Well, now you can—with just a few clicks! 🔥 No more messy data or manual cutt

4 likes

Make handmade bags with old clothes #handmadebags #lifetricks #wasteutilization #creativediy #sewingtutorial

6 likes

How to build your CREDIT in 2026🤑

Building credit isn’t about impressing the bank. It’s about building trust. Every on-time payment, every responsible purchase, and every month of consistency helps strengthen your financial foundation. Whether your goal is buying your first car, renting an apartment, qualifying for better credit

523 likes

Nursing hustles

#nursetips #sidehustle #nurselife #moneymaking #entrepreneur

247 likes

An image overlaying the title 'DEALING WITH DEBT COLLECTORS DO'S & DON'TS' on a financial dashboard. The dashboard displays monthly expenses, incomes, credit card usage, and transaction logs, illustrating financial management concepts relevant to debt.

An image titled 'DO's' listing six actions for dealing with debt collectors, including requesting validation, verifying debt, disputing incorrect information, negotiating, recording everything, and seeking help from the CFPB. The background is a financial planning template.

An image titled 'DON'TS' listing three actions to avoid when dealing with debt collectors: don't communicate before validation, don't do nothing, and don't forget to pay taxes on canceled debt. The background is a transaction log template.

👇KNOW your Rights - Dealing with Debt Collectors

#debtcollector prey on negative feelings and all they care about is meeting their quotas. They don’t care if the debt is legitimately yours so here are some things that you shouldn’t should not do when interacting with them. DO’S: 1. Request a validation letter - they have 5 business days f

526 likes

A resume template for Jonathan Brooks, an early-career tech professional, with sections for summary, work experience, education, skills, and certificates. The text "Get Hired by Top Companies!" is overlaid in orange.

A resume template for Sarah Morgan, a customer service representative, detailing her professional summary, education, work experience, and skills. The text "Stand out Get Hired!" is overlaid in orange.

A resume template for Ethan Rodriguez, a finance and accounting executive, showcasing his professional summary, work experience, skills, and educational background. The text "Easy to edit!" is overlaid in orange.

Resume Templates - Hired by Top Companies ✅

With over 5 years of experience recruiting for global companies like BMS, Merck, Amazon, Johnson&Johnson, Stryker, Northrop - I’ve reviewed thousands of resumes and helped hundreds of professionals land interviews at Fortune 500 companies. I’ve learned what hiring managers like and what gets

156 likes

#verifiedonlemon8 #honestreview #elf Random Thoughts 💭What's on my mind: How to guides for Excel Current Mood: Accomplished ⭐Rate: ⭐️⭐️⭐️⭐️⭐️

0 likes

A purple square with a white border overlays a background of purple flowers. The text inside reads: "The Best Time-Saving Tools Every Business Owner Needs." Below, "SWIPE" with an arrow indicates to scroll, and "Lemon8 @organized2flow" is in the corner.

A purple rectangle with white text overlays purple flowers. The text describes "Automation Tools for Sales and Marketing," including setting up automated sales funnels, email marketing automation, and social media scheduling tools to save time for business owners.

A purple rectangle with white text overlays purple flowers. The text details "Streamlined Product Delivery," covering automated digital delivery systems, membership sites for access control, and instant payment processing to ensure efficient customer transactions.

The Best Time Saving Tools for Business Owners

As a business owner, particularly in the world of digital products, time is your most valuable resource. Every minute spent on tasks that don’t directly contribute to revenue is a minute wasted. If you're selling PLR (Private Label Rights) and MRR (Master Resell Rights) digital products, you&#3

2 likes

Trade lines are one of the most overlooked credit strategies out there 👀 Adding the right trade line can significantly increase your credit score — sometimes by as much as 150 points — by strengthening your payment history, increasing your average credit age, and lowering your utilization. If you

157 likes

14 likes

soft-nursing remote LPN positions 🩺

This post is for my nursing community, the ones about to finish school or maybe those who are already out here working as an LPN/LVN. Se there are so many positions out there for us, that we probably never knew existed. If you're looking for a soft nursing role, remote jobs allow such a nice wo

93 likes

🔥 1987 Toyota pick up SR5 4x4🔥

186k Miles Shown Fuel-Injected 2.4-Liter Inline-Four Five-Speed Manual Transmission 1,605 Dual-Range Transfer Case Repainted Silver Metallic Grav Side Graphics 162 Gray Cloth Upholstery 15" Allov Wheels Bilstein Shock Absorbers 258 Front Disc Brakes Bed-Mounted Toolbox Kenwood eXc

4 likes

Two Ingredient Immune Support

Ginger is loaded with health benefits as is raw honey. The combination of ginger and honey is traditionally used to soothe sore throats, ease coughs, and relieve other respiratory symptoms. It’s easy to make and easy to take. You can take it preventatively or just when you feel like you’re gettin

202 likes

A person's feet in white sneakers on a dark surface, with text 'Musclemommy Tips How to Reach your Protein Goals to Achieve Your Dream Body' and a pink arrow.

A graphic detailing protein timing for early, mid-day, and evening workouts, including pre-workout, post-workout, and balanced meal suggestions, with tips on carb and protein ideas.

An image showcasing good sources of lean protein, including cottage cheese, Greek yogurt, protein powder, egg whites, chicken breast, deli turkey, pork tenderloin, canned fish, shrimp, ground beef, ground turkey, and jerky.

Unconventional Protein Sources to Reach your Goals

✨Protein Tips for Glute Growth✨ 🍋Prioritize Lean Protein Sources: Aim to include lean protein sources in every meal to support muscle repair and growth. Opt for options like chicken breast, turkey, fish, lean cuts of beef or pork, tofu, tempeh, and low-fat dairy products. 🍋Timing is Key: Cons

842 likes

The BEST way to pay maxed credit cards✨👇

Maxed-out cards feel impossible to fix until you actually understand how credit card interest works. It’s not that you’re bad with money — the banks just make it way too easy to get stuck. Here’s the simplest way to get out: • stop paying just the minimum • use the Avalanche method (it real

36 likes

You Don't Need a Dispute Strategy

You Need a Clarity Strategy. WHAT TIKTOK GOT WRONG 😶 You've been following the advice. Disputing everything. Waiting for 680. Sending the letters. Starting over. And nobody told you it might not be necessary. WHAT I SAW FROM THE DESK 📊 📋 A 620 isn't a dead end — it's F

2 likes

20 Years At The Desk. Here’s The Exact File I’d Build Before Applying.

I'M NOT GUESSING AT THIS I spent 20 years behind the lending desk, reviewing files, approving and denying mortgages. I know exactly what a ready file looks like, because I'm the one who said yes or no to them. Here's the blueprint I'd build for myself. STEP ONE AND TWO, CLE

9 likes

✨ Welcome to Our Excel Mini-Class! 🐶 In this session, we’re diving into essential Excel functions that will save you tons of time! ⌛ From quick calculations to powerful data organization, these functions do the work for you—no more repetitive tasks! 🔄🔍 These go-to functions will boost your produ

3 likes

NYX Make ‘EM Wonder Soft Matte Foundation

The shade for this line is GOOD! 45 shades to choose from. I don’t think I ever hated a #nyxprofessionalmakeup foundation/skin tint launch. Are we shade twins??? #nyxcosmetics #nyxmakeup #blackgirlmakeup #shadetwins

14 likes

Level up now or watch your friends surpass you.

#levelup #improvemindset #levelingup #upgradeself #focusedmindset

5 likes

Understanding Credit Utilization

Understanding credit utilization ratio is one the most powerful steps you can take toward healing and building your financial future. It is truly inspiring to watch yourself balance what you owe against your available limit, turning a simple percentage into a reflection of growth and dedication. By

2 likes

#anatomy #nursing #nursingstudent #college

1 like

A tablet screen displays the title "FLEXJOBS VS REMOTE CO" and "Remote job hunting," with a "SWIPE" arrow, indicating a comparison of two remote job platforms.

A person on a beach uses a laptop, with an overlay detailing FlexJobs' features, including vetted listings across 50+ career fields, client support, and subscription costs, alongside a screenshot of the FlexJobs website.

A laptop screen shows the Remote.co website, with an overlay describing its features as a FlexJobs partner, offering job postings, a remote work blog, and Q&A. It highlights comprehensive resources but notes fewer job listings.

Remote Job Hunting: FlexJobs vs RemoteCo

Hello everyone! When hunting for remote jobs, FlexJobs and RemoteCo are top platforms to consider. FlexJobs requires a subscription but offers a highly curated, scam-free list of remote jobs along with resources like resume reviews and career coaching. RemoteCo, while free, provides a wide variety

29 likes

Sis, it’s time to stop playing small. 💳💼

It’s 2025, It’s time to live your best life!! We’re using credit as a tool—not a trap—to build wealth, fund our goals, and create freedom. 🔑✨ No more broke mindsets. No more bad credit holding us back. We’re fixing scores, stacking savings, and stepping into the soft life we deserve.💅🏾 #LevelUpL

6 likes

10 likes

#creditutilization #creditrepair #creditscore #parttwo

20 likes

The image features a purple background of flowers with a central purple square containing the title "How to Make Your Business Work for You, Even While You Sleep." A "SWIPE" indicator with an arrow is in the bottom right, and the Lemon8 handle "@organized2flow" is at the bottom.

This image, set against a purple floral background, lists ways to "Automate Your Income Streams." It details selling digital products, setting up subscription-based offers, affiliate marketing, and e-commerce with dropshipping, providing examples for each method. The Lemon8 handle is visible at the bottom.

Against a purple floral background, this image outlines how to "Use Automation to Handle Business Tasks." It covers customer support with chatbots, automating email marketing, scheduling social media in advance, and automating appointment bookings, with examples for each. The Lemon8 handle is present.

Make Your Business Work For You While You Sleep

Imagine waking up to new sales, fresh leads, or booked appointments—all while you were sleeping. That’s the power of setting up automated systems that keep your business running 24/7, even when you’re not actively working. The goal isn’t just to make money; it’s to create freedom so your business w

13 likes

A tip to make you distinguish from ur colleagues!✨

👉 Welcome to Our Excel Mini-Class! 👋 Tired of text getting cut off or spilling out of cells in Excel? 😅 Today, we’re showing you the Shrink to Fit feature—a simple way to automatically adjust text size so it fits neatly inside any cell! 📝💼 Perfect for making your spreadsheets look clean, organiz

3 likes

See more