Automatically translated.View original post

時短ちゃん⌇元SEの定時退社×Excel術

1794 followers

Follow

Follow

Follow

299 saved

191

2

Create a large number of folders in an instant!

It is former engineer working OL Tokusho-chan 👩🏻‍💻

Thank you for looking at the post 🤍 -

♡ - - - - - - - - - - - - - - - - - - - - °

Excel time saving tech introduced this 🧸🎧

How to create a folder in an instant

① Enter the folder name in column B

② Enter "md" in column A

③ Press F12 (* Depending on the PC, press fn as well)

④ Save the file format as "CSV (comma-separated) (* .csv)"

⑤ Display → Display → Check "File Name Extension"

⑥ Change the extension from csv to bat

⑦ Click "Yes" for the warning sentence for changing the name

⑧ Double-click to complete the folder in an instant

♡ - - - - - - - - - - - - - - - - - - - - °

Introducing PC time saving technology that can go home early!

Be sure to check out 〰️ other posts 🐾

@ jitanchan _ pc

The person who thought this was a genius The moment I felt spring # excel # excel # excel _ beginner

4/4 Edited to

Excelを使って大量のフォルダを一気に作成する方法は、仕事の効率化にとても役立ちます。私も職場でよく新入社員のフォルダや部署ごとのファイル整理に苦労していましたが、このやり方を知ってから格段に負担が減りました。具体的には、まずフォルダ名をB列に入力し、その隣のA列に「md」と入力します。これはフォルダ作成のコマンドを示す記号です。その後、保存時にファイル形式を「CSV(コンマ区切り)」で保存し、Windowsのエクスプローラーで拡張子を.csvから.batに変更します。batファイルはバッチファイルと呼ばれ、クリックするだけで複数のフォルダを自動で作成してくれます。私の場合、100人分の社員名入りフォルダを作る際にこの方法を使い、数分で作業が終わりました。通常、一つずつ手でフォルダを作成するのは時間もかかり、ミスの元ですが、batファイルによって簡単に一括処理できるのでミスも減りました。また、ファイル名拡張子の表示設定を有効にしないとbatファイルに変更ができないため、事前に確認しておくことが重要です。拡張子を変える際には、「名前の変更の注意文」が表示されますが、ここでは「はい」を選択し問題ありません。この方法は一見難しそうに感じますが、Excelの基本操作と少しのファイル操作の知識があれば誰でも簡単に習得できます。特に部署ごとやプロジェクトごとに大量のフォルダを管理している方、フォルダ作成に時間を取られている方にはおすすめです。ぜひ試してみてください！

Related posts

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

3091 likes

An iPad displays detailed handwritten notes on 'CH. 7: energy metabolism' with various sections, highlights, and a grid background, accompanied by an Apple Pencil.

An iPad with a lock screen showing two smiling women, emphasizing the need for an iPad and Apple Pencil for note-taking.

An iPad screen displays the Goodnotes 6 app page in an app store, showing its ratings, awards, and a special event featuring Sanrio characters.

best notes on an ipad as a college student💙

This is how I take all of my notes using my iPad as a college nursing student! I love the app GoodNotes and I can keep all my notes in different folders for each class instead of carrying around multiple notebooks in my backpack. I used my graduation money to get my IPad and Apple Pencil and 100% r

1549 likes

Two packages of chicken-flavored instant ramen and a carton of brown eggs are displayed on a countertop, with the text 'Instant Ramen but make it... BETTER'.

Two blocks of instant ramen noodles are boiling in a pot of water on a stovetop, with the text 'BOIL YOUR NOODLES'.

A pat of butter is melting in a black skillet with minced garlic, accompanied by the text 'MELT BUTTER IN A SKILLET & ADD MINCED GARLIC'.

Instant Ramen but make it… BETTER

#ramennoodlerecipes #cheapmeals #dinnerideas #budgetfriendly #cooking

4770 likes

A MacBook screen displaying a customized desktop with a peach-toned wallpaper featuring an August calendar, motivational widgets, and a wave graphic. The title 'customize Macbook with me' is overlaid, indicating a personalization guide.

An illustration showing various aesthetic wallpaper options for a desktop, including floral and gradient designs. A search bar for 'desktop wallpaper' is present, along with a tip to choose high-quality images to avoid pixelation.

A visual guide on how to clean up the MacBook Dock by removing unused apps. It shows a cluttered Dock and then a streamlined one, with step-by-step instructions for removing an app via right-click options.

✨ Tiny MacBook changes that made it way cuter ✨

I finally sat down to customize my MacBook, and it honestly feels like a whole new laptop now. 🌸 The first thing I did was change the wallpaper - I make my own (you can grab them for free 🫶), but if those aren’t your style, Pinterest is always a great option. Just make sure to pick something hig

1788 likes

An iPad home screen displays various app icons and folders, with a white outline highlighting a row of app folders. A pink text overlay reads 'HOW TO SET Custom folder icons for APP FOLDERS'.

The iPad screen shows the 'All Shortcuts' interface with numerous shortcut tiles. A pink text box instructs to 'Open shortcuts and add a new one'.

A close-up of the Shortcuts app interface highlights the 'Choose from Menu' option within the 'Control Flow' section. A pink text box instructs to 'Go to "scripting" and choose "choose from menu"'.

How to set custom folder icons for app folders

You know that default folder you get whenever to combine apps on an iPad? Well let me show you how to change the icon without compromising the folder functionality. ⬇️ ✳️ Open up the Shortcuts app and create a new one ✳️ Go to the SCRIPTING CATEGORY and select “Choose from Menu” function ✳

366 likes

A+ habits to copy before school starts ✨🦋👇

Okay besties… the semester isn’t here yet, but we all know once it starts it’s ✨ pure chaos ✨ so I’m setting myself up now. Not with the boring ‘make a schedule’ tips (been there, forgot to use it), but with habits that actually make my life easier when school takes over. Think: 📂 pre-made dig

2839 likes

A Canon G7X camera on a tripod, recording a person, with the title "THE STEPS OF MAKING A Youtube Video" overlaid. The camera screen shows a live view of the recording subject.

A Canon G7X camera on a tripod, recording a person, with the text "1. FILM" overlaid. The camera screen displays the live recording view.

A laptop screen showing video editing software (iMovie) with a video timeline and a preview of a person speaking. The text "2. EDIT" is overlaid on the screen.

The Steps Of Making A Youtube Video! ✨🍋

I’ve made sooo many videos in my life and these are the steps!! 1. Film! make a video, it can be anything! i make all kinds of videos from vlogs to book reviews! 2. Edit! editing is my favorite part!! you can do ANYTHING with a video!! get creative with it! 3. Thumbnail! I use canva! Th

2119 likes

A laptop screen displays a Gmail inbox with a sidebar showing various custom labels, some with emojis, like 'Promotions', 'Attorney', 'Bank', 'Cash', 'Housing', 'Lifestyle', and 'Shopping'. The text 'Customized Google Labels' is overlaid.

A step-by-step guide showing how to create a new label in Gmail. It highlights navigating to 'Settings > See All Settings', then the 'Labels Tab', and clicking 'Create new label', with a screenshot of the 'New label' input box.

This image illustrates creating a new label by clicking a plus icon next to 'Labels' and provides examples of label names with emojis such as 'URGENT ⚠️', 'Health 🩺', 'IMPORTANT ✉️', and 'Shopping 🛍️'.

✨📧My inbox is now organized with Google Labels📧✨

If your email inbox feels like a junk drawer, this is your sign 👀 Google Labels are basically folders—but ✨cuter✨ and way smarter. Here’s how to set them up and make them fun with emojis 👇 --- 🏷️ How to Create Google Labels (the easy way): 1. Open Gmail (desktop works best) 2. On the le

643 likes

Banana bread inspired banana chocolate chip cookies INGREDIENTS: • 100g cold unsalted butter (cubed) • 80g caster sugar • 65g light brown sugar • 85g very ripe mashed banana • 1 whole egg • 1 tsp vanilla • 250g plain flour • 1/2 tsp cinnamon powder (optional) • 1/2 tsp instant coffee po

228 likes

A close-up of a bowl of Mongolian Beef Instant Noodles, featuring tender beef, ramen noodles, sliced onions, green onions, and red chili peppers, ready to be served.

Ingredients for the beef marinade, including thinly sliced beef, cornstarch, baking soda, Shaoxing wine, dark soy sauce, soy sauce, white pepper, and neutral oil, laid out on a wooden board.

Ingredients for the sauce, including beef broth, oyster sauce, soy sauce, dark soy sauce, sugar, chicken bouillon, and white pepper, arranged on a wooden board.

Mongolian Beef Instant Noodles🍜🌶️

These Mongolian Beef Instant Noodles taste just like your favorite takeout: but they’re easy to make at home!🍜🌶️I used beef chuck instead of flank steak, and it turned out tender, flavorful, and much more budget-friendly😏😏 I was also craving ramen noodles, but you can use any noodles you like. Trus

254 likes

🎮 Make Life Fun with These Apps

1️⃣ Whering ✨ Platform: iOS & Android | Paid: Free A stylish outfit app where you browse looks, upload your own wardrobe, and mix & match clothes. It’s like having your own fashion playground every day. Why recommend: 2️⃣ Folderly ✨ Platform: iOS & Android | Paid: Free A task-o

1817 likes

$1099 Later… Here’s the Truth About the iPad Pro✨

$1099 might sound crazy for a tablet… but here’s why this iPad Pro became my ride-or-die as a work-from-home mom and student: ✨ It’s basically my laptop, sketchbook, planner, & notebook all in one I pair it with: — Apple Magic Keyboard (hello built-in trackpad & laptop vibes!) — Apple

8528 likes

A hand holds a Kindle Basic with a floral skin and a custom Totoro screensaver, showcasing the device after a Kindle jailbreak. The background features a blurred desktop setup with a cherry blossom wallpaper.

A Kindle screen displays the 'winterBreak' jailbreak menu, showing options like KUAL, Helper, KOReader, and 'Rename OTA binaries,' confirming the device is jailbroken. Text indicates the method is legal and released by HackerDude.

The Kindle screen shows the KOReader home interface with various folders like 'apps,' 'audible,' 'Books,' and 'Kindle Wallpapers,' demonstrating the ability to organize and easily drag and drop epub files.

Jailbreaking my Kindle: Was it worth it?

As some who has jailbroken multiple devices over the years (my very first was an iPod touch 4th Gen when I was a teen) when I found out you could jailbreak kindles I knew I had to try it out. I decided to try it on my kindle basic as it’s an older model and not my primary reading device, just in

1598 likes

💡iPad Tip: Create a Battery 🔋 Charging Automation

💡iPad Tip: How to create charging 🔋Automation This trick is so cute and easy to set up! Here's how to do it👀⬇️ 1️⃣Open the Shortcuts app 2️⃣Select Automation and the "+ New Automation" 3️⃣Scroll down to "Charger" and select it 4️⃣Select "Run Immediately" then &#

266 likes

A white basket filled with various college essentials, including notebooks, folders, a pink water bottle, snacks, and school supplies, all arranged on a purple quilted blanket.

A pink metal water bottle and a white cup decorated with black graduation caps, labeled as a 'graduation cup,' resting on a purple quilted blanket.

A bag of Albanese gummy bears, a bag of Snyder's pretzel sticks, and a value pack of Doublemint gum, displayed on a purple quilted blanket.

✏️_college must haves~📓✨

One of my best friends gave me the cutest graduation gift to get me ready for college!!☺️ everything I got✏️📓✨ • water bottle & cup • gum, gummy bears, pretzels • tissues • eos hand cream • hand sanitizer • floss picks • first aid kit & ibuprofen • retractable eraser • 0.5 mm me

891 likes

Create a GIF from ANY VIDEO

Sometimes you just can't find the right gif to express yourself. And making one, well that's something you need special software for right? WRONG! If you have an iPhone you can make a gif. The best part? It only takes a couple of clicks thanks to Apple's Shortcut App! Here's How

61 likes

It worked everytime when I felt depressed

Do something and break that depression. When you start everything will be DIFFERENT! #LifeReset #TinyHabits #Declutter #digitaldetox #ThingsToDo

465 likes

INSTANT POT BOUGUINON,!!

https://www.everydayeileen.com/instant-pot-beef-bourguignon/

0 likes

Excel cheat sheet

Excel cheat sheet #excel #exceltips #exceltricks #exceltraining #tutorials #excel_learning

14 likes

finally dealing with all those “important” papers i never knew what to do with!! 📁✨ and the cute binder definitely helps! @DailyDocs you find this organizer 🔗 in my bio! #organization #organizedlife #aesthetic #fyp

48 likes

Instant Pot Greek Beef Stifado 🍲🧅

Instant Pot Greek Beef Stifado 🍲🧅 Ingredients: 2 lbs (900g) beef chuck, cut into 1-inch cubes 2 tablespoons olive oil 1 large onion, chopped 1 lb pearl onions or small shallots, peeled 4 garlic cloves, minced 2 tablespoons tomato paste 1 can (14 oz) crushed tomatoe

48 likes

This image features handwritten notes on human anatomy and directional terms, with diagrams of body systems. A large text overlay reads "Alternative to GOOD NOTES" and "Swipe" at the bottom.

This image displays the Noteful app icon and highlights its pricing: $4.99 for a lifetime subscription, compared to Goodnotes' $9.99 per year. It states Noteful is more user-friendly.

This image shows the Noteful app's organization features, including folders for classes like "Anatomy" and "Philosophy," and the ability to create custom hashtags for notes.

Alternative to Goodnotes!?

Hey girls!! Just want to help you all study and get good grades🫶🏻😇 I LOVE LOVE LOVVVEEE Noteful. It is so much more user friendly and is just as good as goodnotes with a few differences. ✨ Goodnotes is $9.99 per YEAR. Noteful is $4.99 for a LIFETIME!!! That is such a good deal. I paid for it

1317 likes

Customize your folders in Goodnotes

New customization folder feature in Goodnotes ✨ Y'all know I've been in my brown era 😭 so I couldn't wait to redo my folders 🤎 What do y'all think of this new update? #goodnotes #digitalorganization #digitalplanning #ipad #study

148 likes

A desk setup with a computer displaying ChatGPT and text overlayed: 'Back to school hack I wish I knew sooner: ChatGPT folders for each class.' An iPad with notes, a keyboard, and a white tumbler are also visible.

A computer screen shows the ChatGPT 'Project name' creation interface. An overlay explains 'Step 1: Make a ChatGPT folder for each class,' with examples like 'BIO101: Foundations.'

A computer displays the ChatGPT interface. Overlays detail 'Step 2: Pin your main chat per class' and 'Step 3: Use it weekly - Summarize lectures - Ask for quiz help - Build flashcards.'

Set Up ChatGPT Class Folders for Fall Semester 💻

One of the best things I did last semester was set up separate ChatGPT chats for every class. Each one became a living, searchable study guide. Here’s how to use folders like a low-effort academic assistant: – Name the folder after your class (ex: “BIO202: Genetics”) – Pin your chat for ea

499 likes

A person holds a purple iPad with various stickers on its back, outdoors under a blue sky with trees. The image has text overlay: "HOW I TAKE NOTES ON MY IPAD (AS A COLLEGE STUDENT)".

A screenshot of the Goodnotes app interface showing a 'Documents' screen with folders organized by semester and a 'MISC' folder. The text 'GOODNOTES!' is displayed at the bottom.

A close-up of digital handwritten notes in Goodnotes on an iPad, covering topics like 'Intestinal Motility' and 'Liver'. The notes feature multiple pen colors and highlighting.

the BEST college note-taking app!

Goodnotes has saved my LIFE. Note-taking on here is so easy and convenient I love it so much. It comes with a few free notebooks but I paid a one-time fee (I think it was around $8.00) and I get unlimited folders, images, notebooks, etc! The last two slides are examples of some of my note pages in

657 likes

A title image with the text "HOW TO CREATE YOUR OWN emojis" in black and brown, surrounded by various beige and gold aesthetic items like a perfume bottle, handbag, slippers, ballet flats, candle, and a bouquet of roses, with a colorful emoji app icon at the top.

An iPhone screen displaying app icons, with an arrow pointing to the "AI Emojis" app icon. Text instructions indicate to "UPDATE IOS 18.1" and "DOWNLOAD APP AI EMOJIS," set against a brown background with decorative elements like a coffee drink and a cinnamon roll.

An iPhone screen showing the "Emojis" section of the app, with options for "My Emojis" and "My Packs." An arrow points to the "Create Pack" option, with text instructing to "CREATE YOUR PACK TO CLASSIFY YOUR EMOJIS," surrounded by decorative food items.

Create Your Own Custom Emojis with Genmoji! 📲✨

🎨💖 If you’re obsessed with emojis and want to take your creativity to the next level, here’s a step-by-step guide to making unique ones and using them across all your favorite apps! 🌈🤩 🔹 First, make sure you have iOS 18.1 📱💡 To access the magic of Genmojis, you need the latest iOS version. G

4757 likes

A MacBook Air M2 with a customized desktop background featuring various images, a calendar, and a to-do list. Text overlay reads 'how to get the most out of your mac'.

A close-up of a Mac desktop showing default folder icons for 'photos', 'media planning', 'YT collabs', 'tiktok', and 'IG'. Text overlay says 'customize your folders'.

A Mac screen displaying a right-click context menu on a folder, with 'Get Info' highlighted, illustrating the first step to customize folder icons.

how to customize your Mac🌟💻

you own a MacBook, now what? here’s some ways you can personalize your settings! 1: Custom Folder Images ✨no more boring folders that are hard to keep track of ✨stand out against desktop background ✨simple to change to your preference 2: FreeForm Application ✨bullet point style whiteboa

398 likes

Instant Pot Sausage & Potatoes

• 1 1/2 lbs fresh diced potatoes • 1 lbs kielbasa sausage cut into small pieces • 1 small onion diced • 2 or 3 garlic cloves minced optional • 2 1/2 cups shredded cheddar cheese • 1 1/2 to 2 cups chicken or vegetable stock • 1/2 cup milk • 1/4 cup heavy whipping cream • 1/2 tablespoon unsal

9 likes

Instant Pot Beef Barbacoa

Tender, juicy Instant Pot Beef Barbacoa Tacos loaded with bold, smoky flavor. Perfect for Taco Tuesday (or any day you crave authentic Mexican flavor). Made with chuck roast, chipotle peppers in adobo, and warm spices for that slow-cooked taste. Ingredients 2.5 lbs beef chuck roast, cut into la

51 likes

🍫 Fudgy Marshmallow Cookies = Instant Joy!

Soft, Chewy & Loaded with Marshmallow! These are rich, gooey, and topped with the fluffiest frosting—basically a brownie, cookie, and s'more all in one! 🔥🍪 ✅ Ingredients: Cookies: * ½ cup unsalted butter * 1½ cups granulated sugar * 2 eggs * 1 tsp vanilla extract * 2 cups all-purpos

90 likes

Learn to use Canva

I been using Canva for a year and they have evolved to helping me create better content. Canva is a beginner-friendly design platform for making graphics, presentations, videos, social posts, flyers, websites, and other visual content. It works with templates, drag-and-drop editing, and a large lib

1 like

Create and Manage Your 2nd Brain! 🍋✨🤯

A "2nd brain" tool, like Notion or Obsidian, provides a structured way to capture, organize, and access information, offering immense benefits for focused work and creativity. Here's how: 1. Centralized Knowledge Hub Benefit: Consolidates all your ideas, notes, and research in one

8 likes

INSTANT POT French Onion Beef & Noodles

Instant Pot French Onion Beef & Noodles •1 Lb Steak, Cubed •1 Tb Salt & Pepper •2 Tb Oil •1 Onion, chopped in large pieces •2 Tb Worcestershire •2 C Beef Bouillon/ Beef Stock •1 Can French Onion Soup •1/2 C Cornstarch/water •Wide Egg Noodles •Mozzarella Cheese for topping

119 likes

🧹 📓📚Tips (As a grad student these are the study tips I’ve been living by)📓📚: 1.Stay Organized: Use planners, digital calendars, or apps to track deadlines, assignments, and exams. Keeping things organized will help you manage your time effectively. 2.Break Down Tasks: Large projects can feel ove

28 likes

A smartphone displays Google Drive with color-coded folders like 'Business' (red) and 'Important' (dark grey), illustrating digital organization. A red pushpin and floating yellow and blue folders are also shown, with text 'Organizing my chaos Google Drive With Color-Coded Folders'.

Two smartphones show Google Drive folders in grid and list views, demonstrating color-coded organization. Folders include 'Business' (red), 'Jayden' (blue), 'Miko' (pink), and 'Pics&Videos' (purple) as examples, with the text 'EXAMPLE'.

🌈Change Your Google Drive Into Colorful Folders📁🌈

From chaotic file dumps to a rainbow of productivity, I never knew digital organization could feel this cute! 🩷 Pink for passion projects, 💙 blue for bills, 💚 green for goals, and 💛 yellow for... the stuff I pretend I’ll get to. Highly recommend turning your digital mess into a mood board

145 likes

How to create a viral Facebook page in 30 days using free tools ….💸

This roadmap gives you the exact daily plan to grow faster with AI tools, content strategy, and consistency. 📈 Most people fail because they post randomly. Viral growth is a system — not luck. 🔥 ✅ Niche research ✅ Content planning ✅ Viral post creation ✅ Facebook growth strategy ✅ Moneti

19 likes

Let me show you how to make a Classic & Authentic CHILE VERDE STEW in under 30 minutes! It’s seriously so easy and soooo delicious 🤤 Ingredients: 12 roasted & peeled hatch pepper 2 1/2 lbs chuck roast or pork shoulder 2 tbsp all purpose flour 1 1/2 tbsp salt & 1 tbsp bp 1 onion; chopped

253 likes

Create your NOTES in seconds!✨

In this post I want to share one of my favorite features in Notes💛 It’s super helpful if you have printed or handwritten text in front of you and want to quickly save it as a Note on your iPhone! Swipe left to see this feature work its magic!✨🪄 #iphonetipsandtricks #iphonehacks #iphon

181 likes

triple chocolate brownies

#bakinglove #instabaker #recipeoftheday #bakingrecipes #homebaking Boise

31 likes

Organized your documents folder with one click, its even will create folder

#scan #savetime #easy

1 like

3 Minutes Instant Pot Apple Cinnamon Oatmeal

The Easiest Oatmeal You’ll Ever Make – 3 Minutes in the Instant Pot! No stirring, no pot watching—just cozy, creamy oats with the press of a button. Here’s the magic ratio: 🥣 1 cup oats = 2 cups liquid For this batch: — 3 cups oats — 3 cups water — 3 cups milk (don’t use all milk—it can

29 likes

Dawg…🥹✌️

0 likes

A laptop on a desk displays a design application with various visual assets, while a monitor in the background shows a pixelated tree. The image features text overlay: "These apps will change how you organize your design files, content, and photos!"

A screenshot of the Cosmos app interface displays a grid of diverse design inspirations, including 3D objects and abstract art. The image highlights Cosmos as a sleek AI-powered inspiration hub for capturing creative ideas.

Screenshots of the Playbook app interface showcase a photographer's event gallery, a designer's portfolio, and visual boards. The image describes Playbook as an app for organizing creative assets with AI tags and seamless project management.

Apps to Keep Your Design Files & Photos in Order

Starting my creative projects used to mean drowning in endless folders on my MacBook or piecing together mood boards in Miro—like I did for my recent room makeover. But honestly, I often lost motivation because I’d forget where I found all my inspiration online. Pinterest is always great, b

111 likes

See more