Data Management & Manipulation with SPSS Course

SPSS TrainingData Management & Manipulation with SPSS

by Certstaffix® Training

Length: 2 day(s)      Public Class Price: $1240/person (USD)      Group Onsite Price: Request Quote      Course Category: SPSS


SPSS Training
The focus of this two-day course is on the use of a wide range of transformation techniques, ways to automate your work, manipulate your data files and results, and send your output to other Windows applications. You will gain an understanding of the various options for operating SPSS and how to use syntax to perform data transformations efficiently.
This class will be taught using Version 25; those using Version 19 and newer should attend.
*Please note, there is no training manual for this class.
Course Description: Print It | Download PDF | Email It

  Public Corporate Classes - Live Online: Our Location or Yours How It Works

Certstaffix® Training public classes are instructor-led, live online training you attend in a local computer lab or from your home/office. Our live online instructors teach you from a remote location while being able to interact with students as in a traditional classroom setting.

  • A real, live instructor teaching you from another location
  • Hands-on learning with the software you are being taught
  • Interaction with all students in the class at other locations
  • Easy assistance from the instructor

Click a class date below to register & view location/attendance options. You must register at least 15 days before class.

 Register ➥   March 9, 2020     
 Register ➥   May 28, 2020     
 Register ➥   June 24, 2020     

  Group Classes for Organizations - Onsite at Your Office How It Works

Have a group of employees needing the same training? Onsite training at your office is a great solution.  

  • An expert Instructor will come to your office
  • Course can be customized to your training needs
  • Course is scheduled based on dates you provide (Subject to instructor availability)
  • We usually require about 4 weeks lead time to arrange a training session

  Detailed Course Topics

Course Description: Print It | Download PDF | Email It

Related Certifications

IBM Certified Specialist - SPSS Statistics Level 1 v2 Certification


Knowledge Pre-Requisites


Suggested Follow-Ons


Course Topics

WHO SHOULD ATTEND?
Anyone who has worked with SPSS and wants to explore additional data management and manipulation features of SPSS and generally increase their efficiency with SPSS. The course is a natural follow-on to the "Introduction to SPSS" course or as a stand alone for experienced users who have learned the basic operations of SPSS on their own.

PREREQUISITES
General computer literacy. Completion of the "Introduction to SPSS" course or experience with SPSS for Windows (Version 9 or later) including familiarity with reading and defining data, basic uses of Recode and Compute transformations, and creating charts. No statistical background is necessary.

COURSE OUTLINE
Choices in Running SPSS
¦Different Modes of Running SPSS
¦Menus and Dialogs
¦SPSS Syntax Editor and SPSS Commands
¦SPSS Production Mode Facility
¦When to Use the Different Modes
¦Summary Exercises

Further Data Transformation Features
¦Introduction
¦Automatic Recode
¦Counting Values Across Variables
¦If Conditions
¦Do If Else If Logic
¦Conditional Count Transformation
¦Summary Exercises

Computing Numeric Variables
¦Introduction
¦Using Functions In SPSS
¦The Any and Range Functions
¦Missing Functions
¦Useful System Variables
¦Summary Exercises

Computing Date, Time, And String Variables
¦Introduction
¦Working with Dates and Times
¦Converting String Variables to Date Variables
¦String Transformations
¦Summary Exercises

Helpful Data Management Features
¦Introduction
¦Identifying Duplicate Cases
¦Custom Variable Attributes
¦Variable Sets
¦Saving Selected Variables
¦Displaying SPSS Data File Properties
¦Directing Output to A Different Viewer Window
¦Summary Exercises

Aggregating Data
¦Introduction
¦Data Aggregation
¦Aggregate the Country Data to A Separate Region File
¦Aggregate Region Variables to The Country File
¦Summary Exercises

Merging Files – Adding Cases
¦Adding Cases In SPSS
¦Checking the SPSS Data File
¦Reading the Dbase File
¦Adding the Files
¦Exploring the Combined File
¦Testing Mean Differences – T Test
¦Appendix: Adding Cases from More Than Two Files
¦Summary Exercises

Merging Files – Adding Variables
¦Introduction
¦Considerations in File Merging
¦A One-To-One Match
¦Measuring Change
¦Reporting the Changes
¦A One-To-Many Match
¦A One-To-Many Match Example
¦Appendix: Adding Variables from More Than Two Files
¦Summary Exercises

Editing Charts and Pivot Tables
¦Introduction
¦Chart Templates
¦Setting A Default Chart Template
¦Editing Pivot Tables
¦Rules for Editing Pivot Tables
¦Table Properties
¦Editing Cell Properties
¦Showing and Hiding Cells
¦Creating Category Groups
¦Rotating Labels
¦Summary Exercises

Deployment of SPSS Results
¦Introduction
¦Three Types of SPSS Output
¦ActiveX and SPSS
¦Moving Pivot Table Output to Other Applications
¦Pasting Pivot Tables into Spreadsheets
¦Pasting Standard Graphics From SPSS
¦Moving Text Output from SPSS To Word Processors
¦Exporting SPSS Output
¦SPSS Output Management System
¦Summary Exercises

Controlling the SPSS Environment
¦SPSS Options
¦General Tab
¦Viewer Tab
¦Draft Viewer Tab
¦Output Labels Tab
¦Charts Tab
¦Pivot Tables Tab
¦Data Tab
¦Scripts Tab
¦Using the Set Command
Course Description: Print It | Download PDF | Email It

Public Class Format

Certstaffix® Training public classes are instructor-led live online training you attend either from your home/work location or in one of our computer labs. Our live online instructors teach you from a remote location while being able to interact with you like in a traditional classroom.


Quality Instructors

Our instructors have many years of experience teaching adult learners in person and online.

Complete Lab Environment

Access to software required is provided in a lab environment during class.

Hands-on Learning

Most classes are not all lecture - you can learn by actually doing.


Small Classes

You get more attention from the instructor and classes flow more smoothly.

Post-Class Lab Access*

Access practice lab environment for 180 days after most classes*.


Low Cancellation Rate

Most classes run as scheduled.



*These courses do not have post-class lab environment access: Adobe, Salesforce, QuickBooks Online Edition, Google, HTML, WordPress, ITIL, Six Sigma, CompTIA, Project Management, SEO, Social Media.


Group Training

Have a group of several students needing the same training? Then onsite training is a perfect option for you. We'll come onsite to your office so you don't have to travel. You'll be able to fully customize a course to your needs. Lastly, you can save per student versus our public classes.

How Onsite Training Works

  • An expert Instructor will come to your office and personally train the students
  • Course can be fully customized to your training needs
  • Each student receives a Course Manual with Practice Files (Materials provided before the class date)
  • If a course has a hands‐on lab, we provide access to the configured course software and files.
    (Requires a high‐speed internet connection and certain open ports on your firewall. You can perform a Connection Assessment Test here)
  • Course is scheduled based on dates you provide (Subject to instructor availability)
  • We usually require about 4 weeks lead time to arrange a training session
  • Training is completed in a convenient session(s) of your choosing
  • Two 15 minute breaks and one hour long break for lunch daily

Request a Free Quote

Data Management & Manipulation with SPSS Class Reviews

Here are a sample of SPSS class reviews from past students that have attended our SPSS training courses.



The focus of this two-day course is on the use of a wide range of transformation techniques, ways to automate your work, manipulate your data files and results, and send your output to other Windows applications. You will gain an understanding of the various options for operating SPSS and how to use syntax to perform data transformations efficiently.
This class will be taught using Version 25; those using Version 19 and newer should attend.
*Please note, there is no training manual for this class.


Certstaffix® Class Reviews

Student Average:
4.70 out of 5 from 34 students

4.67 out of 5

There was a lot of information presented. The instructor did a great job presenting the information in a clear manner.


- attended our Introduction to SPSS class

4.89 out of 5

The instructors statistical background was a big plus.


- attended our Advanced Statistical Analysis using SPSS class

4.60 out of 5

The instructor was very responsive to my questions.


- attended our Introduction to Statistical Analysis using SPSS class

4.61 out of 5

The instructor was very knowledgeable and did an excellent job presenting the information. In particular, all pertinent details relevant to each statistical test were covered and illustrated thoroughly. The instructor's delivery style was good. He made it interesting and was very open to questions. The only drawback was not offering opportunities to apply what was learned. Incorporating exercises where students run test independently and receive feedback would help.


- attended our Advanced Statistical Analysis using SPSS class

4.93 out of 5

The instructor was highly effective and I fully enjoyed the course. He clearly communicated the details of SPSS, while stopping to address all questions as they arose. He was effective at bringing in real life examples, keeping my attention, and making me feel at ease. I welcome the chance to take another course with him.


- attended our Data Management & Manipulation with SPSS class

4.72 out of 5

The class was very informative. My only recommendation is, if possible, adjust the class time to 4 hours a day over 3 days. The nature of the material made if difficult for me to stay focused all day. By reducing the number of hours in class each day it would allow me to do my job half of the day and would eliminate the need to stay focused on training for so long.


- attended our Introduction to SPSS class

4.67 out of 5

Jesus did an incredible job. He's very knowledgeable about both SPSS and statistics. Completing the class from my office was very convenient.


- attended our Introduction to Statistical Analysis using SPSS class

4.70 out of 5

Instructor was very encouraging and wanted to make sure she answered questions in a way that applied to how I would use SPSS


- attended our Introduction to SPSS class

5.00 out of 5

In my new job role, this class was exactly what I was looking for to help refresh my statistics skills! Time well spent.


- attended our Introduction to Statistical Analysis using SPSS class

4.76 out of 5

I'm very glad I decided to attend this training. My instructor Jeff was amazing! He was very helpful, knowledgeable and willing to do whatever it took for his students to understand the material covered. I will recommend him and Certstaff to my coworkers or anybody that wants a to learn in a environment as great as this one! Great job!


- attended our Data Management & Manipulation with SPSS class

4.35 out of 5

I really liked that we used the lab often. Intructor Jesus was very knowledgeable


- attended our Introduction to Statistical Analysis using SPSS class

4.59 out of 5

I have taken 3 online SPSS course and Jeff by far the best instructor. He gave examples that helped me understand the material in a simple manner. He took time to answer al of our questions and made sure we understood before we moved on. He was great and very knowledgeable. He really really knows what he is talking about.


- attended our Advanced Statistical Analysis using SPSS class

4.40 out of 5

Handouts on steps for commonly used procedures


- attended our Data Management & Manipulation with SPSS class

4.29 out of 5

Great Professor


- attended our Introduction to SPSS class

4.48 out of 5

Dr. Roger Taylor was fantastic!


- attended our Introduction to SPSS class

4.45 out of 5


- attended our Introduction to Statistical Analysis using SPSS class

4.80 out of 5


- attended our Introduction to SPSS class

4.83 out of 5


- attended our Data Management & Manipulation with SPSS class

4.47 out of 5


- attended our Data Management & Manipulation with SPSS class

4.35 out of 5


- attended our Data Management & Manipulation with SPSS class

5.00 out of 5


- attended our Data Management & Manipulation with SPSS class

4.89 out of 5


- attended our Advanced Statistical Analysis using SPSS class

4.59 out of 5


- attended our Data Management & Manipulation with SPSS class

4.69 out of 5


- attended our Data Management & Manipulation with SPSS class

4.86 out of 5


- attended our Introduction to Statistical Analysis using SPSS class

5.00 out of 5


- attended our Introduction to SPSS class

4.71 out of 5


- attended our Introduction to Statistical Analysis using SPSS class

4.50 out of 5


- attended our Data Management & Manipulation with SPSS class

4.93 out of 5


- attended our Advanced Statistical Analysis using SPSS class

5.00 out of 5


- attended our Introduction to Statistical Analysis using SPSS class

4.65 out of 5


- attended our Introduction to SPSS class

4.88 out of 5


- attended our Introduction to SPSS class

4.93 out of 5


- attended our Advanced Statistical Analysis using SPSS class

4.53 out of 5


- attended our Introduction to Statistical Analysis using SPSS class



Please contact us if we do not yet have any reviews or you would like more.


View all SPSS training reviews

SPSS Courses By City:

AB - Calgary       FL - Sarasota       NB - Moncton       PA - Scranton-Wilkes Barre      
AB - Edmonton       FL - Tallahassee       NB - Saint John       PA - York      
AK - Anchorage       FL - Tampa       NC - Asheville       PR - Puerto Rico      
AL - Birmingham       FL - Winter Park       NC - Charlotte       QC - Montreal      
AL - Huntsville       GA - Augusta       NC - Greensboro       RI - Providence      
AL - Mobile       GA - Columbus       NC - Raleigh       SC - Greenville      
AL - Montgomery       GA - Peachtree Corners       NC - Winston-Salem       SC - Myrtle Beach      
AR - Bentonville       GA - Savannah       ND - Bismarck       SC - North Charleston      
AR - Little Rock       HI - Honolulu       ND - Fargo       SD - Sioux Falls      
AZ - Phoenix       IA - Des Moines       NE - Lincoln       SK - Regina      
AZ - Tucson       IA - Iowa City       NE - Omaha       SK - Saskatoon      
BC - Vancouver       ID - Boise       NH - Bedford       TN - Chattanooga      
CA - Bakersfield       IL - Chicago       NJ - Bridgewater       TN - Knoxville      
CA - Fresno       IL - Rockford       NM - Albuquerque       TN - Memphis      
CA - Los Angeles       IN - Bloomington       NM - Las Cruces       TN - Nashville      
CA - Merced       IN - Evansville       NM - Santa Fe       TX - Amarillo      
CA - Modesto       IN - Fort Wayne       NS - Halifax       TX - Austin      
CA - Napa       IN - Indianapolis       NV - Henderson       TX - Beaumont      
CA - Oakland       IN - South Bend       NV - Reno       TX - Corpus Christi      
CA - Oxnard       KS - Overland Park       NY - Albany       TX - Dallas      
CA - Rancho Cucamonga       KS - Topeka       NY - Buffalo       TX - El Paso      
CA - Sacramento       KY - Lexington       NY - New York City       TX - Fort Worth      
CA - Salinas       KY - Louisville       NY - Rochester       TX - Houston      
CA - San Diego       LA - Baton Rouge       NY - Syracuse       TX - Killeen      
CA - San Jose       LA - Lafayette       OH - Beaver Creek       TX - Laredo      
CA - Santa Maria       LA - New Orleans       OH - Cincinnati       TX - Longview      
CA - Santa Rosa       LA - Shreveport       OH - Cleveland       TX - Lubbock      
CA - Stockton       MA - Burlington       OH - Columbus       TX - McAllen      
CB - Caribbean       MA - Springfield       OH - Toledo       TX - Midland      
CB - Kingston       MA - Westborough       OH - Youngstown       TX - San Antonio      
CB - Nassau       MB - Winnipeg       OK - Oklahoma City       TX - Tyler      
CO - Boulder       MD - Largo       OK - Tulsa       TX - Waco      
CO - Colorado Springs       MD - Laurel       ON - Ottawa       UT - Ogden      
CO - Denver       ME - Portland       ON - Toronto       UT - Salt Lake City      
CT - Cheshire       MI - Ann Arbor       OR - Beaverton       VA - Charlottesville      
CT - New Haven       MI - Flint       OR - Bend       VA - Glen Allen      
CT - Stamford       MI - Grand Rapids       OR - Eugene       VA - Harrisonburg      
DE - Wilmington       MI - Lansing       OR - Medford       VA - Roanoke      
FL - Daytona Beach       MI - Livonia       OR - Salem       VA - Virginia Beach      
FL - Fort Lauderdale       MN - Minnetonka       PA - Allentown       VT - Burlington      
FL - Fort Myers       MO - Columbia       PA - Erie       WA - Seattle      
FL - Gainesville       MO - St. Louis       PA - Harrisburg       WA - Spokane      
FL - Jacksonville       MS - Biloxi       PA - Malvern       WI - Eau Claire      
FL - Lakeland       MS - Jackson       PA - Philadelphia       WI - Green Bay      
FL - Miami       MT - Billings       PA - Pittsburgh       WI - Madison      
FL - Naples       MT - Montana       PA - Reading       WI - Milwaukee      
FL - Pensacola