When dealing with large amounts of data in an Excel worksheet, you often need to use the Split Screen item on the ribbon or menu. This option divides your screen into 4 sections and allows you to scroll through these sections while keeping other sections of your worksheet visible.

When dealing with large amounts of data in an Excel workbook, you often need to use the Freeze Panes item on the ribbon. This option allows you to keep a certain area visible as you scroll to other parts of your worksheet. You can freeze rows, columns or both rows and columns. Be sure to click on each video to view the tutorial!

Q: What is Joomla!? 
A: It's a Content Management System for your website - and the ! is part of the name.

Q: What is the 2.5 upgrade? 
A: An important "migration" from the old 1.5 version for security, continued support, and loads of new features.

I was given a copy of an article today out of the review section of the Wall Street Journal. I don't spend a lot of time reading the paper, but the nearly full page view of Larry Page and Sergey Brin (Google's co-founders) on the front with the headline "Google: The Beginning" grabbed my attention. So I sat down and "read the paper".

Which AntiVirus Software Should I Use?

I often get the question "which AntiVirus or AntiMalware software should I use?".  It's a difficult one to answer because there are so many new threats introduced each day and none of the packages out there are going to catch everything.  There are a lot to choose from as well, and some of what's out there purporting to be antivirus programs are actually viruses themselves.

I did a short presentation this morning about Windows Small Business Server 2008. Whenever I talk about the number of things that this system brings to the table, I get really excited for the small business owner with whom I'm potentially going to be working because it's so common to come across offices that have a lot of technology investments but aren't utilizing them to improve their business processes and boost their overall productivity. Instead, they (and often their employees) feel unproductive, and sometimes even "beaten" by their computers. They believe "this is just the way it is with computers".

If you were at my presentation on April 21, 2010 and would like an electronic copy (pdf) of the document I handed out, here's a link to Microsoft's website where it came from:

http://download.microsoft.com/download/B/8/A/B8A6537E-A709-414C-9F5D-0EAE781A6F6D/SBS%202008_Datasheet.pdf

I have uploaded a new video showing an interesting new feature of Windows 7 and that is "pinning" windows to the sides of the display. This is a useful feature that allows you to quickly and easily place two windows on the screen side by side for comparison, copying and pasting data, or many other reasons.

Rather than write a bunch of text for something that is very visual in nature, I decided that I would capture some screen recordings of a few of the new features in Windows 7.