Category Archives: How to?

How to?

Date Formulas and Functions in Microsoft Excel

Excel stores dates in sequential serial numbers beginning with January 1st, 1900 as 1.  January 1st, 2006 is 38718 because it’s 38,718 days after January 1st, 1900.  Excel on MAC works the same, except the dates start on January 1st, 1904. Don’t ask me why. Note: There are several different ways to do everything in […]

Named Ranges in Microsoft Excel

Names ranges can be very useful. Some people argue that point, whether using named ranges in VBA or formulas. The most common problem regarding names ranges, everyone agrees, is user ignorance of their existence in the application. Create a Named Range Select a range of cells using the Shift key, Shift+Ctrl, or Ctrl keys (yes, […]

Google apps stupported server list

Following server are listed to google apps – 123-reg.co.uk, 1and1, 4d Web Hosting, BT broadband office, cPanel, dnsExit, DNS Park, Domain Explorer, DomainSite, DreamHost, Dynadot, DynDNS, Enom, EveryDNS.net, Gandi.net, GoDaddy, iCodia, iPowerWeb, ix Web Hosting, Lxlabs, Name.com, Name.net, Namesecure, NearlyFreeSpeech, Netfirms, Network Solutions, No-IP, Registerfly.com, vserver.de, Webhost4Life, WHM, XName, Yahoo!, ZoneEdit

Microsoft Word – Enabling Macro Protection

Instructions for Word running on a Windows machine: Word 2000 Start Word Click on Tools, highlight Macro and click on Security Click on either Medium or High to select it Click on OK Click on OK again to close out of the options menu Word 2002 (XP) / 2003 Start Word Click on Tools and select Options Select the Security tab and click on the Macro […]

Remove All Hyperlinks in MS Word or Excel

Ever copy and paste something from the Internet and then into Word only to get the hyperlinks embedded? You can removed them easily with the Macros below. Word Hit [ALT]+[F11] to open the Visual Basic Editor Go to “Insert” > “Module” and in the pop-up window copy: Sub RemoveHyperlinks() Dim oField As Field For Each […]

Windows 7 Winsxs

What is Winsxs? The winsxs (Windows Side-by-Side) folder is a system folder. It would not be a good thing to delete this folder. A coworker recently received his every two year work laptop refresh and was in the middle of loading his new laptop with Vista. For some reason, his hard drive C: was partitioned […]

How to clear Skype IM Chat and Call History?

If you’re a frequent Skype user, you might have noticed that Skype keeps a record of all events including instant messages, calls, file transfers and SMS all stored and accessible from the Conversation tab by clicking on the Show History button. Deleting the chat and call history in Skype is easy, but the Delete History […]

Web browser

A web browser is a software application for retrieving, presenting, and traversing information resources on the World Wide Web. An information resource is identified by a Uniform Resource Identifier(URI) and may be a web page, image, video, or other piece of content. Hyperlinks present in resources enable users to easily navigate their browsers to related resources. Although browsers are primarily intended to […]

Backlink

Backlinks are incoming links to a website or web page. Inbound links were originally important (prior to the emergence of search engines) as a primary means of web navigation; today their significance lies in search engine optimization (SEO). The number of backlinks is one indication of the popularity or importance of that website or page […]

HTTP referrer

The referrer, or HTTP referrer—also known by the common misspelling referer that occurs as an HTTP header field—identifies, from the point of view of an internet webpage or resource, the address of the webpage (commonly the URL, the more generic URI or the i18n updated IRI) of the resource which links to it. By checking […]