- 69
- 70 278
Rebekah Oster
Registrace 18. 10. 2023
Bulk Create Folders and Subfolders in File Explorer using Excel | 2 Methods
Learn the first steps to optimize any spreadsheet: www.excelpowerup.com/training
Take your Excel spreadsheets to the next level: www.excelpowerup.com/course
Get personalized professional support: www.excelpowerup.com/support
In this tutorial, I reveal how to create 500 folders in File Explorer in mere seconds! If you need to set up multiple folders and sub-folders efficiently, these techniques are game-changers. I’ll walk you through using Excel’s powerful text functions and handy Windows tools to simplify the task. Whether you’re organizing your digital workspace or managing a project, these tips will save you valuable time.
Website: www.excelpowerup.com
Instagram: rebekahoster
TikTok: www.tiktok.com/@rebekahoster
LinkedIn: www.linkedin.com/in/rebekah-oster
00:00 Introduction
00:36 Create List of Folder Names
01:27 Remove Duplicates
02:05 Remove Special Characters
03:18 Enclose in Quotes
04:17 Method 1: Open in Terminal
06:04 Method 2: Create Batch File
07:46 Repeat Process for Subfolders
Take your Excel spreadsheets to the next level: www.excelpowerup.com/course
Get personalized professional support: www.excelpowerup.com/support
In this tutorial, I reveal how to create 500 folders in File Explorer in mere seconds! If you need to set up multiple folders and sub-folders efficiently, these techniques are game-changers. I’ll walk you through using Excel’s powerful text functions and handy Windows tools to simplify the task. Whether you’re organizing your digital workspace or managing a project, these tips will save you valuable time.
Website: www.excelpowerup.com
Instagram: rebekahoster
TikTok: www.tiktok.com/@rebekahoster
LinkedIn: www.linkedin.com/in/rebekah-oster
00:00 Introduction
00:36 Create List of Folder Names
01:27 Remove Duplicates
02:05 Remove Special Characters
03:18 Enclose in Quotes
04:17 Method 1: Open in Terminal
06:04 Method 2: Create Batch File
07:46 Repeat Process for Subfolders
zhlédnutí: 720
Video
How to Find and Remove Duplicates in Excel | 4 Methods
zhlédnutí 446Před 14 dny
Learn the first steps to optimize any spreadsheet: www.excelpowerup.com/training Take your Excel spreadsheets to the next level: www.excelpowerup.com/course Get personalized professional support: www.excelpowerup.com/support Are duplicates in your spreadsheets driving you crazy? I’ve got the perfect solution! In this video, I’ll show you 4 simple methods to identify and eliminate those pesky du...
Combine Multiple Excel Sheets or Files | 2 Methods to Save Time!
zhlédnutí 1,2KPřed 21 dnem
Learn the first steps to optimize any spreadsheet: www.excelpowerup.com/training Take your Excel spreadsheets to the next level: www.excelpowerup.com/course Get personalized professional support: www.excelpowerup.com/support Discover the secrets of Excel file management with our comprehensive guide on how to append and merge tables. Master the art of combining Excel files using dynamic formulas...
Master Advanced Conditional Formatting | Step-by-step Excel Tutorial
zhlédnutí 1,3KPřed měsícem
Learn the first steps to optimize any spreadsheet: www.excelpowerup.com/training Take your Excel spreadsheets to the next level: www.excelpowerup.com/course Get personalized professional support: www.excelpowerup.com/support Unlock the full potential of your Excel spreadsheets with this easy-to-follow tutorial on Advanced Conditional Formatting! Learn how to highlight rows based on a condition....
Remove Blank Rows | Easy Excel Tutorial
zhlédnutí 234Před měsícem
Learn the first steps to optimize any spreadsheet: www.excelpowerup.com/training Take your Excel spreadsheets to the next level: www.excelpowerup.com/course Get personalized professional support: www.excelpowerup.com/support Jump into my easy guide on fixing up your Excel sheets! Ever seen those annoying empty rows that pop up when you move data around? Well, it’s time to get rid of them for go...
Copy Rows from One Sheet to Another with Multiple Criteria | Excel Filter Trick
zhlédnutí 343Před měsícem
Learn the first steps to optimize any spreadsheet: www.excelpowerup.com/training Take your Excel spreadsheets to the next level: www.excelpowerup.com/course Get personalized professional support: www.excelpowerup.com/support Unleash the potential of Excel’s FILTER function with my step-by-step guide! I’ll show you how to set up an advanced filter to effortlessly manage large datasets. Forget th...
How to Sum by Month in Excel | Easy PivotTable Tutorial and SUMIF Function
zhlédnutí 265Před měsícem
Learn the first steps to optimize any spreadsheet: www.excelpowerup.com/training Take your Excel spreadsheets to the next level: www.excelpowerup.com/course Get personalized professional support: www.excelpowerup.com/support Maximize your Excel skills with this quick and powerful tutorial. Learn to sum monthly data effortlessly using PivotTables and the SUMIF function, without relying on the ma...
Excel Dynamic Organization Chart | 2 Methods
zhlédnutí 238Před měsícem
Learn the first steps to optimize any spreadsheet: www.excelpowerup.com/training Take your Excel spreadsheets to the next level: www.excelpowerup.com/course Get personalized professional support: www.excelpowerup.com/support Discover the power of Organization Charts in this video! An Organization Chart is a visual representation of a company’s structure, illustrating the roles, responsibilities...
Highlight Row and Column when Clicked in Excel | VBA Shortcut
zhlédnutí 341Před 2 měsíci
Learn the first steps to optimize any spreadsheet: www.excelpowerup.com/training Take your Excel spreadsheets to the next level: www.excelpowerup.com/course Get personalized professional support: www.excelpowerup.com/support This auto-highlighting feature in Excel can be implemented in a straightforward two-step process. This feature is particularly beneficial when dealing with extensive tables...
How to Insert Excel Date Picker | Mini Calendar Add-in | Secret VBA Hack!
zhlédnutí 2,4KPřed 2 měsíci
Learn the first steps to optimize any spreadsheet: www.excelpowerup.com/training Take your Excel spreadsheets to the next level: www.excelpowerup.com/course Get personalized professional support: www.excelpowerup.com/support I added this date picker to my Excel spreadsheet in less than 5 minutes! One of the biggest complaints people have about Excel is that it’s hard to use. That’s why I always...
How to Return Multiple Values in Excel Lookup Function | Get All Matches!
zhlédnutí 636Před 2 měsíci
Learn the first steps to optimize any spreadsheet: www.excelpowerup.com/training Take your Excel spreadsheets to the next level: www.excelpowerup.com/course Get personalized professional support: www.excelpowerup.com/support Have you ever created a perfect lookup function, only to realize that your lookup table actually has multiple rows that should be matching? If so, you're not alone. Traditi...
How to Check if Cell Contains Specific Text from a List | Partial Match Excel Tutorial
zhlédnutí 394Před 2 měsíci
Learn the first steps to optimize any spreadsheet: www.excelpowerup.com/training Take your Excel spreadsheets to the next level: www.excelpowerup.com/course Get personalized professional support: www.excelpowerup.com/support In this video, I reveal a simple yet dynamic method to automate text analysis. This approach can save you countless hours by using a formula to check if a cell contains spe...
Extract Data with Dynamic Functions TAKE and DROP | Excel 365
zhlédnutí 825Před 2 měsíci
Learn the first steps to optimize any spreadsheet: www.excelpowerup.com/training Take your Excel spreadsheets to the next level: www.excelpowerup.com/course Get personalized professional support: www.excelpowerup.com/support Are you tired of doing the same data analysis over and over? What if I told you that you could set up a one-time function to do the heavy lifting for you? In this tutorial,...
Combine Multiple Rows into One Row in Excel | Comprehensive Tutorial
zhlédnutí 1,3KPřed 2 měsíci
Combine Multiple Rows into One Row in Excel | Comprehensive Tutorial
Excel Habit Tracker in 5 minutes! Minimal and Efficient
zhlédnutí 413Před 2 měsíci
Excel Habit Tracker in 5 minutes! Minimal and Efficient
Multiple Dependent Drop-Down List in Excel | NEW Simple Method | Works with multiple rows
zhlédnutí 4,4KPřed 2 měsíci
Multiple Dependent Drop-Down List in Excel | NEW Simple Method | Works with multiple rows
Excel Insert Picture Into Cell | Multiple Pictures
zhlédnutí 641Před 3 měsíci
Excel Insert Picture Into Cell | Multiple Pictures
COUNT or SUM Cells by Color in Excel | Quick Method and VBA Method
zhlédnutí 912Před 4 měsíci
COUNT or SUM Cells by Color in Excel | Quick Method and VBA Method
Excel Dashboard for Beginners | Interactive and Dynamic!
zhlédnutí 4,2KPřed 4 měsíci
Excel Dashboard for Beginners | Interactive and Dynamic!
Excel Dynamic Search Box Tutorial | Find Anything | Multi-Column Search
zhlédnutí 32KPřed 4 měsíci
Excel Dynamic Search Box Tutorial | Find Anything | Multi-Column Search
New Excel Features for 2024 | Fast and Easy!
zhlédnutí 9KPřed 4 měsíci
New Excel Features for 2024 | Fast and Easy!
This helps me a lot. Thank you very much.
Also, can't you use """" (4 double quotation marks) =""""&A1&""""" , which gives you "test". Not sure if there is a reason not too
OMG, this is incredible, I normally use PowerAutomate but this is so much simpler and easier to use
This will be such a time saver when setting up new folders at the beginning of each year!
رائع جدا برنامج عظيم . Very nice project great .
I really needed help...I try doing many excel search box tutorial but in vain...it won't work on mine...im using FILTERXML...need suggestions please...
I started using Pivot Table and i prefer it over formulas now. It is obviously convenient.
few ppl have office 365 here in pak
I have one problem how to get filter function🥺🥺
Excellent presentation but I cant get mine working.
Hi so I did like your video and it worked but only 1 problem, I cant overwrite the date?
GREAT !!! THANKS .... Can I have your file, so Excel translates the formulas to Dutch format ??
Insanely helpful! This is like the only useful vid on Date Picker thing I could find on CZcams
I can't thank you enough. You are a great Excel tutor
Great!
This was so easy to follow!! You have a great pace and way of explaining!
Thank you so much! Have you signed up for my masterclass? www.excelpowerup.com/training 🎉
I have the issue cannot insert objest for the textbox
Thank you. We need more of your educative tutorials
I’m working on them! I have a free masterclass with great content here: www.excelpowerup.com/training
Hi I love your search box I am looking for a way of searching data then have the ability to edit data can you help
Oh i didn't know power query could be refreshed this quickly on such a sheet (i know very little about power query, the tutorial i tried didn't vibe with my version of excel). Very good tutorial as always! I set up a report that finds duplicate orders for my colleagues, so they have a lot less hassle with unhappy customers now. I created a report that goes through our open orders and finds duplicate order numbers. If this happens, i get an alert, and an email. It rans constantly on a spare pc, and about once a day there is something wrong. And if there is something wrong, i find out very quickly and we don't ship the stuff. It works with countif i think. My colleagues think I'm some kind of all knowing genius 😂 and it just runs by itself.
Wow, that sounds amazing!! I love it when a spreadsheet “just runs by itself” 🥳. If you have any other spreadsheets that need work, I have an awesome masterclass here: www.excelpowerup.com/training
I was the first student to arrive to study and felt very happy.
I follow step by step and it worked. Thank youu
Woot woot! You are so welcome 🤗
Nice work. Could you please share some sample data in excel also any websites where i will get sample data for self study.
@@FaizFarook-st1ny kaggle se uthalo bhai
Waiting for more videoss❤❤
They are coming!! Have you signed up for my free masterclass? www.excelpowerup.com/training 🎉
@@RebekahOster tell me details..what to expect
Just awesome.....keep it up
Thank you so much!!
Definitely power query will forever my choice from now on.
Haha me too!
In minute 9.52, I think you mean F4, rather than Ctrl+F 😂😂😂
Thank you so much Rebekah. You're a STAR!
Wow thank you!!
I’m your new follower, love your videos. Thanks for sharing.
Thanks for subbing! I have more content in a free masterclass here: www.excelpowerup.com/training
Great tutorial. Many thanks.
Fantastic! Very clearly explained.
Thank you! What if the Name of the school and primary contact email address were on a second tab. How could a search bar on the primary sheet "pull through" second tab details like the email address by entering the name of the school?
How do I create a text box where it says Type Here and have the text disappear when you click the text box as they do in various websites? And if left blank, the Type Here would return. Also, Type Here would be a light gray. When you type in a query in the box, it would be default black.
you are great, please make a playlist for videos
Great idea!
Fantastic tutorial. Saves lives! Thank you so much!
Thank you so much for this.
You are so welcome!
Gracias, muy buena aclaración. Saludos cordiales!!!!!😊👍
Thank you for watching!! I have a free masterclass here: www.excelpowerup.com/training
W video
👏👏👏 If you could make available to down load formulas in some sort of format will be helpful to follow for anyone interested
This tutorial helped me a lot to clear my misunderstanding. Whenever using conditional formatting through formula. Thank you.
I’m so glad it helped! 🎉
@@RebekahOster I got a query for excel formula. i spent few hours with Bing AI getting help but could not succeed help. How can i share this file or tell you that query i need to solve.,
i have dates in 3 columns, paid upto then from and to. I want claculate sum in column arrear, whereas date of next month in column "from" following paid upto column and 1 month less date than column "to" date.
=IFERROR(SUM(OFFSET($E4, 0, MATCH(TEXT($B4, "mmm-yy"), $E$2:$U$2, 0) - 1, 1, MATCH(TEXT($C4, "mmm-yy"), $E$2:$U$2, 0) - MATCH(TEXT($B4, "mmm-yy"), $E$2:$U$2, 0) + 1)), "Date Not Found")
I got the first spot.
thanks
Of course, learned something new. Thanks
I’m so glad it was helpful! You could learn more in my free training: www.excelpowerup.com/training 🎉
you are awesome
Kudos to you for the tutorial!👍👍👍👍👍👍🚩🚩🚩🚩🚩🚩🎈🎈🎈🎈🎈🎈
Thank you so much! I have more helpful tips in my free training: www.excelpowerup.com/training 🥳
Hello, this video was super helpful for me, thanks for sharing it! I created 3 dependent lists with lots of options within each list. I'm running into a problem though: as I get further down into my spreadsheet and choose from my first list I start loosing the different options I have in the second and third dependent lists that I used to see towards the beginning of the spreadsheet. I think this is because as I go down the possible options for each dependent list the formula goes down one row and the options start to get used up, so I'm left with less options to choose from each list. Would you know how I can fix this!? I tried copying and pasting the formula to each cell under the drop-down "Helper" instead of dragging down like you did, but that ends up only limiting me to the first thread of options of the dependent lists...I hope this explanation makes sense...Thanks!
Hi, this is awesome work. I just found you on my CZcams feed but i am happy i did. I am beginner freelancer with exxel being my tool of business. This video is super useful
Easy to understand tutorial, I learned how to multiconditional filter and how to display dynamic table box lines after filtering the table, thanks.
Hi Rebekah, very nice tutorial on filter function! 👍 Just a question- Is the filter function applicable to multiple sheets in a same file?
Rebeka u made things so easy but i need ur help instead of School we can use Apartment and in apartment i want to find a certain room that will be in the row . i m trying to find the solution but failed. plz help.