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."

Related Posts

|| TAGS:
Subscribe to our weekly newsletter

RECENT ARTICLES

USF ID card back
Mar 28, 24 /

Caveat emptor when adding contact numbers to campus cards

The back of University of South Florida’s ID card provides several phone numbers for students in crisis or seeking safety services. Many campus cards contain similar resources, but what happens when this information changes. How do you deal with incorrect contact info for essential services? The USF card prominently lists contact numbers for the victim […]
High school bathroom

Bathroom breaks tracked by campus ID and mobile app

At California’s Fresno High, a new app is authorizing and monitoring trips to the bathroom in an effort to increase students’ time in class and decrease gathering in halls and bathrooms. Of course, this has not gone over well with students. Raising your hand and asking the teacher if you can go to the bathroom […]
Atrium Ozzi container

Atrium clients track check-out and return of reusable containers at OZZI kiosks

The push to reduce or even eliminate single-use containers from campus dining is now easier for Atrium clients. Thanks to a seamless integration between Atrium and the OZZI reusable container program, the processes for both students and dining services is streamlined. Atrium clients have been using OZZI for years, but the two systems were independent. […]
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

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

Join Jeff Koziol and Robert Gaulden from @AllegionUS as we explore how mobile credentials and proptech are changing on- and off-campus housing.

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.
©2024 CampusIDNews. All rights reserved.