Category Archives: Software

WordPress Error “Allowed memory size of XXXXXX bytes exhausted” Resolution

With recent versions of WordPress the error message has started displaying in Dashboard.

“Fatal Error: Allowed memory size of XXXXXX bytes exhausted (tried to allocate YYYY bytes)”

By default WordPress tries to allocate 32MB to PHP. You would need to manually increase the allocated memory to fix the error. Read More »

Pivot table Tutorial in Excel 2007

Pivot table is great tool in Excel to create reports and analyze data. Go thru the simple exercise below to understand the concept Read More »

How to add a control multiple times in Excel VBA Forms

You can drag a control to place it on the form. If you want to place again, you need to drag it again. Read More »

What is Object Linking and Embedding (OLE)

OLE is technology developed by Microsoft to make different programs interact with each other to make each program more useful and visually appealing. OLE object can be embedded into different application; they however retain original format and link to originating program. Read More »

Data Validation in Excel

When you need to verify data that can go in a cell, Data validation is the function in Excel to use. Read More »

Conditional Formatting in Excel 2007

Conditional Formatting allows changing appearance (different color, font, format etc) of cell based on certain condition. For example you can show employees with Salary Higher than 100000 USD in Red. This makes easy and visually appealing to read and interpret data. Read More »

How to work on multiple controls simultaneously in Excel VBA Forms

You can work on the multiple controls at the same time and change properties. Keep holding Ctrl key and select multiple controls (such as labels). Read More »

Norton Toolbar extension for Firefox 3.5 released

Wait for using Norton with Firefox 3.5 is over. You can apply the hotfix released for Norton Internet Security 2009, Norton Antivirus 2009, Identity Safe and Norton 360 3.0 . Read More »

Steps for Migrating AdSense Manager to Advertising Manager Plugin in WordPress

AdSense Manager WordPress Plugin is being rebranded and developed as Advertising Manager Plug in now. If you have upgraded WordPress, then you might have noticed a massage at the top “AdSense Manager is now being developed as Advertising Manager for WordPress 2.5 and up. It is recommended you download and install today”. Follow these steps to switch to Advertising Manager Plugin. Read More »

Need Norton Toolbar add-on for Firefox 3.5 – Wait

If you have upgraded to Firefox 3.5 and looking to use Norton toolbar, Norton Internet Security (NIS) 2009 or other related plugins, you would need to wait for sometime. Read More »

Key Data Types in VBA

A data type communicates to program what kind of variable is needed in operation.

Here is a quick list of data types. Read More »

Extracting Data from Internet in Excel 2007

Excel 2007 comes with the option of querying web to export table data from internet. This is a very good option if you rely on constantly updated data such as exchange rates etc. Read More »

Important Windows Control used to design Form in Excel VBA

Form is the graphical container where other controls can be added to make user input logical and meaningful in Excel.

Here are the key controls Read More »

Rotate ads in WordPress using WPAds Plugin

If you want to rotate ads in your blog, WPAds Plugin can help you. Read More »

List of Formulas/Functions in Excel

Here is a quick reference of important formulas in MS Excel. Functions are pre-defined formulas in Excel and can be interchangeably used with term Formula. The list has been prepared using Excel 2007. But most of the formulas should be applicable to other versions as well. Read More »

Generate all routine WordPress Blog lists with Post-Plugin Library

Post Plugin Library is the base for installing number of other plugins to generate Similar Posts, Recent Posts, Random Posts, Popular Posts, and Recent Comments. This plugin is the prerequisite for installing all other wonderful Plugins. Read More »

Submit Sitemap to Search Engines using WordPress Google XML Sitemap Plugin

XML-Sitemap plugin automatically generates sitemap for submission to Search Engines. Generated Sitemap supports Google, Yahoo, MSN and Ask.com. Read More »

Clean Archive Reloaded Plugin generates Clean Archive for WordPress

Well, as the name suggests, Clean Archive Plugin generates a list of all posts, sorted by month. This does not generate summary or abstract for posts, just simple list of posts. Read More »

Track all WordPress feeds with FeedBurner FeedSmith plugin

FeedBurner FeedSmith plugin is one of the must have plugins for WordPress, if you are using FeedBurner for your RSS needs. The plugin will redirect all WordPress feeds to single FeedBurner feed and all RSS subscriptions will be properly counted. Read More »

Reply/Reply to all with original attachment in Outlook

Have you encountered need to reply or reply to all and leave the original attachment attached in outlook? I feel the need sometimes because I might want to add couple of more ids to reply to all. Read More »

Using What If Analysis Function Data Table in Excel

Data Table is a What If Analysis Function to find out result by altering an input cell in Excel. Read More »

Using Name Range in Excel

Name range in Excel is a way to define a range to be used in Formula. Read More »

Using Select Case Statement in VBA

If you have large number of conditions to verify, Select Case statement provides a way to check these conditions easily and in readable manner. Read More »

Relative, Absolute and Mixed References in Excel

There are different ways a cell can be referenced or called in Excel. Read More »

Different types of If statement with examples in VBA

Here is a list of If Statement for Visual Basic for Application. Read More »