Follow this link to go to the text only version of nasa.gov
 
HQ Information Technology and Communications Division
HQOPS HOME
ITCD HOME
ABOUT ITCD
POLICY AND PLANS
BOARDS AND COMMITTEES
EMERGENCY PREPAREDNESS (NASA ONLY)
IT SECURITY (NASA ONLY)
PRIVACY MANAGEMENT (NASA ONLY)
CUSTOMER OUTREACH
IT TRAINING
PRODUCTS & SERVICES
PROJECTS & INITIATIVES
INSTRUCTIONS & GUIDELINES
FAQ'S
 
 
 + Private Classes

 + Deskside Training

 + SATERN

 + SkillSoft

 + FAQ's (MS Word)

 
 
+ ITCD Home > Products & Services > CTC > Excel
 
COMPUTER TRAINING CENTER - EXCEL

Outlook MascotMicrosoft Excel Workshops

The NASA HQ Computer Training Center offers various levels of training in Microsoft Excel. New workshops are currently being developed and will be added to this page when available.

Note: Students must bring NASA issued laptop with appropriate software installed.

Windows

Excel 2013 for Windows: It Starts with a Cell
(Basic)

Excel 2013 for Windows: Excel Edge!
(Advanced)

Excel 2013 for Windows: In the Pits with Pivot Tables?
(Advanced)

Excel 2013 for Windows: Perfect Printing
(All Levels)

Excel 2013 for Windows: Formula Wizards
(Intermediate)

Excel 2013 for Windows: Take Charge of Charts
(Intermediate)

Macintosh

Excel 2011 for Macintosh: It Starts with a Cell
(Basic)

Excel 2011 for Macintosh: Perfect Printing
(All Levels)

Excel 2011 for Macintosh: Take Charge of Charts
(Intermediate)


Outlook MascotMicrosoft Excel 2013 for Windows: It Starts with a Cell
            Level: Basic

Course Description:  In this workshop, you will learn the various elements of the Excel screen, navigation, the mouse appearances, the formula bar, and work with the basic tools like changing views, data entry, naming a worksheet, adding and moving worksheets, cell formatting, page setup, simple formulas and printing tips.

Virtual Classroom: A Lync online meeting room and teleconference number can be provided by request.  Contact the CTC at 358-1111, at least 24 hours in advance, if you would like to attend online.

Registration: Register in SATERN (search "SWAC"). Availability is offered on a first-come first-serve basis. Click here for help with searching and registering in SATERN.

Resources: See Quick Reference Guides below

Training Schedule:

Microsoft Excel 2013 for Windows: It Starts with a Cell
SATERN Registration Required

Date
Times
Location
March 19, 2015 10:00 a.m. – 12:00 p.m. Room CX31
April 21, 2015 10:00 a.m. – 12:00 p.m. Room CX31
May 20, 2015 10:00 a.m. – 12:00 p.m. Room CX31
June 18, 2015 10:00 a.m. – 12:00 p.m. Room CX31
July 21, 2015 10:00 a.m. – 12:00 p.m. Room CX31
August 19, 2015 10:00 a.m. – 12:00 p.m. Room CX31
September 24, 2015 10:00 a.m. – 12:00 p.m. Room CX31

Note: Students must bring NASA issued laptop with appropriate software installed.

Outlook MascotExcel 2013 for Windows: Excel Edge!
Level: Advanced

Course Description:  Please be sure to bring your laptop to class with you. In this workshop, you will learn the most-asked about advanced features of Microsoft Excel 2013. Learn how to make a visual impact with Quick Analysis tools, use sorting/filtering, advanced filter, and link spreadsheets with Word and PowerPoint. Plus we'll cover formulas, concatenations, arrays, and techniques for collaboration. We will also cover new features to Excel 2013 like Recommended Charts, Timeline and comparing two workbooks. Finally, we will discuss how to work with files created in older versions of Excel.

Virtual Classroom: A Lync online meeting room and teleconference number can be provided by request.  Contact the CTC at 358-1111, at least 24 hours in advance, if you would like to attend online.

Registration: Register in SATERN (search “Edge!”). Availability is offered on a first-come first-serve basis. Click here for help with searching and registering in SATERN.

Resources: See all Quick Reference Guides below

Quick Reference Guides
for Excel Edge!
(All documents are in PDF format)
QRG# Title
9
10
11

 

Training Schedule:

Microsoft Excel 2013 for Windows: Excel Edge!
SATERN Registration Required

Date
Times
Location
March 19, 2015 1:00 p.m. – 2:00 p.m. Room CX31
April 21, 2015 1:00 p.m. – 2:00 p.m. Room CX31
May 20, 2015 1:00 p.m. – 2:00 p.m. Room CX31
June 18, 2015 1:00 p.m. – 2:00 p.m. Room CX31
July 21, 2015 1:00 p.m. – 2:00 p.m. Room CX31
August 19, 2015 1:00 p.m. – 2:00 p.m. Room CX31
September 24, 2015 1:00 p.m. – 2:00 p.m. Room CX31

Note: Students must bring NASA issued laptop with appropriate software installed.

Outlook MascotExcel 2013 for Windows: In the Pits with Pivot Tables?
            Level: Advanced

Course Description:  Please be sure to bring your laptop to class with you. In this workshop, you will learn how to create pivot tables in only 1 hour! This Microsoft Excel 2013 workshop will show you how to easily take raw data and turn it into drillable tables that make sense. You'll learn how to build a pivot table from a pivot table, troubleshoot tables, drill down for additional data, export, refresh and save tables.

Virtual Classroom: A Lync online meeting room and teleconference number can be provided by request.  Contact the CTC at 358-1111, at least 24 hours in advance, if you would like to attend online.

Registration: Register in SATERN (search “Pivot”). Availability is offered on a first-come first-serve basis. Click here for help with searching and registering in SATERN.

Resources: See Quick Reference Guides below

Training Schedule:

Microsoft Excel 2013 for Windows: In the Pits with Pivot Tables?
SATERN Registration Required

Date
Times
Location
March 19, 2015 2:30 p.m. – 3:30 p.m. Room CX31
April 21, 2015 2:30 p.m. – 3:30 p.m. Room CX31
May 20, 2015 2:30 p.m. – 3:30 p.m. Room CX31
June 18, 2015 2:30 p.m. – 3:30 p.m. Room CX31
July 21, 2015 2:30 p.m. – 3:30 p.m. Room CX31
August 19, 2015 2:30 p.m. – 3:30 p.m. Room CX31
September 24, 2015 2:30 p.m. – 3:30 p.m. Room CX31

Note: Students must bring NASA issued laptop with appropriate software installed.

Outlook MascotExcel 2013 for Windows: Perfect Printing
            Level: All Levels

Course Description:  Coming soon.

Registration: Register in SATERN (search “Perfect”). Availability is offered on a first-come first-serve basis. Click here for help with searching and registering in SATERN.

Resources: See Quick Reference Guides below

Training Schedule:

Excel 2013 for Windows: Perfect Printing
SATERN Registration Required

Date
Times
Location
Coming soon…    
     
     

Outlook MascotExcel 2013 for Windows: Formula Wizards
            Level: Intermediate

Course Description:  Please bring your Windows 7 laptop to the workshop. Learn simple formulas, parts of a formula, Relative vs Absolute vs Mixed references, and create formulas using the Function Wizard. Understand the Order of Operations as it relates to formulas, practice numerous commonly used functions, create a Vlookup formula, and build Concatenations.

Virtual Classroom: A Lync online meeting room and teleconference number can be provided by request. Contact the CTC at 358-1111, at least 24 hours in advance, if you would like to attend online.

Registration: Register in SATERN (search “Formula Wizards”). Availability is offered on a first-come first-serve basis. Click here for help with searching and registering in SATERN.

Resources: See Quick Reference Guides below

Training Schedule:

Excel 2013 for Windows: Formula Wizards
SATERN Registration Required

Date
Times
Location
March 18, 2015 1:00 p.m. – 2:30 p.m. Room CX31
April 22, 2015 1:00 p.m. – 2:30 p.m. Room CX31
May 21, 2015 1:00 p.m. – 2:30 p.m. Room CX31
June 17, 2015 1:00 p.m. – 2:30 p.m. Room CX31
July 22, 2015 1:00 p.m. – 2:30 p.m. Room CX31
August 20, 2015 1:00 p.m. – 2:30 p.m. Room CX31
September 20, 2015 1:00 p.m. – 2:30 p.m. Room CX31

Note: Students must bring NASA issued laptop with appropriate software installed.

Outlook MascotExcel 2013 for Windows: Take Charge of Charts
            Level: Intermediate

Course Description:  Coming soon.

Registration: Register in SATERN (search “charge”). Availability is offered on a first-come first-serve basis. Click here for help with searching and registering in SATERN.

Resources: See Quick Reference Guides below

Training Schedule:

Excel 2013 for Windows: Take Charge of Charts
SATERN Registration Required

Date
Times
Location
Coming soon…    
     
     

 


Outlook MascotExcel 2011 for Macintosh: It Starts with a Cell
           Level: Basic

Course Description:  Uses for Excel, exploring the screen, panes, menus, Tabs, and Ribbon; Excel Mouse Displays; Navigating In a Worksheet; Entering and Editing Data in a Worksheet; Formatting Data and Cells; Working with workbooks;  Learning Simple Formulas; Order of Operations (or Precedence); and Creating Functions using the Formula Wizard.

Registration: Register in SATERN (search “SWAC”). Availability is offered on a first-come first-serve basis. Click here for help with searching and registering in SATERN.

Resources: See Quick Reference Guides below

Training Schedule:

Excel 2011 for Macintosh: It Starts with a Cell
SATERN Registration Required

Date
Times
Location
March 17, 2015 10:00 a.m. – 11:30 a.m. Room CX19
April 23, 2015 10:00 a.m. – 11:30 a.m. Room CX19
May 19, 2015 10:00 a.m. – 11:30 a.m. Room CX19
June 16, 2015 10:00 a.m. – 11:30 a.m. Room CX19
July 23, 2015 10:00 a.m. – 11:30 a.m. Room CX19


Outlook MascotExcel 2011 for Macintosh: Perfect Printing
            Level: All Levels

Course Description:  Coming soon..

Registration: Register in SATERN (search “perfect”). Availability is offered on a first-come first-serve basis. Click here for help with searching and registering in SATERN.

Resources: See Quick Reference Guides below

Training Schedule:

Excel 2011 for Macintosh: Perfect Printing
SATERN Registration Required

Date
Times
Location
Coming soon…    
     
     

Outlook MascotExcel 2011 for Macintosh: Take Charge of Charts
            Level: Intermediate

Course Description:  Coming soon..

Registration: Register in SATERN (search “charge”). Availability is offered on a first-come first-serve basis. Click here for help with searching and registering in SATERN.

Resources: See Quick Reference Guides below

Training Schedule:

Excel 2011 for Macintosh: Take Charge of Charts
SATERN Registration Required

Date
Times
Location
Coming soon…    
     
     

 
REGISTER IN SATERN


Need help locating and registering for classes or workshops in SATERN?  Follow these instructions:

  1. Log in to SATERN.
  2. Search for the designated search term (shown above) in the Catalog box in the upper right corner.
  3. Locate your desired course offering in the list and click Add to Learning Plan at the far right.
  4. Your Learning Plan will be displayed.  Under No Due Date, click on the course title you just added.
  5. Item Details will appear.  Click View Offerings.
  6. Available sessions will appear.  Click the blue Register button to the right of a session you wish to attend.
  7. The Registration screen appears.  Click the yellow Confirm button in the bottom right corner.
DOCUMENTATION

Excel 2013 for Windows
Quick Reference Guides
(All documents are in PDF format)
QRG# Title
1
2
3
4
5
6
7
8
9
10
11

 

Excel 2011 for Macintosh
Quick Reference Guides
(All documents are in PDF format)
QRG# Title
1
2
3
4
5
6
7
8
9
10

 

ASSISTANCE

For more computer training opportunities, visit the Computer Training Center Web site.

For questions, contact the Computer Training Center at 358-1111 or ctc@hq.nasa.gov.

For technical support, contact the Enterprise Service Desk (ESD): Submit a ticket online or call 358-HELP (4357).

 


< Back to CTC Home



+ Freedom of Information Act
+ Budgets, Strategic Plans and Accountability Reports
+ The President's Management Agenda
+ Privacy Policy and Important Notices
+ Inspector General Hotline
+ Equal Employment Opportunity Data Posted Pursuant
to the No Fear Act

+ Information-Dissemination Priorities and Inventories
+ USA.gov
+ ExpectMore.gov
NASA - National Aeronautics and Space Administration
NASA Official: Mary Shouse
Site Curator: Christopher Brunner
+ Contact ITCD