Learn how to download YouTube videos to your computer, iPhone, or Android with YouTube Premium. Includes plan comparison, offline download limits, and how to manage downloads.

How to Download YouTube Videos for Offline Viewing

⬇️ How to Download YouTube Video

Introduction

What you get with YouTube Premium

YouTube Premium plans

Try it free

Manage membership

Download YouTube video on Laptop or PC

Download YouTube video on phone

Download YouTube music

Wrap up

In this step-by-step tutorial, learn how to Download YouTube videos on your laptop, PC, iPhone or Android phone. This is completely legal and officially offered by YouTube and it's by far the easiest way to download videos, but it does cost some money. We check out what you get with a Premium membership to see if it's even worthwhile and how you can use it to download videos and music.

⌚ TIMESTAMPS
0:00 Introduction
0:50 What you get with YouTube Premium
3:21 YouTube Premium plans
4:33 Try it free
5:14 Manage membership
5:45 Download YouTube video on Laptop or PC
7:08 Download YouTube video on phone
7:54 Download YouTube music
8:26 Wrap up
 
📺 RELATED VIDEOS
- Playlist with all my videos on YouTube: https://youtube.com/playlist?list=PLlKpQrBME6xKCAJlzTSWm7I20cJcNzCCC 

📩 NEWSLETTER
- Get the latest high-quality tutorial and tips and tricks videos emailed to your inbox each week: https://kevinstratvert.com/newsletter/

🙌 SUPPORT THE CHANNEL
- Hit the THANKS button in any video!
- Amazon affiliate link: https://amzn.to/3kCP2yz (Purchasing through this link gives me a small commission to support videos on this channel -- the price to you is the same)

🔽 CONNECT WITH ME
- Official web site: http://www.kevinstratvert.com
- LinkedIn: https://www.linkedin.com/in/kevinstratvert/
- Discord: https://bit.ly/KevinStratvertDiscord
- Twitter: https://twitter.com/kevstrat
- Facebook: https://www.facebook.com/Kevin-Stratvert-101912218227818
- TikTok: https://www.tiktok.com/@kevinstratvert
- Instagram: https://www.instagram.com/kevinstratvert/

🎁 TOOLS AND DISCOUNTS
✅ 🎙️ Voicemod AI Voice Changer | 5% off | https://link.xsolla.com/KZBi89AY
✅ 🌐 Squarespace Websites | https://squarespace.syuh.net/XYaqYM
✅ 🔍 Grammarly | https://grammarly.go2cloud.org/SH3nL
✅ 🛍️ Shopify | https://shopify.pxf.io/XY9rPa
✅ 📋 Notion | https://affiliate.notion.so/rffva4tr71ax
✅ 🖼️ Figma | https://psxid.figma.com/lqjg97licpry
✅ 🤖 ElevenLabs Text-to-Speech | https://try.elevenlabs.io/taqepq60mptr

🎒 MY COURSES
- Excel for Beginners in under 2 hours: https://kevinstratvert.thinkific.com/

🙏 REQUEST VIDEOS
https://forms.gle/BDrTNUoxheEoMLGt5

🔔 SUBSCRIBE ON YOUTUBE
https://www.youtube.com/user/kevlers?sub_confirmation=1

⚖ DISCLOSURE
Some links are affiliate links. Purchasing through these links gives me a small commission to support videos on this channel. The price to you is the same.

#stratvert #youtube

Learn how to watch movies for free using legal, ad-supported streaming services. Get quick navigation tips for YouTube Movies, Tubi, Vudu, Freevee, and more.

7 Free & Legal Streaming Sites (With Tips to Find Movies)

🎦 How to Watch Movies for FREE

YouTube Movies

Tubi

Vudu

Freevee

Roku Channel

Peacock

Pluto TV

Find out how to watch movies legally & for free. Of course, since these sites are free, you'll have to trade some of your time to watch an occasional ad, although you'll see far fewer ads than you would see on TV. Also, you may not find every movie that you're looking for, but you'll likely find some high-quality movies that you haven't seen yet.

📚 RESOURCES
- YouTube Movies: https://www.youtube.com/feed/storefront
- Tubi: https://tubitv.com/
- Vudu by Fandango: https://www.vudu.com/
- Freevee (previously known as Amazon's IMDb TV): https://www.amazon.com/gp/video/storefront/ref=atv_hm_hom_1_c_JTXu6q_3?contentType=subscription&contentId=freewithads&benefitId=freewithads
- Roku Channel: https://therokuchannel.roku.com/
- Peacock: https://www.peacocktv.com/
- Pluto TV: https://pluto.tv/

⌚ TIMESTAMPS
0:00 Introduction
0:26 YouTube Movies
1:10 Tubi
1:49 Vudu
2:40 Freevee
3:21 Roku Channel
3:53 Peacock
4:39 Pluto TV
5:22 Wrap up
 
📺 RELATED VIDEOS
- Playlist with all my videos on Best FREE Sites: https://youtube.com/playlist?list=PLlKpQrBME6xLMjZjlDSrFx_9Xxag-kxtT 

📩 NEWSLETTER
- Get the latest high-quality tutorial and tips and tricks videos emailed to your inbox each week: https://kevinstratvert.com/newsletter/

🙌 SUPPORT THE CHANNEL
- Hit the THANKS button in any video!
- Amazon affiliate link: https://amzn.to/3kCP2yz (Purchasing through this link gives me a small commission to support videos on this channel -- the price to you is the same)

🔽 CONNECT WITH ME
- Official web site: http://www.kevinstratvert.com
- LinkedIn: https://www.linkedin.com/in/kevinstratvert/
- Discord: https://bit.ly/KevinStratvertDiscord
- Twitter: https://twitter.com/kevstrat
- Facebook: https://www.facebook.com/Kevin-Stratvert-101912218227818
- TikTok: https://www.tiktok.com/@kevinstratvert
- Instagram: https://www.instagram.com/kevinstratvert/

🎁 TOOLS AND DISCOUNTS
✅ 🎙️ Voicemod AI Voice Changer | 5% off | https://bit.ly/voicemodaivoice
✅ 🌐 Squarespace Websites | https://bit.ly/getsquarespacewebsite
✅ 🔍 Grammarly | https://bit.ly/getgrammarlyai
✅ 🛍️ Shopify | https://shopify.pxf.io/XY9rPa
✅ 📋 Notion | https://affiliate.notion.so/rffva4tr71ax
✅ 🖼️ Figma | https://psxid.figma.com/lqjg97licpry
✅ 🤖 ElevenLabs Text-to-Speech | https://try.elevenlabs.io/taqepq60mptr

🎒 MY COURSES
- Excel for Beginners in under 2 hours: https://kevinstratvert.thinkific.com/

🙏 REQUEST VIDEOS
https://forms.gle/BDrTNUoxheEoMLGt5

🔔 SUBSCRIBE ON YOUTUBE
https://www.youtube.com/user/kevlers?sub_confirmation=1

⚖ DISCLOSURE
Some links are affiliate links. Purchasing through these links gives me a small commission to support videos on this channel. The price to you is the same.

#stratvert #freemovies

Learn SQL basics for reporting and analysis. This beginner-friendly tutorial shows how to select, filter, combine, sort, and summarize data using SQL Server and SSMS with a sample database.

SQL for Beginners: Query Data with SQL Server

SQL Tutorial for Beginners

Why learn SQL?

What is SQL?

What is a database?

Relational database management systems

Install Microsoft SQL Server

Install SQL Server Management Studio

Connect to server

Object Explorer

Restore sample database

Tables

Primary keys

Database diagrams

Data types

Select

Filtering with where

Inner join & outer join

Order by

Functions including getdate, sum, count

Group by

Bonus: Query designer

In this step-by-step tutorial, learn how you can write your own SQL queries. You don't need any prior knowledge and we're going to use all free tools. By the end of this video, you'll know how to retrieve data from databases. At the end, I'll show you a neat trick to write some of the most complex queries with very little effort.

SQL stands for structured query language. It's a language that you can use to talk to your database. You can also use it to retrieve, filter, sort, combine, add, update, and delete data in a database. It's basically a language you can use to interact with the database. The great thing is that anyone can learn how to write SQL queries. You definitely don't need a degree in computer science. And once you know it, you'll have another superpower that you can use at work.

👋 Additional resources
- Download & install Microsoft SQL Server: https://www.microsoft.com/en-us/sql-server/sql-server-downloads
- Download & install SQL Server Management Studio (SSMS): https://docs.microsoft.com/en-us/sql/ssms/download-sql-server-management-studio-ssms?redirectedfrom=MSDN&view=sql-server-ver15
- Sample database to follow along: https://1drv.ms/u/s!AmxrofZZlZ-whNsNYa3M9O0USq1WhQ?e=r06ifZ
- Sample data in Excel format including flat file and tables: https://1drv.ms/x/s!AmxrofZZlZ-whNsGOcpx-aZS1RN2yA?e=My4Otp
- SQL Functions: https://docs.microsoft.com/en-us/sql/t-sql/functions/functions?view=sql-server-ver15

⌚ Timestamps
00:00 Introduction
00:37 Why learn SQL?
01:49 What is SQL?
02:25 What is a database?
03:09 Relational database management systems
04:11 Install Microsoft SQL Server
06:51 Install SQL Server Management Studio
07:26 Connect to server
08:13 Object Explorer
09:26 Restore sample database
10:42 Tables
14:33 Primary keys
15:57 Database diagrams
17:57 Data types
18:30 Select
24:50 Filtering with where
32:02 Inner join & outer join
38:21 Order by
39:01 Functions including getdate, sum, count
41:02 Group by
41:20 Bonus: Query designer 
44:09 Wrap up

📃 Watch related playlists
- Playlist with all my videos on SQL: https://youtube.com/playlist?list=PLlKpQrBME6xLJxrKUNTty3Ne8j_B0QYUT

📩 NEWSLETTER
- Get the latest high-quality tutorial and tips and tricks videos emailed to your inbox each week: https://kevinstratvert.com/newsletter/

🔽 CONNECT WITH ME
- Official website: http://www.kevinstratvert.com
- LinkedIn: https://www.linkedin.com/in/kevinstratvert/
- Discord: https://bit.ly/KevinStratvertDiscord
- Twitter: https://twitter.com/kevstrat
- Facebook: https://www.facebook.com/Kevin-Stratvert-101912218227818
- TikTok: https://www.tiktok.com/@kevinstratvert
- Instagram: https://www.instagram.com/kevinstratvert/

🎁 TOOLS AND DISCOUNTS
✅ 🎙️ Voicemod AI Voice Changer | 5% off | https://link.xsolla.com/KZBi89AY
✅ 🌐 Squarespace Websites | https://squarespace.syuh.net/XYaqYM
✅ 🔍 Grammarly | https://grammarly.go2cloud.org/SH3nL
✅ 🛍️ Shopify | https://shopify.pxf.io/XY9rPa
✅ 📋 Notion | https://affiliate.notion.so/rffva4tr71ax
✅ 🖼️ Figma | https://psxid.figma.com/lqjg97licpry
✅ 🤖 ElevenLabs Text-to-Speech | https://try.elevenlabs.io/taqepq60mptr

🎒 MY COURSES
- Go from Excel novice to data analysis ninja in just 2 hours: https://kevinstratvert.thinkific.com/

🙏 REQUEST VIDEOS
https://forms.gle/BDrTNUoxheEoMLGt5

🔔 SUBSCRIBE ON YOUTUBE
https://www.youtube.com/user/kevlers?sub_confirmation=1

🙌 SUPPORT THE CHANNEL
- Hit the THANKS button in any video!
- Amazon affiliate link: https://amzn.to/3kCP2yz

⚖ DISCLOSURE
Some links are affiliate links. Purchasing through these links gives me a small commission to support videos on this channel. The price to you is the same.

#stratvert #sql

Learn how to build an interactive Excel dashboard using built-in tools like Excel tables, PivotTables, PivotCharts, slicers, and a timeline—so your dashboard updates instantly when new data arrives.

Interactive Excel Dashboard Without VBA: PivotTables & Slicers

📊 How to Build Excel Interactive Dashboards

Background on dashboard

Overview of data

Create table

Insert pivot tables

Pivot table 1

Pivot table 2

Pivot table 3

Align objects

Set chart height and width

Add timeline & slicers

Connect slicers to all pivot charts

Using slicers to filter

Add new data & refresh dashboard

Adjust view to look less like Excel

Customize theme

Share dashboard

In this step-by-step tutorial, learn how to create dynamic and interactive Excel dashboards. With a dashboard, you can showcase the most important information and key performance indicators (KPIs) that your organization cares about. All you need is Microsoft Excel -- there's no need for any VBA or add-ons. When you receive new data, you can easily update your dashboard to reflect the latest. You can adjust the look and feel using various themes and you can even customize the dashboard to match your organization's color scheme. Once you finish, you can share out your dashboard easily for others to consume. If you'd like to follow along, you'll find the sample sheet that I used below.

📚 RESOURCES
- Sample spreadsheet to follow along: https://1drv.ms/x/s!AmxrofZZlZ-whMgx8bXq-2uARjf45Q?e=VU4CPy
- Introduction to Pivot Tables video: https://youtu.be/m0wI61ahfLc
- Advanced Pivot Tables video: https://youtu.be/3g1CSG5zvQ0

⌚ TIMESTAMPS
00:00 Introduction
00:52 Background on dashboard
01:25 Overview of data
02:15 Create table
02:55 Insert pivot tables
04:10 Pivot table 1
08:43 Pivot table 2
10:00 Pivot table 3
11:57 Align objects
12:31 Set chart height and width
12:50 Add timeline & slicers
14:42 Connect slicers to all pivot charts
15:47 Using slicers to filter
16:02 Add new data & refresh dashboard
17:13 Adjust view to look less like Excel
17:58 Customize theme
18:28 Share dashboard
18:54 Wrap up
 
📺 RELATED VIDEOS
- Playlist with all my videos on Excel: https://youtube.com/playlist?list=PLlKpQrBME6xLYoubjOqowzcCCd0ivQVLY

📩 NEWSLETTER
- Get the latest high-quality tutorial and tips and tricks videos emailed to your inbox each week: https://kevinstratvert.com/newsletter/

🔽 CONNECT WITH ME
- Official website: http://www.kevinstratvert.com
- LinkedIn: https://www.linkedin.com/in/kevinstratvert/
- Discord: https://bit.ly/KevinStratvertDiscord
- Twitter: https://twitter.com/kevstrat
- Facebook: https://www.facebook.com/Kevin-Stratvert-101912218227818
- TikTok: https://www.tiktok.com/@kevinstratvert
- Instagram: https://www.instagram.com/kevinstratvert/

🎁 PARTNERS & DISCOUNTED OFFERS
💻 Hostinger | https://hostinger.kevinstratvert.com
📋 Notion | https://notion.kevinstratvert.com
💵 Quickbooks Online | https://qbo.kevinstratvert.com
🎙️ Voicemod AI Voice Changer | https://voicemod.kevinstratvert.com
🕵️ VidIQ | http://vidiq.kevinstratvert.com 

🎒 MY COURSES
- Go from Excel novice to data analysis ninja in just 2 hours: https://kevinstratvert.thinkific.com/

🙏 REQUEST VIDEOS
https://forms.gle/BDrTNUoxheEoMLGt5

🔔 SUBSCRIBE ON YOUTUBE
https://www.youtube.com/user/kevlers?sub_confirmation=1

🙌 SUPPORT THE CHANNEL
- Hit the THANKS button in any video!
- Amazon affiliate link: https://amzn.to/3kCP2yz

⚖ DISCLOSURE
Some links are affiliate links. Purchasing through these links gives me a small commission to support videos on this channel. The price to you is the same.

#stratvert

Explore five top free video editing software options, including Windows 10 Video Editor and OpenShot. Learn key features, workflows, and limitations to find the right editor for your needs.

Best Free Video Editors: Windows Video Editor, OpenShot & More

🎬 5 BEST FREE Video Editing Software

Windows 10 Free Video Editor

OpenShot Video Editor

ShotCut Video Editor

Kdenlive Video Editor

DaVinci Resolve

Other noteworthy mentions

In this step-by-step tutorial, learn about the best 5 free video editors.

First, I show you how to use a video editor that comes for free with Windows 10. The Windows 10 free video editor is a basic editor that can produce nice videos. However, there are some drawbacks.

Next, we look at the OpenShot video editor. OpenShot is easy to use, quick to learn, and a surprisingly powerful video editor. Next, we review ShotCut video editor. Shotcut is a free, open source, cross-platform video editor for Windows, Mac and Linux.

We then look at Kdenlive, another free and open-source video editor that's easy to use.

Lastly, we look at the video editor that I personally use, DaVinci Resolve 17. DaVinci Resolve is divided into "pages," each of which gives you a dedicated workspace and tools for a specific task. Editing is done on the cut and edit pages, visual effects and motion graphics on the Fusion page, color correction on the color page, audio on the Fairlight page, and media organization and output on the media and deliver pages.

At the end, we also take a quick look at a few other noteworthy mentions, including VSDC Video Editor, HitFilm Express, and VideoPad.

📚 LINKS TO VIDEO EDITING SOFTWARE
- OpenShot: https://www.openshot.org/
- ShotCut: https://www.shotcut.org/
- Kdenlive: https://kdenlive.org/en/
- DaVinci Resolve: https://www.blackmagicdesign.com/products/davinciresolve/
- VSDC Editor: http://www.videosoftdev.com/
- HitFilm Express: https://fxhome.com/product/hitfilm-express
- VideoPad: https://www.nchsoftware.com/videopad/index.html

🏫 TUTORIALS ON VIDEO EDITING SOFTWARE
- Windows 10 Free Video Editor: https://youtu.be/t6yQwLuoO3w
- OpenShot: https://youtu.be/rLWXlc1BW-I
- Shotcut: https://youtu.be/PCMcyYAtRzw
- DaVinci Resolve: https://youtu.be/UguJiz9AYM8

⌚ TIMESTAMPS
00:00 Introduction
00:49 Windows 10 Free Video Editor
03:54 OpenShot Video Editor
06:10 ShotCut Video Editor
08:46 Kdenlive Video Editor
11:21 DaVinci Resolve
14:58 Other noteworthy mentions
16:02 Wrap up
 
📺 RELATED VIDEOS
- Playlist with all my videos on Video Editing: https://youtube.com/playlist?list=PLlKpQrBME6xLya9ITLp53bfo4SBn0g-Au

📩 NEWSLETTER
- Get the latest high-quality tutorial and tips and tricks videos emailed to your inbox each week: https://kevinstratvert.com/newsletter/

🔽 CONNECT WITH ME
- Official web site: http://www.kevinstratvert.com
- LinkedIn: https://www.linkedin.com/in/kevinstratvert/
- Discord: https://discord.gg/kHuujY2pZf
- Twitter: https://twitter.com/kevstrat
- Facebook: https://www.facebook.com/Kevin-Stratvert-101912218227818
- TikTok: https://www.tiktok.com/@kevinstratvert
- Instagram: https://www.instagram.com/kevinstratvert/

🎒 MY COURSES
- Excel for Beginners in under 2 hours: https://kevinstratvert.thinkific.com/

🙏 REQUEST VIDEOS
https://forms.gle/BDrTNUoxheEoMLGt5

🔔 SUBSCRIBE ON YOUTUBE
https://www.youtube.com/user/kevlers?sub_confirmation=1

#stratvert

Learn how to use Audacity to record voice, choose sample rate and audio devices, fix levels, rearrange clips, apply effects, and export your finished audio project.

Audacity Beginner Tutorial: Record, Edit, and Export Audio

🔊 How to use Audacity to Record & Edit Audio | Beginners Tutorial

Download Audacity

Main interface

Project rate / Sample rate

MME, Windows DirectSound & WASAPI audio drivers

Set microphone & playback device

Set & monitor recording levels

Record audio

Playback & selection tools

Zoom tool

Import audio

Save project

Adjust gain

Mute & solo tracks

Delete audio segments

Envelope tool

Amplify effect

Time shift tool

Insert silence

Split clips

Copy, paste & cut

Auto duck effect

Fade effect

Remove background noise

Compressor

Preview finished commercial

Distribute audio as wav, mp3 or other types

In this step-by-step tutorial, learn how to record and edit audio using Audacity. Audacity is free and open source and works across platforms, including Windows, Mac, and Linux.

📚 RESOURCES
- Download Audacity: https://www.audacityteam.org/

⌚ TIMESTAMPS
00:00 Introduction
00:51 Download Audacity
01:21 Main interface
01:51 Project rate / Sample rate
03:34 MME, Windows DirectSound & WASAPI audio drivers
04:12 Set microphone & playback device
05:20 Set & monitor recording levels
08:42 Record audio
10:59 Playback & selection tools
14:52 Zoom tool
16:43 Import audio
17:31 Save project
18:48 Adjust gain
19:58 Mute & solo tracks
20:41 Delete audio segments
22:34 Envelope tool
24:06 Amplify effect
25:37 Time shift tool
26:59 Insert silence
27:45 Split clips
28:12 Copy, paste & cut
29:08 Auto duck effect
31:41 Fade effect
32:33 Remove background noise
34:00 Compressor
35:36 Preview finished commercial
36:09 Distribute audio as wav, mp3 or other types
37:47 Wrap up 

📺 RELATED VIDEOS
- Playlist with all my videos on Audacity: https://youtube.com/playlist?list=PLlKpQrBME6xKm9iJlVHWbJd_xAvtAQy6W

📩 NEWSLETTER
- Get the latest high-quality tutorial and tips and tricks videos emailed to your inbox each week: https://kevinstratvert.com/newsletter/

🔽 CONNECT WITH ME
- Official website: http://www.kevinstratvert.com
- LinkedIn: https://www.linkedin.com/in/kevinstratvert/
- Discord: https://bit.ly/KevinStratvertDiscord
- Twitter: https://twitter.com/kevstrat
- Facebook: https://www.facebook.com/Kevin-Stratvert-101912218227818
- TikTok: https://www.tiktok.com/@kevinstratvert
- Instagram: https://www.instagram.com/kevinstratvert/

🎁 TOOLS AND DISCOUNTS
✅ 🎙️ Voicemod AI Voice Changer | 5% off | https://link.xsolla.com/KZBi89AY
✅ 🌐 Squarespace Websites | https://squarespace.syuh.net/XYaqYM
✅ 🔍 Grammarly | https://grammarly.go2cloud.org/SH3nL
✅ 🛍️ Shopify | https://shopify.pxf.io/XY9rPa
✅ 📋 Notion | https://affiliate.notion.so/rffva4tr71ax
✅ 🖼️ Figma | https://psxid.figma.com/lqjg97licpry
✅ 🤖 ElevenLabs Text-to-Speech | https://try.elevenlabs.io/taqepq60mptr

🎒 MY COURSES
- Go from Excel novice to data analysis ninja in just 2 hours: https://kevinstratvert.thinkific.com/

🙏 REQUEST VIDEOS
https://forms.gle/BDrTNUoxheEoMLGt5

🔔 SUBSCRIBE ON YOUTUBE
https://www.youtube.com/user/kevlers?sub_confirmation=1

🙌 SUPPORT THE CHANNEL
- Hit the THANKS button in any video!
- Amazon affiliate link: https://amzn.to/3kCP2yz

⚖ DISCLOSURE
Some links are affiliate links. Purchasing through these links gives me a small commission to support videos on this channel. The price to you is the same.

#stratvert

Learn Python from scratch with a step-by-step tutorial: install Python, run code in the terminal, use print(), and save your first .py file using Notepad.

Python for Beginners: Install, Run Code, and Create Your First Script

👩‍💻 Python for Beginners Tutorial

Why program?

Why Python?

Get Python

Run code in Python terminal

Write code in a text editor like Notepad

Get an IDE like Visual Studio Code for free

Set up VS Code

Run code in VS Code

Work with numbers & operators

Work with text / strings

Comments

Variables

Conditional logic

If, elif, & else statements

Functions

While & for loops

Import libraries

Troubleshooting code.

In this step-by-step Python for beginner's tutorial, learn how you can get started programming in Python. In this video, I assume that you are completely new to programming. We'll walk through how to get Python, how to run your first code, and how to get an IDE (Integrated Development Environment) to help you code faster. You'll also learn about variables and how to set them. We'll look at functions, if statements, while and for loops, and we'll import libraries. At the end, we'll also look at how you can troubleshoot your code, for instance, when you run into syntax, semantic, or runtime errors. By the end, you'll know how to run code and you'll also understand the basic concepts of programming. My name is Kevin Stratvert and I'll be your guide to Python. I previously worked at Microsoft for 14 years.

📚 RESOURCES
- Get Python: https://www.python.org
- Get Microsoft Visual Studio Code: https://code.visualstudio.com

⌚ TIMESTAMPS
0:00:00 Introduction
0:01:25 Why program?
0:02:18 Why Python?
0:04:33 Get Python
0:06:43 Run code in Python terminal
0:09:13 Write code in a text editor like Notepad
0:11:59 Get an IDE like Visual Studio Code for free
0:14:20 Set up VS Code
0:16:34 Run code in VS Code
0:18:12 Work with numbers & operators
0:22:24 Work with text / strings
0:24:03 Comments
0:25:37 Variables
0:32:01 Conditional logic
0:34:55 If, elif, & else statements
0:41:14 Functions
0:54:39 While & for loops
0:59:00 Import libraries
1:00:02 Troubleshooting code.  
1:02:28 Wrap up
   
📺 RELATED VIDEOS
- Playlist with all my videos on Python: https://youtube.com/playlist?list=PLlKpQrBME6xKNfcbz2nHyY_anC8BpXRnp

🙌 SUPPORT THE CHANNEL
- Hit the THANKS button in any video!
- Amazon affiliate link: https://amzn.to/3kCP2yz (Purchasing through this link gives me a small commission to support videos on this channel -- the price to you is the same)

🔽 CONNECT WITH ME
- Official web site: http://www.kevinstratvert.com
- LinkedIn: https://www.linkedin.com/in/kevinstratvert/
- Discord: https://discord.gg/kHuujY2pZf
- Twitter: https://twitter.com/kevstrat
- Facebook: https://www.facebook.com/Kevin-Stratvert-101912218227818
- TikTok: https://www.tiktok.com/@kevinstratvert
- Instagram: https://www.instagram.com/kevinstratvert/

🎁 TOOLS AND DISCOUNTS
✅ 🎙️ Voicemod AI Voice Changer | 5% off | https://link.xsolla.com/KZBi89AY
✅ 🌐 Squarespace Websites | https://squarespace.syuh.net/XYaqYM
✅ 🔍 Grammarly | https://grammarly.go2cloud.org/SH3nL
✅ 🛍️ Shopify | https://shopify.pxf.io/XY9rPa
✅ 📋 Notion | https://affiliate.notion.so/rffva4tr71ax
✅ 🖼️ Figma | https://psxid.figma.com/lqjg97licpry
✅ 🤖 ElevenLabs Text-to-Speech | https://try.elevenlabs.io/taqepq60mptr

🎒 MY COURSES
- Excel for Beginners in under 2 hours: https://kevinstratvert.thinkific.com/

🙏 REQUEST VIDEOS
https://forms.gle/BDrTNUoxheEoMLGt5

🔔 SUBSCRIBE ON YOUTUBE
https://www.youtube.com/user/kevlers?sub_confirmation=1

⚖ DISCLOSURE
Some links are affiliate links. Purchasing through these links gives me a small commission to support videos on this channel. The price to you is the same.

#stratvert #python #pythonprogramming

Learn how to use Microsoft Access from scratch to create an order tracking database, including customers and orders tables, relationships, queries, forms, and printable reports.

Beginner Guide to Building an Access Order Tracking Database

How to use Microsoft Access - Beginner Tutorial

Advantages of a database over Excel

Access alternatives

Overview of tutorial structure

Access start page

Create blank database

Tables, fields & records

Calculated field & expression builder

Sample order data

Opening & closing windows

Relationships

Import data sources

Forms

Queries

Reports

Save Database

In this step-by-step tutorial, learn how to use Microsoft Access. We walk what Access is for, why you should use it over a spreadsheet, how to create tables, how to add a form, how to run SQL queries, and how to create a report. By the end of this video, you'll understand the fundamentals of working with databases in Access.

📚 RESOURCES
- Sample Access database: https://1drv.ms/u/s!AmxrofZZlZ-whKx-OHtH9VLpU4PdJw?e=0aRP1p

⌚ TIMESTAMPS
00:00 Introduction
01:01 Advantages of a database over Excel
02:36 Access alternatives
03:17 Overview of tutorial structure
04:10 Access start page
05:04 Create blank database
05:22 Tables, fields & records
14:36 Calculated field & expression builder
15:50 Sample order data
16:50 Opening & closing windows
17:16 Relationships
19:01 Import data sources
19:25 Forms
22:12 Queries
27:51 Reports
30:02 Save Database
30:25 Wrap up

📺 RELATED VIDEOS
- Playlist with all my videos on Access: https://youtube.com/playlist?list=PLlKpQrBME6xJ4Mxv00syl8iOSgL-GVLMG

🙌📩 NEWSLETTER
- Get the latest high-quality tutorial and tips and tricks videos emailed to your inbox each week: https://kevinstratvert.com/newsletter/

🔽 CONNECT WITH ME
- Official website: http://www.kevinstratvert.com
- LinkedIn: https://www.linkedin.com/in/kevinstratvert/
- Discord: https://bit.ly/KevinStratvertDiscord
- Twitter: https://twitter.com/kevstrat
- Facebook: https://www.facebook.com/Kevin-Stratvert-101912218227818
- TikTok: https://www.tiktok.com/@kevinstratvert
- Instagram: https://www.instagram.com/kevinstratvert/

🎁 TOOLS AND DISCOUNTS
✅ 🎙️ Voicemod AI Voice Changer | 5% off | https://link.xsolla.com/KZBi89AY
✅ 🌐 Squarespace Websites | https://squarespace.syuh.net/XYaqYM
✅ 🔍 Grammarly | https://grammarly.go2cloud.org/SH3nL
✅ 🛍️ Shopify | https://shopify.pxf.io/XY9rPa
✅ 📋 Notion | https://affiliate.notion.so/rffva4tr71ax
✅ 🖼️ Figma | https://psxid.figma.com/lqjg97licpry
✅ 🤖 ElevenLabs Text-to-Speech | https://try.elevenlabs.io/taqepq60mptr

🎒 MY COURSES
- Go from Excel novice to data analysis ninja in just 2 hours: https://kevinstratvert.thinkific.com/

🙏 REQUEST VIDEOS
https://forms.gle/BDrTNUoxheEoMLGt5

🔔 SUBSCRIBE ON YOUTUBE
https://www.youtube.com/user/kevlers?sub_confirmation=1

🙌 SUPPORT THE CHANNEL
- Hit the THANKS button in any video!
- Amazon affiliate link: https://amzn.to/3kCP2yz

⚖ DISCLOSURE
Some links are affiliate links. Purchasing through these links gives me a small commission to support videos on this channel. The price to you is the same.

#stratvert

Learn how to get started with Microsoft Teams quickly: sign in, choose desktop or web app, create a team with channels, and start conversations with replies and @mentions.

Microsoft Teams Tutorial for Beginners: Set Up in Minutes

🏫 Microsoft Teams Tutorial in 10 min

Sign up for Microsoft Teams

Sign in

Download desktop app

Navigation bar

Join or create team

Edit team settings

Channels

Posts & conversations

Organizing channels

Activity

Chat

Calendar & schedule meetings

Join meeting

Calls

Files

In this step-by-step tutorial in under 10 minutes, learn how you can use Microsoft Teams to meet, chat, and collaborate with others.

📚 RESOURCES
- Sign up for Microsoft Teams: https://www.microsoft.com/en-us/microsoft-365/microsoft-teams/group-chat-software
- Sign into Microsoft Teams: https://teams.microsoft.com

⌚ TIMESTAMPS
0:00 Introduction
0:24 Sign up for Microsoft Teams
0:42 Sign in
0:55 Download desktop app
1:28 Navigation bar
1:48 Join or create team
3:18 Edit team settings
3:34 Channels
3:57 Posts & conversations
5:55 Organizing channels
6:15 Activity
6:38 Chat
7:12 Calendar & schedule meetings
7:44 Join meeting
8:46 Calls
9:04 Files
9:15 Wrap up

📺 RELATED VIDEOS
- Playlist with all my Microsoft Teams videos: https://youtube.com/playlist?list=PLlKpQrBME6xJ4Mxv00syl8iOSgL-GVLMG

🙌 SUPPORT THE CHANNEL
- Hit the THANKS button in any video!
- Amazon affiliate link: https://amzn.to/3kCP2yz (Purchasing through this link gives me a small commission to support videos on this channel -- the price to you is the same)

🔽 CONNECT WITH ME
- Official web site: http://www.kevinstratvert.com
- LinkedIn: https://www.linkedin.com/in/kevinstratvert/
- Discord: https://discord.gg/kHuujY2pZf
- Twitter: https://twitter.com/kevstrat
- Facebook: https://www.facebook.com/Kevin-Stratvert-101912218227818
- TikTok: https://www.tiktok.com/@kevinstratvert
- Instagram: https://www.instagram.com/kevinstratvert/

🎒 MY COURSES
- Excel for Beginners in under 2 hours: https://kevinstratvert.thinkific.com/

🙏 REQUEST VIDEOS
https://forms.gle/BDrTNUoxheEoMLGt5

🔔 SUBSCRIBE ON YOUTUBE
https://www.youtube.com/user/kevlers?sub_confirmation=1

#stratvert #teams #microsoft

Discover 5 free screen recording tools that help you capture desktop or app activity without watermarks or restrictive limits, with practical tips for choosing the right option for your workflow.

Best Free Screen Recorders (No Watermarks, No Time Limits)

💻 5 Best FREE Screen Recorders - no watermarks or time limits

XBOX Game Bar

Zoom

Flashback Express

Apowersoft

OBS Studio

In this step-by-step tutorial, learn about the top 5 best free screen recorders. These screen recorders are free, show no watermarks, have no recording limits, and allow you to export at high quality levels. I personally use OBS as my screen recorder for all my YouTube videos.

📚 RESOURCES
- XBOX Game Bar: Comes pre-installed on Windows 10
- Zoom: http://www.zoom.us
- Flashback Recorder Express: https://www.flashbackrecorder.com/express/
- Apowersoft Free Online Screen Recorder: https://www.apowersoft.com/free-online-screen-recorder
- OBS (Open Broadcaster Software): http://www.Obsproject.com
- OBS Beginner's Tutorial: https://youtu.be/ySENWFIkL7c

⌚ TIMESTAMPS
00:00 Introduction
00:30 XBOX Game Bar
03:29 Zoom
05:41 Flashback Express
09:16 Apowersoft
11:32 OBS Studio
13:49 Wrap up

📺 RELATED VIDEOS
- My screen recording playlist: https://www.youtube.com/playlist?list=PLlKpQrBME6xLJaD0HEgfWfQ7dzoQS9be1

📩 NEWSLETTER
- Get the latest high-quality tutorial and tips and tricks videos emailed to your inbox each week: https://kevinstratvert.com/newsletter/

🔽 CONNECT WITH ME
- Official website: http://www.kevinstratvert.com
- LinkedIn: https://www.linkedin.com/in/kevinstratvert/
- Discord: https://bit.ly/KevinStratvertDiscord
- Twitter: https://twitter.com/kevstrat
- Facebook: https://www.facebook.com/Kevin-Stratvert-101912218227818
- TikTok: https://www.tiktok.com/@kevinstratvert
- Instagram: https://www.instagram.com/kevinstratvert/

🎁 TOOLS AND DISCOUNTS
✅ 🎙️ Voicemod AI Voice Changer | 5% off | https://link.xsolla.com/KZBi89AY
✅ 🌐 Squarespace Websites | https://squarespace.syuh.net/XYaqYM
✅ 🔍 Grammarly | https://grammarly.go2cloud.org/SH3nL
✅ 🛍️ Shopify | https://shopify.pxf.io/XY9rPa
✅ 📋 Notion | https://affiliate.notion.so/rffva4tr71ax
✅ 🖼️ Figma | https://psxid.figma.com/lqjg97licpry
✅ 🤖 ElevenLabs Text-to-Speech | https://try.elevenlabs.io/taqepq60mptr

🎒 MY COURSES
- Go from Excel novice to data analysis ninja in just 2 hours: https://kevinstratvert.thinkific.com/

🙏 REQUEST VIDEOS
https://forms.gle/BDrTNUoxheEoMLGt5

🔔 SUBSCRIBE ON YOUTUBE
https://www.youtube.com/user/kevlers?sub_confirmation=1

🙌 SUPPORT THE CHANNEL
- Hit the THANKS button in any video!
- Amazon affiliate link: https://amzn.to/3kCP2yz

⚖ DISCLOSURE
Some links are affiliate links. Purchasing through these links gives me a small commission to support videos on this channel. The price to you is the same.

#stratvert

Learn how to use Microsoft Power Query in Excel to combine multiple files from a folder, clean order data, calculate profit and shipping time, and refresh analysis when new data arrives—without writing code.

Power Query for Excel: Refresh Reports Without Coding

How to use Microsoft Power Query

Sample data

How to get Power Query

Get data

Combine data

Main Power Query interface

Transform data

Applied steps

Close & Load

Data imported into Excel

Insert pivot table & chart

Importing additional data

🔥 Learn Excel in just 2 hours: https://kevinstratvert.thinkific.com

In this step-by-step tutorial, learn how you can use Microsoft Power Query to get and clean up data in both Microsoft Excel and Microsoft Power BI. Power Query is the easiest way to connect, extract, transform and load data from a wide range of sources.

👋 Additional resources:
- Sample files: https://1drv.ms/u/s!AmxrofZZlZ-whKZQTEiA4iLu-WPiaQ?e=AkAtOi
- Download Power Query for Excel 2010 or 2013: https://www.microsoft.com/en-au/download/details.aspx?id=39379

⌚ Timestamps
00:00 Introduction
00:59 Sample data 
2:14 How to get Power Query
2:31 Get data
3:35 Combine data
5:26 Main Power Query interface
7:00 Transform data
11:21 Applied steps
12:06 Close & Load
12:33 Data imported into Excel
13:34 Insert pivot table & chart
14:46 Importing additional data
16:00 Wrap up

📃 Watch related playlists and videos
- Pivot Table tutorial: https://youtu.be/m0wI61ahfLc 
- Excel: https://www.youtube.com/playlist?list=PLlKpQrBME6xLYoubjOqowzcCCd0ivQVLY
- Power BI: https://www.youtube.com/playlist?list=PLlKpQrBME6xIAUqcPjFRPsMQJhgXdJVxe

🚩 Connect with me on social:
- LinkedIn: https://www.linkedin.com/in/kevinstratvert/
- Twitter: https://twitter.com/kevstrat
- Facebook: https://www.facebook.com/Kevin-Stratvert-101912218227818

🔔 Subscribe to my YouTube channel
https://www.youtube.com/user/kevlers?sub_confirmation=1

🎬 Want to watch again? Navigate back to my YouTube channel quickly
http://www.kevinstratvert.com

🛍 Support me with your Amazon purchases: https://amzn.to/3kCP2yz

⚖ As full disclosure, I use affiliate links above. Purchasing through these links gives me a small commission to support videos on this channel -- the price to you is the same.

Learn how to use Microsoft Power BI step by step—download Power BI Desktop, import and clean Excel data in Power Query, create visuals, and share an interactive report.

Power BI for Beginners: Build Your First Report

How to use Microsoft Power BI - Tutorial for Beginners

Download and install

Welcome screen

Sample data overview

Get data spreadsheet

Transform data from spreadsheet using Power Query Editor

Get data from web

In this step-by-step tutorial video, learn how to get started using Microsoft Power BI. Power BI allows you to get insight from your business data. This is an introductory overview of Power BI to get you started.

📚 RESOURCES
- Download Power BI here: https://powerbi.microsoft.com/en-us/desktop/
- Kevin Cookie Company Financial Spreadsheet: https://1drv.ms/x/s!AmxrofZZlZ-whJlAigx1zFltyTiC2g?e=e3YVTq
- Wikipedia link: https://en.wikipedia.org/wiki/List_of_countries_and_dependencies_by_population
- How to use Microsoft Power Automate: https://youtu.be/dDO4Y4aDYXw

⌚ TIMESTAMPS
00:00 Introduction
01:01 Download and install
03:00 Welcome screen
04:20 Sample data overview
06:00 Get data spreadsheet
07:40 Transform data from spreadsheet using Power Query Editor
10:10 Get data from web
11:25 Transform data from web using Power Query Editor
13:10 Join tables by merging queries
14:27 Overview of Power BI layout, including fields and visualizations
16:40 Insert title
17:20 Insert variety of visualizations
22:10 Insert slicer
23:30 Apply theme and change style
25:00 Save and Publish report
26:30 Share with others
27:05 Wrap up

📺 RELATED VIDEOS
- Playlist with all my videos on Power BI: https://www.youtube.com/playlist?list=PLlKpQrBME6xIAUqcPjFRPsMQJhgXdJVxe

📩 NEWSLETTER
- Get the latest high-quality tutorial and tips and tricks videos emailed to your inbox each week: https://kevinstratvert.com/newsletter/

🙌 SUPPORT THE CHANNEL
- Hit the THANKS button in any video!
- Amazon affiliate link: https://amzn.to/3kCP2yz (Purchasing through this link gives me a small commission to support videos on this channel -- the price to you is the same)

🔽 CONNECT WITH ME
- Official web site: http://www.kevinstratvert.com
- LinkedIn: https://www.linkedin.com/in/kevinstratvert/
- Discord: https://discord.gg/kHuujY2pZf
- Twitter: https://twitter.com/kevstrat
- Facebook: https://www.facebook.com/Kevin-Stratvert-101912218227818
- TikTok: https://www.tiktok.com/@kevinstratvert
- Instagram: https://www.instagram.com/kevinstratvert/

🎒 MY COURSES
- Excel for Beginners in under 2 hours: https://kevinstratvert.thinkific.com/

🙏 REQUEST VIDEOS
https://forms.gle/BDrTNUoxheEoMLGt5

🔔 SUBSCRIBE ON YOUTUBE
https://www.youtube.com/user/kevlers?sub_confirmation=1

#stratvert

Kevin Stratvert

Kevin Stratvert

Archive

Mobile Devices

⬇️ How to Download YouTube Video

Marketing & SEO

🎦 How to Watch Movies for FREE

Coding & App Building

SQL Tutorial for Beginners

Excel

📊 How to Build Excel Interactive Dashboards

Video Editing

🎬 5 BEST FREE Video Editing Software

Audio & Transcription

🔊 How to use Audacity to Record & Edit Audio | Beginners Tutorial

Coding & App Building

👩‍💻 Python for Beginners Tutorial

Microsoft 365

How to use Microsoft Access - Beginner Tutorial

Microsoft 365

🏫 Microsoft Teams Tutorial in 10 min

Screen Recording & Streaming

💻 5 Best FREE Screen Recorders - no watermarks or time limits

Automation

How to use Microsoft Power Query

Power BI

How to use Microsoft Power BI - Tutorial for Beginners

Kevin Stratvert