Tag Archive

Tag Archives for " smartexcelshortcuts "

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.

 



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.

 

Smart Excel Shortcuts

 

Smart Excel Shortcuts

It’s Saturday morning. For as long as I have been blogging my blogs have had different names but, one has lasted through the bunch, Assume Wisely. In college, I saw a tee-shirt that read, “Assume Responsibility.” I thought It said, “Assume Responsibly”. It was clever, one too many assumptions can be as bad as one too many drinks. It’s the type of humor an econ major would appreciate. Assume Wisely, is an extension of this idea, with an enlightened perspective. The concept is assumptions should be refined in libraries or places of meditation, not bars.

 

I have blogged under keyword targeted domains. Nothing really ever came of it. Now I am considering, smartExcelShortcuts.com. I’m not going to keep up with more than one blog. Keeping both is not an option. Should I have two blogs?  Assume ResponsiblyI want to, but I really can’t split my focus. That has been my issue in the past, dividing my effort too many different ways. I need to focus like an arrow. Arrows are devastating because all their weight and momentum is focused on one point. The more you can focus the better.

I have to choose one.

 

Saturday afternoon (nap-time). I am leaning towards smartExcelShortcuts.com. I have several reasons.

  1. AssumeResponcibility and assumeWisely don’t have any meaning other than to me. It’s a brand that doesn’t have any weight.
  2. There are roughly 33k searches for excel shortcuts. Even if there were comparable search volume for ‘assumptions’. What would they be looking for? Nothing I can help them with.
  3. Buzzsumo  is showing that this is content that is shared. I think it is a viable niche.
  4. I have done extensive research over the last two days looking for an alternative. I don’t see one in the excel search space.
  5. I like the clarity of having a domain name that matches the content of the blog. It is easier to search. It provides clarity of purpose, of why.
  6. Ranking on Google search is a key part of my strategy.
  7. But is should be third, the collective authority of the sites that rank for the search, ” excel shortcuts” is low.

I am working my way through Pat Flynn’s backlink strategy. As I review the resources he shares I will share my thought here relative to the info market for excel shortcuts.

Saturday night. Just came back from the pool and the family is watching Bob the Builder before we go on a Jammy (pajama) walk. We take night time walks before the kids go to bed. While I was at the pool I realized that I might want to look at pursuing my email overload solution. I need to create wow-content for my excel site from scratch, the benefit here is that the wow content for this email solution is almost done. Unfortunately, it isn’t a solution people are searching for. It is also not something anyone is terribly interested in sharing. Email overload is an enormous productivity killer, i’m surprised.

Monday afternoon. I’m Mr. Excel Shortcuts; I am now the owner of smartexcelshortcuts.com. I finally accepted that this is a brand i want to develop because it meshes well with my background and experience. I thought I could swap out domain names on my bluehost site. I was so wrong! I almost I crashed the site and couldn’t access the wp-admin. So smartexcelshortcuts.com is it’s own site. After all that thought I have two blogs . . . for now. Soon-ish I will migrate the content so there is one site.

Tuesday morning (2am). I thought I finished with Pat Flynn’s backlink strategy, but i guess that isn’t the case.  So I reviewed it again. This has to be my third pass on this post and I’m still pulling new information and taking notes to re-read it again. This is dense solid content. I have one main takeaway with two large to-do items from this last pass.

Content is king, and design is queen. Great, wow level content has to communicate visually. I need html/css pages and posts. Need! Last night I learned how to import a template html page into my wordpress site. I even edited the html directly. Big win. It looks great! Visitors will be able to download my excel shortcuts mindmap. I need to know how to do that within wordpress. I spent some time looking for videos and found nothing.  So, I need to relearn html/css. (1) Design is queen. (2) Learn html/css. It should take me 7 hours at Codecademy.

So, the question is how much time is too much time to dedicate to learning a skill?

How much html can i get away with not learning?