Automatically translated.View original post

わこ｜1分で学べるPC仕事術

8001 followers

Follow

Follow

Follow

30 saved

42

[Excel function introduction] Address input is short-lived with only postal code input! Introducing how to use the PHONETIC function

@ wako _ pc _ work ← Overtime will be reduced by following!

Today, I introduced an example of using the PHONETIC function ✨

■ PHONETIC FUNCTION

Function to extract and display 'furigana' such as kanji specified in parentheses

■ Procedure

① Enter = PHONETIC (address cell) in the column of postal code

② Auto Fill

③ In full-width mode, enter the postal code in the column of the address

④ Press the space key to convert the zip code entered in full-width and press Enter when the address is displayed

⑤ Postal code is displayed in the column of postal code

I would be happy if you could send your requests and comments to comments / DM 😊

# Excel Click here for information memo

3/24 Edited to

ExcelのPHONETIC関数を使うと、入力作業をかなり時短できるのが本当に助かります。私も業務で大量に住所を扱うことがあるのですが、従来は一文字ずつ漢字を手打ちするのに時間がかかっていました。その点、郵便番号から住所を自動補完する仕組みを取り入れてからは、作業効率が格段にアップしました。特に郵便番号を全角モードで入力し、スペースキーを押して変換を確定させる操作は覚えてしまえばすぐにできて、ミスや誤入力もかなり減りました。さらに、PHONETIC関数でふりがなを抽出する機能は、日本語のデータ処理において意外と重宝しています。例えば、名簿作成や住所録の整理など、ふりがなが付いていると後で検索や並び替えがしやすくなるためです。 OCRの画像情報からも分かるように、東京都内の住所情報との連携がスムーズに行えるので、地名や番地の入力ミスも減りました。Excelのオートフィル機能と組み合わせることで、大量データの一括処理も簡単に行えます。この方法は、普段あまりExcelに詳しくない方でも、手順を踏めばすぐに使いこなせるのが嬉しいポイントです。ちょっとした工夫で働き方が変わるので、ぜひ試してみてくださいね。コメントやDMで質問も受け付けているので、困ったときは気軽に相談してみるのもおすすめです！

Related posts

Student apps master list! 📋✨

Hope you find this useful :> BONUS: PDF reader apps PDF and Reading Apps for Students: - Adobe Acrobat Reader: Industry-standard PDF viewer with annotation tools - Foxit PDF Reader: Fast, feature-rich PDF reader with editing capabilities - LiquidText: Innovative PDF reader for active

5679 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

7049 likes

A comprehensive DeepSeek Complete Cheatsheet by Jafar Najafov, outlining roles, tasks, restrictions, and specific prompts for business owners, developers, marketers, and designers, along with prompt priming and the C.R.E.A.T.E. formula.

A list of roles from a DeepSeek AI cheatsheet, including Lawyer, Ghostwriter, Website Designer, Best Selling Author, Chief Financial Officer, Expert Copywriter, Prompt Engineer, Accountant, Project Manager, Sports Coach, Financial Analyst, and Full Stack Developer.

A list of roles from a DeepSeek AI cheatsheet, including Analyst, Teacher, Marketer, Advertiser, Mindset Coach, Therapist, Journalist, and Inventor, under the heading 'Act as a [ROLE]'.

🚀 DeepSeek Complete Cheatsheet

Hey everyone! 🌟 I’ve put together a comprehensive cheatsheet based on the DeepSeek Complete guide by Jafar Najafov.This is perfect for anyone looking to leverage AI prompts effectively. Let’s dive in! 🧭 ---- Act as a [ROLE] Need to switch roles? Here’s a list of personas you can adopt: 1. Anal

75 likes

A flat lay image featuring a pink notebook, gold heart-shaped dish with paperclips, and a gold pen, alongside a keyboard and pink flowers. The text overlay reads "5 FREE ONLINE CERTIFICATIONS to Boost YOUR RESUME."

5 Free Online Certifications to Boost Your Resume

Hi, lemons! In today's competitive job market, having a standout resume is crucial. Employers seek candidates with not only relevant experience but also a commitment to continuous learning. Fortunately, the digital age offers a wealth of free online certifications that can enhance your skill se

744 likes

A woman takes a mirror selfie, holding a coffee cup and phone, with text overlay 'EXCEL SHORT CUTS SAVE TIME & FRUSTRATION PART 1'. Abstract shapes frame the image.

A beige graphic slide explains the Excel shortcut 'SHIFT + END + DOWN' for selecting an entire column or section of data, with a 'SWIPE' indicator.

A brown graphic slide details the Excel shortcut 'CTRL + A' which selects all data in a worksheet, accompanied by a 'SWIPE' instruction.

EXCEL SHORTCUTS

These excel short-cuts are just a few that have made my excel work take a fraction of the time and genuinely changed my work life!! Working in excel can be extremely frustrating when not using the tool efficiently. Here are some crucial shortcuts to enhance your experience with Excel. CTRL + A

2584 likes

A detailed Excel Cheat Sheet page covering 'Edit a Workbook', 'Basic Formatting', 'Insert Objects', 'View and Manage Worksheets', and 'Basic Formulas' with instructions and examples.

1/3: Ultimate Excel Cheatsheet You Should Know

Hey there, I've got just the right boost for your Excel game. 🌟 📝 The Journey from Junior to Senior: My Excel Cheatsheet Chronicles I've been there, struggling with the basics and wondering how to climb the Excel ladder. But fear not, because I've distilled my journey into a one-p

540 likes

Language Study Template (Notion) - Part 2 Tutorial

✨Perfect for Chinese learners (but work for any language too). Start your language study journey today with structure, creativity and motivation all in one place. Download now at 🛒missydizzy.gumroad.com #notiontemplate #studytemplates #chineselearning #notionstudent #learnlanguage

2 likes

A laptop displays a Notion template for tracking Stardew Valley Community Center bundles, featuring item checklists, bundle categories, and Stardew Valley-themed graphics like corn and gift boxes. The screen shows various items and their associated bundles.

A close-up of the Notion template shows the 'SDV: Bundle Items' section with a search function highlighted. Checkboxes next to items like Potato and Tomato indicate that checked items disappear, helping users track bundle progress.

The Notion template displays 'Bundles' and 'Rooms' sections, allowing users to check progress on each bundle. Stars indicate donated items, while black circles signify missing items, helping track donations and bundle access.

notion template to track your stardew bundles 🌷💐✨

*i did not create this, but is available online for free!* i’ve been very vocal that i’m on my first ever play through of stardew valley right now, and i’m currently on winter of year 1 and finally decided to see what was up at the community center 😂 i was quickly overwhelmed and was going to m

166 likes

5 easy tech careers for anyone

1. IT Support Specialist - Role: Troubleshoot and resolve basic hardware, software, and network issues. - Why It’s Easy to Start: Requires minimal technical skills, and many entry-level positions provide on-the-job training. - Getting Started: Certifications like CompTIA A+ or Google IT Support

643 likes

An iPad displays the cover of "The Only Purple House in Town" by Ann Aguirre, with text overlays reading "MAKING My iPad Into A Kindle" and "With one app." A cup of coffee and a wooden spoon are visible.

An iPad screen shows the PocketBook app icon within a "Books" folder, highlighted by a brown arrow. The app icon features three colorful books.

An iPad screen displays the PocketBook app's "Unlimited Library" interface, showing recently opened and added e-books like "The Lost Bookshop" and "Never Coming Home," with navigation options at the bottom.

Why I Turned My iPad Air into a Kindle

👩🏻As a busy mom of two and an avid reader, I decided to turn my iPad Air into a Kindle instead of purchasing a separate e-reader. 👩🏻‍💻The decision was simple once I discovered the Pocketbook app. This app has transformed my iPad into a seamless Kindle e-reader, and here's how. 📓Unlimited

1184 likes

A green and white graphic titled 'Master Simple Excel Operations', listing five basic Excel tasks: creating a workbook, entering data, adjusting column/row size, inserting/deleting cells, and using functions.

A graphic titled 'Keyboard Function Key Identification' showing a white keyboard layout and a table identifying common keys like Esc, Tab, Caps Lock, Shift, Ctrl, Alt, Enter, Backspace, Sleep, and Wake Up.

Getting Started with Excel: It's Really Simple!

We'll start with the basics, learning about Excel's interface, toolbar, cells, and other fundamental operations. Then, we'll move on to common office shortcuts, as well as some frequently used functions and formulas. #ExcelBasics #ProductivityTips #SpreadsheetSkills #Exce

40 likes

Fast Task Tracking in Excel! 🏃‍♂️✅❌

✨ Welcome to Our Excel Mini-Class! ✨ Hey productivity champs! 🙌 If you’re juggling multiple tasks and need a simple, fast way to track your progress, I’ve got the perfect Excel trick for you! 📊✨ Let’s set up a Done/Not Done Tracker that will keep your tasks organized and help you stay on top

4 likes

A person wearing glasses and a houndstooth jacket sits in a car, looking at the camera. Text overlay introduces the 'RANDBETWEEN FUNCTION IN EXCEL'.

An Excel screenshot shows the formula bar with '=RANDBETWEEN(1,100)' and cell A1 displaying '12'. Text explains how to generate a random number within a specific range using this Excel formula.

An Excel screenshot shows cell A1 with '12' and the formula '=RANDBETWEEN(1,100)'. Text explains that the number is between 1 and 100 and can be refreshed for a new random value.

HOW I USE RANDBETWEEN IN EXCEL

In the pool of Excel formulas, the RAND() function brings the ability of randomness to my data. However, if you want control over the range of integers generated, enter the RAND() formula in combination with RANDBETWEEN(min, max). With this formula, I can set the minimum and maximum values to tailo

42 likes

A desert landscape at sunset with mountains and cacti, overlaid with a white rectangle containing the title "Chat GPT Use Cases" in large coral text. The bottom left corner shows "lemon8 @peytonmulder0."

A screenshot of a ChatGPT conversation titled "Write me an email...". The user asks for an email to a VP of finance, and ChatGPT drafts a professional email requesting a presentation review.

A screenshot of a ChatGPT conversation titled "Give me topic ideas for a writing piece...". The user asks for AI newsletter sub-topic ideas, and ChatGPT provides a numbered list of 10 suggestions.

CHAT GPT USE CASES

Chat GPT has changed the way I do everything. Wether is work, ideas, or personal hobbies, it always helps me out. People don't realize what all you can use it for! Writing emails that sounded professional used to be a headache and take tons of time, but now it's a smooth process with ChatGP

111 likes

Excel Trick: Color-Coded List Menu 💫 📊

✨ Welcome to Our Excel Mini-Class! ✨ Hey productivity pros! 👋 Want to make your Excel sheets not just functional but also visually stunning? Let me show you how to create a color-coded list menu that’s perfect for tracking tasks, organizing data, or making your spreadsheets pop! 💼✨ Using a co

2 likes

Sis Let Him Lead…

The idea of submission in a relationship often stirs up controversy. Many women cringe at the word, associating it with weakness, loss of autonomy, or the old-fashioned belief that one partner must dominate the other. However, in a healthy, loving relationship, submission is far from any of those s

51 likes

Excel tip to create a search function

Excel search function #tutorials #excel #exceltraining #exceltricks #exceltips

13 likes

Paycheck Budgeting: Step-by-Step Excel Guide

💻💰 Using Excel to budget your paycheck is a straightforward way to stay on top of your finances. Here’s a step-by-step guide: 1. Input Paycheck Total(s)💵 : $4,630 Start by entering the total amount(s) of your paycheck(s) into Excel. 2. Review the Expense Tab📅 Look at your expens

35 likes

NOTION TOUR ✨how I stay organized w/ notion!

welcome to my notion! I use notion for literally EVERYTHING. it’s a fantastic tool to stay organized with. while notion can feel a little overwhelming at first, templates are a great way to get started. here’s a lil overview of my page: • directory page - I use this page to quickly acces

59 likes

The image displays the book cover for "What Got You Here Won't Get You There" by Marshall Goldsmith, showing a man climbing a ladder. Text highlights the book's premise: past behaviors that led to success might now be obstacles, offering actionable steps for career transitions.

This image summarizes "Break the Habits Holding You Back," outlining highlights like the trap of old habits, mastering communication, and evolving leadership. Practical tips include identifying limiting habits, using "magic phrases," and weekly reflection for improvement.

The image explains how "Success Can Be Your Biggest Obstacle," detailing how habits from early career stages can become liabilities in leadership. It discusses success blind spots, shifting responsibilities, and advises self-reflection and feedback loops for adaptability.

Break the Habits Holding You Back

📘 What Got You Here Won’t Get You There By Marshall Goldsmith The behaviors that got you to success might now be your greatest obstacles. 🌟 This book identifies common yet overlooked habits that stall professional growth. By addressing these behaviors, you can unlock new opportunities and achi

4 likes

Let your little ones take the wheel with this adorable USPS mail truck🥹 it’s currently 15% off and you can stack the Target Circle offer where you save an additional $20! It’s sold out for shipping but you can still order for store pick up❤️ #target #targetfind #holidaygift #christmas

1277 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

A TikTok ad credit offer showing up to $6,000 in credits, expiring 05/21/2026, with a spend $200 to get $200 match, and details about a Q2 Affiliate Advertiser Coupon.

An Outlook email interface displaying an inbox with a welcome email from the Outlook Team, with a red text overlay instructing to register and save the email password.

A Google search page with a TikTok-related URL entered in the browser's address bar, and a red arrow pointing to it with text instructing to visit the link.

How to save money on TikTok ad delivery?

Get it. #tiktok #tiktokads

2 likes

A ChatGPT cheat sheet by Calvin Klein Reyes, detailing prompting techniques, roles, tasks, formats, writing styles, plugins, marketing prompts, tools, role-playing, prompt ideas, jailbreak prompts, and tips for effective prompting.

A ChatGPT prompting cheat sheet outlining modes, roles, formats, tones, chain prompt examples, and specific prompts for marketers, coders, sales, designers, research, customer service, and general use, along with top prompting tools.

A ChatGPT 'Zero to Power User' cheat sheet defining key terms, use cases, prompt frameworks, tones, formats, miscellaneous tips, modes, other chatbots, example prompts, and useful plugins for advanced prompting.

Chatgpt cheatsheet 1/10: one page equals a book

I've recently curated and tested several high-quality cheat sheets, each packed with a plethora of useful prompts and techniques that are easy to look up and remember. Leveraging these prompts can lead to efficient and top-notch creations for users across various industries and needs. #chatgp

76 likes

Neuroaesthetic Study Essentials

Have you heard of neuroaesthetics? It's a concept that involves enriching life by incorporating art that resonates with you and positively affects your nervous system. You've probably come across posts about study aesthetics and well-curated study setups, and it turns out, they indee

3 likes

How I got into Postal 1. You’re not gonna like it.

Full video is on my YouTube in bio!! Is finding games off TikTok valid?? What’s a game you found off TikTok.. please don’t say resident evil. #horrorgaming #horrorgamingcommunity #scarygames #horrorgames #postal

12 likes

Build better habits with this Notion Habit Tracker

I started using this Notion Habit Tracker to organize my daily routines, and it has made staying consistent so much easier. Instead of feeling overwhelmed by big goals, I can now: 🌿 track my habits every day 📊 see my progress visually 🎯 stay focused on what matters 💡 build routines that actu

17 likes

An HP iPAQ Pocket PC displaying a calendar and task list for July 1, 2003, showing appointments, events, and tasks. The image highlights how Pocket PCs in the 2000s helped manage schedules and productivity.

An HP iPAQ Pocket PC showing its 'Start' menu with options like Calendar, Contacts, Inbox, and Pocket Word/Excel. Text describes the Pocket PC 2000 as a portable device for managing schedules, contacts, and tasks, supporting Microsoft Office applications and wireless connectivity.

A Windows XP Tablet PC with a stylus resting on its screen. Text explains the 2002 Windows XP Tablet PC Edition featured a pen-based interface for handwritten notes and included pre-installed Microsoft Office applications like Word, Excel, PowerPoint, and Outlook.

Productivity in the 2000s:📱📊⏳

⫘⫘⫘⫘⫘✌🏾🩵🤙🏾⫘⫘⫘⫘⫘ Throughout the 2000s, technology evolved rapidly to enhance productivity planning, beginning with the Pocket PC in 2000, which allowed users to organize tasks and access applications on portable devices. The introduction of Windows XP Tablet in 2002 and the Palm Treo 650 in 2

377 likes

POSTAL WORKERS BE CAREFUL

1 like

Junk journal supplies organization

#junkjournal #junkjournalingcommunity #junkjournalsupplies #junkjournalorganize

11 likes

so thankful 🙏🏼 i used to pray for times like this! keep posting that content babies 💛💛💛 #fy #real

0 likes

Replying to @Seaplane Eric

17 likes

A laptop screen displays a Google Doc titled 'Due Dates (Week of 10/21)' listing color-coded assignments and tasks for Monday through Friday. The screen is on a MacBook Air, with overlay text 'PLAN MY WEEK as a first year college student'.

A physical weekly planner shows color-coded entries for Monday, Tuesday, and Wednesday, detailing work hours and class schedules like 'Business Calc.' and 'Evolution & Ethics'. Two highlighters rest on the planner, with overlay text explaining the addition of classes and work.

A physical weekly planner continues with color-coded entries for Thursday, Friday, and Saturday, showing class times and work shifts. Two highlighters are placed on the planner, with overlay text indicating the addition of other events or meetings.

Plan My Week & Assignments

Every Sunday/Monday it is very important for me to map out of my week. I use a digital calendar for a lot of my events so I can easily see on my phone but I find it helpful to also write everything down in a real planner. On my first slide, I have my Google Doc that I update weekly with what my

212 likes

They’re literally paying you to re-verify info from your couch 😭💻 Non-phone. Work-from-home. 98% accuracy = paid detective vibes 🕵🏽‍♀️ So tell me 👇 would you actually catch every mistake or just pretend to look busy? 😂 #workfromhomejobs #nonphoneworkfromhomejobs #remoteworklife #wfh #hi

21 likes

NOBODY COULD STOP MY AAU TEAMS DOMINATING PERFORMANCE!

5 likes

A handwritten notebook page titled 'The Faith of a Warrior Wife Day 1' with notes on marriage as a battle, focusing on faith, and putting God first. It includes bullet points about challenges in marriage and references to Ephesians 6:16, 2 Corinthians 12:9, and Nehemiah 4:14.

The Faith of a Warrior Wife - Day 1

Walk with me through this 5 day plan from the Bible app. Weather you are married or hoping to be married one day it is important to learn and understand what God expects from us as wives. A lot of people think that marriage is easy when in reality marriage is a battlefield. The devil wants to do e

47 likes

A PC setup featuring a monitor displaying a Stardew Valley-themed wallpaper, with a Nintendo Switch docked below. The desk is adorned with plants, a keyboard, mouse, and various gaming accessories, creating a cozy and customized workspace.

A close-up of a PC monitor showing the Windows Start menu. An arrow points to the 'Settings' icon, indicating the first step to access system settings.

The Windows Settings window is open, displaying the 'Personalization' section. An arrow highlights 'Personalization' in the left-hand menu, guiding the user to the next step.

How to change the color of your cursor

You guys, my husband told me about this and I love it! So im here to tell you about it! It’s great for people who have a hard time seeing the mouse too, not only can you change the color but you can change the size of it as well! If you’ve seen my previous posts, I really enjoy anything I c

64 likes

They Sorted Millions of Letters While The Military Ignored Them… #blackhistory

#blackhistory #blacklemon8creator #embracevulnerability #hiddenhistory #untoldstories Las Vegas

7 likes

Twin Snail Mail twin turbocharged Postal Service V

70 likes

Not even playing postal redux just rawdogging the original #postalgame #90sgames #pcgamer #pcgames #vintagegames

1 like

Under $100 - Luxe Gifts for HIM

Valentine’s Day gifts for HIM under $100 💝 Because men deserve love too! These designer picks are affordable luxury that he’ll actually use 🔥 Shop smarter, not harder this V-Day ✨ #valentinesdaygifts #giftsforhim #valentinesday #giftideas #mensgifts

21 likes

Santa’s address!!

For all of you with littles.. this is a real address you can mail out letters to🫶🫶 #santasaddress #letterstosanta #momsoflemon8 #parents #toddlerparents

25 likes

A light gray Jeep Wrangler is parked outside a car stereo shop, identified as "Audiowave Car Stereo", under a clear blue sky.

A close-up view shows a Kenwood 3.5-inch coaxial speaker installed in the upper dash of the Jeep, secured with screws.

The packaging for Kenwood Excelon KFC-X3C custom fit speakers is displayed, featuring images of the speakers on a black box.

2024 JLU LED UPGRADES

INFINITE OFFROAD 9” LED HEADLIGHTS/FOGLIGHT Combo with Halo .. DRL Function & Turn Signal METRA Smoked Sequential LED Turn Signals and Marker Lights . KENWOOD 3.5” Coaxials for Upper Dash ESCORT Passport Radar Detector & Hardwire Kit #jeep #infiniteoffroad #metraelectr

6 likes

Turn any data into intelligence instantly

Built something I wish existed sooner. Upload anything. Get insights, charts, and decisions in seconds. This is Hanalyzer. Hanalyzer.ai #lemon8challenge #lemon8badgehunt #AI #DataAnalytics #Tech

2 likes

I stood there for 30 mins trying to figure this out… ur welcome😂💀 #americaninparis #paris #france #expat #cultureshock

4 likes

See more