Campus ID News
Card, mobile credential, payment and security
FEATURED
PARTNERS
NACCU Logo2022

NACCU Blog: An Excel tip for the card office pro

Andrew Hudson   ||   Dec 02, 2022  ||   

In the latest installment of the National Association of Campus Card Users (NACCU) Positive IDentity Blog, Georgian College's Jen McDonald shares an Excel formula that she can't live without. An Excel enthusiast, McDonald works in Georgian College's ONEcard Office and discovered a helpful formula for the job's accounting demands.

"Before I began my role in the ONEcard Office, I had a basic understanding of Excel and primarily used it for data tracking and quick stats," writes McDonald. "Once I joined the card office, and now needed to add accounting tasks to my list of responsibilities, I quickly realized the value of upping my skill level in all things Excel."

The invaluable Excel formula that she now swears by is the VLOOKUP.

"If you’re already familiar with this little gem, then I likely don’t need to tell you how helpful it can be," says McDonald.

For those unfamiliar, McDonald illustrates the importance of the formula.

"I find myself frequently, in fact on an almost daily basis, needing to combine data from two different sets," she explains. "A few examples would be needing to compare a list of registered students to a list of accounts with balances, or perhaps you want to compare data in your test environment to that of PROD."

That, according to McDonald, is where VLOOKUP comes in. She offers some top tips for maximizing the effectiveness of the formula:

  1. Make sure that the identifier you have chosen is converted to the appropriate format. This can be done by selecting the column, then selecting “Text to columns” in the Data tab.
  2. Ensure that the identifier in each table is in the same column location. For me, I always have it in the first column. For example, if you’re using student/account number because it exists in both sets of data, have the student/account numbers in column A in both tables.
  3. After selecting all of the data in the second table, be sure to press F4. This establishes that you want to check the entire table, and not just the area relative to where the original line occurs.

McDonald concludes her blog entry by soliciting advice from fellow card office pros for their own Excel formula suggestions. "I would love to hear about it! Okay, maybe love is a little strong, but I would certainly find it interesting."

|| TAGS:
Subscribe to our weekly newsletter

RECENT ARTICLES

Brista Hurst UT Tyler

Learn to analyze card system data at NACCU’s popular Data Summit

In a recent CampusIDNews Chats interview, Brista Hurst-Kent, Business Technology Services Manager at the University of Texas at Tyler, shared her experience attending the NACCU Data Summit. This two-day workshop focused on empowering participants to use common reporting tools – specifically Microsoft Excel with Power Pivot and Power Query – to create interactive dashboards that […]
Credentials 101 Series banner

Understanding chip options for contactless campus cards

Three main components underly modern credential technology – chips, formats, and encryption. Each are applicable to both cards and mobile credentials and understanding them is key to making informed decisions for your campus card program. In this series of articles, we will dive into each component, but first a brief preview. Chips are the core of […]
Apex OrderHQ Array modular lockers
Jul 02, 25 /

Modular locker solution streamlines campus order pickup

Apex Order Pickup Solutions launched a new modular system of automated order pickup lockers that can be stacked or setup in custom configurations. The OrderHQ Array Series lockers work in any floor plan without expensive remodeling. In an interview with Food On Demand, Kent Savage, founder and executive chairman of Apex Order Pickup Solutions, compares […]
CIDN logo reversed
The only publication dedicated to the use of campus cards, mobile credentials, identity and security technology in the education market. CampusIDNews – formerly CR80News – has served more than 6,500 subscribers for more than two decades.
Twitter

Attn: friends in the biometrics space. Nominations close Friday for the annual Women in Biometrics Awards. Take five minutes to recognize a colleague or even yourself. http://WomenInBiometrics.com

Feb. 1 webinar explores how mobile ordering enhanced campus life, increased sales at UVA and Central Washington @Grubhub @CBORD

Load More...
Contact
CampusIDNews is published by AVISIAN Publishing
315 E. Georgia St.
Tallahassee, FL 32301
www.AVISIAN.com[email protected]
Use our contact form to submit tips, corrections, or questions to our team.
©2025 CampusIDNews. All rights reserved.