Automatically translated.View original post

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

622 followers

Follow

Follow

Follow

163 saved

55

[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 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 🍵

3048 likes

5 Credit Building Tips💰

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

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

Have you been pharmaceutically ab*sed? 🥺

1 like

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

3679 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

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

3 credit hacks that actually work

#makemoneyonline #creditcard #sidehustles #Lemon8

43 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

23 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

1827 likes

Here’s how your credit score is really calculated (and the 1 factor that makes up 35% 👀 #creditscore #credittips #creditcardtips #moneytok #personalfinance

1 like

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

#gardeningtips #gardeninghacks #gardentips #rawmilk #milkrecipe

0 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

A woman in a black blazer and grey top stands against a brick wall, holding an open book. Overlaid text asks, "How to increase Your credit score," with "OVERSIZE BLAZER" also noted.

A modern bathroom with a glass shower enclosure is adorned with pink heart emojis. A pink banner advises, "Keep your credit utilization low," as a credit score improvement tip.

A hotel room features two beds with white bedding and decorative flower graphics. A pink banner states, "Pay your bills on time," offering a key tip for credit scores.

INCREASE YOUR CREDIT STORE 🤑

Having a good credit score is super important. The better score you have the more access you have to Financial perks such as low interest rates, ability to apply for things like apartments, cars, etc. If you don’t have the best credit, here are three ways to increase your credit score. #lemon8part

22 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

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

843 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

Credit Utilization 101: Maximize Your Score!

Unlock Your Credit Potential! 💳✨ Discover how to master your credit utilization and boost your score like a pro! #CreditTips #FinancialFreedom

2 likes

Credit Utilization 💳💵

Understand the key factors of your credit score to boost it and gain financial freedom! 💳💡 #CreditScore #lemon8diarychallenge

9 likes

See more