average time to get doctorate degree
Deans call loudly and frequently for streamlined degree programs, and many, if not most, graduate directors have been asked to figure out ways to reduce the amount of time students spend in graduate school. Yet time to degree remains stubbornly high. It's lowest in the sciences, where students still take about seven years to earn a Ph.D., and highest in education, where doctoral students take about 12 years (though students earning education Ph.D.'s often work full time while they study).
You can use Get External Data (dispite its name), located in the 'Data' tab of Excel 2010, to set up a connection in a workbook to query data from itself. Use From Other Sources From Microsoft Query to connect to Excel. Once set up you can use VBA to manipulate the connection to, among other thing, view and modify the SQL command that drives the query. This query does reference the in memory workbook, so doen't require a save to refresh the latest data.