Campus ID News
Card, mobile credential, payment and security
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


May 26, 23 / ,

Penn State adds mobile ordering to campus app

Penn State has added a mobile ordering feature to its comprehensive campus mobile app, Penn State Go. The Penn State Eats Mobile function is available for use by students on the flagship University Park campus, as well as across the university's Commonwealth Campuses.
May 26, 23 / ,

NAU leverages delivery robots to support late-night dining

Northern Arizona is leveraging Starship delivery robots and the mobile ordering app in a clever way to prop up late night dining, and putting a twist on the ghost kitchen concept. The university has launched its Hole in the Wall dining window that now serves either pickup or robot delivery for students by offering a number of dining concepts all from a single, concession-style window.
May 25, 23 / ,

HID's Technology Partner Program helps companies develop mobile solutions

Trusted identity solutions provider, HID Global, has announced its HID Origo Technology Partner Program, the company’s first program dedicated to partners with a focus on mobile technologies. The Origo Technology Partner Program is designed to help technology partners by providing the ideal platform for organizations to design, test, and market products that integrate with HID Origo via APIs and SDKs.
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.

Join us, @NACCUorg, and @TouchNet to explore how campus card programs can successfully navigate the sales and procurement process. Join the webinar on June 6, 2 pm EDT.

Webinar: Learn how the University of Arizona uses campus cards, mobile ordering, kiosks, lockers, and robots to revolutionize campus dining. April 7, 2-2:30 EDT. Register Now at

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