Pivot table is great tool in Excel to create reports and analyze data. Go thru the simple exercise below to understand the concept
You can drag a control to place it on the form. If you want to place again, you need to drag it again.
Yahoo and Microsoft announced a search deal. Bing (from Microsoft) becomes search engine behind Yahoo. Yahoo gets the ad revenue share and saves money not having to build search. Microsoft gets Yahoo search traffic. With the announcement, Yahoo goes back to being a Portal Company. The deal is the biggest development in Search Arena in [...]
A data type communicates to program what kind of variable is needed in operation. Here is a quick list of data types.
Bing recently replaced Live Search. Bing is much better version of Live Search and got really good response from community.
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.
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.
If you have large number of conditions to verify, Select Case statement provides a way to check these conditions easily and in readable manner.
There are different ways a cell can be referenced or called in Excel.
Here is a list of If Statement for Visual Basic for Application.
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.
Loops are used to repeat actions.