Tech Tips

​This long-running eAIR feature is a resource for simplifying and streamlining IR activities. Often supported by step-by-step instructions, each tip provides solutions to common software or data issues of interest to IR and assessment professionals.
All submissions are peer reviewed by volunteers before being published in eAIR. To submit a Tech Tip or suggest a topic for consideration, please contact eAIR​

April 2014

Barry Nagle, Managing Partner/Senior Researcher, Evaluation and Action Research Associates shares this tip on Installing and Using RExcel.

Gary Moser, Institutional Research, Analysis, and Decision Support Analyst, California State University-East Bay, shares a Tech Tip about Using Reference Management Software.

Past Tech Tips

Using Excel SUBTOTAL Functions

Specifying Output in SAS

Domain Functions in Microsoft Access

Mapping Admission Data with Google Maps Engine

Merging Two Worksheets with AbleBits Excel Add-In

Using the VLOOKUP Function in Microsoft Excel

Publishing MS Excel 2010 Dashboard Online Using SkyDrive


Excel Text to Columns Feature

Adding Custom Page Numbering to a PDF

Using the Camera Function in Excel.

Data Validation in Excel

Setting up a Simple Interactive Dashboard Using Excel 2010 “Slicers.”

AGGREGATE Function in Excel 2010