NACADA / Conference Presentation Proposal / Presentation Handouts
Presentation Proposal - NACADA Annual Conference
Presentation Info and Handouts
  Code=ExtraEvent
Conference Year: 2018
Session #: T501
Title: Tech Lab: Conquering Your Fear of Excel: Mastering Your Student Spreadsheet
Date: October 02, 2018    Time: 10:30 am - 10:55 am
Room: W 106 A
Abstract: Presenter: Zach Richards, Southern New Hampshire University

Do Excel formula like =IF(VLOOKUP(B2,C2:T152,15,FALSE)=0,"SS Check In",(VLOOKUP(B2,C2:T152,15,FALSE))) lead to you go running away and screaming "I can't do this!"? Perfectly understandable! There are 300+ different types of formulas in Excel which can be daunting. Most of us have basic knowledge of Excel through our daily work. Whether that is creating reports or even working off of your student spreadsheet, this session will cover two often used formulas Concatenate and VLookUp that will help you to transform your student spreadsheet. Concatenate combines columns such as first name and last name while VLookUp allows the ability to type a student name in and gather the necessary data without tedious scrolling. This session will help advisors understand the basics of Excel and leave with a solid foundation. Attendees will leave with a sample student spreadsheet with both formulas as well as resources to further their new excel knowledge. Only basic Excel knowledge is needed to attend this session!
Handouts
No handouts available.
Back

 
NACADA Executive Office
Kansas State University
2323 Anderson Avenue, Suite 225
Manhattan, KS  66502-2912
Phone: (785) 532-5717   Fax: (785) 532-7732
e-mail: nacada@ksu.edu

©1990-2024
NACADA: The Global Community for Academic Advising
All rights reserved