Kevin Stratvert
How to use Signal App - Beginner Tutorial
updated
π RESOURCES
- Full length video on YouTube Tips and Tricks: youtu.be/LicfHxvAlXI
πΊ RELATED VIDEOS
- Playlist with all my videos on YouTube: youtube.com/playlist?list=PLlKpQrBME6xKCAJlzTSWm7I20cJcNzCCC
- Playlist with all my quick tips: youtube.com/playlist?list=PLlKpQrBME6xL5J5ZUVIWP1MCGBq88yLCu
π© NEWSLETTER
- Get the latest high-quality tutorial and tips and tricks videos emailed to your inbox each week: kevinstratvert.com/newsletter
π½ CONNECT WITH ME
- Official web site: http://www.kevinstratvert.com
- LinkedIn: linkedin.com/in/kevinstratvert
- Discord: discord.gg/kHuujY2pZf
- Twitter: twitter.com/kevstrat
- Facebook: facebook.com/Kevin-Stratvert-101912218227818
- TikTok: tiktok.com/@kevinstratvert
- Instagram: instagram.com/kevinstratvert
π MY COURSES
- Excel for Beginners in under 2 hours: kevinstratvert.thinkific.com
π REQUEST VIDEOS
https://forms.gle/BDrTNUoxheEoMLGt5
π SUBSCRIBE ON YOUTUBE
youtube.com/user/kevlers?sub_confirmation=1
π SUPPORT THE CHANNEL
- Hit the THANKS button in any video!
- Amazon affiliate link: 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)
#stratvert #youtube
π RESOURCES
- clipchamp.com
β TIMESTAMPS
0:00 Introduction
0:52 Import media
1:50 Music & SFX
2:08 Add pictures to timeline
3:00 Add music to timeline
3:17 Adjust photos
3:57 Layers & collage
5:11 Filters
6:14 Transitions, Text & Motion Graphics
6:59 Export
7:29 Wrap up
πΊ RELATED VIDEOS
- Playlist with all my videos on Clipchamp: youtube.com/playlist?list=PLlKpQrBME6xJGEX3hk74EJsTHpXH3RiBZ
π© NEWSLETTER
- Get the latest high-quality tutorial and tips and tricks videos emailed to your inbox each week: kevinstratvert.com/newsletter
π½ CONNECT WITH ME
- Official web site: http://www.kevinstratvert.com
- LinkedIn: linkedin.com/in/kevinstratvert
- Discord: discord.gg/kHuujY2pZf
- Twitter: twitter.com/kevstrat
- Facebook: facebook.com/Kevin-Stratvert-101912218227818
- TikTok: tiktok.com/@kevinstratvert
- Instagram: instagram.com/kevinstratvert
π MY COURSES
- Excel for Beginners in under 2 hours: kevinstratvert.thinkific.com
π REQUEST VIDEOS
https://forms.gle/BDrTNUoxheEoMLGt5
π SUBSCRIBE ON YOUTUBE
youtube.com/user/kevlers?sub_confirmation=1
π SUPPORT THE CHANNEL
- Hit the THANKS button in any video!
- Amazon affiliate link: 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)
#stratvert #clipchamp
π RESOURCES
- My project file to follow along: usethis.video/kevins-intro
β TIMESTAMPS
00:00 Introduction
00:30 Get ClipChamp
00:44 Get project files
01:00 Log in to ClipChamp
01:26 Home screen & templates
01:58 Insert music & SFX
03:29 Adjust timeline view
04:05 Trim clips
05:15 Insert text
06:57 Split clips
07:34 Copy timeline objects
07:58 Adjust text timing
09:13 Text animations
10:51 Motion graphics
13:00 Stock video
14:55 Text to speech
16:21 Transitions
17:18 Export & share
17:51 Wrap up
πΊ RELATED VIDEOS
- Playlist with all my videos on ClipChamp: youtube.com/playlist?list=PLlKpQrBME6xJGEX3hk74EJsTHpXH3RiBZ
π© NEWSLETTER
- Get the latest high-quality tutorial and tips and tricks videos emailed to your inbox each week: kevinstratvert.com/newsletter
π½ CONNECT WITH ME
- Official web site: http://www.kevinstratvert.com
- LinkedIn: linkedin.com/in/kevinstratvert
- Discord: discord.gg/kHuujY2pZf
- Twitter: twitter.com/kevstrat
- Facebook: facebook.com/Kevin-Stratvert-101912218227818
- TikTok: tiktok.com/@kevinstratvert
- Instagram: instagram.com/kevinstratvert
π MY COURSES
- Excel for Beginners in under 2 hours: kevinstratvert.thinkific.com
π REQUEST VIDEOS
https://forms.gle/BDrTNUoxheEoMLGt5
π SUBSCRIBE ON YOUTUBE
youtube.com/user/kevlers?sub_confirmation=1
π SUPPORT THE CHANNEL
- Hit the THANKS button in any video!
- Amazon affiliate link: 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)
#stratvert #clipchamp #youtube
π RESOURCES
- Download Warzone 2: callofduty.com/warzone
- Python for Beginners Tutorial: youtu.be/b093aqAZiPU
β TIMESTAMPS
0:00 Introduction
0:11 Download and install
2:20 Launch game
2:49 Wrap up
πΊ RELATED VIDEOS
- Playlist with all my gaming videos: youtube.com/playlist?list=PLlKpQrBME6xIYlnj2TYvfPg-Na7THlAa_
π© NEWSLETTER
- Get the latest high-quality tutorial and tips and tricks videos emailed to your inbox each week: kevinstratvert.com/newsletter
π½ CONNECT WITH ME
- Official web site: http://www.kevinstratvert.com
- LinkedIn: linkedin.com/in/kevinstratvert
- Discord: discord.gg/kHuujY2pZf
- Twitter: twitter.com/kevstrat
- Facebook: facebook.com/Kevin-Stratvert-101912218227818
- TikTok: tiktok.com/@kevinstratvert
- Instagram: instagram.com/kevinstratvert
π MY COURSES
- Excel for Beginners in under 2 hours: kevinstratvert.thinkific.com
π REQUEST VIDEOS
https://forms.gle/BDrTNUoxheEoMLGt5
π SUBSCRIBE ON YOUTUBE
youtube.com/user/kevlers?sub_confirmation=1
π SUPPORT THE CHANNEL
- Hit the THANKS button in any video!
- Amazon affiliate link: 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)
#stratvert #warzone2 #callofduty #warzone
πΊ RELATED VIDEOS
- Playlist with all my videos on Microsoft Word: youtube.com/playlist?list=PLlKpQrBME6xJi-alBn-OFEAX79E3bZ_H4
- Playlist with all my quick tips: youtube.com/playlist?list=PLlKpQrBME6xL5J5ZUVIWP1MCGBq88yLCu
π© NEWSLETTER
- Get the latest high-quality tutorial and tips and tricks videos emailed to your inbox each week: kevinstratvert.com/newsletter
π½ CONNECT WITH ME
- Official web site: http://www.kevinstratvert.com
- LinkedIn: linkedin.com/in/kevinstratvert
- Discord: discord.gg/kHuujY2pZf
- Twitter: twitter.com/kevstrat
- Facebook: facebook.com/Kevin-Stratvert-101912218227818
- TikTok: tiktok.com/@kevinstratvert
- Instagram: instagram.com/kevinstratvert
π MY COURSES
- Excel for Beginners in under 2 hours: kevinstratvert.thinkific.com
π REQUEST VIDEOS
https://forms.gle/BDrTNUoxheEoMLGt5
π SUBSCRIBE ON YOUTUBE
youtube.com/user/kevlers?sub_confirmation=1
π SUPPORT THE CHANNEL
- Hit the THANKS button in any video!
- Amazon affiliate link: 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)
#stratvert
πΊ RELATED VIDEOS
- Playlist with all my videos on Word: youtube.com/playlist?list=PLlKpQrBME6xJi-alBn-OFEAX79E3bZ_H4
- Playlist with all my quick tips: youtube.com/playlist?list=PLlKpQrBME6xL5J5ZUVIWP1MCGBq88yLCu
π© NEWSLETTER
- Get the latest high-quality tutorial and tips and tricks videos emailed to your inbox each week: kevinstratvert.com/newsletter
π½ CONNECT WITH ME
- Official web site: http://www.kevinstratvert.com
- LinkedIn: linkedin.com/in/kevinstratvert
- Discord: discord.gg/kHuujY2pZf
- Twitter: twitter.com/kevstrat
- Facebook: facebook.com/Kevin-Stratvert-101912218227818
- TikTok: tiktok.com/@kevinstratvert
- Instagram: instagram.com/kevinstratvert
π MY COURSES
- Excel for Beginners in under 2 hours: kevinstratvert.thinkific.com
π REQUEST VIDEOS
https://forms.gle/BDrTNUoxheEoMLGt5
π SUBSCRIBE ON YOUTUBE
youtube.com/user/kevlers?sub_confirmation=1
π SUPPORT THE CHANNEL
- Hit the THANKS button in any video!
- Amazon affiliate link: 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)
#stratvert
π RESOURCES
- Power Virtual Agents: http://powervirtualagents.microsoft.com
- Try a Microsoft business/work account for 30-days: microsoft.com/en-us/microsoft-365/business/compare-all-microsoft-365-business-products
β TIMESTAMPS
00:00 Introduction
01:03 How to get Power Virtual Agents
02:15 Set up account
02:35 Main interface
03:22 Create chatbot
04:11 Navigate through chatbot
05:01 Test bot
05:31 Topics overview
06:39 Add new topic
07:19 Trigger phrases
08:00 Add message node
09:42 Add rich media
10:43 Authoring canvas tools
11:37 Navigate topics
11:55 Add question with multiple choices
15:30 Entities
16:16 Add question with entities
19:16 Call an action with Power Automate
25:24 Boolean questions with conditions
26:52 Send to another topic
28:09 Publish bot
29:08 Analytics
29:43 Wrap up
πΊ RELATED VIDEOS
- Playlist with all my videos on Power: youtube.com/playlist?list=PLlKpQrBME6xKl9Arm-rMRK9Dg89yDTJOW
π© NEWSLETTER
- Get the latest high-quality tutorial and tips and tricks videos emailed to your inbox each week: kevinstratvert.com/newsletter
π½ CONNECT WITH ME
- Official web site: http://www.kevinstratvert.com
- LinkedIn: linkedin.com/in/kevinstratvert
- Discord: discord.gg/kHuujY2pZf
- Twitter: twitter.com/kevstrat
- Facebook: facebook.com/Kevin-Stratvert-101912218227818
- TikTok: tiktok.com/@kevinstratvert
- Instagram: instagram.com/kevinstratvert
π MY COURSES
- Excel for Beginners in under 2 hours: kevinstratvert.thinkific.com
π REQUEST VIDEOS
https://forms.gle/BDrTNUoxheEoMLGt5
π SUBSCRIBE ON YOUTUBE
youtube.com/user/kevlers?sub_confirmation=1
π SUPPORT THE CHANNEL
- Hit the THANKS button in any video!
- Amazon affiliate link: 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)
#stratvert #powervirtualagents #microsoft
This video is sponsored by Google.
π« FREE TRAINING OFFERED BY GOOGLE
- Google Sheets Getting Started course: bit.ly/3UwekAu
- Google Sheets Advanced Topics course: bit.ly/3tpxDj2
- Google Sheets Functions, Formulas, and Charts course: bit.ly/3UNI9vV
π RESOURCES
- Google Sheets Start Page: http://sheets.google.com
- Google Sheets New Blank Spreadsheet: http://sheets.new/
- How to use Google Forms video: youtu.be/I4T-FGZo7zo
- Sample Workbook Used in Video: docs.google.com/spreadsheets/d/1cA5v_v6KBrz_2scR78HBgfKr7jBVxfizJKSHtwLxQOE/edit?usp=sharing
β TIMESTAMPS
00:00 Introduction
00:46 Official Google Sheets training
01:43 What is Google Sheets
02:24 How to get Google Sheets
03:30 Start page
04:30 Top bar
06:26 Cells, columns, & rows
07:30 Zoom level
07:46 Enter data & smart fill
10:04 Format numbers
11:01 Adjust column widths & row heights
12:24 Move columns & rows
12:57 Alternating colors
13:42 Conditional formatting
15:07 Hide columns & rows
15:57 Insert columns & rows
16:57 Freeze columns & rows
17:42 Column stats
19:01 Explore
19:54 Addition
21:52 Subtraction
22:13 Multiplication
22:35 Division
22:54 Functions
23:40 SUM function
25:53 Relative & absolute references
28:20 Named ranges
29:32 VLOOKUP function
31:57 Multiple worksheets
33:57 Sort & filter
35:30 Filter views
36:39 Charts
39:09 Pivot tables
42:49 Create a new form
44:23 Share & collaborate with others
47:24 Version history
48:02 Publish, email, & print
48:31 Wrap up
πΊ RELATED VIDEOS
- Playlist with all my videos on Google Products: youtube.com/playlist?list=PLlKpQrBME6xLGL3Ty_1Wbd3nTZ_q_OKFQ
π© NEWSLETTER
- Get the latest high-quality tutorial and tips and tricks videos emailed to your inbox each week: kevinstratvert.com/newsletter
π½ CONNECT WITH ME
- Official web site: http://www.kevinstratvert.com
- LinkedIn: linkedin.com/in/kevinstratvert
- Discord: discord.gg/kHuujY2pZf
- Twitter: twitter.com/kevstrat
- Facebook: facebook.com/Kevin-Stratvert-101912218227818
- TikTok: tiktok.com/@kevinstratvert
- Instagram: instagram.com/kevinstratvert
π REQUEST VIDEOS
https://forms.gle/BDrTNUoxheEoMLGt5
π SUBSCRIBE ON YOUTUBE
youtube.com/user/kevlers?sub_confirmation=1
π SUPPORT THE CHANNEL
- Hit the THANKS button in any video!
- Amazon affiliate link: 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)
#stratvert #googlesheets #googlecloudskillbadge #googlecloudskillsboost
π RESOURCES
- Surface Laptop 5 on Amazon: amzn.to/3heqPSk
- Surface Laptop 5 on Microsoft Store: bit.ly/3Uz9jXq
β TIMESTAMPS
0:00 Introduction
0:22 Unboxing
0:32 Exterior
0:49 Size and weight
1:18 Ports
2:30 Screen
3:18 Microphones
3:39 Dolby Vision IQ
3:55 Windows Hello
4:05 Webcam
4:20 Keyboard and trackpad
4:43 Intel Core i5 and i7 EVO processor
5:29 Intel Iris Xe Graphics
5:50 Memory and storage
6:08 Speakers
6:25 Windows 11
6:35 Wrap up
πΊ RELATED VIDEOS
- Playlist with all my videos on Microsoft Surface: youtube.com/playlist?list=PLlKpQrBME6xKKs-pCy2vN0GuZj-0rRP2J
π© NEWSLETTER
- Get the latest high-quality tutorial and tips and tricks videos emailed to your inbox each week: kevinstratvert.com/newsletter
π½ CONNECT WITH ME
- Official web site: http://www.kevinstratvert.com
- LinkedIn: linkedin.com/in/kevinstratvert
- Discord: discord.gg/kHuujY2pZf
- Twitter: twitter.com/kevstrat
- Facebook: facebook.com/Kevin-Stratvert-101912218227818
- TikTok: tiktok.com/@kevinstratvert
- Instagram: instagram.com/kevinstratvert
π MY COURSES
- Excel for Beginners in under 2 hours: kevinstratvert.thinkific.com
π REQUEST VIDEOS
https://forms.gle/BDrTNUoxheEoMLGt5
π SUBSCRIBE ON YOUTUBE
youtube.com/user/kevlers?sub_confirmation=1
π SUPPORT THE CHANNEL
- Hit the THANKS button in any video!
- Amazon affiliate link: 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)
#stratvert #microsoftsurface
Having worked at Microsoft and on Excel, we focus on the core functionality that most people use to make you productive as quickly as possible vs. digging into every single feature available. This way, youβll have a strong foundation to start getting insights from your data.
π’ BUILD A STRONG FOUNDATION
We start with the absolute basics. When you first open Excel, it may appear somewhat intimidating with so many different buttons and controls. It may even feel like the cockpit of a jet plane. To demystify Excel, we begin by walking through the interface and covering how you can easily get back to the controls that you use most often.
Next, we delve into how you can enter data efficiently and format it so that it looks good. We then save the workbook in a way that lets us collaborate with others in real time and gives us access to something called version history so you can easily jump back to earlier versions.
π’ FORMULAS AND FUNCTIONS MADE EASY
Once we save our workbook, youβll learn all about formulas and functions to help you answer those critical business questions. Here too we cover the basics, like how to use the status bar for simple metrics, how to enter a formula by referencing cells, and how to reference cells relatively, absolutely, or with naming.
From there, we move on to some of the most used Excel functions, like SUM, MAX, MIN, COUNT, AVERAGE, VLOOKUP, and XLOOKUP. Youβll understand how functions work and how to make sense of other functions not covered in this course, as there are over 500 functions in Excel.
π VISUALIZE YOUR DATA WITH CHARTS
We then launch into how to visualize your data using charts and conditional formatting. Charts make it easy to see trends and anomalies in your data that you might otherwise miss by just looking at your data.
π EXPLORE YOUR DATA WITH SORTING, FILTERING, AND PIVOT TABLES
Sorting and filtering come next, which lets you manipulate how to view your data. Youβll also discover how pivot tables work and how you can analyze data simply by dragging and dropping fields. With the magic of pivot tables, you donβt even need to enter in formulas or functions to quickly summarize your data.
π FOCUS ON JUST WHAT MATTERS
Throughout this course, youβll learn quick shortcuts to make you more efficient, like how you can flash fill to separate or merge columns, how to split panes to view far away rows at the same time, and even how to print just what you need.
By the end of this course, you'll gain a strong foundation in Excel & youβll be well on your way to understanding the story behind your data. Join me, your host, to master the essentials of Excel.


