Archive

Monthly Archives: October 2015

Excel – Insert more than one row at a time.

How to Quickly Insert multiple blank rows or columns in Excel.

To quickly insert multiple rows in Excel it makes more sense to use a mouse shortcut. You can insert multiple blank rows all at once with the following steps:

Step 1: Select the number of rows you want to insert.

Step 2: Right click the selected rows, and choose the Insert item in the context menu, see this video demonstration below:

 

Alternatively, you can insert one row (right click and select ‘insert’) and then press F4 as many times as you need. This works when you are too lazy to count rows.

 

Did you know there are only a handful of tools that differentiate an excel expert from an intermediate user?

Yesterday my good friend said, “Anytime someone says they are an excel expert I know they don’t know anything.” I know where he is coming from. I have the same bias. As I learn a new tool in Excel I realize how much more there is to learn. But you don’t have to know how to use every tool to be an expert. When it comes to Excel, it really is possible to become an expert in a short amount of time because there are only about a half dozen areas where people get stuck, bottlenecks. Manipulating data is one area where cut, copy, and paste is just a portion. If you would like to access my (Rho Lall’s) full mind-map,  Become An Excel Expert, it covers all five areas. Just follow this link to my become an excel expert mind-map.

 



Strand puts some points on the board TWD style in Episode 5 of FTWD!

Strand puts some points on the board TWD style in Episode 5 of FTWD!

 

Who is this guy? I’ll get to that, but first, can we talk about how Salazar killed it TWD style. From now on I’ll refer to him as ‘the barber’ because in this episode his craft takes on a whole new dimension. Now he is “the barber”, not unlike the designation “butcher” or how we referred to Gustavo Fringe as “Pollos”. Salazar put points on the board. I care about him. But why? We get some more of his story. I think that is part of it but, if that is true . . .

 

What about Strand?

 

Strand. WTF! Awesome. When we first meet him he is confined but, we learn he is anything but. Strand is badass in a way that doesn’t exist in reality like Heath Ledger’s Joker in Dark Knight. He just knows what’s up. Maybe he just knows himself. (And human nature.) The only person I can think of that approaches this level of personal mastery is Victor Frankel. Thoughts? Please share in the comments below.

What is TWD style? When you first met Daryl did you realize he was going to have a leading role? What about Carol? That’s a great part of the brand, you never know who is going to step up.

Strand is the new daryl dixon

 

Why did it take until episode 5, Cobalt, to finally get some points on the board?

If you took the walking dead wiki poll on FTWD and you are part of the majority who think FTWD is “absolutely amazing” I’d love to hear why in the comments below. Please. Enlighten me. I’m not looking to start a fight, I can appreciate people who think differently than I do and believe friends can have different ideas. 

At the end of episode 1, the pilot, the scene closes with a great feeling of dissonance where we know what is happening but, this poor family has no idea. The pilot is a solid first down. In episode two, So Close, Yet So Far, I am still looking for a reason to care. Any reason. Nothing. Borrowing the football reference again, the play was incomplete. I was hoping for a touchdown. Now I’m worried. I’m ok with not seeing a lot of zombies, but will I care once they do show up?

Episode 3, The Dog, the zombies show up. The episode starts with mom at home looking to protect her kids. Outside their neighbor has turned and is preying on his family before he comes looking for hers. If you didn’t notice in the last episode, these are not the same zombies from TWD. These skulls are fresh and don’t cave like withered pumpkins. The shotgun scene is on par with The Terminator, and Pollo’s death in Breaking Bad.

 

I say I still don’t care about this family but at the end of the show we meet Mr. Tran, Patrick. He has overcome all odds to get back home to his wife. He is unaware that in his absence she committed suicide. Our family rushes to aid as he unwittingly reaches out to embrace her. That scene was great. It gives me hope that if i can care for Mr. Tran I can care for this family.



Excel – Clean, Trim, and other useful formulas to Cleaning up text (data).

Clean, Trim, & useful formulas to Clean up text (data).

When working with data it is often necessary to ‘clean’ the data first so that you can work with it.  Often formatting is distracting or inconsistent, there may be extra spaces between words and on occasion there may be special characters that are not visible but, get in the way of working with data. Sometimes data is not in a format that you can use. This data needs to be prepped for use. Sometimes this is called data processing; we refer to it polishing data. Two common formulas for cleaning data include:

=clean()  Removes special characters from your cell values. 

=trim()  Removes extra spaces between words and at the ends of your cell value.

This video goes into how to use these two functions.



Excel – Uppercase, Lowercase, and The Proper Capitalization.

Uppercase, Lowercase, and The Proper Capitalization.

 

=upper() The upper function puts your text in “all caps”. I.E. “THIS IS AN EXAMPLE OF UPPER.”

=lower() The lower function puts your text into all lower case letters. I.E. “this is an example of lower.”

=proper() The proper function capitalizes the first letter of ever word in the cell value. I.E. “This Is An Example Of Proper.”

This video goes into each function.

 

Did you know there are only a handful of tools that differentiate an excel expert from an intermediate user?

Yesterday my good friend said, “Anytime someone says they are an excel expert I know they don’t know anything.” I know where he is coming from. I have the same bias. As I learn a new tool in Excel I realize how much more there is to learn. But you don’t have to know how to use every tool to be an expert. When it comes to Excel, it really is possible to become an expert in a short amount of time because there are only about a half dozen areas where people get stuck, bottlenecks. Manipulating data is one area where cut, copy, and paste is just a portion. If you would like to access my (Rho Lall’s) full mind-map,  Become An Excel Expert, it covers all five areas. Just follow this link to my become an excel expert mind-map.

 

 

Excel – Switch tabs, move between open workbooks, and Jumping to the last row.

Switch tabs, Move Between Open Workbooks, and Jumping to the Last Row.

 

How to switch between workbooks?

[Alt + Tab] This is the same shortcut to tab through all of your open workbooks. Pressing tab once brings up the selection screen. Pressing tab additional times selects the next window.

[Windows + D] Is a handy shortcut as well. ‘D’ stands for desktop. This short cut minimizes all windows. Pressing it again brings them back. To audit my open windows I like to show my desktop (Windows  D) and then bring each window up at a time using (alt + Tab).

 

How to switch tabs?

[ctrl + page up] To move right across the tabs in your workbook to the end of the list.

[ctrl + page down] To move left across the tabs in your workbook towards the beginning of the list.

 

 

How to jump to the last row of data,  across, and back?

[ ctrl + arrow keys ]You can use the arrow keys, while holding ‘ctrl’ to navigate across your table in all different directions.

 

Did you know there are only a handful of tools that differentiate an excel expert from an intermediate user?

Yesterday my good friend said, “Anytime someone says they are an excel expert I know they don’t know anything.” I know where he is coming from. I have the same bias. As I learn a new tool in Excel I realize how much more there is to learn. But you don’t have to know how to use every tool to be an expert. When it comes to Excel, it really is possible to become an expert in a short amount of time because there are only about a half dozen areas where people get stuck, bottlenecks. Manipulating data is one area where cut, copy, and paste is just a portion. If you would like to access my (Rho Lall’s) full mind-map,  Become An Excel Expert, it covers all five areas. Just follow this link to my become an excel expert mind-map.