Report Automation Using Excel
Report Automation Using Excel
Alison Joseph, David Onder, and Billy Hutchings
NCAIR Summer Drive-in 2013
1
?
? 9608 students ? Master's Comprehensive ? Mountain location ? Residential and Distance
2
Why automate?
? Efficiency ? Time
? Mitigates problems related to staff turn-over
? Consistency ? Data (same queries/criteria) ? Format/design/branding
? Timeliness ? Reports are ready as soon as data is available
3
What to automate?
? Same report generated throughout the year(s) ? Fact Book ? Census reports ? Admissions reports ? Facilities utilization ? Class-level profiles ? Grade distribution
? Same report generated at the same time for several different groups ? Program/Dept. profiles ? Main campus v. other teaching sites/distance ? Legislative reports
4
What can be included?
? Data tables ? Graphs ? Complex graphics (e.g., maps with enrollment) ? Cover pages ? Branding/logos
5
................
................
In order to avoid copyright disputes, this page is only a partial summary.
To fulfill the demand for quickly locating and searching documents.
It is intelligent file search solution for home and business.
Related download
- how to mail merge pdf documents
- snail mail to emails generating auto emails from sas
- how to use publications and schedule reports
- report automation using excel
- how to automate data refresh using windows task
- creating a slider in excel
- how to integrate excel spreadsheet into ms outlook
- creating an email mail merge from an excel file windows pc
- excel 2016 tips tricks colorado state university
- you have got sasmail simple sas macro for sending e mails
Related searches
- using excel to analyze stocks
- converting pdf to excel using adobe reader
- using excel for statistical calculations
- excel formula using colored cells
- using excel for timesheet
- using variables in excel formulas
- using excel for statistics class
- excel conditional formatting using formula
- using excel for inventory management
- excel using vlookup in if statement
- excel using variables in formulas
- using excel for statistics