This is the Query tag.

VBA icon

An Introduction to YQL for VBA

YQL logo

YQL is a flavor of SQL that allows you to query Yahoo's databases in a simple way. In Yahoo's words:

The Yahoo! Query Language is an expressive SQL-like language that lets you query, filter, and join data across Web services. With YQL, apps run faster with fewer lines of code and a smaller network footprint.

Yahoo! and other websites across the Internet make much of their structured data available to developers, primarily through Web services. To access and query these services, developers traditionally endure the pain of locating the right URLs and documentation to access and query each Web service.

With YQL, developers can access and shape data across the Internet through one simple language, eliminating the need to learn how to call different APIs.

Continue Reading »

Excel icon

Get fat with Excel

All of the talk about losing weight after the holidays (see Excel Weight Loss Tracker for one) has me swinging in the other direction. They say that as a result of posting the calorie counts at restaurants (as required here in NYC), people are responding by making more responsible food choices, but I think it's safe to start eating some high fat, high calorie meals again.

Continue Reading »

learn excel dashboards