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​

December 2018

Josh Rosales, Research Analyst, El Camino College shared a Tech Tip on creating a Clear Slicer Button in Excel and Dana Prymak, Research Associate, Thompson Rivers University also shared a tip for Tableau users. 

Past Tech Tips

Importing/Exporting Fixed-Width Data with R

Toy Models for Fun & Profit

Customized Help for Excel Workbooks

Microsoft Access: an Introduction to VBA Programming

Perfecting StudentTracker® Data Elements

Pivot Tables, VLOOKUP, and Absolute/Relative Formula References.

Row-Level Data Containing Duplicate IDs

Automating Surveys with Python, Qualtrics API, and Windows Task Scheduler

Variable/Value Labels: SPSS Syntax with Excel

Microsoft Outlook Email Search Syntax

Formatting Numeric Data to “Millions” in Excel

Data Validation in R

ASAP Utilities for Excel

Using a Zeros Table in Microsoft Access

Excel Chi-Square Test With VBA

Building an Excel Form or Survey

Using Qualtrics for Survey Design

Mapping Student Enrollment Data with R

INDIRECT Function in Excel

Converting Text Columns to Fixed-Width Text in Excel

Project Management: Microsoft Planner

Using Tableau Parameters

Using CONCATENATE in Excel to Create STATA Commands 

Using the RAND Function in Excel

Creating Word Clouds with Online Tools/Tableau

Using VBA in Excel To Work With Sliders

Using QDA Miner Lite

Using the DateDiff Function in Access

Using Stata in Multiple Response Sets

Using the LOOKUP COLUMN Function

Using the Criteria Field in Microsoft Access

Using LAG in SPSS

Creating a Gauge Chart in Excel

Using Dashboards in Excel

Merging Multiple Reviewer feedback into one Document

Using Excel Text Formulas

Windows Command Prompt

Using the Status Bar in Excel

Creating an Excel Menu Worksheet

Filling in Blank Spaces in Data

Creating a Percent Change Field

Excel Indexing and Spinner Controls

Easy Excel Data Entry Form

Excel's SUMPRODUCT Function

Introduction to Google Script

Qualtrics Drill Down.

Using REXCEL to Reshape or Aggregate Data

Using Macros in Microsoft Word to Export Codes and Notes

Lookup in Excel Using Multiple Criteria

Excel Combining Rows Wizard

Essential Excel Shortcuts

Creating a Thermometer Chart in Excel

Tiger Line Shapefiles

Using the FRED Excel Add-In

Using Reference Management Software

Installing and Using RExcel

Using Excel SUBTOTAL Functions

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