Automatically translated.View original post

7548 followers

176 saved

Color specific cells in bulk🎨

The shift table...

· Troublesome

・ Simple

・ But it takes time

There s a lot of repetition, right 😭

Especially

"I want to change the color only for holidays"

Isn't this a simple hassle?

If you apply it by hand

✔ paint

✔ wrong

✔ Redo each time you modify

Honestly, it's hard.

For those who are in charge of shifting

I will do [shift table series] for a week ✨

[It ends quickly because it is done every month]

Introducing time saving 🪄

😎 today

How the color changes the moment you enter "rest"

[Operation method]

① Select the range you want to color

② [Home] → [Conditional Format] → [New Rule]

Select "Format only cells that contain the specified value."

④

Cell value - > "Equal to next value"

Enter "rest" in the value field

⑤ Select the fill color in [Format]

⑥ OK

👉 this

The moment you type "rest,"

It is color-coded automatically!

Once you set it up.

Even if you enter or modify it later

All ✨

📌 and use it to create the next shift

👀 follow for more

In the next video

We will introduce the setting that automatically enters the date and day of the week!

- - - - -

On this account.

For those who are not good at computers and lack confidence

"I didn't know...!" changes to "I did it!"

We are sending PC basics and time saving techniques 💻🔰

I'm starting to feel sorry for asking around

· I want to graduate from my own style soon

・ I want to gain confidence in office work

Such a person

"I think I can do this too."

So that it seems...

Let's reduce the discomfort of computers together 🌸

I am posting this post.

・ Excel / Word time saving technique

・ Basic operations that make office work easier

· Beginners are easy to stumble point explanation

▼ Profile

· PC instructor experience 20 years

· Support more than 2,000 beginners so far

· Calicon qualified / It is an ally of those who want to change jobs 🍀

▼ There are many other time saving techniques

@ yuri _ pcwork

2/20 Edited to

私も以前、シフト表の作成で「休み」のセルを一つ一つ色付けして時間を取られていました。手作業だとどうしても塗り忘れや間違いが起こってしまい、修正も手間。ゆりさんの紹介している条件付き書式を使った色付け方法を知ってからは、その問題がすぐに解決しました。具体的には、Excelの［ホーム］タブの［条件付き書式］→［新しいルール］から「指定の値を含むセルだけを書式設定」を選択し、セルの値に「休」を入力。塗りつぶしの色を設定しておくと、「休」と書いた瞬間にセルが自動で色付けされます。私の場合はライトグレーを使っていて、シフトの見やすさもアップ。さらに一度設定しておけば、翌月のシフト作成にテンプレートとして使い回せるので、毎月の作業が本当に楽になりました。この方法はExcel初心者の私でも簡単にできたので、事務作業の効率化に悩んでいる方にはぜひおすすめです。色選びやセル範囲の指定も自分好みにアレンジでき、仕事の流れに合わせて色を変えたり条件を追加したりも可能です。次のステップとしてゆりさんの動画で紹介されている日付と曜日の自動入力設定も学び、シフト表全体の作成時間をさらに短縮したいと思っています。私の職場でもこの時短ワザを共有したところ、「これなら自分にもできそう」と好評でした。シフト表作りが苦痛だった方には、小さな工夫で大きな効率アップとなる条件付き書式による色分け、ぜひ試していただきたいですね。

A slice of watermelon rests on a wooden cutting board, accompanied by the title text "FRUITS FOR WEIGHT LOSS According to Nutritionists."

The image features text detailing how papaya aids digestion, highlighting its papain, fiber, and water content. Halved papayas with visible seeds are shown at the top and bottom.

Text explains how avocado helps burn fat, listing its vitamins, healthy fats, and fiber. Halved avocados are depicted at the top and bottom of the image.

Fruits To Eat To Help Lose Weight & Get Healthy🍒🫐🍉

Hey, luvs! I’m excited to share some juicy info with you today. Let’s talk about fruits that can help you shed those extra pounds and keep you healthy. They'll help you satisfy your sweet tooth too! 🍏🍓🍍 Despite their natural sweetness, research shows that fruits are excellent for weight mana

33.2K likes

A person with braided hair and sunglasses sits at an outdoor table, looking right. Behind them is a purple food truck decorated with flowers. An overlay reads "Spanish resources for beginner learners!".

A laptop screen displays "The Spanish Experiment" website, showing free Spanish lessons on greetings, question words, and formal vs. informal 'you'. The text overlay highlights learning through children's stories and basic lessons.

A laptop screen shows the StudySpanish.com website, featuring a lesson on "Gender of Nouns" with notes and examples. The overlay describes it as offering beginner lessons with grammar, vocabulary, pronunciation, and quizzes.

Spanish-specific resources

Here’s a list of resources that you can use if you are learning Spanish and are maybe not prepared to spend money or want to try something different than DuoLingo. These are Spanish-specific resources that you can use – but make sure to check my page for other learning resources that are more advan

3267 likes

Excel shortcuts every student should know! 👩🏻‍💻

Stop Wasting Time: Master These Excel Formulas for Maximum Efficiency! 🕒 If you’ve ever struggled with Excel, mastering formulas can seriously up your game. Here’s a breakdown of the essentials that’ll make you look like a pro 1.Core Calculation Formulas 🧮 These are the basics you can’t live

1175 likes

A person sits on a beach at sunset, looking back at the camera. The image is overlaid with the text "Feminine Glow Up Phase 2 - Beauty & Self Care."

A list of morning skincare routine steps: cleanser, toner/mist, antioxidant serum, hydrating serum, eye cream, moisturizer, and sunscreen. Several skincare product bottles and tubes are shown below the text.

A list of nighttime skincare routine steps: oil-based cleanser, water-based cleanser, toner/mist, targeted serum, eye cream, retinol, and moisturizer. A pink silk eye mask is shown below the text.

Enter your glow up era! Step-by-Step Glow Up Plan

Glowing up is an exciting journey that encompasses self-care, grooming, and beauty routines. Here's my in-depth guide part two of a larger series, that includes products, routines, and tips to help you look and feel your best. I’ll be making a larger post with links on my blog too! I’ll post it

3647 likes

An iPad screen displays the title 'HOW TO TAKE NOTES HOT GIRL ADDITION' with pink bows and cherry illustrations, indicating a guide to effective note-taking.

An iPad screen shows the Notability app page in an app store, highlighting its 4.7-star rating, features like PDF note-taking, and recent updates including an AI study tool.

An iPad screen within the Notability app shows organized notes with subjects and dividers like 'Weekly Reset' and 'Salon Life,' demonstrating how to categorize notes for easy access.

HOW TO TAKE NOTES

✨ Taking Effective Notes with Notability: A Game-Changer for Students and Professionals ✨ Are you looking to boost your productivity, improve your study habits, or streamline your work life? Taking organized, clear notes is key, and Notability is a powerful tool that helps you do just that! Here

3042 likes

A person in workout attire stands next to text stating "CARBS DON'T MAKE YOU FAT!". Surrounding them are images of Fairlife chocolate milk, pasta with broccoli, bread, white rice, avocado, and ice cream, illustrating various food types.

A graphic titled "What Should I Eat? Foods with High Quality Carbs" displays images of butternut squash, granola, couscous, sweet potatoes, pasta, lentils, oats, cooked rice, and fruit, each with their carbohydrate content per serving.

Text outlines how to calculate carbohydrate needs for weight loss, including formulas for Basal Metabolic Rate (BMR) for men and women. A yellow cartoon character is shown thinking of a croissant.

Carbs are not the enemy!!✋🏼✨🩵 Weight loss With Carb

I wanted to talk about something that's been on my mind lately—carbohydrates. It seems like carbs have gotten a bad reputation, especially when it comes to weight loss. There's this belief out there that if you want to shed pounds, you have to avoid carbs at all costs. But let me tell y

2009 likes

book recommendations: oddly specific edition

Looking for an extremely specific book to fit an extremely specific mood??? 👀 99% of the time when I’m choosing my next read I’m looking for something that fits the very specific criteria in my head. More often than not, it’s one of these categories! I love a story about the horrors of girlhood,

1927 likes

Pre-Nursing

#prenursingstudent #medicalterminology #urinarysystem Notes by me

471 likes

A woman takes a gym selfie, with text 'My Current Workout Split How I'm Crafting My Dream Body Muscle By Muscle' and a muscle anatomy diagram.

A workout plan detailing Day 1: Glute Max Focus exercises including hip thrusts and lunges, and the start of Day 2: Quad and Hamstring Focus with bike, jump rope, and stretching.

A workout plan detailing the end of Day 2: Quad and Hamstring Focus exercises and Day 3: Middle Stomach Muscles and Pelvic Floor exercises like weighted V-ups and flutter kicks.

How to Target Specific Muscles for your Dream Body

Here’s my Muscle Cheat Sheet Guide: 🍑Glute Muscles🍑 Gluteus maximus Gluteus medius Gluteus minimus 🍑Gluteus Maximus: Squats Deadlifts Hip Thrusts Lunges Bulgarian Split Squats Glute Bridges Romanian Deadlifts Cable Kickbacks Sumo Deadlifts Barbell Hip Thrusts 🍑Gluteus Medi

692 likes

A person is exercising on a leg press machine, with various food icons like meat, avocado, peanuts, and shrimp surrounding the text "FOOD FOR MUSCLE GROWTH" overlaid on the image.

A white page titled "Red Meat" lists top sources like beef, lamb, and bison with their protein content per 3 oz serving, along with benefits such as high iron and creatine.

A white page titled "Poultry" lists top sources like chicken breast, turkey breast, and duck with their protein content per 3 oz serving, highlighting benefits like low saturated fats.

Foods for Muscle Growth, Repair, & Recovery🥩🥑🥜🧀🍤

Building muscle isn’t just about lifting heavy weights or following an intense workout routine. Your nutrition plays a critical role in muscle growth, repair, and recovery. Specific foods provide the essential nutrients your body needs to repair microscopic tears in muscle fibers, replenish energy

929 likes

This image introduces DNA and genetics, explaining DNA carries genetic information for growth and reproduction. It shows DNA is found in the cell nucleus, organized into chromosomes, and determines an organism's traits.

This image details the double helix structure of DNA, resembling a twisted ladder. It highlights the sugar-phosphate backbone and the four nitrogen bases (Adenine, Guanine, Cytosine, Thymine) with their specific pairing rules (A-T, C-G).

This image explains genes as DNA segments controlling traits like eye color, and chromosomes as tightly packed DNA. It illustrates how genes are located on chromosomes within a cell's nucleus, passing traits from parents.

DNA and genetic

DNA (Deoxyribonucleic Acid) is the molecule that carries hereditary information in living organisms. It is found in the cell nucleus and is structured as a double helix made of nucleotides containing adenine, thymine, cytosine, and guanine. Genes are specific segments of DNA that determine traits s

25 likes

A refrigerator stocked with fresh fruits and vegetables like apples, corn, lemons, and tomatoes, with text 'Vitamin Cheat Sheet A Must Know!' and 'SWIPE' indicating more information.

A plate of food with text detailing Vitamin A, B1, B2, B3, and B5, including their functions and food sources. The background shows a dish with meat and sesame seeds.

A stir-fry dish with chicken and vegetables serves as the background for text describing Vitamin B6, B7, B9, and B12, listing their functions and food sources.

Vitamin Cheatsheet: A Must Know!

Vitamins are the catalysts & protectors of our body’s health; each vitamin serves a unique role, from boosting the immune system to the proper function of cellular processes, the list is endless! As an example, Vitamin D is predominant in calcium absorption/bone health, while Vitamin C aids in

1073 likes

I know an Anatomy and Physiology test hates me 😂

I know an Anatomy and Physiology test hates to see me coming These are my very condensed A&P notes but they worked for me!! I didn't go over the integumentary system and that ended up being the questions I missed so don't that 100% recommend this for those trying to brush up on the t

242 likes

Mastering the Mechanisms of Antiretroviral Therapy

Antiretroviral drugs are essential medications that treat HIV by disrupting specific stages of the viral life cycle to prevent replication and reduce viral load. The process begins with Entry and Fusion Inhibitors, such as Maraviroc and Enfuvirtide, which block the virus from attaching to or enteri

15 likes

Naturally Detox your Mind & Body from Head to Toe🌷

🌸🌸🌸🌸🌸🌸🌸🌸🌸🌸🌸🌸🌸🌸🌸🌸🌸🌸 3 Colon Cleanse Recipes I Use to Clean my Stomach and Intestines Naturally If you’ve been feeling headaches, fatigue, weight gain, or low energy, a natural colon cleanse might be just what you need. 🍋What is a Natural Colon Cleanse? 🌸A natural colon cleanse involves f

547 likes

A young woman in a car with text "Clean Girl Skincare Routine" and various skincare products, illustrating the guide's focus on a natural, polished look.

A visual guide outlining the correct order to layer skincare products, from cleanser to sunscreen, with examples of each product type.

A selection of face washes categorized by skin type, including options for oily, dry, combination, acne-prone, sensitive skin, and hyperpigmentation.

Clean Girl Complete Self-Care Routine Guide

Hey loves! Want to achieve the clean girl look but not sure where to start? I’ve got you covered! The clean girl aesthetic is all about simplicity, natural beauty, and a polished, put-together vibe that’s both effortless and sophisticated. Think fresh, dewy skin, a well-rested glow, and a look

6526 likes

📚 Nursing Student Study Guide: Renal & Urinary

📚 Nursing Student Study Guide: Renal & Urinary System Essentials 🌊 Hi everyone! As we dive into the Renal & Urinary system this week, here’s a quick breakdown to help simplify this complex system. 🔑 Key Functions: • Filtration: Kidneys filter blood, removing waste, toxins, a

699 likes

A hand holds a half-eaten green apple with the text overlay "Eat Your Way Skinny" and "An Apple a Day Keeps the Fat Away," promoting apples for fat loss.

Text explaining that apples are a high-carb, low-calorie volume food, providing about 95 calories per medium apple, helping to feel full and curb cravings.

Text outlining the best ways to use apples for fat cutting, including as a pre-meal snack, meal replacement, craving crusher, and volume filler in meals.

How Eating Fruits can Reduce Body Fat and Hunger🍏🍎

🍏High‑volume, low‑calorie snacking for weight control: Apples provide high water and fiber content while remaining low in calories, making them a powerful tool for satiety and fat loss: one medium apple (≈182 g) has about 95 kcal and 4–5 g of fiber, meaning you eat a lot of bulk with few calories—s

152 likes

Master Your Hormones: The Neuroendocrine Hub

The endocrine system serves as the body’s sophisticated communication network, utilizing chemical messengers called hormones to maintain homeostasis and regulate vital processes like growth, metabolism, and reproduction. At the heart of this system is the "neuroendocrine" partnership betwee

14 likes

how I got started learning Python 🐍💻👾

I’ve been learning Python this summer to prepare for my research lab and courses in the fall. Programming isn’t required for my major, so I’m taking the time to learn it alone. The biggest tip I can give is specific goals from the beginning! Speaking from experience, this will save a lot of time an

41 likes

EXERCISE FACTS: glute growth 101 🤓🧠✨ because you deserve to feel like you know what you’re doing at the gym AND I want you to see those resultssss and incase you didn’t know.. stronger legs/glutes has been shown to play a role in neurogenesis, AKA: the “creation of new brain cells” = higher b

22 likes

A Spotify playlist titled "tik tok songs but it's 2019/2020" with a cover of a child in sunglasses. Text describes scrolling TikTok during quarantine or driving with friends. A Spotify code is at the bottom.

A Spotify playlist titled "the main character finally gets the thing they spent the whole movie pursuing" with a cover of two people walking. Text describes accomplishing a goal or the end of a teen movie. A Spotify code is at the bottom.

oddly specific scenario based spotify playlists

since you guys loved my last spotify playlist post so much, i thought i’d post more of the playlists i’ve made. hopefully you guys like these ones too :) playlists featured: tik tok songs but it’s 2019/2020: exactly what it sounds like! you’re scrolling through tik tok during the summer of 2

8511 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

175 likes

✨📕STEAL MY PSYCH NOTES: Sensation & Perception🍋✨

🗣️ Learning about sensation and perception? Here are a few notes to get you through it! I’ve included 20 key terms and a few important figures you should know when learning about and reviewing these concepts. As always, let me know if there is anything you’d like to see discussed or need clarity on

89 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

6986 likes

Goal Specific Fitness Routines 💕

And remember, NUTRITION NUTRITION NUTRITION 🥗 it plays a major role when it comes to reaching your goals. To build muscle and reveal definition, you need to fuel your body properly while staying in a calorie deficit or surplus, depending on your goals. Now, about “toning” when people use this te

688 likes

✨ Medical Made Simple ✨

The medical field can feel like a whole new language, but breaking it down into easy terms makes it less intimidating. Whether you’re studying, working in healthcare, or just curious, knowing these basics can really help. 🩺 The first chart covers common medical abbreviations and their full forms

546 likes

Quick Access Notes for Nursing

306 likes

$The image contains nursing notes on fractures (open/closed, complications, emergency care, hip/skull fractures), Lyme Disease symptoms and treatment, and Osteomyelitis. A profile picture and a heart icon with '263' are visible.$