Digital Spectrum

Have you been wondering what the difference is between the Excel functions =today() and =now()? The two functions display the current date but the only difference is that the =now() function also displays the current time. The two functions allow the date to be updated any time you reopen the your worksheet. If you do not want the date to be updated automatically, use the keyboard shortcut below in a cell where you want the date to be displayed. CTRL+; That is, use the CTRL and semicolon keys in a cell.

Making two or more Excel files to open side-by-side can be very cool and make work easier. You can accomplish this by carrying out a simple setting. Click on the big office button (Top left corner) Locate "Excel Options" button and click on it Select "Advanced" at the left. Scroll all the way down to locate "General Settings" Put a check mark in "Ignore other applications that use Dynamic Data Exchange. Click the OK button and open as many excel files as you want. They will appear separately. Hope this helps. Try leaving a comment...

Sometimes you might need to use the images on a word document for other things. A good example is a document received containing the images to be used for a web page design. These images can be quickly extracted without much work even if you have up to 200 images on the doc. Two unique methods will be discussed here. I personally prefer the second. METHOD 1: Save the document as a web page(HTML) Look for the folder containing the media files. Copy the files for your use. METHOD 2: Download and install WinRar. It is free. Launch the application when done. Drag and drop the Word document containing the images into the WinRar Window Look for the folder named Word. In this folder you will find another folder named Media. Open this and enjoy.

Your Acer D255E and it's equivalent has a recovery partition on the hard disc. It is a good practice to burn a recovery disc as soon as your purchase this netbook. However, if you do not have the recovery disc you can follow the steps below to get your system back to factory default. Restart your system and press the ALT and F10 keys simultaneously while the system is booting. You are presented with series of screen. Follow the wizard carefully. If you have questions post them here in the comment section.

Installing a program called aTube catcher recently gave me the opportunity to download mp3 files of my choice. The application aTube catcher is a free program for downloading videos from youtube and other video hosting sites. But after installing this app I was given the additional application called MP3 Downloader which I now use to download thousands of MP3 files without much effort. Follow the steps: Google search "aTube Catcher Install it when done Check your desktop for the icon MP3 Downloader Launch it and you should see the screen below Type a song title or artiste in the Hot Search bar and press enter key. You instantly see a list of the files. Some with lyrics and some without. Select one and click on Download button. Enjoy

There is no doubt that android applications are becoming more and more popular by the day. However, you need android based phones or tablets to run them. Today, this restriction has been removed. You can now run your favorite android applications on Windows. This is only possible on AMD driven machines. 1. To get this done, proceed to www.bluestacks.com to download the player. 2. Install the player and you should be good to go.

I got this message from my Internet Explorer today "Internet Explorer Has Stopped Working", and I had to fix the problem with the following procedure. I believe it will work for you too. 1. Close any instance of Internet Explorer 2. Click on Start button 3. Click Control Panel 4. Click Internet Options 5. Click the Advanced tab 6. Click on Reset button 7. Click on the Reset button again 8. Click Close 9. Now you can launch Internet Explorer Hope this helps... You may leave a message here.

You can renew your startimes subscription by simply login-in to your account on the startimes web page. This is quite easy and convenient. Steps: Go to www.startimes.com.ng Point at "customer care" and select "Self Care" Enter your smart card number Enter 123456 in the password field if you login for the first time. Change this password to your own. Enter the chek code shown and click login button. You can then select the link that allows you to load a card For more information click here You can contact me through the form below:

Do you love hilarious jokes in your events. Contact this friend to MC your ceremonies and your guests can't stop laughing. humourprince1.blogspot.com

When you push the power button on your laptop, what action does it perform? You can set this based on what you want the button to do any time you push it. If you use Windows 7, you can follow the 5 easy steps bellow: 1. Right-click on the START button 2. Select properties 3. Click on START MENU tab 4. Look for the "Power button action :" and click on the drop down button 5. Select any of the following options:  Switch user  Log off  Lock  Restart  Sleep  Hibernate  Shut down 5. Click "OK" button Hope this helps. Try leaving a comment.

One of the best modems in the country and in Lagos in particular is Visafone. There is no doubt that Visafone connection is second to none. I have used various modems at different points in recent time and some of my friends use others too. But these friends always come bombarding me with questions on how to get a faster connection. They have never been disppointed by my suggestions. For my friends already using this modem, please stop calling me to help you load your modem. Just grab a visafone phone and take the following steps for the 3GB for 30 days subscription : See their website for more... 1. Load 6000 naira for instance in the phone. 2. Dial the code *444*652*Modem Number# 3. You get a message asking you to confirm with a code. 4. Use this code to confirm and wait for another mesage that confirms for subscription. The above information is the 3GB monthly subscription. For more information, go to visafone page.

Coming up......

I am personally tired of installing third party software to download from www.youtube.com . The simple way to download from youtube on any computer is to first open the video you want to download. Copy the url of the video. Launch www.keepvid.com and paste the url in the field provided. Click on the download button. Follow the wizard until your video starts downloading. In summary: 1. Launch youtube.com 2. Search for your video. 3. Copy the url of the video from youtubbe address bar into keepvid.com 4. Click download 5. Follow the wizard to complete the task.... 6. Enjoy... If you have any question leave a comment....

PHPMagic is a great tool if you are a php programmer like me. PhpMagic makes the creation of your apps a breeze. All you need do is to define the look of your db by a simple selection process and PHPMagic generates the codes for you. You may edit the codes generated. Make sure you test the app on your localhost before uploading to your on-line server. Read more...

One of the great tools I use to protect my computer from the menace of virus and other threats is Norton Internet Security. Apart from protecting your system from malware, it also has a strong firewall which creates security against on-line hackers and other ills. I strongly recommend NIS. There is a new version every year. Go to NIS site