Tech Tips

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

Transcription Coming soon.

Transcription Okay, so I have a CSV right here, also known as a comma-separated value file. And let’s say I wanted to change the delimiter in this file from commas to semi-colons. Now there’s not many rows in this particular file, so I could almost manually do it, but what if you want to do it quicker than that? Well I could do a find replace, so for example I did CTRL+F in this case in Notepad++, and then went to replace, I’m going search for comma, and I’m going to put semi-colon to replace it, but the problem with that, if I replace them all, you’ll notice that the names had commas in them, Kiley, Terra, and now that’s … Read more

Transcription Let’s say you’re in Excel, and you want to select all the rows that are in your sheet. You could just use your mouse, select the first option, click, hold the left mouse button, drag, and then pull all the way down. But you know, you might have a bunch of rows that you’re dealing with, and you don’t want to do this manually. Well thankfully there’s an easy way around this and I just wanted to show you guys. So if you go back to the top, for example, and you select the first cell and then hold shift on your keyboard, and use the arrow keys, here I’m pressing to the right, you can see that I’m … Read more

Transcription So today, I’d like to show you that the VLOOKUP function, by default, is really not as precise as you think it is, unless you understand how it works. The same applies to HLOOKUP. So, as you can see, the file in front of you right now is kind of like a phone book – on the right hand side, you can see I have names and their associated phone numbers. I can scroll down, you’ll see I have a bunch of these. And on the left-hand side I have a few features – so there’s a text box here that we’ll be interacting with shortly. This is where I can type in a name, and if there’s a … Read more

Transcription So have you ever been in a situation where you try to double-click an Excel file, and it just doesn’t open? Watch this, if I double-click File2, nothing happens. You do see the wheel going in Windows, so it’s actually working, but nothing’s happening. What’s also puzzling about this is that if you check the task bar here, Excel’s not flashing, nothing’s flashing, it’s like nothing need my attention… so what gives? Now to understand why this is happening, let’s click the Excel icon in the taskbar. So here you can see that I was already updating a file called File1.xlsx, and the file we were trying to open is actually File2. Now what’s interesting here is that there’s … Read more

Transcription Hi everyone. Let’s say I needed to take a screenshot of this, what you’re seeing right here, the Google search page, but more specifically, the Web Store button and I wanted to explain to someone that hey you can remove this, you can get rid of this button. Well, the way to do that is you have to hover on it, then you press this, then you press remove. Simple, right? Well, the problem is, if I want someone to know how to do this, often what works best is having a screenshot, so if I want a screenshot, I have to kind of like hover on this, to make sure that the triple dots are visible, the button … Read more

Transcription “So starting with Windows 10, Microsoft got really comfortable with showing ads for apps, games, and, you know, Bing searches, things like that, in Windows. They’re trying to, of course, push their own products, push people to buy stuff in the Windows Store because they get a cut, things like that. So from their perspective they think they are being helpful, they’re offering us these “suggestions,” but personally I find these suggestions really irritating, because I don’t want sponsored content appearing everywhere as I’m working. So here’s 3 different places where we can turn off these helpful “suggestions,” and I’ll also show you how to keep your lock screen clean in Windows, so that you don’t have like these … Read more