Home » TechGenie Answers
TechGenie Answers
How To Link Data to Different Worksheets in Microsoft Excel
You may sometimes require the same data on multiple sheets, in which you would need the data to be updated on multiple sheets at the same time. In Microsoft Excel you don’t have to type everything twice, you can link up the data together.
Different worksheets provide a logical and intuitive way to organize your data in Microsoft Excel, in these cases multiple worksheets are used to further separate... Read More »
How To Fix the “C:\Documents.xls’ could not be found.” Error in MS Excel
Have you ever encountered the error “C:\Documents.xls could not be found” in excel. Well, this error is not a generic error that is most often encountered in using MS Excel. When you open any Excel spreadsheet by double clicking the file, it successfully opens but so does the error, “C:\Documents.xls’ could not be found”, display? You can check the spelling of the filename and you... Read More »
How to troubleshoot problems of Windows Phone 7
Windows phone 7 is the latest of release in the line of smartphone. In comparison to its predecessor-Windows Phone, Windows Phone 7 is a hallmark of a new operating system that is specifically dedicated to smartphones. As a new OS Windows Phone 7 has some problems that may take time for users to to use to. In order to troubleshoot some of these problems, please follow the instructions stated below:
Windows... Read More »
Troubleshooting problems with Windows Live ID
Through Windows Live ID you can access your Xbox game account, mails, messages, photos, media, documents, and much more using one single Windows Live account and its password. But what if you have more than one Windows Live account? You might want to use all the accounts for mailing purposes but how to decide which account you should be using for communicating and connecting with other resources which... Read More »
How to use Microsoft Excel for Statistical Analysis
MS excel can also be used for doing Statistical analysis, It requires you to learn the associated Excel functions in order to perform the specific statistical analysis task.
In this article you can find how to perform the most important statistical analysis using MS Excel. Following are the important statistical analysis tasks which scientists, engineers and even people in the financial sectors should... Read More »
Top 5 tips on working on Windows Phone
Microsoft has just recently launched a Windows Phone, which integrates various applications of MS office and provides seamless navigation in mobile phones. Since its a new phone in the market, there are still a lot of consumers that have gotten used to the applications and the interface the the phone has to offer.
Here are some tips that may help you to understand Windows Phone better.
Copilot... Read More »
How to Create a BOM Using MS Excel
BOM or Bill of Material is a documentation for all the raw material, components and other parts and quantities but it is not necessary that all the physical material are described in BOM. It contains all the major information and list of components for the project.
There are number of ways to make BOM and you can do that by using MS Excel as well. This wonderful tool and the statistics and calculation... Read More »
How Plot a complex Graphs in Microsoft Excel
Microsoft Excel is main part of Microsoft Office and without MS Excel MS Office would not be complete. Microsoft Excel allows you to organize data in a meaningful way. However sometimes you may need to represent data graphically, and in such cases it is necessary to plot a graph to analyse data from various perspectives.
To plot a graph by using Microsoft Excel, following are the steps through which... Read More »
How to Track your Bills in Microsoft Excel
If you have started making larger purchases, including houses, vehicles, etc. and it is getting harder for you to remember all the bills you have to pay or have already have paid and when they are due. You just need to create a Bill Tracking sheet in Microsoft Excel an user friendly way just to keep track of paid bills and also shows how much you have spent each month.
Following are the ways you can... Read More »
How to Restore Microsoft Excel to Its Default Spreadsheet
Microsoft Excel is used as a spreadsheet tool for performing calculations, analyzing data and integrating information.
Here are some of the basic steps to restore the default settings in spreadsheet:
Step 1:
If you want to restore Microsoft Excel to its default Spreadsheet, you can go to my computer then Documents and Settings folder, open your username and then Application Data, Microsoft and finally... Read More »
How to Check Voicemail in Windows Phone 7
Windows Phone 7 was launched in October in Australia, Europe and Singapore and was released in the month on November in US/Canada. Asian consumers still have to wait till 2011 to use this wonderful mobile platform. It is bundled with wonderful compatibility with hardware and software and featuring Microsoft applications.
The application comes with so many great and unique features and some of the... Read More »
How to Reset Windows Live ID password in Windows Phone 7
There are time when you forget your password or you might also need to reset/change the password for security reasons and like any other service providers, Microsoft also provides the functionality to change and reset the Windows Live password.
Here are some of the very simple steps to change/reset the Windows Live ID password:
Step1:
The first thing you need to do is to open the Windows Live Solution... Read More »
How to Light up your phone with Windows Live in Windows Phone 7
Through a Windows Live account in Windows Phone 7 you can share and sync with many devices and users. You can share your computers data on the phone and you can sync your emails between the computer and the phone. You can chat with your friends and you can even share your data on some remote location. The best feature of using Windows Live account on your Windows Phone is that you can stay connected... Read More »
How to use MS Excel as a tool for interpreting data
MS Excel is a powerful tool for interpreting data. It is a spreadsheet application. You can use this for sorting data, creating charts and performing complex calculations.
You can interpret data various types which are following:
Create a filter for your data:
First step is to open the spreadsheet which you want to interpret the data.
Highlight the data which you want to filter, including headings.
Click... Read More »
Advantages and Disadvantages of Microsoft Lync Server
Communication servers are a new way to provide internal communication in an organization. It provides various kind of communication like mail, chat, conference, etc.
Microsoft Lync Server was previously known as Microsoft Office Communications Server and as it names suggest it was originally designed to provide communication related solutions to business and corporate. It supports all kinds of organizational... Read More »
Top 5 Uses of Windows Live Meetings
Corporate and MNCs are regularly in need for a way to communicate with the overseas clients and professional. With the increasing growth of the global business market, it is getting increasingly difficult to be connected with other office branches and professionals and clients working offshore. There are various tools which can be used for the proper business functioning like emails, telephonic conferencing.... Read More »
5 Good computing habits
Computers have become our daily need and we spend a lot of time sitting in front of it and working on it. We depend so much on computers that now it is hard to think of a world without computers. We use computers at work, at home, at schools and at every possible place in every possible manner. Since we work and rely so much on computers so will it not be good to keep your computer in a good shape... Read More »
How to edit movies through Windows movie maker
If you have a computer with Windows operating system on it and a video recording camera which can be connected to the computer to transfer the captured video then you are well equipped to edit your own movies. You can shoot the video and can easily edit it on your computer and make it viewable and interesting. You can add special effects to it, cut unnecessary portions from it and make it a small... Read More »
How to build the ultimate digital music jukebox
Windows Media Player 11 is the next generation media player designed and developed by Microsoft. It comes with impeccable visual effects and wonderful in built tools which can be used to make the ultimate music jukebox.
Here are some of the tips for music lovers to build the ultimate digital music jukebox using Windows Media player 11:
Customize the playlist:
Using Media Player 11, you can instantly... Read More »
How to work on Windows live essentials
Windows Live Essentials is a suit of many applications which earlier were released as separate standalone applications but now are the part of Windows Live Essentials. For example the MSN messenger, Windows Movie Maker, Windows Mail etc were earlier separate software and were separately available along with the operating system but now they are a part of the Windows Live Essential suite and can be... Read More »
How to change the input language of your keyboard
Now computer systems have almost completely phased out the usage of old typewriters and almost every publishing and documentation task is done on computers now. Doing the documentation task on computers gained massive acceptability because it is very easy to create documents on computers, make the changes, make language changes, change the fonts, and editing the entire document. Computers have proved... Read More »
How to troubleshoot with on-screen keyboard
A Keyboard is a collection of various input keys and can be termed as computer typewriter which are used to prepare documents and provide various important commands to computer. There have been huge improvements in keyboard development and there are various types of keyboard available in the market like wireless keyboard, USB keyboard, etc and apart from that there are also alternative input devices... Read More »
How to Download Dreamscenes for Windows Vista Home Premium
Unlike Windows Vista Ultimate the Home Premium does not come configured with DreamScene. But there is no reason to worry as there are plenty of hacks available on the net that would help you install DreamScene on your Windows Vista Home Premium.
Steps to install DreamScenes for Windows Vista Home Premium
Click here to download unzip file of “NonUltimateDreamScene” installer.
Unzip the... Read More »
Convert a Microsoft Word Table Into an Excel Workbook
Microsoft Office Word is a Text editor which has many formatting and advanced features for creating rich text documents. Not only text documents but you can at times receive some files which have tables in it. Though tables in a Word document are good for representing the data along with the other text of the document but tables in Word lack features like advanced calculations and formatting. This... Read More »
How to Create a MS Excel Skin
MS excel can be customize to get an attractive design of the spreadsheet. You can create a MS Excel skin; this process is same as applying wallpaper to a spreadsheet. A skin applied to a file reflects the sense of your style and uniqueness, it is also used to enhance the document you are creating. If you are applying any photograph or custom drawing then it can be used to cover the background of your... Read More »



























