TechGenie Answers - Part 7
iYogi

Home » TechGenie Answers

TechGenie Answers

How to Setup Home Wireless Network

Now days, where ever you go, you are surrounded by wireless routers. From shopping malls to offices, every place is equipped with routers, so that you get the maximum connectivity. You may connect to that Wireless Network or not is different deal but you are in its reach almost all the times. Wireless Networks were initially used only by big telecom companies. All this has happened because of low... Read More »

How to get rid of the Antivirus System Pro Virus

The Antivirus System Pro is another malicious virus that attacks your computer anytime before you even come to know about it. This particular virus affects your computers not only speed but also the memory. It slows your computer down, it redirects or can also hijacks Internet Explorer so that when you are browsing the web, instead of going to the page you want, you will be diverted to one of the... Read More »

How to Install Symantec AntiVirus Corporate 10 in Windows 2003

Symantec is the world leader in providing solutions which provide help to individuals and enterprises assuring the security, availability, and integrity of their information. Symantec’s Headquartered in Cupertino, California and it has operations in more than 40 countries. Symantec Antivirus Corporate Edition provides real-time and spyware protection to enable enterprise-wide system uptime for workstations... Read More »

How to Remove California Anti Virus

Old antivirus is needed to be removed as these software helps to ensure that your updated antivirus program can work properly. Uninstalling or deleting the unwanted software helps the computer users reclaim space on an already cramped computer hard drive. Removing old anti-virus software is very important because older programs and their background processes can keep new antivirus programs from properly... Read More »

How to Install and Use Avast Anti-Virus Freeware

Avast Anti-Virus Freeware is claimed to outperform their competitor’s paid products as claimed in its website. It provides great protection against viruses as well as spyware. Avast Anti-Virus is an antivirus program developed by AVAST Software, a company which is based in Prague, Czech Republic. In 1988 it was first released. Avast is based on a central scanning engine that is certified by ICSA... Read More »
Tags: , , , , 884 views

How to Create an online photo album

Photos are very important for us. If you want to keep your memories live, then you need photos. You can share photos over the internet, you can store your photos on your computer and you can send them to your relatives and friends online. If you want to choose the appropriate photos to be displayed, then you need to create different categories for each photo. Following steps are to show you that how... Read More »
Tags: , , , 379 views

How to Print Bar Codes in Microsoft Excel

Microsoft Excel is a spreadsheet program from Microsoft corp. Other than creating and editing databases and tables Excel is also capable of creating bar codes. If a macro-based function is used Excel is also capable to create bar codes for any given formula. You can even print these bar codes and you can use them for all the products you are selling or planning to sell. The following are the simple... Read More »

10 ways to work more securely

It is not the computer system which is precious all the times but mostly it is the data which is in there which is precious. Lost or stolen data from your computer’s hard drive can lead you and your company into a very troublesome situation because that data can reveal a lot about the company and even a lot about you as in person. One should always take apt care when it comes to computer security... Read More »
Tags: , , , , , 364 views

How to Start and Launch Microsoft Excel

Microsoft Excel is a computer application that allows you to do basic spreadsheet as well as the mathematical functions. With this tool, you can create balance sheets, standard input forms, databases, reports, or charts and graphs and many more. Microsoft excel do not limit you to only imputing numerical data into columns and row.  You get an option that may add text, insert images, and include... Read More »

How to Make a Schedule on Microsoft Excel

Microsoft Excel is the most popular program by Microsoft. It’s a part of Microsoft Office Suite. It’s a spreadsheet application that has written and developed by Microsoft for Windows and Mac OS X and it has features like calculation, pivot tables, charts, graphs etc. It has the basic features of all spreadsheets. In MS Excel you can use a grid of cells that can arranged in numbered rows and you... Read More »

5 Tips to use Keyboard Efficiently

Keyboard is the main input device for any computer system. Keyboard is such an important device for any computer that a computer doesn’t even boot if the keyboard is not present in it or if it is in a non-functional state. Keyboard is what we mostly use while working on computer and so we should be comfortable using it as it directly affects our productivity. If one is not comfortable using keyboard... Read More »

Tips to Organize your computer

We buy a new computer; work on it for some time happily and eventually we realize that it is not working the way it used to work earlier. We notice that it has gone sluggish, it takes time to boot, it takes time to shutdown and it takes time to open files and applications. We call a local technician or visit a local service centre, pay them the hard earned money to get the missing speed back. Wait!... Read More »

How to Disable FTP on Trend Antivirus

Trend Micro is an antivirus or internet security program created by Trend Micro and is known as PC cillin Internet Security in Australia and Virus Buster in Japan. The program includes antivirus software, a firewall and a scanner and is available for 30 day trail. In the consumer reports electronic buying guide 2008, Trend Micro was rated higher than any other antivirus tested. Trend Micro has had... Read More »

How to Tune Up Windows Aero Glass

Microsoft really has gone too ahead of others in Windows Vista and Windows 7 by releasing the new Aero theme. Though this theme requires special configuration but it really is an eye candy for its users. You definitely can tease other users who do not have such theme or if their computer cannot support the Aero. The glossy look introduced by Microsoft as Aero has been adopted by many afterwards. This... Read More »

How To Create a MS Outlook Email From MS Excel

Microsoft Outlook is a personal information manager from Microsoft, which is available both as a separate application as well as a part of the Microsoft Office suite. The current version recently launched by Microsoft is Microsoft Outlook 2010 for Windows and 2011 for Mac. Although often used mainly as an e-mail application, it also includes few features which are not known much, such as a calendar,... Read More »

How To Use AutoSum in Microsoft Excel

The AutoSum function in Excel quickly calculates the total of a row or column of numbers and saves you from entering a formula manually. The AutoSum is very helpful in performing simple calculations. It saves a lot of time as well as from the complications that you may end up with. The following are the simple steps that you need to use AutoSum in Microsoft Excel. Microsoft excel is a spreadsheet... Read More »

How to do a Fast Fourier Transform (FFT) in Microsoft Excel

Fast Fourier Transform (FFT) is the easiest way to show the dominant frequencies in a signal. FFT is an efficient algorithm to compute the discrete Fourier Transform and in its inverse. There are many distinct FFT algorithms which involves a wide range of mathematics, which starts from simple complex-number arithmetic to group theory and number theory too. You also need Microsoft Excel with the Data... Read More »
Tags: , , , 17,691 views

How to Review the System Security Needs of a Computer

In order to go ahead with this topic one must be aware of the concepts of what computer security actually is? In simple terms Computer Security can be termed as the branch of computer technology which is applied to computers and networks. It is a collective process and mechanism to protect a system from unauthorized access. The main objective of computer security is to protect the information and... Read More »

How to Manually Remove Antivirus System Pro

Antivirus System Pro is a new innovative malware program by the hackers which make out itself as an antivirus program. It gets downloaded automatically with the open of various websites or from click on the pop-out ads of various websites and then ensue a fake scan on your PC. Once done the program gets access to your PC it will automatically start up with the start of the Window and will radically... Read More »

How to Get Free Antivirus for MacOS

Apple Inc. (formerly Apple Computer, Inc) developed a series of graphical user interface based Operating Systems for their Macintosh systems and named it Mac OS. Macintosh user’s experiences a high level of graphical user interface. Mac OS was first introduced in 1984 as system software. Mac OS is categorized into two families – Apple’s own code based Mac OS family and UNIX based Mac OS X operating... Read More »

How to Choose a Computer Network Hub

Hub is a device through which multiple computers can be connected on a network and can share information. It connects computers and as well as other devices like printer, scanner etc on a local area client/server network. Cable is the means to connect the network cards of each device one wants to connect to the ports on the hub. Different types of Hubs are available in the market, out of which Ethernet... Read More »
Tags: , , , , 931 views

How to Make a Histogram in Microsoft Excel

Microsoft Excel is used for financial matters has got all the functionalities needed for financial, accounting as well as statistical functions there by giving flexibility to the users to solve out any financial terms. Whether be it calculations, documentations or presentations, it’s a solution to all factors related to finance. It can generate pie diagram, bar diagram, histogram and many more.... Read More »

4 Tips to Connect Your Phone With Your PC

If you synchronize your phone with you PC then it is going to be the best way to transfer information, settings, and files. You can have all of them up to date and can access it at home and at work to. Maintain Your Appointments It sometime happens that you have made an appointment in your PC but have not synced it with your hone and so you missed it. You are sometime outside your home and have entered... Read More »

How To View Microsoft Access Relationships With the Relationship Builder

It’s really very confusing to keep track of many relationships that might occur in a very large database. Relationship in MS Access terms can be defined as one table being used in multiple tables in a database having common fields in more than one table which can involve primary and foreign key. Through Relationship builder you can have the clear picture of how the relationships between the tables... Read More »

How To Create MS Access Report by Selecting Indv Record

Microsoft Access is a part of Microsoft Office Suite and is available in the professional and higher editions of Office. The latest version of Microsoft Access is Access 2010 and this was released as an application in the new Office 2010 Suit in May 2010. Access has been the first choice for keeping databases and information for quite some time now and it serves as the backend of many database applications.... Read More »