Effective Use of Spreadsheets - Microsoft Excel - Indexing Your Spreadsheets

Almost everyone these days use spreadsheet in their daily life, whether it is at work or at home or at school.

However, many are also just using it for its basic function, without knowing or exploring other functions and features that are available in spreadsheets, like Microsoft Excel.

Some are too afraid to ask others as they may look stupid for not knowing.

Others may want to read up on the additional functions and features, but the amount of books available and the thickness of these books tend to scare them away.

What I will do in this series of tips on "Effective use of spreadsheets" I will explain useful features in Microsoft Excel, which would make working with spreadsheets easier, whether you use spreadsheets for serious applications in the office or to catalogue your DVD collection or to keep your favourite recipes.

One feature that I have found to be very useful, especially if you have a large number of spreadsheets to work on or refer to frequently, is Indexing Your Spreadsheets by using the HYPERLINK Function.

When you have 10 or 50 or 100 spreadsheet in your workbook, you may find locating a particular spreadsheet by scrolling through the sheet tab at the bottom of the spreadsheet as being very difficult and time consuming.

The best way to locate find fast and accurately is to create your Spreadsheet Number 1 as an INDEX SPREADSHEET for the whole Workbook.

Try this out.

1) Open a New Spreadsheet File

2) On Row 1 Column A (location A1) type in Customer A or Recipe A

3) Right click on A1 and scroll down to HYPERLINK and click on it

4) Select Place in this document on the left hand side

5) Select Sheet 2 from the list - Cell Reference

6) Press OK

You have now referenced Cell A1 in Sheet 1 to Cell A1 in Sheet 2

You should now see Customer A in Cell A1 Sheet 1 with a Hyperlink underline to it.

When you place your cursor over A1 in Sheet 1 and click there, it will take you straight to Sheet 2

7) Now do the same on Cell A1 in Sheet 2 but now reference to Sheet 1 to take you back to Sheet 1 (the Index)

Repeat Steps 1 to 7 for a few more spreadsheets, say about 5 or 6 more, for Customer or Recipe B onwards, and then see the results.

Great isn't it.

Now you have just created a link through an Index Spreadsheet and a link to go back to the Index in every Spreadsheet.

Have fun trying it out and using it EFFECTIVELY in your daily work.

XP Antivirus - Dreading Security Software Removal

The year 2008 definitely showed its benevolence for Internet scammers: they found a way to get paid for their illegal activity.

And that way includes wild promotion of fake security software via aggressive spamming on forums and blogs.

One example of such software is a notoriously known XP antivirus, also called Windows XP antivirus 2008. It is a classic rogue software that behaves quite differently from what it claims to do.

So, instead of scanning for viruses and removing them, it ruins the system security by L & U shape computer desk,metal computer desk,office desk opening wide breaches, then installs Trojans and acts like any other spyware - but that's not all. XP antivirus scares the user into buying the full version of it! Of course, the paid version doesn't get any milder on the computer, but it reaches the goal - its creators get money for their evil work.

So how do you tell if your PC has been infected with XP anti virus?

There are signs that cannot go unnoticed:

Windows-like balloons inform about malware detected in the system.

A corrupt Windows security center recommends downloading antivirus software.

Pop-ups scare the user with all kinds of messages urging to get the protection NOW.

While visiting websites you may see annoying pop-ups offering free online scan.
A sad fact about this rogue software is that it stays unnoticed by antivirus programs. To get rid of XP antivirus, you can follow several simple manual steps:

unregister DLL-files related to XP antivirus or modified by it;

end malicious processes in the Task Manager;

remove relevant entries from the Windows registry;

locate and delete program files installed by the software.
There's nothing really complicated with the manual removal procedure; any intermediate PC user can do that.

However, if you don't feel like playing with the system and registry (which is always risky), there are tools that can do the removal process for you for free.

Page Borders in Word 2007

Microsoft Word 2007 offers some limited page layout capabilities. One such feature enables you to add a border around text or other page contents. Page borders in Word 2007 can add a decorative touch to a document and can be applied to each page in a section or the entire document, or to a single page within the document.

Word 2007 comes with a selection of page borders, including plain, dashed, dotted and decorative lines, artwork and three-dimensional shadowed lines. The artwork within the program is appropriate for certain celebrations and events, such as birthday and holiday parties, common announcements and seasons of the year.

To add page borders in Word 2007, select the page or section to which the border will be applied. Choose Page Layout > computer cart desk Page Borders. The Borders and Shading dialog box will appear. From within the Borders and Shading dialog box, select the basic border type - Box, Shadow, 3-D or Custom.

Within the same dialog box, choose the border width, style and color. The default border is a solid line, but you may choose a different line style or to substitute artwork for a plain line. You'll find dozens of pre-loaded page borders in Word 2007. There is no way to add custom border artwork, however. Select the appropriate border from the list of those available.

You can control which sides of the page the border appears on. To add or delete a border, simply click on each line along the side of the page graphic shown in the Preview section of the dialog box.

From the "Apply to" list, indicate whether the border should be applied to each page in the document, the current section, the first page of the current section or all pages except the first page of the current section. Click OK to apply the border.

Windows Cannot Find File at Startup - How to Solve This Error Message?

If you already have the problem with "Windows cannot find Somefile.exe. Make sure you typed the name correctly, and then try again.", be sure that you have thousands of "colleagues" all over the world. The visible part of the problem in most cases is that you see "Windows cannot find" error message on your Windows startup. If you see "Windows not found" error for the first time, think of which third-party program could show it. In most cases "Windows not found" error message means that there was a command to run some file, but the file itself is absent. As a rule "Windows can't find" error message means that you have a virus infection on your computer.

Be sure to check your computer with the latest version of your anti virus if you see "Windows conference table,laptop stand,printer equipment table,trainning table cannot find XXX. Make sure you typed the name correctly, and then try again." on Windows startup. If "Windows can't find" error is caused by some malicious program, it is often accompanied by other problems like performance loss, poor Internet connection or additional error messages. No matter how this problem came to your computer, the only definite thing is that you will have to solve it sooner or later. When your computer boots, Windows reads a list of files that should be started automatically, and the program causing "Windows cannot find Somefile.exe. Make sure you typed the name correctly, and then try again." can appear among them. Let God bless you if you want to try solving "Windows cannot find XXX. Make sure you typed the name correctly, and then try again." problem manually.

We also faced with situations when "Windows cannot find" was caused by the second part of autorun entry, especially if the first part of it was connected with Rundll32.exe file. To summarize all discussed above: there are several tens of possible (and different!) reasons how "Windows not found" error message could appear on your computer. Recently installed program can cause "Windows could not find" problem as well. The other most important source of this problem is YOU who deleted some important system file thinking that it is not useful. If you are professional, you will certainly need to use "Autoruns" program, as it provides much more options for editing your autoruns list than any other program of this kind.

If you are an experienced user and want to seach your autorun list and fix "Windows not found" error - use msconfig.exe utility shipped with your Windows. You may also try to use System Restore to restore your Windows to the state where there was no "Windows can't find" problem at all, but this helps only in one case from ten. For safer fixing of "Windows not found" error we recommend you to reboot into Safe Mode. Fixing "Windows could not find" problem manually can be a tedious task if you are professional and dangerous task if you are newbie. Never commit your friends to solve your computer problems, especially with "Windows cannot find" if you are not sure if they are known the exact solution.

Great Plains Installation - Overview For IT Professional

Microsoft Dynamics GP installing process is straight forward and simple if your company deploys versions 10.0 or 9.0. If you are still on earlier version or on Pervasive SQL or Ctree: 7.5, 7.0, 6.0, 5.5 or 5.0 - then installation requires either to be done by professional consultant or GP support person should be available on the phone during installation phase. Version 8.0 is also relatively simple, however we heard some complains on ODBC connection creation. Let's review installation phases:

1. New Server Installation. This is when you are coming through implementation process. It is very unlikely that you do it in-house - GP requires professional consultant for initial installation, data conversion and implementation

2. Moving GP Server from one computer to another. There is special technical article on Microsoft customer source website to do so. If you are experienced SQL DBA, then all what this article does is transferring SQL logins and DB security for GP databases - this should be good hint for DBA folks

3. GP user workstation installation. Insert GP CD#1 and follow installation wizard. Versions 9.0 and 10.0 will create ODBC DSN for you automatically, so if you are reading wizard questions - you should be fine. Earlier versions require ODBC manual creation - please read installation manual

4. Customization Installation. If you have add-ons or customizations (typically written in GP Dexterity and distributed as Dex chunk), be sure to copy the chunks into GP user workstation directory

5. Reports Dictionary location. If you are installing GP in mid-size or large organization, the chances are high that you are sharing REPORTS.DIC. Prior to install new GP workstation, please review Dynamics.set file for working users. This setup file should give you the idea where shared dictionary is located and how to modify Dynamics.set file on new workstation

6. FRX. FRx financial reports: Balance Sheet, P&L, Cash Flow, including reporting trees and consolidated reports should be installed with special attention to ODBC settings for the company and SYSDATA folder location. Please review the settings for existing and working FRx workstations first

7. Crystal Reports. If you have them, then installation is simple - just install computer workstation,computer carrel,audio visual cart & stand Crystal Reports designer and then instruct user how to open reports from your network shared folder

8. Integration Manager and eConnect integration connectors. If you are also installing IM tool, then know that for version 10.0 you have a set of eConnect conectors, requiring you to specify domain name and userid for eConnect user. eConnect gives you the option to speed up integration, however it requires you to specify DB name in integration, meaning that you eConnect integration will work for just one company only. This is not really a big constraint as you can always copy integrations and have them tuned to work with your multiple companies as required.