IT Training Guides and Resources
A comprehensive library of training resources. You will find a variety of guides, e-Books, self-paced tutorials, demos and how-to videos to enhance your use and knowledge of university technology and software.
Software/Applications
MICROSOFT
- Access
- Excel
- Office for the PC
- Office for Macintosh
- Outlook
- PowerPoint
- Publisher
- Visio
- Word
- Operating Systems (OS)
Access
- Access 2010 – Basic Tasks

- Access 2010 – Make the Switch

- Access 2007 – Training Tutorial Courses

- Access 2007 – Get To Know Access 2007

- Access 2007 – Basics

- Access 2007 – Intermediate

- Access 2007 – Import and Export Data Files

- Access 2007 – Import Data: Import or link to data in an Excel workbook

- Access 2007 – Import Data: Import data from Excel to a new table in Access
- Access 2007 – Export Data: Export Data from Access to Excel

- Access 2007 – View and manage objects by using the Navigation Pane

- Access 2007 – Primary Keys: Create or remove a primary key

- Access 2007 – Tab Order: Set the tab order for controls

- Access 2007 – Print: Print your Access data

- Access 2007 – A variety of Access Guides & Tutorials

- Access 2007 – Step by Step
- Access 2007 – Create a Database

- Access 2003 – Training Tutorial Courses

- Access 2010 – Basic Tasks
Excel
- Excel 2010 – Basic Tasks

- Excel 2010 – Getting Started

- Excel 2010 – Online Training Course List

- Excel 2010 – PivotTables

- Excel 2010 – Create Formulas

- Excel 2010 – Create Your First Spreadsheet

- Excel 2010 – Make the Switch

- Excel 2010 – Manage Information

- Excel 2010 – VLookup (What it is and when to use it)

- Excel 2007 – Training Tutorial Courses

- Excel 2007 – Up to speed with Excel 2007

- Excel 2007 – Basics: Create your First Workbook

- Excel 2007 – Basics

- Excel 2007 – Charts I: How to Create a Chart

- Excel 2007 – Charts: Creating Charts

- Excel 2007 – Data Query & Management

- Excel 2007 – Filters: Filter Data in a Range or Table

- Excel 2007 – Formulas: Enter Formulas

- Excel 2007 – Formulas: Using Formulas

- Excel 2007 – Macro Basics

- Excel 2007 – Macros – Record a Basic Macro

- Excel 2007 – Working with Multiple Workbooks and Sheets

- Excel 2007 – Using Pivot Tables

- Excel 2007 – PivotTable I: Get Started

- Excel 2007 – PivotTable II: Filters

- Excel 2007 – PivotTable III: Calculate Data

- Excel 2007 – Sorting: Sort Data

- Excel 2007 – Sorting: Sort By Date

- Excel 2007 – Sorting: Sort By Multiple Columns of Data

- Excel 2007 – Sorting: Sort Data by Cell Color

- Excel 2007 – Sorting: Sort Data by Font Color

- Excel 2007 – Tips & Shortcuts

- Excel 2007 – VBA

- Excel 2007 – A variety of Excel Guides & Tutorials

- Excel 2003 – Training Tutorial Courses

- Excel 2010 – Basic Tasks
Lync
- Lync 2010 – Use and Customization

- Lync 2010 – Use Instant Messaging & Presence

- Lync 2010 – Add a Contact

- Lync 2010 – Add a Note

- Lync 2010 – Change Your Status

- Lync 2010 – Check a Contact's Availability

- Lync 2010 – Find Missed Conversations

- Lync 2010 – Send an Instant Message

- Lync 2010 – Start Multiple IM's

- Lync 2010 – Use and Customization
Office for the PC
- Office 2010 – Office Training Directory

- Office 2010 – Getting Started with Office 2010

- Office 2010 – Menu to Ribbon Workbooks

- Office 2010 – Interactive Menu to Ribbon Guide

- Office 2010 – Exploring the Backstage

- Office 2010 – Exploring the Ribbon

- Office 2010 – What's New

- Office 2007

- Getting Started with 2007 Microsoft Office System

- Office 2007 System – Training Tutorials Catalog

- Office 2003 System – Training Tutorials Catalog

- Office 2010 – Office Training Directory
Office for Macintosh
Outlook
- Emailing Within a Microsoft Application

- Outlook 2010 – Basic Tasks

- Outlook 2010 – Calendar Backup

- Outlook 2010 – Mail, Calendar, Contacts, Notes & Tasks

- Outlook 2010 – Make the Switch

- Outlook 2007 –Scheduling Assistant

- Outlook 2007 – Training Tutorial Courses

- Outlook 2007 – Up to speed with Outlook 2007

- Outlook 2007/2010 – Create & Use a Distribution List

- Outlook 2007/2010 – Using the Drag & Drop Feature

- Outlook 2007/2010 – Edit Recurring Meetings

- Outlook 2007/2010 – Calendar Best Practices: Do's, Dont's & Tips

- Outlook 2007/2010 – Microsoft Recommendations To Manage Your Outlook Calendar

- Outlook 2007 – Using Mail, Calendar, Contacts, Tasks & Notes

- Outlook 2007 – Using Calendaring Features

- Outlook 2007 – Calendar I: Outlook Calendar Basics

- Outlook 2007 – Create a New Meeting & Use The Scheduling Assistant (University of Wisconsin–Eu Claire - LTS Online Help Documentation)

- Outlook 2007 - Manage Your Mailbox I: Finds Its Size and Trim It Down

- Emailing Within a Microsoft Application
PowerPoint
- PowerPoint 2010 – Basic Tasks

- PowerPoint 2010 – Make the Switch

- PowerPoint 2007 – Training Tutorial Courses

- PowerPoint 2007 – Basics: Basics & Best Practices

- PowerPoint 2007 – Basics: Create Your First Presentation

- PowerPoint 2007 – Basics: PowerPoint 2007 Starter's Guide

- PowerPoint 2007 – Intermediate: Working with Themes, Layouts & Masters

- PowerPoint 2007 – A variety of PowerPoint Guides & Tutorials

- PowerPoint 2010 – Basic Tasks
Publisher
Visio
Word
- Word 2010 – Basic Tasks

- Word 2010 – Make the Switch

- Word 2007 – Training Tutorial Courses

- Word 2007 – Up To Speed with Word 2007

- Word 2007 – Basics: Get to Know Word 2007 I: Create Your First Document

- Word 2007 – Authoring Structured & Accessible Documents

- Word 2007 – Creating & Using Tables

- Word 2007 – Formatting: Format your document with styles

- Word 2007 – Formatting: Bullets, Numbers, and Lists

- Word 2007 – Headers, Footers, Pages & Sections

- Word 2007 – Using Mail Merge

- Word 2007 - Mail Merge I: Use Mail Merge for Mass Mailings

- Word 2007 – Spacing: Why did the line spacing change in Word?

- Word 2007 – Spacing: Adjust the spaces between lines or paragraphs

- Word 2007 – Table of Contents: Create an automatic Table of Contents

- Word 2007 – A variety of Word Guides & Tutorials

- Word 2003 – Training Tutorial Courses

- Word 2010 – Basic Tasks
-
Operating Systems (OS)
- Windows 7 – What's New

- Windows 7 – Getting Started

- Windows 7 – Tour

- Windows 7 – Finding Your Files

- Windows 7 – Changing Settings

- Windows 7 – 7 Ways to Have Fun

- Windows 7 – Features

- Windows 7 – Help & How–To's

- Windows 7 – Personalizing

- Windows 7 – What's New with the Start Menu?

- Windows 7 – What's New with the Taskbar?

- Windows 7 – What's New with Windows Desktop?

- Windows on a Mac

- Window XP File Management

- Windows 7 – What's New
OTHER SOFTWARE
Adobe Acrobat Learning Center
- Forms, Forms, Forms - Easily Create Forms

- Adobe Acrobat 9 - The Basics of Editing a PDF Document

- Adobe Acrobat 9 - Creating Accessible PDF Forms

- Adobe Acrobat 9 - Using the Accessibility Checker

- Adobe Acrobat 9 - PDF Accessibility Repair Workflow

- Adobe Acrobat 9 - Creating Accessible PDF from Microsoft Word

- Adobe Acrobat 9 - PDF Accessibility Overview

- Adobe Acrobat 9 - Working with Tables: PDF Forms Using Acrobat and Live Cycle Designer

- Forms, Forms, Forms - Easily Create Forms
-
Dreamweaver 8
- Dreamweaver 8 – Resources & Documentation

-
EB Suite
- EB Suite – Agent Guide for Creating & Managing Cases

- EB Suite – How to Create the Top 3 Requested Reports
-
PCI Broadcast Tool
- Using the PCI Broadcast Tool

-
Second Life
- Second Life – How to Use Resources

- Second Life – Slide Tutorial

-
Faculty and Staff Email (Exchange)
- Options for Accessing CSUN Email (Webmail, Email Client, Smartphone)

Outlook
- Emailing Within a Microsoft Application

- Outlook 2011 – Configuring Outlook

- Outlook 2011 – Get Started with Outlook

- Outlook 2010 – Basic Tasks

- Outlook 2010 – Mail, Calendar, Contacts, Notes & Tasks

- Outlook 2010 – Make the Switch

- Outlook 2007/2010 – Calendar Best Practices: Do's, Dont's & Tips

- Outlook 2007 – Up to speed with Outlook 2007

- Outlook 2007 – Using Mail, Calendar, Contacts, Tasks & Notes

- Outlook 2007 – Using Calendaring Features
- Outlook 2007 – Calendar I: Outlook Calendar Basics

- Outlook 2007 – Manage Your Mailbox I: Finds Its Size and Trim It Down

- Emailing Within a Microsoft Application
Entourage
- Entourage 2004

Gmail
Majordomo
- Creating and Managing Majordomo Lists (List Administrators)

- Two Ways for Faculty to Email Students

Junk Mail/SPAM
- Setting Junk Mail/SPAM Filter Controls - Faculty & Staff

MOODLE
ELLUMINATE
Elluminate
- Elluminate – Getting Started

BROWSERS
SOLAR SUPPORT
SOLAR Financials
- Financials (Fin)

SOLAR Human Resources
- Human Resources (HR)

SOLAR Student Administration
- New Faculty Center

- New Faculty Waitlist Feature

- Student Administration (SA)

- Faculty Center – Class Rosters, Emailing Students, Permission Numbers

- Faculty Center – Incomplete Contract

- Faculty Center – Recording Grades

- Managing Service Indicators

- Student Inquiry/Advisement Applicant Option

- TEWS – Advisors

- TEWS – Faculty

- Withdrawal & Repeat Summaries (Faculty)

- Withdrawal & Repeat Summaries (Staff)

The myNorthridge Portal
- Personalizing the Portal

SPSS
-
SPSS 20 – Vista Home Business / Windows 7 (64 bit)
- SPSS 20 (64 bit) – Advanced Statistics

- SPSS 20 (64 bit) – Bootstrapping

- SPSS 20 (64 bit) – Categories

- SPSS 20 (64 bit) – Complex Samples

- SPSS 20 (64 bit) – Conjoint

- SPSS 20 (64 bit) – Custom Tables

- SPSS 20 (64 bit) – Data Preparation

- SPSS 20 (64 bit) – Decision Trees

- SPSS 20 (64 bit) – Direct Marketing

- SPSS 20 (64 bit) – Exact Tests

- SPSS 20 (64 bit) – Forecasting

- SPSS 20 (64 bit) – GPL Reference Guide

- SPSS 20 (64 bit) – Missing Values

- SPSS 20 (64 bit) – Neural Networks

- SPSS 20 (64 bit) – Regression

- SPSS 20 (64 bit) – Statistics Algorithms

- SPSS 20 (64 bit) – Statistics Brief Guide

- SPSS 20 (64 bit) – Statistics Command Syntax

- SPSS 20 (64 bit) – Statistics Core System Guide

- SPSS 20 (64 bit) – Statistics Base

-
SPSS 20 – XP Professional / Vista Home Business / Windows 7 (32 bit)
- SPSS 20 (32 bit) – Advanced Statistics

- SPSS 20 (32 bit) – Bootstrapping

- SPSS 20 (32 bit) – Categories

- SPSS 20 (32 bit) – Complex Samples

- SPSS 20 (32 bit) – Conjoint

- SPSS 20 (32 bit) – Custom Tables

- SPSS 20 (32 bit) – Data Preparation

- SPSS 20 (32 bit) – Decision Trees

- SPSS 20 (32 bit) – Direct Marketing

- SPSS 20 (32 bit) – Exact Tests

- SPSS 20 (32 bit) – Forecasting

- SPSS 20 (32 bit) – GPL Reference Guide

- SPSS 20 (32 bit) – Missing Values

- SPSS 20 (32 bit) – Neural Networks

- SPSS 20 (32 bit) – Regression

- SPSS 20 (32 bit) – Statistics Algorithms

- SPSS 20 (32 bit) – Statistics Brief Guide

- SPSS 20 (32 bit) – Statistics Command Syntax

- SPSS 20 (32 bit) – Statistics Core System Guide

- SPSS 20 (32 bit) – Statistics Base

-
SPSS 19 – XP / Vista / Windows 7 (32/64 bit)
- SPSS 19 (32/64 bit)) – Advanced Statistics

- SPSS 19 (32/64 bit) – Bootstrapping

- SPSS 19 (32/64 bit) – Categories

- SPSS 19 (32/64 bit) – Complex Samples

- SPSS 19 (32/64 bit) – Conjoint

- SPSS 19 (32/64 bit) – Custom Tables

- SPSS 19 (32/64 bit) – Data Preparation

- SPSS 19 (32/64 bit) – Decision Trees

- SPSS 19 (32/64 bit) – Direct Marketing

- SPSS 19 (32/64 bit) – Exact Tests

- SPSS 19 (32/64 bit) – Forecasting

- SPSS 19 (32/64 bit) – GPL Reference Guide

- SPSS 19 (32/64 bit) – Missing Values

- SPSS 19 (32/64 bit) – Neural Networks

- SPSS 19 (32/64 bit) – Regression

- SPSS 19 (32/64 bit) – Statistics Algorithms

- SPSS 19 (32/64 bit) – Statistics Brief Guide

- SPSS 19 (32/64 bit) – Statistics Command Syntax

- SPSS 19 (32/64 bit) – Statistics Core System Guide

- SPSS 19 (32/64 bit) – Statistics Base

WIRELESS ACCESS
ACCESSIBLE TECHNOLOGY
ATI Web Site CSUN
ATI Website CSU
- Web Accessibility Training Information Note: Must be connected to the campus network.

- Web Content Editor's Guide for faculty/staff who update existing web content Note: Must be connected to the campus network.

- Website Developer's Guide for faculty/staff who create new pages and/or maintain department/college web server(s) Note: Must be connected to the campus network.

- Web Accessibility Training Information Note: Must be connected to the campus network.
Adobe Acrobat Learning Center
FILE MANAGEMENT
REMOTE ACCESS
- Mapping the UDrive

- Mapping the VDrive

- Mapping the WebDrive

- SSH Secure Shell

- Mac SFTP - Fugu

- Working Remotely at CSUN - Tips & Tricks

VPN
- Accessing Open Wireless (csun)

- Accessing Open Wireless (csun) - Tips & Tricks for Laptop Users

- Downloading Instructions for Mac OS X 10.6

- VPN for iOS

- VPN for Mac OS X 10.5 & 10.4

- VPN for Mac OS X 10.6, 10.7.4 & 10.8

- Downloading Instructions for Windows XP & 64-bit

- Downloading Instructions for Windows Vista

- VPN FAQs

- Accessing Open Wireless (csun)
MAC TUTORIALS & REFERENCES
General Information
- Mac Video & Text tutorials

- Anatomy of a Mac

- PC to Mac: The Basics

- Windows on a Mac
- Wireless Basics for Mac
- Take Control of Maintaining Your Mac

Office for Mac
- Office 2011 – Features

- Office 2011 – What's New / How–To

- Excel 2011 – Get Started with Excel

- Outlook 2011 – Configuring Outlook

- Outlook 2011 – Get Started with Outlook

- PowerPoint 2011 – Get Started with PowerPoint

- Word 2011 – Get Started with Word

SECURITY
OPERATING SYSTEMS
- Windows 7 – What's New

- Windows 7 – Getting Started

- Windows 7 – Tour

- Windows 7 – Finding Your Files

- Windows 7 – Changing Settings

- Windows 7 – 7 Ways to Have Fun

- Windows 7 – Features

- Windows 7 – Help & How–To's

- Windows 7 – Personalizing

- Windows 7 – What's New with the Start Menu?

- Windows 7 – What's New with the Taskbar?

- Windows 7 – What's New with Windows Desktop?

- Windows on a Mac

- Window XP File Management

OTHER REFERENCES
- Free Online Tutorials – Tutorials on a list of computer related topics

- Microsoft.com Online Tutorials – Free self paced training courses for Office programs

- Safari Books Online – A on-demand digital library with over 7,000 technology, digital media, business books and videos online. Note: Must be connected to the campus network.

- Subscribe to the CSUN IT YouTube Channel – Instructions on how to subscribe to the CSUN IT YouTube channel.

- Tutorialized – A large selection of Graphics, Web Design & Development, Business Applications, Databases, Desktop Programming, Operating Systems, Video Editing tutorials and more

Hardware/Equipment
CLICKERS
- Clickers (Request Guide)
MEDIA
MOBILE DEVICES
CSUN Wireless
- Accessing Open Wireless (csun)

- Accessing Open Wireless (csun) - Tips & Tricks for Laptop Users

- Android 2.2

- iPad

- iPad – Getting Started

- iPhone 3 & 4

- Encrypted Wireless Network Access Guides (csun_wpa2)

- FAQs

- Mac Wireless Basics

- VPN

Student Gmail
- Android 2.2

- iPad

- iPhone 3 & 4

- Android

- iPad, iPhone, iPod touch

- Blackberry

- Palm webOS

- Symbian

- Windows Mobile 5

- Windows Mobile 6

- SnapperMail

Faculty & Staff Email
- Configuring Your Smartphone

PHONES & VOICEMAIL
IT Training & Development
training@csun.edu
(818) 677–1700
Oviatt 19
IT Help Center
http://techsupport.csun.edu
(818) 677–1400
M–Fri: 8am–5pm
Oviatt 33
