Lynda.com at NIU

go.niu.edu/lynda

Free online courses on hundreds of topics like business skills, photography, graphic design, web and interactive design, programming, technical certifications and much more.


Get the most out of Office 365 

Lynda playlist created by the Division of IT


Civil Service: Clerk Series

The required skills and suggested courses are aligned to the State University Civil Service System (SUCSS) Clerk Series. Use the suggested Lynda playlists to fill in gaps and to achieve mastery in required skills.

CLERICAL ASSISTANTSUCSS Skill Level RequiredSuggested Lynda Playlist

Tech/ Equipment Skills

Keyboarding 25 WPM None
Operation of standard office equipment Competent None
Word processing, database & software Competent Learn Word 2016: The Basics (1h 14m)
Learn Excel 2016: The Basics (1h 10m)
Communication Skills
Follow written and oral instructions Competent Effective Listening (1h 8m)
Communication skills Skilled Understanding introversion and extroversion (3m 26s)
Entering and exiting a conversation (2m 55s)
Building rapport (3m 22s)
Making a request (3m 57s)
Redirecting gossip (3m 40s)
Communicating with accuracy (4m 38s)
Working with a bully (5m 39s)
Communicating with multiple bosses (4m 58s)
Understanding common etiquette practices during a phone call (4m 9s)
Understanding common etiquette practices when leaving a voicemail message (4m 39s)
Spelling, grammar, punctuation, sentences & paragraphs Working knowledge American English tricks and traps (3m 31s)
Possessive rules (4m 23s)
Using sound-alikes (4m 6s)
Writing or spelling a number (3m 36s)
Comma rules (5m 47s)
Minor punctuation rules (5m 21s)
Troublesome adjectives and adverbs (3m 50s)
Organization & Workflow
Filing Routine by subject Filing made simple (3m 51s)
Knowledge of office practices & procedures Basic Organizing Your Office for Maximum Efficiency (1h 2m)
Managing records and reports Updating Learn PowerPoint 2016: The Basics (1h 3m)
Learn Access 2016: The Basics (1h 6m)
Supervision
Supervision None None
Working Independently, Problem Solving and Analysis
Arithmetic calculations & reconciling Competent Everyday Math Fundamentals (2h 6m)
Work independently, judgment, and problem solving None None

CLERKSUCSS Skill Level RequiredSuggested Lynda Playlist

Tech/ Equipment Skills

Keyboarding 25 WPM None
Operation of standard office equipment Competent None
Word processing, database &software Competent Learn Word 2016: The Basics (1h 14m)
Learn Excel 2016: The Basics (1h 10m)
Communication Skills
Follow written and oral instructions Competent Effective Listening (1h 8m)
Communication skills Skilled Understanding introversion and extroversion (3m 26s)
Entering and exiting a conversation (2m 55s)
Building rapport (3m 22s)
Making a request (3m 57s)
Redirecting gossip (3m 40s)
Communicating with accuracy (4m 38s)
Working with a bully (5m 39s)
Communicating with multiple bosses (4m 58s)
Understanding common etiquette practices during a phone call (4m 9s)
Understanding common etiquette practices when leaving a voicemail message (4m 39s)
Spelling, grammar, punctuation, sentences & paragraphs Thorough knowledge Why does grammar matter? (2m 48s)
American English tricks and traps (3m 31s)
Possessive rules (4m 23s)
Using sound-alikes (4m 6s)
Using look-alikes (5m 30)
Making sentences parallel (4m 55s)
Writing or spelling a number (3m 36s)
Comma rules (5m 47s)
Minor punctuation rules (5m 21s)
Troublesome adjectives and adverbs (3m 50s)
Organization & Workflow
Filing Comprehensive Filing made simple (3m 51s) 
Organizing and naming virtual files (4m 25s)
Knowledge of office practices & procedures Working Organizing Your Office for Maximum Efficiency (1h 2m)
Managing records and reports Maintain comprehensive records Learn PowerPoint 2016: The Basics (1h 3m)
Learn Access 2016: The Basics (1h 6m)
Supervision
Supervision Supervise others What is delegation? (1m 10s)
Understanding the benefits of delegating effectively (2m 5s)
Working Independently, Problem Solving and Analysis
Arithmetic calculations & reconciling Competent Everyday Math Fundamentals (2h 6m)
Work independently, judgment, and problem solving None None

CHIEF CLERKSUCSS Skill Level RequiredSuggested Lynda Playlist

Tech/ Equipment Skills

Keyboarding 25 WPM None
Operation of standard office equipment Competent None
Word processing, database &software Competent Learn Word 2016: The Basics (1h 14m)
Learn Excel 2016: The Basics (1h 10m)
Communication Skills
Follow written and oral instructions Competent Effective Listening (1h 8m)
Communication skills Skilled Understanding introversion and extroversion (3m 26s)
Entering and exiting a conversation (2m 55s)
Building rapport (3m 22s)
Making a request (3m 57s)
Redirecting gossip (3m 40s)
Communicating with accuracy (4m 38s)
Working with a bully (5m 39s)
Communicating with multiple bosses (4m 58s)
Understanding common etiquette practices during a phone call (4m 9s)
Understanding common etiquette practices when leaving a voicemail message (4m 39s)
Spelling, grammar, punctuation, sentences & paragraphs Extensive knowledge Why does grammar matter? (2m 48s)
American English tricks and traps (3m 31s)
Possessive rules (4m 23s)
Using sound-alikes (4m 6s) 
Using look-alikes (5m 30)
Making sentences parallel (4m 55s)
Writing or spelling a number (3m 36s)
Comma rules (5m 47s)
Minor punctuation rules (5m 21s)
Troublesome adjectives and adverbs (3m 50s)
What is plain English? (4m 47s)
Problems from writing that is not clear (4m 27s)
Catch mistakes by reading aloud (8m 45s)
How to avoid wordiness (4m 56s)
Delete extra words from your writing (5m 54s)
Eliminate vague words and expressions (5m 49s)
Remove gibberish and nonsensical writing (3m 21s)
Find the right voice (5m 14s)
Organization & Workflow
Filing Comprehensive Filing made simple (3m 51s)
Organizing and naming virtual files (4m 25s)
Knowledge of office practices & procedures Working Organizing Your Office for Maximum Efficiency (1h 2m)
Managing records and reports Maintain comprehensive records Learn PowerPoint 2016: The Basics (1h 3m)
Learn Access 2016: The Basics (1h 6m)
Supervision
Supervision Organize and supervise others What is delegation? (1m 10s)
Understanding the benefits of delegating effectively (2m 5s)
Avoiding micromanaging (3m 29s)
Working Independently, Problem Solving and Analysis
Arithmetic calculations & reconciling Competent Everyday Math Fundamentals (2h 6m)
Work independently, judgment, and problem solving None None

STAFF CLERKSUCSS Skill Level RequiredSuggested Lynda Playlist

Tech/ Equipment Skills

Keyboarding 25 WPM None
Operation of standard office equipment Competent None
Word processing, database &software Competent Learn Word 2016: The Basics (1h 14m)
Learn Excel 2016: The Basics (1h 10m)
Communication Skills
Follow written and oral instructions Competent Effective Listening (1h 8m)
Communication skills Skilled Understanding introversion and extroversion (3m 26s)
Entering and exiting a conversation (2m 55s)
Building rapport (3m 22s)
Making a request (3m 57s)
Redirecting gossip (3m 40s)
Communicating with accuracy (4m 38s)
Working with a bully (5m 39s)
Communicating with multiple bosses (4m 58s)
Understanding common etiquette practices during a phone call (4m 9s)
Understanding common etiquette practices when leaving a voicemail message (4m 39s)
Spelling, grammar, punctuation, sentences & paragraphs Extensive knowledge including formatting Why does grammar matter? (2m 48s) 
American English tricks and traps (3m 31s)
Possessive rules (4m 23s)
Using sound-alikes (4m 6s)
Using look-alikes (5m 30)
Making sentences parallel (4m 55s)
Writing or spelling a number (3m 36s)
Comma rules (5m 47s)
Minor punctuation rules (5m 21s)
Troublesome adjectives and adverbs (3m 50s)
What is plain English? (4m 47s)
Problems from writing that is not clear (4m 27s)
Catch mistakes by reading aloud (8m 45s)
How to avoid wordiness (4m 56s)
Delete extra words from your writing (5m 54s)
Eliminate vague words and expressions (5m 49s)
Remove gibberish and nonsensical writing (3m 21s)
Find the right voice (5m 14s)
Simplify sentence structure (4m 25s)
Incorporate easy-to-read design features (4m 23s)
Edit flow and content of writing (4m 39s)
Importance of organization structure (4m 17s)
Organization & Workflow
Filing Comprehensive Filing made simple (3m 51s)
Organizing and naming virtual files (4m 25s)
Knowledge of office practices & procedures Extensive Organizing Your Office for Maximum Efficiency (1h 2m)
Managing records and reports Compile and organize complex statistical and narrative records and reports Access 2016 Essential Training (6h 45m)
Word 2016 Essential Training (5h 41m)
Supervision
Supervision Organize and supervise others What is delegation? (1m 10s)
Understanding the benefits of delegating effectively (2m 5s)
Avoiding micromanaging (3m 29s)
Working Independently, Problem Solving and Analysis
Arithmetic calculations & reconciling Competent Everyday Math Fundamentals (2h 6m)
Work independently, judgment, and problem solving Ability to work independently and exercise judgment to analyze and investigate a variety of questions and problems Actively listening to customers (5m 5s)
Overcoming listening barriers (3m 46s)
Anchoring your own attitude (3m 43s)

ADMINISTRATIVE CLERKSUCSS Skill Level RequiredSuggested Lynda Playlist

Tech/ Equipment Skills

Keyboarding 25 WPM None
Operation of standard office equipment Competent None
Word processing, database &software Competent Learn Word 2016: The Basics (1h 14m)
Learn Excel 2016: The Basics (1h 10m)
Communication Skills
Follow written and oral instructions Competent Effective Listening (1h 8m)
Communication skills Skilled Understanding introversion and extroversion (3m 26s)
Entering and exiting a conversation (2m 55s)
Building rapport (3m 22s)
Making a request (3m 57s)
Redirecting gossip (3m 40s)
Communicating with accuracy (4m 38s)
Working with a bully (5m 39s)
Communicating with multiple bosses (4m 58s)
Understanding common etiquette practices during a phone call (4m 9s)
Understanding common etiquette practices when leaving a voicemail message (4m 39s)
Spelling, grammar, punctuation, sentences & paragraphs Extensive knowledge including formatting Why does grammar matter? (2m 48s) 
American English tricks and traps (3m 31s)
Possessive rules (4m 23s)
Using sound-alikes (4m 6s)
Using look-alikes (5m 30)
Making sentences parallel (4m 55s)
Writing or spelling a number (3m 36s)
Comma rules (5m 47s)
Minor punctuation rules (5m 21s)
Troublesome adjectives and adverbs (3m 50s)
What is plain English? (4m 47s)
Problems from writing that is not clear (4m 27s)
Catch mistakes by reading aloud (8m 45s)
How to avoid wordiness (4m 56s)
Delete extra words from your writing (5m 54s)
Eliminate vague words and expressions (5m 49s)
Remove gibberish and nonsensical writing (3m 21s)
Find the right voice (5m 14s)

Simplify sentence structure (4m 25s) 
Incorporate easy-to-read design features (4m 23s) 
Edit flow and content of writing (4m 39s) 
Importance of organization structure (4m 17s)
Organization & Workflow
Filing Comprehensive Filing made simple (3m 51s)
Organizing and naming virtual files (4m 25s)
Knowledge of office practices & procedures Analyze and develop office guidelines, procedures and systems Organizing Your Office for Maximum Efficiency (1h 2m)
Managing records and reports Compile and organize complex statistical and narrative records and reports Access 2016 Essential Training (6h 45m)
Word 2016 Essential Training (5h 41m)
Supervision
Supervision Organize and supervise others What is delegation? (1m 10s)
Understanding the benefits of delegating effectively (2m 5s)
Avoiding micromanaging (3m 29s)
Working Independently, Problem Solving and Analysis
Arithmetic calculations & reconciling Competent Everyday Math Fundamentals (2h 6m)
Work independently, judgment, and problem solving Work independently and exercise judgment to analyze and investigate a variety of questions and problems. Select and develop appropriate criteria, methods and procedures to solve problems.

Actively listening to customers (5m 5s)
Overcoming listening barriers (3m 46s)
Anchoring your own attitude (3m 43s)
Solving Business Problems (39m 3s)
Critical Thinking (1h 6m)