<?xml version="1.0" encoding="iso-8859-1"?>
<rss version="2.0">

	<channel>
		<title><![CDATA[TECH TAB - Articles - 2006 Newsletters]]></title>
		<link>http://techtab.matthewferrara.com</link>
		<description><![CDATA[The Technology Center]]></description>
		<language>en-us</language>
		<copyright><![CDATA[http://techtab.matthewferrara.com]]></copyright>
		<generator>N/A</generator>
		<webMaster>matt.hadley@matthewferrara.com</webMaster>
		<lastBuildDate>Tue, 06 Jan 2009 11:07:30 PST</lastBuildDate>
		<ttl>20</ttl>
		<item>
			<title><![CDATA[TECH TIPS NEWSLETTER - 12/29/06]]></title>
			<link>http://techtab.matthewferrara.com/articles/4619/1/TECH-TIPS-NEWSLETTER---122906/Page1.html</link>
			<description><![CDATA[<span style="FONT-SIZE: 11pt; FONT-FAMILY: Arial"><strong>REDUCE THE SIZE OF A WORKSHEET IN EXCEL</strong></span><span style="FONT-SIZE: 11pt; FONT-FAMILY: Arial"><br/><br/><span class="kbendusermaintextstyle">Did you ever notice when you are working in an EXCEL worksheet that the default worksheet contains lots of columns and rows?&nbsp; It's easy to reduce the size of the sheet.&nbsp; After you've added the data to the workbook, delete all of the rows after the last cell.&nbsp; Then, delete all of the columns to the right of the cell that do not contain data.&nbsp; Press CTRL & S to save the file.&nbsp; The next time you access the spreadsheet, the file will be more convenient and smaller</span>!<?xml:namespace prefix = o ns = "urn:schemas-microsoft-com:office:office" /><o:p></o:p></span>]]></description>
			<author>no@spam.com (Matthew D)</author>
			<pubDate><![CDATA[Fri, 29 Dec 2006 10:00:00 PST]]></pubDate>
			<guid isPermaLink="true">http://techtab.matthewferrara.com/articles/4619/1/TECH-TIPS-NEWSLETTER---122906/Page1.html</guid>
		</item>
		<item>
			<title><![CDATA[TECH TIPS NEWSLETTER - 12/15/06]]></title>
			<link>http://techtab.matthewferrara.com/articles/4223/1/TECH-TIPS-NEWSLETTER---121506/Page1.html</link>
			<description><![CDATA[
<p><strong><span>GOOGLE CHECKOUT</span></strong></p>
<p><span>If you are like most consumers, you are doing a lot of your shopping online.&nbsp; There is an easier way to shop securely and track your purchases in one place, Google checkout!&nbsp; Sign up for a FREE Google check out account and enjoy an online portal to all of your purchases and shipping information with only ONE user name and password to remember!&nbsp; </span></p>
<p><span><a href="http://checkout.google.com/buyer/tour.html" target="_blank"><span>http://checkout.google.com/buyer/tour.html</span></a></span></p>]]></description>
			<author>no@spam.com (Matt H)</author>
			<pubDate><![CDATA[Fri, 15 Dec 2006 11:30:00 PST]]></pubDate>
			<guid isPermaLink="true">http://techtab.matthewferrara.com/articles/4223/1/TECH-TIPS-NEWSLETTER---121506/Page1.html</guid>
		</item>
		<item>
			<title><![CDATA[TECH TIPS NEWSLETTER - 12/01/06]]></title>
			<link>http://techtab.matthewferrara.com/articles/4221/1/TECH-TIPS-NEWSLETTER---120106/Page1.html</link>
			<description><![CDATA[
<p><strong><span>PRINT PREVIEW SHORTCUT</span></strong></p>
<p><span>Did you know that you could PRINT PREVIEW in word by pressing the CTRL +F2 key?This shortcut comes in handy when you can't get to your mouse!Just hit CTRL +F2 to get back to your main document.</span></p>]]></description>
			<author>no@spam.com (Matt H)</author>
			<pubDate><![CDATA[Fri, 01 Dec 2006 11:00:00 PST]]></pubDate>
			<guid isPermaLink="true">http://techtab.matthewferrara.com/articles/4221/1/TECH-TIPS-NEWSLETTER---120106/Page1.html</guid>
		</item>
		<item>
			<title><![CDATA[TECH TIPS NEWSLETTER - 11/17/06]]></title>
			<link>http://techtab.matthewferrara.com/articles/4219/1/TECH-TIPS-NEWSLETTER---111706/Page1.html</link>
			<description><![CDATA[
<p><strong><span>READY FOR VISTA?</span></strong></p>
<p><span>Visit Microsoft.com at the link below and you can download a free tool that will let you know if your system is ready for the new VISTA operating platform! </span></p>
<p><span><a href="http://www.microsoft.com/windowsvista/getready/upgradeadvisor/default.mspx" target="_blank">http://www.microsoft.com/windowsvista/getready/upgradeadvisor/default.mspx</a></span></p>]]></description>
			<author>no@spam.com (Matt H)</author>
			<pubDate><![CDATA[Fri, 17 Nov 2006 10:30:00 PST]]></pubDate>
			<guid isPermaLink="true">http://techtab.matthewferrara.com/articles/4219/1/TECH-TIPS-NEWSLETTER---111706/Page1.html</guid>
		</item>
		<item>
			<title><![CDATA[TECH TIPS NEWSLETTER - 10/27/06]]></title>
			<link>http://techtab.matthewferrara.com/articles/2947/1/TECH-TIPS-NEWSLETTER---102706/Page1.html</link>
			<description><![CDATA[
<p class="MsoNormal"><strong><span style="FONT-SIZE: 8.5pt; COLOR: rgb(102,102,102); FONT-FAMILY: Verdana">IMPORTING INTO POWERPOINT</span></strong><span style="COLOR: black"><br/></span><strong><span style="FONT-WEIGHT: normal; COLOR: gray; FONT-FAMILY: Verdana">Many people like to work in Word as much as possible and then import the Word document into PowerPoint. To do this, run Word and open the document you want to use in PowerPoint. Now choose File/Send To/Microsoft PowerPoint. This will open PowerPoint and load the current Word document into a new slide show. <?xml:namespace prefix = o /><o:p></o:p></span></strong></p>]]></description>
			<author>no@spam.com (Matt H)</author>
			<pubDate><![CDATA[Fri, 27 Oct 2006 11:00:00 PDT]]></pubDate>
			<guid isPermaLink="true">http://techtab.matthewferrara.com/articles/2947/1/TECH-TIPS-NEWSLETTER---102706/Page1.html</guid>
		</item>
		<item>
			<title><![CDATA[TECH TIPS NEWSLETTER - 10/13/06]]></title>
			<link>http://techtab.matthewferrara.com/articles/1457/1/TECH-TIPS-NEWSLETTER---101306/Page1.html</link>
			<description><![CDATA[
<p class="MsoNormal"><span class="style21"><span style="FONT-SIZE: 8.5pt; FONT-FAMILY: Verdana"><font color="#ff0000"><?xml:namespace prefix = o /><o:p></o:p></font></span></span></p>
<p class="MsoNormal" style="BACKGROUND: white 0% 50%"><strong><span style="FONT-SIZE: 8.5pt; COLOR: rgb(102,102,102); FONT-FAMILY: Verdana">REARRANGE TOOLBARS IN IE<br/></span></strong><strong><span style="FONT-WEIGHT: normal; FONT-SIZE: 8.5pt; COLOR: gray; FONT-FAMILY: Verdana">Somehow, your address bar is not where it used to be and you suddenly have a Yahoo, Google and AOL toolbar when you start up Internet Explorer.<span>&nbsp; </span>It&#8217;s easy to control your tool bars and gain control of your Internet experience.<span>&nbsp; </span>Open IE and click VIEW, TOOLBARS.<span>&nbsp; </span>Make sure that &#8220;Lock the toolbars&#8221; is not clicked.<span>&nbsp; </span>Next, LEFT CLICK your address bar and drag it to where you want it to be.<span>&nbsp; </span>Click VIEW, TOOLBAR and UNCHECK any of the toolbars installed that you do not want to see when you open IE.<span>&nbsp; </span>You can even clean up the ICONS on your toolbar by clicking VIEW, TOOLBARS and CUSTOMIZE.<span>&nbsp; </span><o:p></o:p></span></strong></p><strong><span style="FONT-WEIGHT: normal; FONT-SIZE: 8.5pt; COLOR: gray; FONT-FAMILY: Verdana"><o:p></o:p></span></strong><span class="kbendusermaintextstyle"><span style="FONT-SIZE: 8.5pt; COLOR: rgb(102,102,102); FONT-FAMILY: Verdana"><span style="FONT-WEIGHT: bold"></span></span></span><strong><span style="FONT-SIZE: 8.5pt; COLOR: rgb(102,102,102); FONT-FAMILY: Verdana"><br/>CYCLE FONT COLOR IN EXCEL<o:p></o:p></span></strong><strong><span style="FONT-WEIGHT: normal; FONT-SIZE: 8.5pt; COLOR: gray; FONT-FAMILY: Verdana"><br/>You can add a handy icon to your Excel toolbar that will allow you to cycle through all of the font colors in a spreadsheet!<span>&nbsp; </span>Changing font colors can be just a click away if you follow the steps below&#8230;<o:p></o:p></span></strong> ]]></description>
			<author>no@spam.com (Matt H)</author>
			<pubDate><![CDATA[Fri, 13 Oct 2006 14:00:00 PDT]]></pubDate>
			<guid isPermaLink="true">http://techtab.matthewferrara.com/articles/1457/1/TECH-TIPS-NEWSLETTER---101306/Page1.html</guid>
		</item>
		<item>
			<title><![CDATA[TECH TIPS NEWSLETTER - 10/06/06]]></title>
			<link>http://techtab.matthewferrara.com/articles/1455/1/TECH-TIPS-NEWSLETTER---100606/Page1.html</link>
			<description><![CDATA[
<p class="MsoNormal"><strong><span style="FONT-SIZE: 8.5pt; COLOR: rgb(102,102,102); FONT-FAMILY: Verdana">HIDE A WORKSHEET IN EXCEL<br/></span></strong><strong><span style="FONT-WEIGHT: normal; FONT-SIZE: 8.5pt; COLOR: gray; FONT-FAMILY: Verdana">If you are working on an EXCEL document and you want to share it, but not ALL of it, you can hide a worksheet.<span>&nbsp; </span>Hiding a worksheet does not delete it; it simply &#8220;hides&#8221; it.<span>&nbsp; </span>To HIDE a worksheet, click the worksheet that you want to hide.<span>&nbsp; </span>On the FORMAT menu, point to SHEET and then HIDE.<span>&nbsp; </span>To UNHIDE, just click the FORMAT menu, point to SHEET and click UNHIDE.<span>&nbsp; </span>A box will appear listing the worksheets. Click on the worksheet that you want to unhide and click OK.<?xml:namespace prefix = o /><o:p></o:p></span></strong></p>]]></description>
			<author>no@spam.com (Matt H)</author>
			<pubDate><![CDATA[Fri, 06 Oct 2006 11:30:00 PDT]]></pubDate>
			<guid isPermaLink="true">http://techtab.matthewferrara.com/articles/1455/1/TECH-TIPS-NEWSLETTER---100606/Page1.html</guid>
		</item>
		<item>
			<title><![CDATA[TECH TIPS NEWSLETTER - 09/22/06]]></title>
			<link>http://techtab.matthewferrara.com/articles/4538/1/TECH-TIPS-NEWSLETTER---092206/Page1.html</link>
			<description><![CDATA[<strong><span>EASY WAY TO SELECT TEXT IN WORD</span></strong>
<p><span>If you are tired of fighting with your mouse when editing a word document, try a new trick!If you want to select a block to text to change, delete, copy, etc., simply place your cursor at the beginning of the text, hold down the SHIFT key and place your cursor to the end point.It's much easier than holding down the right mouse button and dragging your mouse around the page.Try it!</span></p>]]></description>
			<author>no@spam.com (Matt H)</author>
			<pubDate><![CDATA[Fri, 22 Sep 2006 13:30:00 PDT]]></pubDate>
			<guid isPermaLink="true">http://techtab.matthewferrara.com/articles/4538/1/TECH-TIPS-NEWSLETTER---092206/Page1.html</guid>
		</item>
		<item>
			<title><![CDATA[TECH TIPS NEWSLETTER - 09/22/06]]></title>
			<link>http://techtab.matthewferrara.com/articles/4609/1/TECH-TIPS-NEWSLETTER---092206/Page1.html</link>
			<description><![CDATA[<strong><span>EASY WAY TO SELECT TEXT IN WORD</span></strong> 
<p><span>If you are tired of fighting with your mouse when editing a word document, try a new trick!If you want to select a block to text to change, delete, copy, etc., simply place your cursor at the beginning of the text, hold down the SHIFT key and place your cursor to the end point.It's much easier than holding down the right mouse button and dragging your mouse around the page.Try it!</span></p>]]></description>
			<author>no@spam.com (Matt H)</author>
			<pubDate><![CDATA[Fri, 22 Sep 2006 09:30:00 PDT]]></pubDate>
			<guid isPermaLink="true">http://techtab.matthewferrara.com/articles/4609/1/TECH-TIPS-NEWSLETTER---092206/Page1.html</guid>
		</item>
		<item>
			<title><![CDATA[TECH TIPS NEWSLETTER - 09/08/06]]></title>
			<link>http://techtab.matthewferrara.com/articles/4554/1/TECH-TIPS-NEWSLETTER---090806/Page1.html</link>
			<description><![CDATA[
<p class="MsoNormal" style="BACKGROUND: white; MARGIN: 0in 0in 0pt"><strong><span style="FONT-SIZE: 11pt; FONT-FAMILY: Arial">ADD SOME STYLE TO EXCEL WORKSHEETS<?xml:namespace prefix = o ns = "urn:schemas-microsoft-com:office:office" /><o:p></o:p></span></strong></p>
<p class="MsoNormal" style="BACKGROUND: white; MARGIN: 0in 0in 0pt"><strong><span style="FONT-SIZE: 11pt; FONT-FAMILY: Arial"><o:p>&nbsp;</o:p></span></strong></p>
<p class="MsoNormal" style="BACKGROUND: white; MARGIN: 0in 0in 0pt"><strong><span style="FONT-WEIGHT: normal; FONT-SIZE: 11pt; FONT-FAMILY: Arial">If you are working in an excel worksheet and you want to format certain cells to do the same thing, you can create a CUSTOM STYLE to make life easier!<span style="mso-spacerun: yes">&nbsp; </span>For example, if you want all of the cells that contain a TOTAL calculation to be RED, IN CURRENCY and have DOUBLE LINES above them, follow the steps below:<o:p></o:p></span></strong></p>
<p class="MsoNormal" style="BACKGROUND: white; MARGIN: 0in 0in 0pt"><strong><span style="FONT-WEIGHT: normal; FONT-SIZE: 11pt; FONT-FAMILY: Arial"><o:p>&nbsp;</o:p></span></strong></p>
<ul style="MARGIN-TOP: 0in" type="circle">
<li class="MsoNormal" style="BACKGROUND: white; MARGIN: 0in 0in 0pt; mso-list: l0 level1 lfo1; tab-stops: list .5in"><strong><span style="FONT-WEIGHT: normal; FONT-SIZE: 11pt; FONT-FAMILY: Arial">Click on one of the TOTAL cells in your worksheet<o:p></o:p></span></strong> 
</li><li class="MsoNormal" style="BACKGROUND: white; MARGIN: 0in 0in 0pt; mso-list: l0 level1 lfo1; tab-stops: list .5in"><strong><span style="FONT-WEIGHT: normal; FONT-SIZE: 11pt; FONT-FAMILY: Arial">Go to FORMAT/STYLE<o:p></o:p></span></strong> 
</li><li class="MsoNormal" style="BACKGROUND: white; MARGIN: 0in 0in 0pt; mso-list: l0 level1 lfo1; tab-stops: list .5in"><strong><span style="FONT-WEIGHT: normal; FONT-SIZE: 11pt; FONT-FAMILY: Arial">In the name box, type TOTAL CELL<o:p></o:p></span></strong> 
</li><li class="MsoNormal" style="BACKGROUND: white; MARGIN: 0in 0in 0pt; mso-list: l0 level1 lfo1; tab-stops: list .5in"><strong><span style="FONT-WEIGHT: normal; FONT-SIZE: 11pt; FONT-FAMILY: Arial">Click MODIFY<o:p></o:p></span></strong> 
</li><li class="MsoNormal" style="BACKGROUND: white; MARGIN: 0in 0in 0pt; mso-list: l0 level1 lfo1; tab-stops: list .5in"><strong><span style="FONT-WEIGHT: normal; FONT-SIZE: 11pt; FONT-FAMILY: Arial">Under the Number tab select CURRENCY<o:p></o:p></span></strong> 
</li><li class="MsoNormal" style="BACKGROUND: white; MARGIN: 0in 0in 0pt; mso-list: l0 level1 lfo1; tab-stops: list .5in"><strong><span style="FONT-WEIGHT: normal; FONT-SIZE: 11pt; FONT-FAMILY: Arial">Under the Border Tab select DOUBLE LINE then click on the upper border<o:p></o:p></span></strong> 
</li><li class="MsoNormal" style="BACKGROUND: white; MARGIN: 0in 0in 0pt; mso-list: l0 level1 lfo1; tab-stops: list .5in"><strong><span style="FONT-WEIGHT: normal; FONT-SIZE: 11pt; FONT-FAMILY: Arial">Under font, select RED<o:p></o:p></span></strong> 
</li><li class="MsoNormal" style="BACKGROUND: white; MARGIN: 0in 0in 0pt; mso-list: l0 level1 lfo1; tab-stops: list .5in"><strong><span style="FONT-WEIGHT: normal; FONT-SIZE: 11pt; FONT-FAMILY: Arial">Click OK twice<o:p></o:p></span></strong></li></ul>]]></description>
			<author>no@spam.com (Matthew D)</author>
			<pubDate><![CDATA[Fri, 08 Sep 2006 14:30:00 PDT]]></pubDate>
			<guid isPermaLink="true">http://techtab.matthewferrara.com/articles/4554/1/TECH-TIPS-NEWSLETTER---090806/Page1.html</guid>
		</item>
	</channel>
</rss>