Automatically translated.View original post

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

400 followers

Follow

Follow

Follow

153 saved

52

[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

6/16 Edited to

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

Related posts

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

3598 likes

Just being honest😭😭

#relatablestudent #collegehumor #collegestudentfail #college #notesapp

1178 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

Late Night Study Session ☕💕✨

Learning wealth habits nobody taught me. Lately I’ve been studying: 💳 credit utilization 💳 statement dates 💳 financial discipline 💳 emotional spending 💳 delayed gratification 💳 wealth habits 💳 protecting my future And honestly? The more I learn about money… the more I realize wealt

68 likes

Improve your credit score using ChatGPT

Here are some tips you can use to educate and improve your credit score in 2025 #creditscore #chatgpttricks #financetips #2025resolutions

354 likes

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

7 likes

Bottles of hair conditioning spray, some with green labels indicating rosemary and mint, and others with red labels for rice water.

A hand holds a bottle of hair oil with a green label, featuring rosemary and mint infused with biotin.

Tubs of hair mask are displayed, with green labels for rosemary and mint, and red labels for rice water.

999 likes

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

1296 likes

Digital Financial Planner

Yes, the Financial Planner is in Digital form and it will be getting an uplift soon. (Also in physical form too) Key features : Credit utilization, credit planning, monthly budget, debt, planing, monthly savings challenge, 14 month undated #digitalfinancialplanner #digitalart #digitalma

5 likes

Nursing hustles

#nursetips #sidehustle #nurselife #moneymaking #entrepreneur

251 likes

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

1 like

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

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

💳 HOW FINANCIAL BADDIES USE CREDIT CARDS ✨

💳✨ Nobody taught us this stuff. I used to think credit cards were just for spending money… But the truth? The way you use your credit card can either help you build wealth or keep you stuck paying interest. These are some of the biggest credit card mistakes I see people making👇 💕 Which

144 likes

This image displays a jar of Shilajit resin with two wooden applicators, highlighting its natural origin and rich mineral content. The product is associated with muscle strength, vitality, and improved skin elasticity.

This image shows a bottle of organic black seed oil with a dropper and a spray top. The oil is known for its antioxidant properties, supporting skin and hair health, reducing inflammation, and aiding weight loss.

This image features a bottle of organic Lion's Mane mushroom liquid extract and its packaging. This supplement is recognized for regulating blood sugar, reducing blood pressure, boosting energy, and supporting brain and heart health.

Herbs 🌿 and supplements ✨ I use and why 💃

Shilajit: Shilajit's high mineral content contributes to muscle strength and vitality. Its role in improving oxygen delivery to tissues may delay fatigue during strenuous physical activities. Regular consumption of Shilajit may lead to increased stamina and overall fitness. Shilajit can also he

170 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

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

#Preparing For A Exam

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

89 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

17 likes

How to boost your credit score 📈

Tips to Boost Your Credit Score: 1. Pay on Time: 🕒💸 - Always pay your bills on time. Set reminders or automate payments to avoid missing due dates. 2. Keep Balances Low: 📉 - Try to keep your credit card balances below 30% of your credit limit. This helps maintain a healthy credit utilization

437 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

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

Cut Your Credit Utilization & Boost Your Score Fast 💳

Your credit utilization ratio can seriously impact your credit score — but the good news is it can also be one of the fastest things to improve. If you’re trying to fix bad credit, raise your score, or prepare for homeownership, lowering your balances before your statement date can help you see

10 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

14 likes

How I Started Rebuilding My Credit in 7 Days 💳✨

Nobody teaches this stuff in school… 👀 When I first started learning about credit, I thought rebuilding my score would take YEARS. But honestly? A huge part of improving your credit is: ✨ understanding what’s hurting you ✨ organizing your reports ✨ removing inaccuracies ✨ lowering utiliz

37 likes

How to make credit cards work for you💳

Credit cards can be powerful financial tools when used responsibly. Here’s how to make credit cards work for you: 1. Choose the Right Credit Card Based On Your Financial Needs - Rewards Cards, Low-Interest Cards, Balance Transfer Cards 2. Pay Your Balance in Full - Avoid Interest Char

65 likes

GUIDE TO IMPROVING YOUR CREDIT SCORE

By following these steps, you can improve your credit score and increase your chances of accessing loans and credit cards at favorable rates. #lemon8partner #personalfinance #MoneyTips #moneysavingtips #money

36 likes

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

47 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..

35 likes

The image shows the title "ADULTING: THINGS NOT TAUGHT IN HIGH SCHOOL CREDIT SCORE" with an illustration of a smiling person next to a credit score dashboard.

This image defines a credit score as a number reflecting creditworthiness, stating FICO scores range from 300-850 and are the most common.

The image explains why credit scores matter, highlighting their role in lending decisions and mentioning that U.S. credit bureaus calculate FICO scores differently.

Adulting: CREDIT SCORE

Continuing with things not taught in high school Today we are talking about credit score.. I want to go more into depth but dont want to overwhelm y’all next I’ll talk about credit utilization and good strategies for a good credit score #adulting #Adulting101 #creditscore #Lemon8 #lemon

376 likes

#gardeningtips #gardeninghacks #gardentips #rawmilk #milkrecipe

0 likes

🚨 A low credit score isn’t a life sentence.

Your credit score affects more than just loans. ✅ Lower interest rates ✅ Better credit card offers ✅ Easier apartment approvals ✅ Better insurance rates ✅ More financial opportunities The formula is simple: • Never miss a payment • Keep credit utilization under 10% • Check your credi

89 likes

【Smart rotating cabinet system】

💡The most sought after storage! The rotating cabinet rotates like a "magic shelf"🥹 #design #cabinets #electric #interiordesign #homedesign

2 likes

Before hitting the dealership, protect your credit score with these smart moves! 🚗💳✨ Avoid multiple inquiries and boost your credit—watch to find out how! 👀 #CreditTips #SmartShopping #lemon8diarychallenge #creditutilization #creditispower #creditrepairtips #credittips #creditrep

23 likes

A hand holds US dollar bills (10, 20, 100 denominations) against window blinds. Text indicates how to save money and pay off a debt, reducing it from $3200 to $1500, with a 'SWIPE' prompt.

A hand holds US dollar bills against window blinds. Text explains that settling or negotiating debt prevents accounts from defaulting, which benefits your credit score by avoiding default.

A hand holds US dollar bills against window blinds. Text states that settling debt reduces the total amount owed, thereby lowering your credit utilization ratio and reducing debt load.

WHY YOU SHOULD NOT PAY THE FULL PRICE OF A DEBT 💰💅🏽

Boosting Your Credit: The Benefits of Debt Negotiation & Settlement Discover how negotiating and settling your debt can give your credit score a glow-up! By taking charge and making smart moves, you can sparkle with a healthier credit score, less stress, and a fresh start. It’s all about tur

103 likes

Medical-Surgical Nursing study material

Boost your nursing exam preparation with the TEST BANK for Medical-Surgical Nursing: Focus on Clinical Judgment (3rd Edition) by Honan, covering Chapters 1 through 55 in full. Each chapter includes high-quality practice questions, rationales, and exam-focused content. #medicalstudent #nursingstud

5 likes

The Impact of Your Credit Utilization

Understanding the impact of your credit utilization ratio is crucial for maintaining a healthy credit score. By managing your credit responsibly and keeping your utilization ratio low, you can improve your creditworthiness and access better financial opportunities in the future 🌤️🤍🫧 - What is Cr

48 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

#TikTokShopCreatorPicks #tiktokshopmemorialday #weeklydeals #summervibes #Dealsforyoudays

1 like

See more