To Log in, you have to buy Subscription from us.
Contact: +8801755304499 (WhatsApp)
#stratvert
🔥 Learn Excel in just 2 hours: https://kevinstratvert.thinkific.com
In this step-by-step Microsoft Excel tutorial, learn how to use Formulas and Functions. We start with the fundamentals of entering formulas into Excel. Then we advance to the most common formulas and functions that you'll encounter in Excel. This video is perfect for beginners who are new to formulas and functions, and even more advanced users who want to pick up a new trick or two.
📚 RESOURCES
- Excel Workbook without formulas to follow along: https://1drv.ms/x/s!AmxrofZZlZ....-whN9F9EUuTyuaf_kIbQ
- Completed Workbook with all formulas and Functions: https://1drv.ms/x/s!AmxrofZZlZ....-whN9QhwPmlmuTzwgZBg
- Learn the fundamentals of Excel in just 2 hours: https://kevinstratvert.thinkific.com
⌚ TIMESTAMPS
00:00 Introduction
00:45 Status bar metrics
02:03 Enter formula to add
02:50 Edit formulas
03:06 Relative references
05:29 Fill handle
06:13 Subtract
06:57 Multiply
07:40 Absolute reference
09:46 Reference cells on other sheets
10:45 Name manager
12:03 Divide
12:44 Order of operations
14:40 Basic functions
15:04 Sum function
17:46 Formula text function
18:13 Discovering functions
18:37 Auto sum
19:37 Max function
20:15 Min function
20:48 Large function
21:54 Small function
22:35 Count function
23:00 Counta function
23:49 Countblank function
24:08 Average function
24:44 Median function
25:00 Mode function
25:23 Sumif function
27:29 Wildcards
28:36 Sumifs function
31:26 Proper function
32:00 Trim function
32:25 Concat function
33:39 & function
34:05 Textjoin function
34:52 Right, left and mid functions
35:27 Len function
35:46 Find and search functions
36:40 Left together with find
38:23 Logical functions
39:21 And function
39:53 Or function
40:14 If function
41:27 If together with and
42:23 If together with or
43:00 Nested if
44:41 Ifs function
45:32 Vlookup function
47:18 Xlookup function
49:24 Today and now functions
49:51 Bonus
52:04 Wrap up
📺 RELATED VIDEOS
- Playlist with all my videos on Excel: https://youtube.com/playlist?l....ist=PLlKpQrBME6xLYou
🙌 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-101912218
- 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/k....evlers?sub_confirmat
#stratvert #microsoftambassador
Get Started with free WordPress hosting: https://automattic.pxf.io/6eLBKQ
In this step-by-step tutorial, learn how to make your own website using WordPress. WordPress is a software that allows you to create and manage websites, blogs, or apps. It is free, open source, and highly customizable. WordPress is used by millions of people around the world, from hobbyists to professionals, to express their passion, share their ideas, or grow their businesses.
In this video, you will learn how to:
- Choose a design for your website from hundreds of free and customizable themes
- Use blocks to add different types of content to your pages and posts, such as text, images, videos, buttons, and more
- Create and manage pages and posts for your website, and organize them with categories and tags
- Add links to your website, both internal and external, and edit them as needed
- Customize the header and the site navigation of your website, and change the site title and tagline
- Publish your website and share it with the world
By the end of this video, you will have a fully functional website that you can use for personal or professional purposes. Whether you want to showcase your portfolio, start a blog, or promote your business, WordPress can help you achieve your goals.
📚 RESOURCES
- Download and install WordPress: https://wordpress.org/
- Free WordPress hosting with WordPress.com: https://automattic.pxf.io/6eLBKQ
⌚ TIMESTAMPS
00:00 Introduction
00:43 Get WordPress
02:42 Personalize your site
03:05 Pick a design
03:54 Select patterns: header, sections, footer
08:22 Select styles
09:26 Activate theme
09:45 Site editor and blocks
11:13 Work with text blocks
13:09 Work with image blocks
17:14 Work with map block
17:53 Save, preview, and launch website
19:25 Stats
19:46 Posts, Media, and Pages
20:41 Add new post
24:09 Add posts block to homepage
26:25 Add link button
27:49 Add new page
29:19 Modify site navigation
31:44 Additional settings
32:32 Visit website
33:25 Wrap up
📺 RELATED VIDEOS
- Playlist with all my videos on WordPress: https://www.youtube.com/playli....st?list=PLlKpQrBME6x
📩 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-101912218
- TikTok: https://www.tiktok.com/@kevinstratvert
- Instagram: https://www.instagram.com/kevinstratvert/
🎒 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/k....evlers?sub_confirmat
🙌 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)
⚖ 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 #wordpress