-
Excel Power Query Saves Time
In Microsoft Excel, you’ve probably seen Power Pivot and Data Model, but have you discovered Power Query? Power Query is a tool introduced in 2013, which is available to all users who have Excel 2016 or later and/o...Read Moreabout: Excel Power Query Saves Time -
Creating Quick, Easy, and Cheap Video Tutorials for Data Consumers
Eight years ago, the Association of Schools and Programs of Public Health (ASPPH) launched on online system of annual reporting and analytics for our member graduate schools and programs. Members were eager to stop repor...Read Moreabout: Creating Quick, Easy, and Cheap Video Tutorials for Data Consumers -
Using the Excel Time Function
I have been working on planning a conference for an organization and need to create a daily agenda. In the past, this task would be achieved by using some combination of cutting, pasting, and filling within Excel. Recent...Read Moreabout: Using the Excel Time Function -
Excel MEDIAN IF Array Formula
A MEDIAN IF array formula in Excel will identify the middle number of values that meet certain criteria. An array formula performs an operation on multiple values instead of a single value. In this array formula, we esse...Read Moreabout: Excel MEDIAN IF Array Formula -
Side-by-Side Comparison Charts
Figure 1. Ethnicity Table The columns I used for the chart were Ethnicity, Georgia Percentage Positive, Georgia Percentage, and College Percentage (Figure 2). Excel 2016 is the software used to construct the chart. The ...Read Moreabout: Side-by-Side Comparison Charts
About eAIR
eAIR is the newsletter of the Association for Institutional Research (AIR). From its start in October 1987 to today, eAIR remains one of the most important tools for providing news to the higher education community.
View Articles By Column
- Special Feature (3)
- Featured (73)
- National Survey Data Bite (49)
- Tech Tips (34)
- Board Corner (35)
- Special Feature / Interview (25)
- Interview (5)
- Ask eAIR (20)
- IPEDS/NCES (9)
- IR In The Know (34)
- Visual Displays of Data (23)
Hot Topics
- COVID (1)
- Ethics Spotlight (3)
Subscribe
Create a free account or update your communication preferences to receive the eAIR newsletter.
Thank You
2021 Editorial Committee
Association at a Glance
Featured Opportunities
AIR Foundations Workshops
Introducing the skills needed for a strong data-informed decision culture. Designed for anyone who works closely with data in higher ed—not just IR professionals.
Coffee Chats
A casual opportunity to connect thoughtfully around various questions and challenges we’re facing.
Always free for members.
Did you know?
AIR welcomes brief conference/event announcements of interest to the IR and higher education communities.
Learn More
Recent Discussions
Listings Closing Soon
Total jobs: 3
| Job Title | Institution | Location | Salary Range | Application Due Date | Control Column |
|---|---|---|---|---|---|
| Research Associate | University of Central Arkansas | AR | $0 - $56100 | 2022-12-31 | |
| Institutional Effectiveness Senior Research Associate | Loyola University Chicago | IL | Dependent on qualifications and experience | 2022-12-31 | |
| Program Assessment Analyst | Massachusetts Institute of Technology | MA | $60050 - $99090 | 2022-12-31 |