Yes, And…

by

I watched a Q&A video recently featuring Adam Savage, a special effects expert best known for being on MythBusters, a show where, according to Wikipedia, they “used elements of the scientific method to test the validity of rumors, myths, movie scenes, adages, Internet videos, and news stories.” It was precisely the focus on the scientific method that made it one of my favorite shows, combined also with how playfully the two hosts interacted. In this particular video, Adam responds to the following viewer question:

Hi Ren

by

One of the best pieces of art I have ever seen/heard/experienced. By RenMakesMusic.co.uk Thanks to Phil for sharing this with me.

How to Make Excel Formulas More Readable With ALT+ENTER

by

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

Using Excel’s Formula Arrows to Understand How Cells Relate to One Another

by

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

How to Move Columns and Rows in Excel

by

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