Excel's Data Model feature allows you to build relationships between data sets for easier reporting. Here's how to use it to make data analysis easier.

FTP Download Step one is to fetch the latest data from another server via FTP. In Windows you can accomplish this using a script to send ftp commands.

Learn more about AJAX, a technique that uses JavaScript and the XMLHTTPRequest object to create faster and better interactive web apps.