technology | Excel & VBA

Javascript Charting Library

Posted on 06 July 2009

A Javascript charting library is a compilation of javascript code which helps you create charts in a browser. Here's a list of 5 Javascript charting libraries that I had a chance to review : (Each of the Javascript charting libraries reviewed below would offer its own custom functions to interact with the chart object. If a chart fits your need, you may want to read the chart library's API documentation in greater detail. However, if you're short on development time, this ...

Comments

SQL Statement Basics - Learn how to write SQL Statement

Posted on 13 May 2009

An SQL Statement is a statement written in SQL. Every SQL statement could be classified as either a Data Access Control Statement, Data Definition Statement, Data Manipulation and Retrieval Statement or a Data Transaction Control Statement. You can download a complete set of SQL statements (SQL Satement & Basics.pdf) here. This handbook describes most of the frequently used SQL statements and contains numerous examples of how to use those statements. ...

Comments (1)

House of Quality Template in Excel

Posted on 10 May 2009

You can download the house of quality template in excel here. House of quality is a graphic tool analyzing the relationship between a firm's focus on improvement and the needs of its customers.It is a part of the Quality Function Deployment (QFD). Visually, it looks like a grid with a correlation matrix at its top and left side. The customer needs vs the firm's product features form the main body of the house of quality. Using this template in ...

Comments

Excel to PDF Converters - List of Free Downloads

Posted on 18 April 2009

Ever wondered how do you convert your excel spreadsheets in to the PDF format? Here are a few tools (mostly free though some are free only during the trail period) that can help you convert from excel to the PDF format (.xls to .pdf). ExpressPDF ExpressPDF is a website based online excel to pdf conversion tool. You will need to submit the document to be converted on the website and ...

Comments

Top 10 Tips to Increase Blog Views and Traffic

Posted on 04 April 2009

If you have been wondering how to increase blog views for your blog, the following tips can come in handy. Mind you, the two most important factors to increase your blog views are - great content and large number of good quality links from other blogs to yours. If you can achieve both of these, rest should be easy to manage. Increase blog views by writing good content on your blog As ...

Comments (1)

Delete Old Calendar Entries and Meeting Requests from Outlook

Posted on 28 March 2009

All too often we let old calender entries and meeting requests accumulate in outlook resulting in the calender folder gradually bloating out of shape (and receiving the dreaded "your mailbox is over its size limit" message from the server) How do you solve the problem of deleting older calendar entries and meeting requests in outlook - well here's how: Go to your outlook ...

Comments