Tech Software Videos

Someone put a bunch of mathematical calculations in column A as text and we want to evaluate those formulas. Mike and Bill provide dueling ways to solve this problem.

In this Excel tutorial learn how to split a word and then count the characters.

Wang asks how to change part of one data label to be red. Unfortunately, the label is then broken. A macro should solve this, but it does not. Episode 1147 discusses this problem.

Mark asks how to fill blanks in with the data from above. Now...if you've watched this podcast, you've seen the trick for this, but Mark's data has something preventing Go To Special Blanks from working! So - another way to go. Episode 1146 shows you how.

Diane from Michigan wants to split a column of names into two columns. Episode 1145 shows two approaches and the problems with each.

Michael from Kansas City asks how to build a floating quartile chart. Episode 1143 shows you how.

Martin from Sweden sends in a question about doing a range VLOOKUP where the lookup table is not sorted. Mike and Bill duel it out in today's Episode 1144.

You can specify up to eight colors in the custom number format box. But wait...you can actually do all 56 colors from the Excel 2003 color palette! Episode 1142 shows you how.

A cool way to streamline a VBA loop using SpecialCells. Episode 1140 shows you how.

Rob from Cambridge needs to divide nine cells by nine other cells and sum them up. In Episode 1141, we look at an array formula to solve this problem.

Over the years Messenger from Microsoft has evolved from MSN to Windows Messenger and finally into Windows Live Messenger; a program that really lets you do it all. You can access your Windows Live Hotmail account, share folders and files, chat with family and friends, make phone calls, send SMS messages and much more.

Windows Live Messenger lets you add as many contacts as you want. You can send them an invitation via email and add them to your contact list. You can place each contact in a group, include their mobile number and receive automatic updates whenever they change their information.

When you're online it's nice to be able to chat with family and friends. Windows Live Messenger makes it easy to do just that. Just find a friend, open a chat window and type up a quick "hello" message to start a conversation. Windows Live Messenger's program has a simple interface that makes chatting easy.

In the early days of the Internet you had to have multiple programs open to do things. Your email program, your browser, your instant messenger and so on. Not so today. With Windows Live Messenger you can access your Windows Live Hotmail account with just one click of your mouse.

Windows Live Messenger looks pretty good right out of the box, but there are lots of things that you can do to tweak, customize and personalize it. You can determine how the program looks and acts: Customize your sounds, colors, alerts, security settings and more. You can set a default download folder, block specific users, and check on your Internet connection. You can even add custom emoticons or change the background picture to give your Windows Live Messenger a new look.

A viewer from Portugal sends in a question about finding which row contains the match. Episode 1139 shows you a few ways to go!

Protect yourself from computer crashes by backing up your computer using this free software. GFI Backup utility: http://www.gfi.com Belarc Advisor (License Keys) http://www.belarc.com/free_download.html

Rod from Cincinati asks how to solve the problem of trailing spaces in the lookup table. I had never tried it before, but you can apply a TRIM to the entire lookup table. Episode 1138 shows you how.

In Episode 1137, a cool way to remove all hyperlinks from a spreadsheet.

Nick asks how to do a pretty lengthy bonus calculation. It might be too complex for the Excel 2003 nested IF limit, so I decided to use the range version of VLOOKUP. But...as a twist, I embed the table right in the formula. Episode 1135 shows you how.