Excel Tips for Pre- and Post-Award Administrators

(90 minutes) 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. 

Speakers:

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

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

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 Zoom webinar room to access this feature. 

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

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. 

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 = .2 CEU's for each webinar.

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

Watching in a group? Everyone watching the presentation can request a CEU certificate by writing down the verification code at the end of the webinar. Please make a note of the verification code as it will not be available after the webinar.

The main registrant can access instructions on the Group CEU tab for group participants to receive CEU certificates.

We recommend testing your browser as soon as possible in case you need to contact your IT department for help.
  • It is recommended that you use a PC or MAC with an updated Internet Browser.
  • 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.


    For additional recommendations on your computer set up for the webinar, please click here.