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!
(Intermediate)

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

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: Excel Edge!
(All Levels)

Excel 2011 for Macintosh: In the Pits with Pivot Tables?
(Advanced)

Excel 2011 for Macintosh: Formula Wizards
(Intermediate)

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
Registration Deadline
June 17, 2015 10:00 a.m. – 12:00 p.m. Room CX31 Cancelled
July 21, 2015 10:00 a.m. – 12:00 p.m. Room CX31 July 17, 4:00 p.m.
August 19, 2015 10:00 a.m. – 12:00 p.m. Room CX31 August 17, 4:00 p.m.
September 22, 2015 10:00 a.m. – 12:00 p.m. Room CX31 September 18, 4:00 p.m.

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

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

Course Description:  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 will 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 cover tips for printing large spreadsheets.

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
Registration Deadline
May 21, 2015 10:00 a.m. – 11:30 a.m. Room CX31 May 19, 4:00 p.m.
June 18, 2015 10:00 a.m. – 11:30 a.m. Room CX31 Cancelled
July 22, 2015 10:00 a.m. – 11:30 a.m. Room CX31 July 20, 4:00 p.m.
August 20, 2015 10:00 a.m. – 11:30 a.m. Room CX31 August 18, 4:00 p.m.
September 24, 2015 10:00 a.m. – 11:30 a.m. Room CX31 September 22, 4:00 p.m.

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:  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
Registration Deadline
May 21, 2015 1:00 p.m. – 2:00 p.m. Room CX31 May 19, 4:00 p.m.
June 18, 2015 1:00 p.m. – 2:00 p.m. Room CX31 Cancelled
July 22, 2015 1:00 p.m. – 2:00 p.m. Room CX31 July 20, 4:00 p.m.
August 20, 2015 1:00 p.m. – 2:00 p.m. Room CX31 August 18, 4:00 p.m.
September 24, 2015 1:00 p.m. – 2:00 p.m. Room CX31 September 22, 4:00 p.m.

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

Outlook MascotExcel 2013 for Windows: Formula Wizards
            Level: Intermediate

Course Description:  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
Registration Deadline
June 17, 2015 1:00 p.m. – 2:30 p.m. Room CX31 Cancelled
July 21, 2015 1:00 p.m. – 2:30 p.m. Room CX31 July 17, 4:00 p.m.
August 19, 2015 1:00 p.m. – 2:30 p.m. Room CX31 August 17, 4:00 p.m.
September 22, 2015 1:00 p.m. – 2:30 p.m. Room CX31 September 18, 4:00 p.m.

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

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

Course Description: Learn how to create charts from the Quick Analysis tools and Recommended Charts; understand the various chart types and when it is appropriate to use them; create Combo charts; learn how to modify charts and create PivotTable Charts.

Registration: Register in SATERN (search "TCOC"). 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
Registration Deadline
June 30, 2015 1:00 p.m. – 2:00 p.m. Room CX31 June 26, 4:00 p.m.
July 30, 2015 1:00 p.m. – 2:00 p.m. Room CX31 July 28, 4:00 p.m.
August 27, 2015 1:00 p.m. – 2:00 p.m. Room CX31 August 25, 4:00 p.m.

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

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
Registration Deadline
June 16, 2015 10:00 a.m. – 12:00 p.m. Room CX19 Cancelled
July 23, 2015 10:00 a.m. – 12:00 p.m. Room CX19 July 21, 4:00 p.m.
August 18, 2015 10:00 a.m. – 12:00 p.m. Room CX19 August 14, 4:00 p.m.
September 23, 2015 10:00 a.m. – 12:00 p.m. Room CX19 September 21, 4:00 p.m.

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

Outlook MascotExcel 2011 for Macintosh: Excel Edge!
            Level: Intermediate

Course Description:  Learn the most-asked about features of Microsoft Excel 2011. Learn how to create Data Validation; use Track Changes; create visual impact with conditional formatting, use sorting/filtering, advanced filters; link data in the spreadsheet and link spreadsheets with Word and PowerPoint.

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 Quick Reference Guides below

Training Schedule:

Microsoft Excel 2011 for Macintosh: Excel Edge!
SATERN Registration Required

Date
Times
Location
Registration Deadline
May 26, 2015 10:00 a.m. – 11:30 a.m. Room CX19 May 22, 4:00 p.m.
June 24, 2015 10:00 a.m. – 11:30 a.m. Room CX19 June 22, 4:00 p.m.
July 29, 2015 10:00 a.m. – 11:30 a.m. Room CX19 July 27, 4:00 p.m.
August 25, 2015 10:00 a.m. – 11:30 a.m. Room CX19 August 21, 4:00 p.m.
September 29, 2015 10:00 a.m. – 11:30 a.m. Room CX19 September 25, 4:00 p.m.

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

Outlook MascotExcel 2011 for Macintosh: In the Pits with Pivot Tables?
            Level: Advanced

Course Description:  Learn the Master Data Prerequisites and understand uses for PivotTables. Learn how to create a PivotTable; customize the PivotTable using PivotTable Options; defining Master Data as a Table and summarizing a Table with a PivotTable Report; update and Refresh Data; sort and filter the Data; use the Group Option; Move the PivotTable; and create Consolidated PivotTables.

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:

Excel 2011 for Macintosh: In the Pits with Pivot Tables?
SATERN Registration Required

Date
Times
Location
Registration Deadline
May 26, 2015 1:00 p.m. – 2:00 p.m. Room CX19 May 22, 4:00 p.m.
June 24, 2015 1:00 p.m. – 2:00 p.m. Room CX19 June 22, 4:00 p.m.
July 29, 2015 1:00 p.m. – 2:00 p.m. Room CX19 July 27, 4:00 p.m.
August 25, 2015 1:00 p.m. – 2:00 p.m. Room CX19 August 21, 4:00 p.m.
September 29, 2015 1:00 p.m. – 2:00 p.m. Room CX19 September 25, 4:00 p.m.

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

Outlook MascotExcel 2011 for Macintosh: Formula Wizards
            Level: Intermediate

Course Description:  This workshop is for Macintosh users only. Please bring your Macintosh laptop to class with you. Learn simple formulas, parts of a formula, Relative vs Absolute vs Mixed references, and create formulas using the Formula Builder. Understand the Order of Operations as it relates to formulas and practice numerous commonly used functions; create a nested if formula, 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 2011 for Macintosh: Formula Wizards
SATERN Registration Required

Date
Times
Location
Registration Deadline
June 16, 2015 1:00 p.m. – 2:30 p.m. Room CX19 Cancelled
July 23, 2015 1:00 p.m. – 2:30 p.m. Room CX19 July 21, 4:00 p.m.
August 18, 2015 1:00 p.m. – 2:30 p.m. Room CX19 August 14, 4:00 p.m.
September 23, 2015 1:00 p.m. – 2:30 p.m. Room CX19 September 21, 4:00 p.m.

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

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