Rebekah Oster
Rebekah Oster
  • 69
  • 70 278
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
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!

Komentáře

  • @saharatsaengyuan3781
    @saharatsaengyuan3781 Před 4 hodinami

    This helps me a lot. Thank you very much.

  • @DinoDelight
    @DinoDelight Před 23 hodinami

    Also, can't you use """" (4 double quotation marks) =""""&A1&""""" , which gives you "test". Not sure if there is a reason not too

  • @DinoDelight
    @DinoDelight Před 23 hodinami

    OMG, this is incredible, I normally use PowerAutomate but this is so much simpler and easier to use

  • @yertletheturtle5843

    This will be such a time saver when setting up new folders at the beginning of each year!

  • @sahralsahri7180
    @sahralsahri7180 Před 2 dny

    رائع جدا برنامج عظيم . Very nice project great .

  • @Cathy-zw1el
    @Cathy-zw1el Před 3 dny

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

  • @MuhammadAli-su3oo
    @MuhammadAli-su3oo Před 4 dny

    I started using Pivot Table and i prefer it over formulas now. It is obviously convenient.

  • @775shahrukh
    @775shahrukh Před 5 dny

    few ppl have office 365 here in pak

  • @balewgeta7132
    @balewgeta7132 Před 5 dny

    I have one problem how to get filter function🥺🥺

  • @hassalmua1691
    @hassalmua1691 Před 6 dny

    Excellent presentation but I cant get mine working.

  • @DanTran-if2jt
    @DanTran-if2jt Před 9 dny

    Hi so I did like your video and it worked but only 1 problem, I cant overwrite the date?

  • @bertvantol9669
    @bertvantol9669 Před 10 dny

    GREAT !!! THANKS .... Can I have your file, so Excel translates the formulas to Dutch format ??

  • @DanTran-if2jt
    @DanTran-if2jt Před 10 dny

    Insanely helpful! This is like the only useful vid on Date Picker thing I could find on CZcams

  • @mukhtarsheriff
    @mukhtarsheriff Před 13 dny

    I can't thank you enough. You are a great Excel tutor

  • @kabwechola7141
    @kabwechola7141 Před 14 dny

    Great!

  • @stephieYT
    @stephieYT Před 15 dny

    This was so easy to follow!! You have a great pace and way of explaining!

    • @RebekahOster
      @RebekahOster Před 13 dny

      Thank you so much! Have you signed up for my masterclass? www.excelpowerup.com/training 🎉

  • @kenanalper361
    @kenanalper361 Před 18 dny

    I have the issue cannot insert objest for the textbox

  • @mukhtarsheriff
    @mukhtarsheriff Před 19 dny

    Thank you. We need more of your educative tutorials

    • @RebekahOster
      @RebekahOster Před 13 dny

      I’m working on them! I have a free masterclass with great content here: www.excelpowerup.com/training

  • @markdavies4255
    @markdavies4255 Před 19 dny

    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

  • @Gigi82knits
    @Gigi82knits Před 19 dny

    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.

    • @RebekahOster
      @RebekahOster Před 13 dny

      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

  • @veruscrt
    @veruscrt Před 19 dny

    I was the first student to arrive to study and felt very happy.

  • @andrenalize
    @andrenalize Před 21 dnem

    I follow step by step and it worked. Thank youu

  • @FaizFarook-st1ny
    @FaizFarook-st1ny Před 21 dnem

    Nice work. Could you please share some sample data in excel also any websites where i will get sample data for self study.

    • @775shahrukh
      @775shahrukh Před 13 dny

      @@FaizFarook-st1ny kaggle se uthalo bhai

  • @775shahrukh
    @775shahrukh Před 21 dnem

    Waiting for more videoss❤❤

    • @RebekahOster
      @RebekahOster Před 13 dny

      They are coming!! Have you signed up for my free masterclass? www.excelpowerup.com/training 🎉

    • @775shahrukh
      @775shahrukh Před 13 dny

      @@RebekahOster tell me details..what to expect

  • @775shahrukh
    @775shahrukh Před 21 dnem

    Just awesome.....keep it up

  • @lydethful
    @lydethful Před 22 dny

    Definitely power query will forever my choice from now on.

  • @lydethful
    @lydethful Před 22 dny

    In minute 9.52, I think you mean F4, rather than Ctrl+F 😂😂😂

  • @zakhelembhele7046
    @zakhelembhele7046 Před 22 dny

    Thank you so much Rebekah. You're a STAR!

  • @paramveerssachdeva
    @paramveerssachdeva Před 23 dny

    I’m your new follower, love your videos. Thanks for sharing.

    • @RebekahOster
      @RebekahOster Před 13 dny

      Thanks for subbing! I have more content in a free masterclass here: www.excelpowerup.com/training

  • @GarageCrafter
    @GarageCrafter Před 24 dny

    Great tutorial. Many thanks.

  • @ziyamoustafa4951
    @ziyamoustafa4951 Před 29 dny

    Fantastic! Very clearly explained.

  • @AmeliaRDream100
    @AmeliaRDream100 Před měsícem

    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?

  • @fcv1967
    @fcv1967 Před měsícem

    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.

  • @user-hm9hw1oy6u
    @user-hm9hw1oy6u Před měsícem

    you are great, please make a playlist for videos

  • @LUSHImboundMarketingFKcom

    Fantastic tutorial. Saves lives! Thank you so much!

  • @wonderwithace
    @wonderwithace Před měsícem

    Thank you so much for this.

  • @reporterodeslenguado7393
    @reporterodeslenguado7393 Před měsícem

    Gracias, muy buena aclaración. Saludos cordiales!!!!!😊👍

    • @RebekahOster
      @RebekahOster Před 13 dny

      Thank you for watching!! I have a free masterclass here: www.excelpowerup.com/training

  • @JustMac5
    @JustMac5 Před měsícem

    W video

  • @tuffley2175
    @tuffley2175 Před měsícem

    👏👏👏 If you could make available to down load formulas in some sort of format will be helpful to follow for anyone interested

  • @MuhammadAli-su3oo
    @MuhammadAli-su3oo Před měsícem

    This tutorial helped me a lot to clear my misunderstanding. Whenever using conditional formatting through formula. Thank you.

    • @RebekahOster
      @RebekahOster Před 13 dny

      I’m so glad it helped! 🎉

    • @MuhammadAli-su3oo
      @MuhammadAli-su3oo Před 5 dny

      @@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.,

    • @MuhammadAli-su3oo
      @MuhammadAli-su3oo Před 5 dny

      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.

    • @MuhammadAli-su3oo
      @MuhammadAli-su3oo Před 4 dny

      =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")

  • @veruscrt
    @veruscrt Před měsícem

    I got the first spot.

  • @abbaaminu6003
    @abbaaminu6003 Před měsícem

    thanks

  • @MuhammadAli-su3oo
    @MuhammadAli-su3oo Před měsícem

    Of course, learned something new. Thanks

    • @RebekahOster
      @RebekahOster Před měsícem

      I’m so glad it was helpful! You could learn more in my free training: www.excelpowerup.com/training 🎉

  • @MoustafaMahmoudElmasry
    @MoustafaMahmoudElmasry Před měsícem

    you are awesome

  • @veruscrt
    @veruscrt Před měsícem

    Kudos to you for the tutorial!👍👍👍👍👍👍🚩🚩🚩🚩🚩🚩🎈🎈🎈🎈🎈🎈

    • @RebekahOster
      @RebekahOster Před měsícem

      Thank you so much! I have more helpful tips in my free training: www.excelpowerup.com/training 🥳

  • @VT-xt3vi
    @VT-xt3vi Před měsícem

    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!

  • @sidrajamal7577
    @sidrajamal7577 Před měsícem

    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

  • @veruscrt
    @veruscrt Před měsícem

    Easy to understand tutorial, I learned how to multiconditional filter and how to display dynamic table box lines after filtering the table, thanks.

  • @satish3777
    @satish3777 Před měsícem

    Hi Rebekah, very nice tutorial on filter function! 👍 Just a question- Is the filter function applicable to multiple sheets in a same file?

  • @jamshedpathan2269
    @jamshedpathan2269 Před měsícem

    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.