EXCEL: Set Cell Value as Tab Name

In order for this formula to work you need to make sure the workbook has been saved; otherwise, the cell will result in an error.

FORMULA:
=MID(CELL(“filename”,A1),FIND(“]”,CELL(“filename”))+1,255)

VIDEO TUTORIAL:

EXCEL: SQL Generator…

In my line of work I write T-SQL statements quite a bit so having to write them over and over again can be tiresome. Here is tip that can help you generate T-SQL insert statements very quickly, especially if you seem to use the same tables over and over again. This is my first attempt using another tutorial software so bare with me.

Enjoy!

VIDEO TUTORIAL:

EXCEL: Count character length…

If you ever need to find the total amount of characters including the spaces between the words use this easy tip.

EXCEL: Repeat text…

Another quick formula that makes duplicating text easy.

EXCEL: All Upper Case…

Once again if you need to change all the text to upper case here is a quick solution.

Enjoy!

EXCEL: Lower case…

Just in the event you need to change the text from capital to lower case.

EXCEL: First Initial Last Name…

I just wanted to post a simple and quick video tutorial on how to Generate a First Initial Last Name from two columns Fristname and Lastname within Excel.

Enjoy!

Highlight every other row in EXCEL…

You are working on an excel spreadsheet that contains literally hundreds to thousands of rows and instead of manually changing the row color line by line, you want it done automagically!

Before

After

Trick number 1.

Select one of the cells that contain data. Then press CTRL+A. I will choose cell 4D. This will highlight all the cells with data in it. If you have breaks or gaps in your spreadsheet this will not work. It only works on clusters of data. Look at the example below!

Trick number 2.

While the needed porition of the spreadsheet is highlighted, click on “Format” from the file menu. Select “Conditional Formatting…”

Change the “Condition 1” dropdown to “Formula Is” and type in

=MOD(ROW(),2)=0, then click “Format”

NOTE:

(The 0 indicates to skip the first row, change it 1 to include the first row. The number 2 in this formula indicates that every other row needs to be highlighted, so if you change this value to the number 3 then every third row will be highlighted, so-on and so forth. Also if you want to highlight columns simply change the word from ROW() to COLUMN() and now the columns will be highlighted instead. However, if you want both then add another formula!)

Click on the “Patterns” tab

Select the lightest shade of Gray and click ok

Then click ok to close the Condional Formatting dialog screen…

…that is it, there you have it. Every other row is now highlighted!