- Видео 83
- Просмотров 109 197
White Board
Добавлен 11 май 2021
Hi Everyone,
This is an eLearning Channel to take you through with various advanced features and functions of Excel, VBA, Power BI Tableau, PowerPoint presentations, Financial modelling for easy data crunching, MIS, Financial Analytical and audit purposes.
I would also be happy to take us through with other interesting eLearnings. Please drop your questions or comments and I will upload a video on that topic.
Stay tuned for more learning sessions.
Like, Share and Subscribe this channel.
Regards,
White Board.
#WhiteBoard
Видео
Automatically rename multiple Files/Folder #AutoRename #Excel #Notepad
Просмотров 4772 года назад
Formula : =A2&" "&D2&B2&D2&" "&D2&C2&D2
Create To Do list in Excel easily (No VBA required) #ToDoList #MSExcel #AddIn
Просмотров 1433 года назад
Create To Do list in Excel easily (No VBA required) #ToDoList #MSExcel #AddIn
Series for Sequential numbers in Excel #SeriesinExcel #MSExcel
Просмотров 703 года назад
Series for Sequential numbers in Excel #SeriesinExcel #MSExcel
How to Protect cells or Section of Excel Sheet #ProtectExcel #MSExcel #ProtectCell
Просмотров 883 года назад
How to Protect cells or Section of Excel Sheet #ProtectExcel #MSExcel #ProtectCell
How to filter data with Pictures in Excel #FilterPictures #MSExcel
Просмотров 1293 года назад
How to filter data with Pictures in Excel #FilterPictures #MSExcel
Clustered Stacked Column Chart in Excel | How to add % with values | #MSExcel #ExcelGraphs
Просмотров 2693 года назад
Clustered Stacked Column Chart in Excel | How to add % with values | #MSExcel #ExcelGraphs
Convert multiple Excel tabs to ONE single PDF FIle in 1 minute !!
Просмотров 4663 года назад
Convert multiple Excel tabs to ONE single PDF FIle in 1 minute !!
Stacked Column Pivot Chart in Excel | Add Totals to the Stacked Column Chart #MSExcel
Просмотров 18 тыс.3 года назад
Stacked Column Pivot Chart in Excel | Add Totals to the Stacked Column Chart #MSExcel
Repeat Rows, Columns, Headers in Excel #MSExcel
Просмотров 523 года назад
Check this video for step by step guide on how to repeat Rows and Columns in Excel while printing reports
Insert Videos/YouTube Video in Power Point #YouTube #PowerPoint
Просмотров 1093 года назад
Insert Videos/RUclips Video in Power Point #RUclips #PowerPoint
Insert 3D Models in Power Point Presentations
Просмотров 713 года назад
Insert 3D Models in Power Point Presentations
Separate Text and Numbers in Excel quickly !! | Learn easy way to split Text and Numbers in Excel
Просмотров 963 года назад
Separate Text and Numbers in Excel quickly !! | Learn easy way to split Text and Numbers in Excel
Sum Function across multiple Tabs in Excel | Dynamic Totals of Tabs #MSExcel
Просмотров 1273 года назад
Sum Function across multiple Tabs in Excel | Dynamic Totals of Tabs #MSExcel
Create Wordcloud online for free. No account creation required | Quick and easy !!
Просмотров 903 года назад
Create Wordcloud online for free. No account creation required | Quick and easy !!
Add Suffix, Prefix to the cells in Excel #MSExcel
Просмотров 1,2 тыс.3 года назад
Add Suffix, Prefix to the cells in Excel #MSExcel
Microsoft Outlook best Hacks | Outlook Tips & Tricks
Просмотров 4823 года назад
Microsoft Outlook best Hacks | Outlook Tips & Tricks
Create Mini Calendar and date picker in Excel | Excel Calendar
Просмотров 3,5 тыс.3 года назад
Create Mini Calendar and date picker in Excel | Excel Calendar
Create People Graph in Excel | Improve Graphical Visualization | #Infographic
Просмотров 1313 года назад
Create People Graph in Excel | Improve Graphical Visualization | #Infographic
3 Ways to Remove the Duplicates in Excel you didn't know about!
Просмотров 443 года назад
3 Ways to Remove the Duplicates in Excel you didn't know about!
Create Google Forms and collect responses | Use Google Forms #GoogleForms
Просмотров 823 года назад
Create Google Forms and collect responses | Use Google Forms #GoogleForms
Automated Loan, Interest Calculator with Graph in Excel
Просмотров 2003 года назад
Automated Loan, Interest Calculator with Graph in Excel
What if Keyboard Keys are not working ?? - Find a quick solution here
Просмотров 493 года назад
What if Keyboard Keys are not working ?? - Find a quick solution here
Progress Donut Chart in Excel in 2 mins !!
Просмотров 603 года назад
Progress Donut Chart in Excel in 2 mins !!
Smart Alternatives to Bar Charts in Excel | #BarCharts #WorldMap #Graphs
Просмотров 2383 года назад
Smart Alternatives to Bar Charts in Excel | #BarCharts #WorldMap #Graphs
Create Dynamic World Map Chart in Excel #WorldMap #Worldographic
Просмотров 4943 года назад
Create Dynamic World Map Chart in Excel #WorldMap #Worldographic
Create Dynamic Organisation Structure, Hierarchy Structure, Flow Chart in Excel #OrgChart #FlowChart
Просмотров 2,5 тыс.3 года назад
Create Dynamic Organisation Structure, Hierarchy Structure, Flow Chart in Excel #OrgChart #FlowChart
Thank you so much. This is the best and easiest video on this topic :)
Thank you so much! I've been looking for a way to do this!
How to copy a file in a subfolder
This is GOLD, thank you so much for sharing this! LOVE IT!
Works well but some folders have the correct name but empty
Worked perfectly thanks
Brilliant! Bravo! Eureka! A thousand thanks, this is enormously helpful.
Can we move different files like type-, type-2, type-3 move into one specific folder like single Type. Please reply if have anything.
Hi, thanks for the video. Your instructions seemed pretty straight forward, however when I double click on the Organize.bat file, I get a pop-up box that says "This App can't run on your PC. To find a version for your PC, check with the software publisher." I have spent a lot of time trying to figure out what to do from here. I have tried right clicking on it and selecting "run as administrator" but that does nothing. I am using Windows 11, however the files that are am trying to organize are on a network that uses Lynux, so I am not sure if that is part of the problem.
oh my goodness, this was EXACTLY what i was looking for. Thank you SO MUCH!!!!!!
Omg you are amazing.
Thank you Thank you THANK YOU!
Thanks for sharing a very informative video, easy to understand
It's Magic. Thanks.
Brilliant! What does it do if there are other folders in the folder?
didn't work only file that got put in folder was the bat file
Thanks A lot..
Thank You.
This video was so useful, thank you very much. hope you have a nice day
Useless
can anybody tell me if there is 1 pdf and 1 dwg file
Thanks you
Bad skill
Why not use v look formula instead if formula
Excellent - thanks 😎
Great ...amazing :)
Bless you, lady! This script does literally 100% exactly what I needed!! I have a bunch of files in one folder, and I wanted to create separate folders for each file, based on the file name. this does EXACTLY that, instantly! It creates a folder named exactly the same as the file, then moves the file into the folder! Brilliant! Thanks so much!!
THANK YOU!
Do you have anything like this for the Mac?
no txt to remove while renaming .remaining as text what to do
put it inside zip and rename it😂
Well Done
Hi, I have the following issue that I can't solve by now. In one folder a have about 25.000 files, which names start with a specific code, followed by other shortbtext. The names of the files look like this: "132536478 [01]", "132536478 [02]" etc ... "162535535 [01]", ... "1753527737 [01]" .... In another folder I have 3000 empty folders, with names starting similar to the file names that look like this as "132536478 - some text ...", "1762667726 - some other text" ..... My question is - how can I move the files with names starting with 132536478 to the folder starting with the same code? Is this possible with Total Commander? With other words - I need to move all files with names starting with "1234567890 ..." for example, to their corresponding folder, with name starting with the same code - "1234567890 ....". Your help is greatly appreciated! Sincerely, Jordan J.
totally unclear on what you are doing on the format cells.
❤
this was useless
Does this also apply to photos? Failed to create photo folders for me.
is there not an app to do this
Wow...very nice
Misleading title. Doesn't really tell how to do it in a pivot chart, just copies data to a table.
thank you
great, very useful, thank you ! <3
Thank You 🙏
Very good i m searching for 3 day! But u solved my problem l thanks
Thank you for your guide, it's so easy to follow. Just wonder, if I would like to create file with part of the name, what should I do? Just like your files, I only want to create folders with year number "2015"... only.
I am wanting to create folders like this but if i have 1000 files how do i set it up so if i click the organize it will put 25 files in each folder so I have 40 folders with 25 files in it
We Can Also make a zip or rar for all the files. And then extract as separate folder.
it worked very well. thank you for sharing
Spoiler alert : After 10 minutes, they just insert a custom table with grand total data and use the old combo chart trick to add totals on stacked columns. So this video has nothing to do with pivot charts and the title is misleading.
Thanks for the heads-up; have you found a way of doing this?
he just wasted 5 minutes of time I don't have... I reported it for misleading title.
Waste of time indeed
god bless you, thanks a lot!
Hi do anyone know how to make folders automatically with characters such as „ö,ä,ü“?