SimonSezIT.com - We Teach IT. You Learn IT.

Tips, podcasts, advice and free video tutorials.

Entries for October, 2008

How to Defragment Your Hard Drive in Windows Vista

Disk fragmentation occurs when your computer stores your file with gaps between other files. Let’s assume you have a Word document that you have saved to your hard drive. The most efficient way for your computer to retrieve this file is when it is stored as one continuous file. Disk fragmentation results when the file [...]

How to Setup Windows Mail in Windows Vista

Windows Mail is the default email program that is bundled with Microsoft Windows Vista. For many of us, configuring Windows Mail can leave us scratching our head, and saying “Now what?”  When you sign up for internet service, the internet service provider should provide you with written instructions how to configure Windows Mail so you [...]

How to Insert WordArt in Your Word 2007 Document

In this video training tutorial, we show you how to insert WordArt using Microsoft Word 2007, a great way to insert decorative text in your Word document.
Watch our FREE Video Tutorial on using WordArt in Word 2007.
Get over 100 Word 2007 training videos at SimonSezIT.com

Using the Text Function in Excel to Extract and Concatenate Data

The Text Function in Excel 2007 can be used to extract data from Excel. Using use the Left, Mid and Right function arguments, data can be easily extracted. Taking this one step further, your extracted data can then be combined or concatenated, thus making this a very power tool. In this video, we show you [...]

How to Use the Text Function in Excel 2007

There are some marvelous things you can do with the Text function in Excel 2007. There are functions that were convert your text into upper case or all capitals, lower case, and proper – which will turn all case into proper case. Using the Text function in Excel is easy to learn and another great [...]