Month: October 2010

5 Tips to work efficiently on Excel

Microsoft Excel is one of the essential tools used at home or office in order to organize data, that can be retrieved and updated effectively. However there are many users, that are not aware of some of the best tips or shortcuts to work more efficiently. Some of the tips to work efficiently in excel can be listed as follow: Tip1: Always know what you have to do. At times it happens that people start working on Excel files and start entering and manipulating data in it. Although in such cases they reach to what they were targeting but often it results in redundancy of data and high usage of functions. It is good to understand what kind of data you have and what all information can be retrieved from it. Why to waste time fetching something which cannot be fetched from the given data. Tip2: Know more and more about the application. Excel shows a very little about it when you look it at a glance but when you go through the various menus or Ribbons you will find a lot in it. If you are new to Excel then make a habit of giving at least 15-20 minutes daily in browsing the new features and the functions available in Excel. I would suggest you to go by function categories. First try all the lookup functions as they are the one’s...

Read More

Download Microsoft templates

At times we waste our time in writing or designing some professional documents like our Resume, Offer Letter, Cover letters etc but what of someone does it all for us. No need to wait for someone to do it for you because Microsoft has already done the same. If you have never noticed then please open Microsoft Word, go to the New option and then click on templates. Here you will find around 40 categories and each category has many templates for you to work upon. It has elegant style resume sample, it has Brochure, Envelopes, and design for almost every professional letter or document. All you need is to have a copy of your Microsoft office application suit and a working Internet connection. We need a working internet connection because these templates are not installed on your hard drive but are on the Microsoft Office Server. You can select the desired template and install it on your computer for current or future use. In this post I will let you know how to download the templates and use them. Step1: Open Microsoft Word and then if you get a new file opened automatically then click on the File menu and close it. Step2: Click on the File Menu (in older versions) or click on the Office button and then click on New. Step3: Click on Online templates. Step4:...

Read More

Tips to Playback movies on Windows Media Center and Xbox

If your computer is running Windows 7 or Windows Vista, you have many options to watch a movie with great experience. You can record a movie from TV or download from the Internet and watch the movie at home.This article we will discuss how to watch movies and videos with Windows and Xbox. Although Xbox is a gaming console, you can however do other tasks such as watching movies or videos. Watching and downloading movies The Windows Vista & Windows 7 comes with Windows Media center which they offer free movie downloads through television networks. There is no need to subscribe any show in Windows Media center. Downloading a normal 2 hour movie normally takes more than one hour or more sometimes on any high-speed connections. Besides downloading duration, you also need minimum 2 GB hard disk space to save it on computer. If you do not want to wait and spend that much time then you can watch a movie while it is downloading. So, to download a movie, follow the steps given below: First open the Windows Media Center, then on the start screen, click movies. In movies window click movie Library. Now in the library, you will have to select the movie provider you want to use. Now follow the instructions for registration and login. Grab a movie on Xbox Live If you are using an...

Read More

How to add more memory to your computer

Programs and applications have increasingly become resource hungry. They need more RAM for working smoothly without the momentary lockups of the operating system. It’s not only the applications on which you work but the operating system also demands more RAM modules of large capacities. Days are gone when Windows 98 used to work efficiently with just 32 MB of RAM; it’s the time of Windows Vista and Windows 7 which requires a minimum of 1 GB RAM. (minimum 1GB). With this much amount of RAM Windows will only work without complaining but will often get tired and stop doing its bit. So if you have to get the most out of the new babies of Windows then you need a 4 GB chip of the Random Access Memory. Users often say that they have large amounts of hard drive space on their computer but still their computer runs slow. The Answer to this is that hard drive plays an important role in enhancing the performance of any computer but it does not play the vital role. The Vital role is played only by the RAM and the Processor off course. If you don’t have enough RAM on your computer than your computers operating system would not be able to feed the necessary amount of data to the processor for processing and will increase the delay of every activity. Further...

Read More

How to Import Excel Files in MS SQL

Microsoft Excel is a very popular and most used program used in building spreadsheets and commonly used in storing data. You can not use Excel as a database but can easily export or import data from and to databases using MS SQL. So you can create a backup of your data base in Excel format and also you can use it as a readable format for the distribution of information.  This is a very useful ability and using this ability, a database architect can merge data from multiple sources into one central location to conduct analysis. To import from Excel to MS SQL, just follow the steps given below. Step1: First step is to upload the Excel file to your server by using the file chooser on your web server control panel. And then select the Excel file from your computer’s local drive to upload. Step2: Now you will have to create a SQL connection to the Excel file using the following code described below: Set fso = Server.CreateObject(“Scripting.FileSystemObject”) psFilePath = “file.xls” sPath = server.MapPath(“\”) psFilePath = fso.BuildPath(sPath,psFilePath) ‘Response.Write psFilePath ‘ Response.End Step3: Now the next step is to add Excel information to the SQL database using the code given below: if update = “true” Then set g_conn = open_db() set objRegExp = New RegExp objRegExp.Pattern = “,” objRegExp.Global = tru Step4: After importing the data from Excel to MS...

Read More