SAS Canada
1-877-SAS-INST
support.sas.com/training/canada |
Accessing SAS from Microsoft Office Applications
Duration: 1.0 day CEU: 0.6
Who Should Attend
Microsoft Office users who want to work with SAS data to create reports and perform analyses
Course Description
This course provides an overview of SAS Add-In for Microsoft Office and shows how it can be used to access SAS information directly from Microsoft Office applications. This course requires the SAS Intelligence Platform.
Course Contents
SAS Business Intelligence and Course Introduction
- SAS Business Intelligence Overview
- overview of the SAS Add-In for Microsoft Office
- introduction to the course data
- introduction to the course scenarios
Exploring the SAS Add-In for Microsoft Office
- using the SAS Add-In for Microsoft Excel
- using the SAS Add-In for Microsoft Word and Microsoft PowerPoint
- using the SAS Add-In to publish documents (self-study)
Inserting SAS Data into Microsoft Excel
- SAS data set concepts and terminology
- using SAS data sources with Microsoft Excel
- using SAS data sources in PivotTables
Inserting SAS Results into Microsoft Office
- an overview of stored processes
- customizing the output style
Analyzing Data with SAS Tasks in Microsoft Office
- overview of SAS tasks
- list data task
- one-way frequencies task
- table analysis task
- summary table task
- bar chart task
- interacting with an activeX graph (self-study)
Prerequisites
No SAS experience or programming experience is required although you should have some experience using Microsoft Office Applications. Specifically, you should be able to
- open and save documents
- use the menus and toolbars to accomplish tasks
- navigate Word documents, PowerPoint presentations, and Excel spreadsheets.
Software Addressed
This course addresses the following software product(s): SAS Add-In for Microsoft Office, SAS Intelligence Platform.
Schedule
11FEB2009 Ottawa, ON
22APR2009 Toronto, ON
| 11FEB2009 Toronto, ON
24JUN2009 Toronto, ON
| 21APR2009 Montreal, QC
|
Check for additional and updated schedule information online at
support.sas.com/training/canada/crs/sbiamo.html.
Registration
To register for this course, call 1-877-SAS-INST or visit
support.sas.com/training/canada.
This course is also available for on-site training, or you
can create a custom course by combining material from several
courses. For more details, contact SAS Education
at 1-877-SAS-INST or send e-mail to sastrain@can.sas.com.
|
