Excel Tips for Pre- and Post-Award Administrators * Part II!

Recorded On: 02/28/2022

Unlimited Free Additional Logins for Your Institution!

February 28, 2022
2:00 – 3:30 pm EST * Webinar
3:35 – 4:30 pm EST * After the Show * Talk with the Faculty Directly!

After the outstanding Excel Tips for the Pre- and Post-Award Administrators webinar, we know you want more!

Rebecca and Diane will be picking up where they left off in Part I to take you deeper into maximizing Excel in your support for Sponsored Research.

Topics will include:
  • Group/Hide
  • Goal Seek
  • Round
  • Concatenate
  • Including text notes in formulas
  • SUM vs. subtotal
  • Slicers
  • Customize Quick Access & Ribbon

Level: Intermediate

Prerequisites: Participants should have a basic knowledge of Excel formulas and functions.

Didn’t see  Part I?

It is available for immediate download so you have EVERYTHING you need to maximize EXCEL FOR Research Administration

Excel Tips for Pre- and Post-Award Administrators – Part I

Do you use Excel to analyze and report data? If so, you’ve probably asked yourself, "Why does this take so long? Is there a better way?" If you use Excel for budget development, you have probably asked yourself, "How can I develop a budget more quickly/accurately?" In this intermediate-level session, you will learn how to use tables, formulas, pivot tables, and conditional formatting that will help you navigate your path to success. This is a 90-minute session and participants should bring their own laptop to the workshop. Excel templates will be provided on the day of the workshop for participants to use as they follow-along. Adequate time will be provided for participants to personalize the templates for use back home. 

Participants will:
  • Examine formatting conventions that effectively communicate key information and/or highlight variances in reports. 
  • Learn how to use select Excel functions, formulas, and tools for reporting. 
  • Learn how to use select Excel functions, formulas, and tools for budgeting. 

Level: Intermediate

Prerequisites: Participants should have a basic knowledge of Excel formulas and functions. 

Diane Meyer

Pre-Award Project Manager

Grants Hub
Iowa State University

Rebecca Hunsaker

Executive Director of Research Management

College of Behavioral & Social Sciences
University of Maryland, College Park

Participants receive 1.5 hours of continuing education credits.

You can access your certificate from the box on the right side of the screen, after filling out the webinar evaluation.

NCURA webinars use the GoToWebinar platform. To confirm that you are ready to participate, please test your browser before joining the webinar, or review the more detailed system requirements.
  • It is recommended that you use a PC or MAC with an updated Internet Browser either Google Chrome, Mozilla Firefox, Edge or Safari.  
  • Make sure you have pop-ups blockers disabled in your Internet browser settings.
  • Wifi is not recommended. The problem with WiFi is signal strength can vary causing bandwidth to increase or decrease.
  • We recommend a wired connection. A wired connection gives a consistent signal and consistent bandwidth. A wired connection provides a better experience.
  • It's better for organizations with low bandwidth to only have the webinar running on 1 computer in a conference room than having 10 individual people running the session on 10 computers at their desks.
  • Audio (sound) is projected through your computer speakers. Be sure your computer is equipped with speakers so you can hear the presenters.

Member Price: $125.00 Non-Member Price: $150.00

Your registration includes one log-in. We are pleased to provide the opportunity for you to register additional sites at your institution for no additional charge.

When you are checking out, click the "Add Extra Login" button in your cart, and type in the email address of your colleague that you would like to register. If they already have a profile in the registration system, their name will pop up and you can add them to your registration.  

If that person has never logged in to the Online Learning Center their name will not come up. Please have them go to the NCURA website to create a profile, then log into this registration site. This initial login is required for the registration site to communicate with NCURA's database. After that, you will be able to add them to your registration.*

If you add at least one additional registration with yours, you will be able to change or add more registrations for the webinar in the future by clicking “My Registrations” in the menu at the top left of the home page, then clicking the “Purchases for Others” button.

*If you have already checked out without adding any additional logins but would still like to invite others from your institution, please refer to the extra logins tab for a registration link for your institution. Note, this tab will only appear after you have completed your paid registration.

Handouts will be available 24 hours before the live webinar. 

Closed Captioning for the live presentation is available at no additional fee. Sign in and click on "Closed Caption" in the Handouts of the webinar room to access this feature. 

For technical assistance email ncura@commpartners.com