Automatically translated.View original post

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

215 followers

Follow

Follow

Follow

36 saved

15

[Excel utilization] Unexpectedly unknown furigana moment! Convenient ✨

Other posts from here 💁‍♀️

@ yui _ exel _ work

Furigana display, for a moment ✨

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

◆ How to display furigana in an instant ◆

① Select the cell you want to know the furigana

Press [Alt + Shift + ↑] at the same time.

by the way...

① I want to know the furigana in the "next cell" of the cell

Enter [= PHONETIC]

② Specify the cell you want to know the furigana in parentheses

If you forget the function...

① Click "fx" on the upper left

② Enter "Furigana" in the search field and click "Start Search"

③ Select "PHONETIC" and click "OK"

Enter the cell you want to know the furigana in the reference field and click "OK."

It's very convenient because you don't have to search for readings you don't understand 👍

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

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

1 day agoEdited to

Excelで漢字などのふりがなを素早く表示できる技は、仕事の効率化にとても役立ちます。私も以前は、知らない漢字の読み方をいちいちネットや辞書で調べたり、手動でふりがなを入力したりして時間がかかっていました。ですが、ExcelのAlt＋Shift＋↑キーのショートカットを知ってからは、数秒でふりがな表示が完了し、作業スピードが大幅にアップしました。特にPHONETIC関数を使う方法は、ふりがなを別のセルに抽出したいときに便利です。例えば漢字名簿や住所録のデータで読み仮名だけを別セルに出すことができます。関数の参照先を変更すれば、一括でふりがなだけをコピーできるので、他の表や資料作成にも重宝しています。さらに、Excelの関数検索機能を使えば、『ふりがな』でPHONETIC関数を簡単に呼び出せるため、関数名を忘れても安心です。これからExcelを使いこなしたい初心者にもおすすめの時短テクニックです。漢字の読み方に迷う場面はビジネスや学校など様々ですが、この機能を利用すれば手間が省けてストレスフリーに。私の経験からも、今ではこのExcelの裏ワザを知っているかどうかで作業効率に大きな差が出ると感じています。ぜひ、日々の業務や勉強で活用してみてください。

Related posts

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 🍵

2987 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

3553 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

4083 likes

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

6 likes

Nursing hustles

#nursetips #sidehustle #nurselife #moneymaking #entrepreneur

240 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

3 credit hacks that actually work

#makemoneyonline #creditcard #sidehustles #Lemon8

38 likes

#gardeningtips #gardeninghacks #gardentips #rawmilk #milkrecipe

0 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

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

148 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

1823 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

3 credit mistakes to avoid📈

If you’re trying to build your credit in 2025, avoid these common mistakes to help boost your credit scores #creditscore #chatgptprompts #financialfreedom

16 likes

Consumer Reporting Agencies

Understanding consumer credit reporting agencies like Equifax, Experian, and TransUnion is crucial. We delve into their role in helping support fair consumer reporting, including accuracy, confidentiality, and the proper use of your information. #CreditReport #ConsumerRights #CreditEducation

3 likes

#TikTokShopCreatorPicks #tiktokshopmemorialday #weeklydeals #summervibes #Dealsforyoudays

1 like

How To Get Funded With High Credit Card Utilization

🔓 Unlock Business Funding Today | Get Prequalified in Minutes 💰 Your current financial situation is NOT your final destination. Even if you have: ✔️ 650+ credit score ✔️ High credit card utilization ✔️ Limited business history You may still qualify for business funding, lines of credit,

0 likes

Stop scrolling! New job alert.

Link in the comments below! I hope I’m able to help someone get their 1st or even 2nd or 3rd remote job! I’m happy for all the support so far. Thank you all so much! #remoteworkfromhomejobs #remotejobs #neednewjobs #remoteopportunity #summerbod

18 likes

POV: You wanted a NON PHONE work from home job and I actually listened 😭 This remote data entry role is medical records based, beginner friendly vibes, and perfect if you’re detail oriented and can type 👀 Y’all already know where to look 💻✨ #wfhjobs #wfhjob #remotejobs #dataentry #workfromh

11 likes

#creditutilization #creditrepair #creditscore #parttwo

20 likes

Maximizing space utilization 🤩 A small study successfully transformed #sofa #sofabed #home #homedesign #bed

1 like

I’m passing this down to a nurse or future nurse bestie that will be the best she can be💕

You know if nothing else, I want to see my people do well. I am a real nursing bestie and if I find some info, I’m passing it along. Someone gave this to me and so I’m passing it to yall so you have it for reference. Save for later. Hope this helps you and provides reference for your growth 💕🥰🥂 #n

1261 likes

You know what’s really funny? We can remember celebrity drama, song lyrics, AND who unfollowed who… 😭 …but ask us what a credit utilization rate is and suddenly we need a nap. 🫠💳 A lot of us weren’t taught money, credit, or how to build real stability.That’s why I’m big on learning now instead

0 likes

Replying to @Em trust me I’m just as surprised as all of you 😅😅 #buyingahouse #creditcarddebt #creditcards

2 likes

Better Credit Score

Unlock the path to a stronger credit score by understanding how your credit profile actually works. Having multiple credit cards can help when managed correctly, but what matters most is low utilization, on time payments, and consistent account history. Lenders are looking for stability and respons

0 likes

Have you been pharmaceutically ab*sed? 🥺

1 like

Don't follow the trend, don't hype, focus on the research and development and production of peptide raw materials With bioactive peptides as the core, it covers the fields of health and scientific research. ✔ High purity: 99%+, no additives, no hormones ✔ High activity: advanced fr

1 like

Credit utilization - be careful high spenders 💳✈️

0 likes

💎🚀 Free LLC Setup - Ask Me How

Leveraging business credit can be a powerful tool for entrepreneurs looking to grow their ventures. By establishing and maintaining a strong credit profile, businesses can access capital more easily, negotiate better terms with suppliers, and build trust with potential partners and investors. Smart

5 likes

The image displays a list of nursing facts, numbered 1 through 17, covering topics such as patient positioning, PERRLA assessment, chest percussion, pulse assessment, patient transfer, respiration assessment, subcutaneous injections, fluid intake/output, and the nurse-patient relationship.

The image presents nursing facts, numbered 18 through 35, discussing blood pressure, malpractice, refusal of patient care, negligence, Good Samaritan Laws, verbal orders, patient rights, health records, controlled substances, nursing duties, patient interviews, nursing diagnoses, care plans, standing orders, heart assessment, and maintaining sterile packages.

The image lists nursing facts, numbered 36 through 55, including topics like maintaining package sterility, ear care, patient identification, activities of daily living, cardinal fields of gaze, heart murmurs, care plan goals, diet, pain assessment, postmortem care, honest answers, clear liquid diets, consistent personnel, hypothalamus function, brain membranes, nasogastric tubes, prescription authority, stoma care, vegetable fiber, and subcutaneous injection needle sizes.

Study for the PN NClex thank me later..

28 likes

Replying to @1badgyal_p 1. Share this to someone who may need a step by step. 2. ASK IT ANYTHING YOU WANT TO KNOW REGARDING YOUR REPORT. 3. Pay it forward ✨✨✨ #credit #creditscore #creditscoreincrease #buildingwealth #investingforbeginners

1 like

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

Tips to RAISE your credit score! ⬆️💳💸

Credit scores are needed when you want to get a loan (such as for a house or car)! If you don’t have any credit history - start by opening a credit card! If you do, here are some tips to raise your score! 1- credit length is an important factor so keep your accounts open, especially your fir

275 likes

Business Funding

3 reasons banks deny business owners access to capital (that have nothing to do with working hard): 1️⃣ Poor positioningYou might have a decent credit score, but if your profile isn’t structured correctly — high utilization, too many inquiries, or mixed personal/business activity — lenders see r

2 likes

They’re paying you to sit at home, type, and fix mistakes — basically what I already do in people’s comments 😭💻 #wfhjobs #nonphoneworkfromhomejobs #remotejobs #remotework #workfromhomejobs

28 likes

Credit Ascension Blueprint | Credit Utilization

Credit card utilization is the amount of revolving credit you're currently using divided by the total amount of credit available to you. It is one of the most important factors in calculating your credit score, typically accounting for about 30% of your FICO score. Lenders view a lower rati

1 like

5 Credit Building Tips💰

Happy credit building! ❤️ 1 Peter 4:10 ✨ #creditbuildingtips #realestate #realtor #christiangirl #Lemon8

4 likes

#Preparing For A Exam

Ways I prep for a test ! #test #notesinspiration #studywithme #medicalbillingandcoding

89 likes

Credit Utilization

Here’s a strong overall caption that wraps the Most people think credit is about paying on time. Wrong. It’s about how much you use, when you use it, and what gets reported. Keep it under 10%. Know your statement date. Protect the 30% that controls your score. That’s how you build l

0 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

5 likes

Don’t forget to get your copy! We are moving on to the next step!

Everyone on my platform should have this FREE copy now. I will help you in the next chapter of your journey. Want to learn how to make money online so that you can either pay down debt or supplement the income you already have? You are in the right place, at the right time, IN the right company

11 likes

CREDIT REPAIR AND FUNDING

#creditrepair #funding #business #personal #fypシ

4 likes

A handwritten financial plan titled "Financial Freedom and Debt Relief." It outlines steps to know your numbers, create a budget, cut expenses, and start an emergency fund, with specific goals and examples for each step.

A handwritten financial plan detailing steps for debt payoff, credit building, and money management. It covers choosing a debt payoff method, improving credit habits, lowering credit utilization, weekly money check-ins, and a no-spend challenge.

A handwritten financial plan outlining steps to increase income, build positive credit, and track financial wins. It suggests options like overtime or selling items, using secured credit cards for small purchases, and celebrating milestones.

My Debt-Free Journey Plan

Paying off debt and rebuilding credit takes time, but small steps make a big difference. This is my simple plan to stay consistent and improve finances. Save this to stay accountable 🍋 #financialgoals #financialfreedom #debtfreejourney #debtjourney #lemon8challenge

118 likes

I Was the One Who Opened Your Dispute Letter.

Here's What I Did With It. THE LETTER THAT CHANGED NOTHING You paid for the program. Filled out the forms. Sent the letters. Waited for something to change on your report. And on my end of that desk I received it. Reviewed the account. Confirmed the debt was valid. Filed it. N

6 likes

Things to avoid as a UGC creator

When I started as a new UGC creator, I wish someone told me these few things that are CRITICAL!!! ✨ DO NOT offer your services for free. Time is money. The work you put in deserves reimbursement! Just make sure it’s good quality ✨ Charging too low for when companies/sellers request copyrights.

0 likes

For students who want to learn how to Focus ⌛️

"Deep work" is a term coined by Cal Newport in his book "Deep Work: Rules for Focused Success in a Distracted World." It refers to the ability to focus without distraction on cognitively demanding tasks. Newport argues that in today's world filled with constant distractions

370 likes

my updated gut health routine !!💓 #wellnessroutine #guthealthjourney #antiinflammatory #coconutcult

46 likes

holistic benefits of CoQ10

13 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

See more