January 25, 2009 – 12:34 pm
|
By Gatt
|
Posted in Software
|
Application Object is the highest object in Excel, followed by Workbook, followed by Worksheet and followed by Column, Row and cell. You can select object by going from highest to lowest in Excel. Read More »
January 21, 2009 – 12:30 pm
|
By Gatt
|
Posted in Software
|
Loops are used to repeat actions. Read More »
You can use Scenarios to see what would happen to your bottom line figure if you change certain values. Read More »
December 16, 2008 – 12:22 pm
|
By Gatt
|
Posted in Software
|
What is VBA
Microsoft Office documents (Excel, Word etc) are shipped with extensive functionality which is more than enough for most users. But there may be a need for enhancement to these applications or automate certain tasks that standard versions of these software are not equipped with. For this purpose, Microsoft applications include a programming environment to add new functions to standard application. Read More »
December 6, 2008 – 12:12 pm
|
By Gatt
|
Posted in Software
|
When you know the result but are not sure of the input that would bring the desired result, Goal Seek function can help. Goal Seek is one of the” What If” analysis functions in Excel. Read More »
November 26, 2008 – 11:20 am
|
By Gatt
|
Posted in Software
|
If you want to use values from one worksheet to another, you would need to use a reference to the worksheet. Read More »
November 8, 2008 – 10:54 am
|
By Gatt
|
Posted in Software
|
Microsoft introduced new format with Office 2007. Word 2007 saves file as .docx. Excel 2007 saves file as .xlsx and so on. But most of the world is still using old versions of Office. These people might have trouble accessing your files. So, for the time being it might still make sense to save files in old doc or xls format. Read More »
October 16, 2008 – 11:15 am
|
By Gatt
|
Posted in Software
|
Here is a look at changes introduced with MS Office 2007. Read More »
September 9, 2008 – 10:16 am
|
By Gatt
|
Posted in Software
|
Do you have need for merging multiple PDF files or splitting a PDF file? PDFill is Windows utility you can use. Read More »
Computer Viruses are programs which can copy it and infect the computer and other programs. Virus authors and antivirus software try to defeat each other. Here are some of the ways viruses use to defeat antivirus software Read More »
Xenu’s Link Sleuth is wonderful software for checking broken links on entire site. The tool is free and simple to use. The software tool can crawl entire site following all the links. This tool is surprisingly fast to use. Read More »
Although there are many ways to get statistics for website, there are few things that set WordPress stats plugin from Auomattic apart. Read More »
Notepad++ is free open source Windows Source code editor and Notepad replacement. Primary feature is syntax highlighting and code editing. Notepad++ supports many languages. Read More »
WordPress Automatic Upgrade Plug in (WAUP) is an amazing plugin that can quickly upgrade the blog to the latest version. It follows recommended process for WordPress Blog upgrade which includes backing up blog (WP files and database), deactivating plugins, replacing files with current versions and then reactivating plug-ins. Read More »
Zero day exploit is taking advantage of security vulnerability before it is known and fixed. Hackers are becoming faster at exploiting vulnerabilities and takes advantage of time needed to know vulnerability, fix it and distribute the fix. Attackers can use this time to spread malwares such as viruses, worms etc. Read More »
WordPress 2.6 is released with new and improved features. Key features are version control (similar to Wikipedia), Google gears support, and ‘Press This’ bookmark for quick posting. Read More »
WordPress 2.5.1 seems to have an issue with iframe as code disappears if you open or edit the post/page in Visual Mode and save or publish it. Read More »
Computer worm is a program that replicates itself on the network and can be a real system hog. Worm can penetrate the network by using security vulnerability in the operating system or by opening a malicious attachment or link in an email message or chat session. Read More »
Anti-virus software is a computer program that works to keep computer free from virus and other malicious programs. There are multiple approaches, antivirus software use to identify viruses.
Dictionary method –In this method Anti virus program continue to match programs with the pre-identified virus definitions and then take appropriate option (quarantine or delete the infected file). New viruses are included in the dictionary as identified. Success of this method is based on how quickly new threats are identified and included in the dictionary. Read More »
If you recently installed Firefox 3 and were using UPEK Biometric fingerprint reader (Protector Suite QL/Fingerprint Reader Suite software), Passwordbank support may not have been installed in Firefox3 and Fingerprint reader will probably not work in Firefox. Read More »
After few days of desertion, Popular All in One SEO plug-in found a new author and maintainer. This plug-in was recently abandoned by its author but is back with new author. Read More »
Extremely popular WordPress SEO plugin is no longer supported and maintained by author. The current version of the plug in is compatible with latest WordPress release 2.5 . However, it may not be compatible with future releases. Read More »
With MYSAP ERP releases (ECC 5.0 onwards) SAP introduced New GL functionality. Most of the User interfaces and transactions remain same, however internal architecture and available functionality has changed significantly. Read More »
Free Software is similar to Open Source. Users must be able to freely use, study, copy, redistribute, modify, and publish modified versions of the software. Here free means Freedom to use rather than Free in price (as in Freewares). Both Free and Open Source have similar objectives but differ on which term is better to covey these objectives. Read More »
Open Source is a method of developing software in which Source Code is openly and freely available to use. This is different than Propriety or Closed Source Software where Source Code is not available at all or not available to copy and modify. Open Source Software is generally developed publicly in collaborative manner. Linux, Apache, Mozilla Firefox are some of the popular Open Source Software. Read More »
