Tech Tips

Transcription So for today’s video, I have a plugin showcase for you. That plugin is called Activity Log, so I’m going to actually show you which one it is, it’s this one right here, Activity Log, and the author is Activity Log Team. It’s of course available in the standard WordPress repository. In my case, I’ve already activated it, so when I go back to my dashboard, you’ll notice I have an Activity Log entry on the left. What this plugin does, is it adds a feature I wish existed from the start in WordPress, you actually get to see what happened to each user as they’re using the site. You see when they logged in, when they logged out, … Read more

Transcription Hello, everybody. I’m here today to share a quick WordPress tip that will help anybody running a WordPress site. It’s becoming increasingly important on the web to have really fast performing websites because the response time is one of those signals that Google uses to determine whether your site appears above other sites. Not to mention that having a quick site is just a really good experience for users. Now there’s many ways to improve performance, but why I’m here today is to promote the use of alternate image formats. So for example, you might be familiar with JPGs and PNGs, but I’m here to talk about WebP. WebP is a Google-developed format, I’m going to show the website … Read more

Transcription Coming soon.

Transcription Coming soon.

Transcription Coming soon.

Transcription So the Excel sheet in front of you acts like a phone book. You enter a name and then you’re provided with a phone number. And this works because I have formulas within this cell, we’ll take a look at that shortly. But I also added another feature that lets you lookup by number, not just by name. And if you do this, you can see the result is “Nothing found” because there’s no phone number that’s called “Sawyer, Allen”. So we’re going to delete this, and instead we’re going to search for “Sawyer, Allen”‘s phone number, so in this case it’s 999-174-5493, press ENTER, and there you go, it finds a name. That’s great and all, but let’s … Read more

Transcription Excel is capable of drawing arrows that show you how cells relate to one another. I’ll show you how it works. So in front of you is kind of a phonebook type application – you can see that I can type a value, in this case I typed “Armstrong, Audrey”, and that it actually pulls up Audrey’s phone number, and if you look here, it also highlights it in green on the side. But what we’re going to be focusing on is this cell right here, we’re going to leave it selected and we’re going to go up to the formulas tab in the ribbon, and in the “Formula Auditing” section we’re going to click “Trace precedents.” What this … Read more

Transcription Did you ever wonder how you could move columns in Excel? Here’s how you do it – in my case, I want to move the “extension” column, which is column D right here, so that it appears right after the “name” column. To achieve that, I have to select the “extension” column, and while it’s selected, you’ll notice that there’s green borders to the left and right. I have to move my mouse to one of these borders, doesn’t really matter which one, and as soon as I hover on the border itself, you’ll notice that the mouse cursor changes. It’s at this moment that I have to press left-click and hold – I can then move the mouse … Read more

Transcription So let’s say I have three bookshelves at home that are packed with movies, and I need to keep an Excel workbook just to know which bookshelf has which movie. So if you look here, I have movie titles and format, I also have three sheets at the bottom: bookshelf 1, bookshelf 2, and bookshelf 3. They’re all identical in format, the only difference is they have a different list of movies. Let’s say I wanted to add a background color to the header, just to make things a little prettier, in this sheet. To do that, I would select row one, select the paintbucker tool here, select the color I wanted, and release. And there you go, I … Read more

Transcription Hey, so you know how in Windows if you want to move a file, all you have to do is left-click the file, hold the left mouse button down, and drag the file somewhere else and release? It’s that simple. But what if you wanted to do the same thing, but with a copy. Here’s how you do it. Let’s start by putting the file back to where it was… ok. So now instead of left-clicking the file, I’m going to right-click and hold, and then move the mouse just like I did before, and release on my desktop. Notice how a little menu pops up? Copy here, move here, and create shortcuts here are my options. In this … Read more