Access Keys:
Skip to content (Access Key - 0)

ITRC National Cancer Institute
                       Information Technology Resource Center (ITRC)

 

 

 

Excel Seminar Series

Do you use Excel spreadsheets often in your job and wish you knew more about some of the features and functions that make Excel such a powerful tool?

Great News!

Beginning in May of 2012 NCI’s new Information Technology Resource Center (ITRC) will be hosting a series of informal brown bag seminars available to NCI staff designed to provide training in the advanced features of Excel. This informal training is being offered as an opportunity for those seeking more advanced skills in Excel in a hands on environment. Seating is limited and availability is on a first come first served basis. Additional sessions may be arranged if there is substantial interest.

Seminar Format

Seminars will be one hour long and will be offered in a computer lab to provide hands on involvment.

Part I: Introduction and Demonstration of a Concept or Function in Excel

The first half hour will be devoted to a demonstration of an Excel functionality chosen for the session by the ITRC. It will include an overview, a demonstration, and hands-on practice.

Part II: Q&A

Q&A! Bring your Excel questions with you and we’ll demonstrate the solution in part 2 of the class. If you have a specific spreadsheet you would like to ask a question about send it to us along with your question(s) at least two days before the class occurs. We may not be able to address all questions in the classroom but we’ll do our best! Note: the questions asked in Part 2 need not be related to the concept covered in Part 1.


Excel Seminar Request

Did you miss a seminar you wanted to attend? Do you have an Excel topic or function you would like to have a seminar dedicated to? We want to know! Please tell us by completing our Excel Seminar Request Form.

Questions?

Have a question about what will be covered in training or the seminar series in general? We want to know! Email us at nciitrc@mail.nih.gov

Excel Seminar Schedule

All seminars will be held in the NCI training lab at: 6116 Executive Blvd. Room 4075 from 12:00 PM - 1:00 PM on the date indicated next to the course below.

Date

Time

Location

Training Topics

Availability

Materials

May 2, 2012

12:00 - 1:00 PM

Building 6116 Room 4075

Advanced Budget Spreadsheets: Using the SoFie Excel Add-In

Registration Closed

Overview Doc
Demo Spreadsheet

June 7, 2012

12:00 - 1:00 PM

Building 6116 Room 4075

Advanced Data Presentation and Analysis: Working with Pivot Tables

Registration Closed

Demo and Interactive Questions.ppt
Solutions to Demo and Interactive Questions

July 11, 2012

12:00 - 1:00 PM

Building 6116 Room 4075

Advanced Data Cross-Referencing: VLookups and Cell Anchoring

Registration Closed

NCI_Excel_Training_Test_Data.xlsInteractive Questions.ppt

August 1, 2012

12:00 - 1:00 PM

Building 6116 Room 4075

Sorting and Filtering Data. See only what you want to see how you want to see it

Registration Closed

 

September 5, 2012

12:00 - 1:00 PM

Building 6116 Room 4075

Page View and Formatting i.e. Freezing Panes, Printing Titles on All Pages, etc.

Register

 

October 3, 2012

12:00 - 1:00 PM

Building 6116 Room 4075

Conditional Functions. Select data based on criteria you determine.

Register

 

November 7, 2012

12:00 - 1:00 PM

Building 6116 Room 4075

Data Manipulation: Trimming fields, combining columns, changing rows to columns, etc

Register

 

Added by Vaughans, Fiona (NIH/NCI) [E] , last edited by Kerr, Christopher (NIH/NCI) [E] on Aug 01, 2012 10:44