How to Use IF Functions In Excel

Transcription Here’s how you can use the IF function in Excel. So in this example, we have an order form that has an item – t-shirt, and a quantity. Let’s make it so when there’s more than 5 t-shirts, the shipping cost is free. So, instead of 14.95, let’s just press =, that will start writing a formula, and then we’ll type IF, and then open parentheses. If cell C4 is greater than 5 – right here it says value if true – so if that’s true that it’s greater than 5, what would it say? Free, right? And then if it’s false – you notice I press a comma and then you see false is highlighted there in bold? … Read more

How to Keep Using the Classic Editor in WordPress (Avoiding the Block Editor)

Transcription So this video is about the plugin “Classic Editor.” Classic Editor is an interesting plugin because as of version 5.0 of WordPress, a new default editor has existed in the product. That new editor is called Gutenberg – you can’t really see it in WordPress referred to as Gutenberg, but it looks like this. If you click it, they usually refer to it as the block editor, okay? So what you’re seeing right here is the block editor. You know, instead of seeing a title, and a body, where I can actually put in the content, you now have to interact with blocks. So I can just type whatever I want here, that works, but let’s say I want … Read more

How to Impersonate Users in WordPress (Or See What They See)

Related View the short version of this video. Transcription In today’s video, I’ll be showing you a plugin that allows you to impersonate other users, which I find especially helpful when it comes around to helping a user that’s encountering a certain issue, maybe they can’t see something, or something’s not – doesn’t look right to them. So in the WordPress dashboard, in the Plugins section, let’s click Add New Plugin, and here we’re gonna search for “user switching” and press enter. The first option is going to be by John Blackbourn & contributors, at least that’s the case right now. You’ll know it’s the right one if it has these contributors and the title is User Switching, so I’m … Read more

How to Filter Out Beeping/Buzzing With Audacity (Microphone Glitch Known as “Frying Mosquitoes”)

Description Here’s the Audacity post. Transcription When I record YouTube videos, these days, I always use the same Blue Yeti microphone, let me show you what it looks like. So this is the microphone I’ve been using the years, I think it looks great, it works pretty well, the only problem is, when I start a recording, and I finish my video, I actually record the whole thing, in Audacity, I can tell that there’s a persistent buzzing in beeping in the track, and even when I’m saying nothing, there’s a persistent buzzing and beeping sound. I never quite figured out how to solve this, I also didn’t really know how to search for this, because it sounds so strange … Read more