![Yosef K](/img/default-banner.jpg)
- Видео 43
- Просмотров 174 110
Yosef K
Израиль
Добавлен 29 окт 2020
My intention was to create short tutorials on selected topics in Excel with VBA, Pivot Tables and Power Query. These are my first steps, with lots of performance anxiety and lots of room for improvement. For the recording and editing of my videos I'm mostly using these freeware programmes: OBS screenrecorder, Openshot video editor and Audacity sound editor. All of them professional and all of them with lots of basic tutorials on RUclips. Unfortunately when you're stuck with some very specific problem, it's difficult to find solutions. I would like to share with you my experiences using these programmes with short and focussed videos. Hoping to provide some help to anyone dealing with problems I encountered. Knowledge is worthless if not shared with others.
Add BIG CAPTIONS to vertical "Shorts" videos using Subtitle Edit
This tutorial shows you how to add big captions to "Shorts" vertical videos for RUclips.
Watch this tutorial to turn a regular 16:9 ratio video into a vertical 9:16 ratio video for RUclips "Shorts": ruclips.net/video/RNSSswcE02w/видео.html
Software used for creating this video:
Subtitle Edit (free subtitle editor): www.nikse.dk/subtitleedit
OBS Studio (free screen recorder): obsproject.com/
OpenShot (free video editor): www.openshot.org/
Audacity (free audio editor): www.audacityteam.org/
VCL (free media player): www.videolan.org/vlc/download-windows.html
Like the video? Buy me a coffee:
buymeacoffee.com/yosefkdm
Watch this tutorial to turn a regular 16:9 ratio video into a vertical 9:16 ratio video for RUclips "Shorts": ruclips.net/video/RNSSswcE02w/видео.html
Software used for creating this video:
Subtitle Edit (free subtitle editor): www.nikse.dk/subtitleedit
OBS Studio (free screen recorder): obsproject.com/
OpenShot (free video editor): www.openshot.org/
Audacity (free audio editor): www.audacityteam.org/
VCL (free media player): www.videolan.org/vlc/download-windows.html
Like the video? Buy me a coffee:
buymeacoffee.com/yosefkdm
Просмотров: 1 313
Видео
A great trick to quickly copy & paste images between two Word documents with synchronous scrolling.
Просмотров 89Год назад
In this tutorial I'll show you how to automatically translate a Word document that contains images, and easily paste the images into the translation using synchronous scrolling. Like the video? Buy me a coffee: buymeacoffee.com/yosefkdm
Create and use animated shapes in the OpenShot video editor.
Просмотров 3,9 тыс.Год назад
OpenShot is a great free video editor with many effects that you can apply to your videos but it's lacking a very important one: animated shapes and shapes in general. In this tutorial I'll show you an easy workaround how to create your own animated shapes and how to use them in any of your videos. Create them once and use them as often you want. All software I used to create these shapes and t...
VBA macro to create a backup of your open Excel file
Просмотров 1,1 тыс.Год назад
In this tutorial I give you the VBA code to easily create backups of an open Excel file. If your file is saved on Microsoft OneDrive, Excel automatically saves all changes you make to the file so that you can easily return to an earlier version if things go bad. This macro will not work for files saved on OneDrive because there is really no need for it. But if you're working on a locally saved ...
How to add a macro button to the ribbon in Excel.
Просмотров 1,9 тыс.Год назад
If you have macros in your Personal Workbook or as Addins that you run often on for example workbooks or worksheets that you are developing, it is very useful and time-saving if you can run these macros at the click on a button in the ribbon. This tutorial explains how to add such a macro button to the ribbon. Like the video? Please consider buying me a coffee: buymeacoffee.com/yosefkdm Softwar...
Insert a picture in a note in Excel
Просмотров 1,7 тыс.Год назад
In this tutorial I'll show you how to insert a picture in a note in Excel. Like the video? Buy me a coffee: buymeacoffee.com/yosefkdm For creating this video I used only FREE software: OBS Studio (screenrecorder): obsproject.com/ OpenShot (video editor): www.openshot.org/ Subtitle Edit (subtitle editor): www.nikse.dk/subtitleedit
Transcribe and translate any video or audio automatically while watching or listening
Просмотров 9 тыс.Год назад
In this tutorial, I’ll show you how to feed the soundtrack of a RUclips video straight into Google Translate and have it translated almost simultaneously and get a transcript of both the original language and the translation as a bonus. DON'T FORGET TO RESET YOUR SOUND SETTINGS AFTER YOU FINISH as explained in the tutorial. download the (free) virtual cable from: vb-audio.com/Cable/ For creatin...
How to turn a regular video into a vertical SHORTS video
Просмотров 290Год назад
This tutorial shows you how to turn a regular 16:9 aspect ratio video, into a vertical 9:16 aspect ratio for uploading to Shorts on RUclips or any other platform that requires vertical videos. This tutorial shows you how to edit these videos straight from your laptop or PC. Like the video? Buy me a coffee: buymeacoffee.com/yosefkdm
SUBTITLE EDIT: generate subtitles in languages not supported by the VOSK speech recognition engine.
Просмотров 1,2 тыс.2 года назад
This tutorial shows you how to generate and translate subtitles for videos in languages that are not supported by the Vosk speech recognition engine that is used by SUBTITLE EDIT. Here is a link to a previous video of mine that shows how to synchronize the subtitles from a text file as used in this tutorial: ruclips.net/video/OKjfPXWIykA/видео.html
How to insert blank rows in Excel based on cell values using VBA
Просмотров 2 тыс.2 года назад
This tutorial shows how to insert blank rows in an Excel spreadsheet every time a value in a column changes, using VBA. Here's a link to download the workbook containing the module: drive.google.com/drive/folders/1KswM8idh2c6pDI1yudmQCIERgAn9vpcH?usp=sharing And here's a link to download a pdf file containing only the code: drive.google.com/file/d/1tOCuwDik1cMSv_FIU_rk3soxMvp9s3V_/view?usp=shar...
How to add bilingual subtitles to your video using SUBTITLE EDIT 3.6.5
Просмотров 2,8 тыс.2 года назад
How to merge .srt files in different languages to generate bilingual subtitles in SUBTITLE EDIT 3.6.5. Here is a link to a tutorial of mine that explains how to automatically generate and translate subtitles: ruclips.net/video/39mP3JMjNao/видео.html and here's another tutorial how to synchronize subtitles: ruclips.net/video/OKjfPXWIykA/видео.html
Excel UDF - Check the validity of credit card numbers
Просмотров 4222 года назад
How to check the validity of credit card numbers or identity card numbers of several countries including Israel and South Africa. The validity is checked using the Luhn algorithm. This algorithm was designed to protect against accidental mistyping errors and it works like this: The individual digits are multiplied by 1 or 2 starting from the most right digit (which is the check digit) with 1, t...
Synchronize subtitles to your videos using SUBTITLE EDIT 3.6.5
Просмотров 15 тыс.2 года назад
In a previous video, I showed you how to Auto-translate and subtitle your videos using Subtitle Edit. And that works great as long as there is speech recognition available for your language. But what if there isn’t? Adding all your subtitles manually at the right time is very time consuming. In this video I’ll show you a great trick that will help you finish subtitling your videos in no time. H...
An Excel User Defined Function to phonetically transcribe Hebrew into the roman alphabet.
Просмотров 2322 года назад
This User Defined Excel function transcribes Hebrew instantly on condition that the Hebrew is with Nikud, meaning that it is voweled. Be able to read the whole Tanach in Hebrew without knowing to read the Hebrew letters. To download the Excel file: drive.google.com/file/d/1bYnqbXueZu8hKE_-uIaoAhqqK9SsuqHv/view?usp=sharing To download the Pdf file: drive.google.com/file/d/1nE8l9_kgoycHS_PGMxmLWw...
How to separate a combined date and time value in Excel
Просмотров 932 года назад
There are several ways to separate a combined Date and Time value in Excel. This video describes how to do this using Flash Fill, Text To Columns and the Integer Function.
Get rid of the “grouped by” date view in your download folder
Просмотров 732 года назад
Get rid of the “grouped by” date view in your download folder
Stop Excel converting Text to numbers or dates.
Просмотров 2,3 тыс.2 года назад
Stop Excel converting Text to numbers or dates.
SUBTITLE EDIT - automatically generate subtitles and translation to your video
Просмотров 53 тыс.2 года назад
SUBTITLE EDIT - automatically generate subtitles and translation to your video
Why not to use the "Sendkeys" command in a VBA module inside of Excel
Просмотров 2 тыс.2 года назад
Why not to use the "Sendkeys" command in a VBA module inside of Excel
How to easily copy a dropdown list, down a column or range in Excel
Просмотров 21 тыс.2 года назад
How to easily copy a dropdown list, down a column or range in Excel
Filling down a formula in Excel thousands of rows.
Просмотров 3 тыс.2 года назад
Filling down a formula in Excel thousands of rows.
Openshot version 2.6.1: how to modify video speed to any custom speed.
Просмотров 19 тыс.2 года назад
Openshot version 2.6.1: how to modify video speed to any custom speed.
Gematria and AtBash in Excel - גימטרייה ואת"בש באקסל
Просмотров 6962 года назад
Gematria and AtBash in Excel - גימטרייה ואת"בש באקסל
MID function: extract DIGITS from NUMBERS including LEADING zeros
Просмотров 6082 года назад
MID function: extract DIGITS from NUMBERS including LEADING zeros
View and Manage your Facebook Comments
Просмотров 82 года назад
View and Manage your Facebook Comments
פתחנו קובץ "ערכים מופרדים בפסיק" באקסל ומה שרואים מלא ג'יבריש
Просмотров 2 тыс.2 года назад
פתחנו קובץ "ערכים מופרדים בפסיק" באקסל ומה שרואים מלא ג'יבריש
איך להקליט ישירות מכרטיס הקול של המחשב בעזרת התוכנה אודסיטי
Просмотров 442 года назад
איך להקליט ישירות מכרטיס הקול של המחשב בעזרת התוכנה אודסיטי
How to add subtitles to your video using the caption effect in Openshot 2.6.1.
Просмотров 21 тыс.2 года назад
How to add subtitles to your video using the caption effect in Openshot 2.6.1.
Thanks!!!
thank you!!!
Thank you so much ❤❤ i needed it Can we add animation to subtitles?
Yes. Check out these webpages: www.nikse.dk/subtitleedit/formats/assa-override-tags and aegisub.org/docs/latest/ass_tags/
thannk you rabbi
Hard to follow and not intuitive at all. I need only a portion of video to move so the total time does not factor in at all for me. Why can't they just make us drag it left or right and it adjust?
thanks
Hello, Muhammad is the last of the prophets. If you love Moses, you must follow Muhammad. The Quran has reached you and the proof has been established against you. Beware before death. ﴿ما كانَ إِبراهيمُ يَهودِيًّا وَلا نَصرانِيًّا وَلكِن كانَ حَنيفًا مُسلِمًا وَما كانَ مِنَ المُشرِكينَ إِنَّ أَولَى النّاسِ بِإِبراهيمَ لَلَّذينَ اتَّبَعوهُ وَهذَا النَّبِيُّ وَالَّذينَ آمَنوا وَاللَّهُ وَلِيُّ المُؤمِنينَ﴾ [آل عمران: ٦٧-٦٨]
No Mac version?
@@jamescohen no
@@yosefk2864 Thanks. Desperate for software that translates videos with timing for srt files. Any suggestions please? Veed forces you to pay before you can try it.
How to remove <br /> from subtitles?
This is amazing, I've been looking for something like this for a long time. Thank you!
Please bear in mind that although an indispensable help, AI translation requiresa professional post translation edition (MTPE) especially in the case of artistic/literary film subtitles. The scientific, instructable genre etc. is much simpler linguistically and easier for the AI to process, but in any case for the subtitle translation to be professional never neglect the expert's eye and practical knowledge.
Had a 115K row spreadsheet I had to fill down on, this saved me bigtime! thank you
thank you
This is remarkable!
Looks like when there pauses in the audio like a meditation speech, this process doesn't work. It stops translating when there are gaps or long pauses. Maybe Google translater stops recording idk. I increased the speed but same issue
Like most things with openshot you can get about 90% way there. Once you get to that point you can spend forever trying to tune what you want. Very powerful application.
Is there no way to simply just add a .srt subtitles file and then just delay or hasten when it begins showing each caption/text by whatever milliseconds or seconds? I'm not trying to spend literally all day trying to manually type in ...and edit timewise each and every text caption that shows on screen with each subtitle file of a 2 hour long movie.
Use Subtitle Edit
Thanks, this is working better then Audacity OpenVino Whisper
Thank you
This is so so so helpful! Precise and straight to the point. Thank you so much!
How to add subtitles using AI perfectly through subtitles edit
How can I upload a video with the new subtitles. The file is not recognized and it seems that when I "save" it only saves the subtitles not the video.
Under the "video" menu, chose "generate video with burned in subtitles". Select the resolution of your video. Click generate. Subtitle Edit will automatically add the resolution to the file name so as not to overwrite your originale video.
nice video! works great
Tons of love and appreciation for sharing this 👍
This was driving me nuts how to do this to save time as I had over 2,000 rows I needed a drop down. This was so simple after watching this video; thank you!
Hello. I tried to install the software twice and failed. How do I remove all the installations I made of Whisper and ffmapg and the other things? Thanks
In order to use Whisper in Subtitle Edit, you first have to install Python on your PC. Here's an install guide: docs.google.com/document/d/17kmDVTSsod4rf8CEKioPcFNAj89j6WX8/edit?usp=sharing&ouid=102331683582601201545&rtpof=true&sd=true I wrote this guide a while ago for someone who wanted to transcribe and autotranslate Hebrew audio files only, so just don't pay attention to that part in the guide. I use Subtitle Edit myself a lot, using the Whisper model will save you an awfull lot of time: the transcription is almost perfect and also the timing of the subtitles is almost perfect. In case you'll decide to uninstall, I think that also all the additional components will be uninstalled. Anyway feel free to contact me: yosefkdm@gmail.com
The video I put is so small, anyone knows how to fix it so it fill the screen?
thank you!
super, vielen Dank, thanks a lot
Sir kindly reply I need some srt of tv shows can you creat for me I paid you
There are plenty of freelancers on fiverr that do these kind of jobs.
Thank you! Very helpful.
wow this is great for translating all of the Japanese game show so I can understand what they saying completely
Pressing the plus sign at the top of the captions window helps a lot. Press twice, and it adds the things in the correct format.
Thanks for sharing this!
Its shame how is this so complicated, i am going to use Shotcut instead...
Noice thanks
Sir please tell me how i add urdu language please please reply
The Urdu language is supported by the Whisper voice recognition engine and is also supported by Google translate, so what you have to do is this: First of all update to the latest version of Subtitle Edit: 4.0.3. so that you can use the Whisper engine instead of the Vosk engine. Also you’ll have to download and install Python on our PC. Download from here: www.python.org/downloads/windows/ scroll down to Python 3.10.11 download “windows installer (64-bit) or 32” according to your Windows bit-version. When installing Python make sure that “use admin privileges…” and add python.exe to PATH” are marked! Probably also the latest version of Python will work, but this is the version I use myself and it works. After installing Python open Subtitle Edit go to menu "Video" and open a video or audio file (Urdu spoken) then also in the Video menu click “Audio to Text (Whisper)”, for Engine select “Purfview’s Faster-Whisper” - you will be prompted to download - click OK, after that for Choose Model select “large-v3 (3.1 GB)”, click OK to download. For Choose language, select Urdu, make sure that “Auto adjust timings” is marked. Click Generate. It will take some 2 to 2.5 minutes for every minute of video to get the Urdu transcription and the subtitles. Make sure that before you generate the subtitles in the “Options - Settings” menu specify the max length and max number of lines. This will save you an awful lot of time because the Purfview’s Faster-Whisper engine will give you an almost perfect sync of the subtitles. Check the transcription for errors and correct them. Only now go to “Autotranslate - autotranslate” and select translate from Urdu to English (or any other language). Click Translate and click OK. Mind you that this is a Google translation which is not perfect so you’ll have to make corrections. Good luck!
@@yosefk2864 thanks a lott
Shalom. How can i add the Hebrew language to the Auto to text model? I want to use it on an Hebrew voice video and add subtitles translated to English Thanks
I advise you to update to the latest version of Subtitle Edit: 4.0.3. so you can use the Whisper engine instead of the Vosk engine. Also you’ll have to download and install Python on our PC. Download from here: www.python.org/downloads/windows/ scroll down to Python 3.10.11 download windows installer (64-bit) or 32 according to your Windows bit-version. When installing Python make sure that “use admin privileges…” and add python.exe to PATH” are marked! Probably also the latest version of Python will work, but this is the version I use and it works. After installing Python open Subtitle Edit go to menu Video and open a video or audio file (Hebrew spoken) then also in the Video menu click Audio to Text (Whisper), for Engine select Purfview’s Faster-Whisper - you will be prompted to download - click OK, after that for Choose Model select large-v3 (3.1 GB), click OK to download. For Choose language, select Hebrew, make sure that Auto adjust timings is marked. Click Generate. It will take some 2 to 2.5 minutes for every minute of video to get the Hebrew transcription and the subtitles. This works great. Make sure that before you generate the subtitles in the Options - Settings menu to specify the max length and max number of lines. This will save you an awful lot of time because the Purfview’s Faster-Whisper engine will give you an almost perfect transcription of the Hebrew (and English and Dutch that I use myself) and an almost perfect sync of the subtitles. Only now go to Autotranslate - autotranslate and select translate from Hebrew to English. Click Translate and click OK. Mind you that this is a Google translation which is not perfect so you’ll have to make corrections. beHatzlacha!
Thank you so much!!! ❤🧡💛💚💙💜🤎🖤🤍
I tried to follow this guide, step by step, watched multiple times, but this method seems to no longer work. I don't understand why OpenShot makes it so difficult to simply slow a video by 30%. HitFilm Express literally lets you just grab the clip and stretch it to the exact duration you need, but HitFilm is no longer free to use. I am deeply disappointed today.
is this english if yes - where u speak this, i found thi unique
Free Palestine
Thank you so much, Yosef, for sharing this information. I have tried several options, but none worked like this one.
Thank you, Thank you, Thank you, Thank you, Thank you, Thank you, Thank you, Thank you, Thank you, Thank you, Thank you,
Great work. Thank you
Good video thanks
I appreciate the video, but I could not do this to slow down the video (for a specific exact amount). It just played as normal and put the end frame as a still for the remaining extended time. EDIT: I successfully 'bodged it' I think - I wanted it slowed by a factor of 0.72. I used the 'automatic' function to slow by 0.5 and then used your trick to speed it up slightly to 0.72. Looks like THAT worked it - Thank you
thank you! this is the only way I am passing.
Thanks for letting me know that this has been usefull to you. Have a great and successful 2024!
Well done, a year later and your efforts are still helping us. Thank you.
thanks.. bro...
Hello, until today I haven't been able to transcribe the Hindi language, but French works perfectly. thank you kindly
Thank you!!!