Microsoft Office

 

GCF Learn Free

This site offers free, self-paced, online lessons on topics such as computer basics, Microsoft Office, and the Internet.
Whether you are new to the computer, returning for review or just want to gain more 21st century skills, our free computer tutorials can help. From Computer Basics and Online Safety to Social Media and Using the Cloud, this site has a wide range of free technology tutorials to choose from.

Free Training Tutorial

In this website you can learn and self practice all the basics of Excel, Word, and typing. It includes many tutorial videos with easy step by step manual instructions.

Excel Easy

This site offers tutorials (Introduction, Basics, Functions, Data Analysis and VBA) on how to use Excel. You can find related examples and features (300 Examples).

Chandoo.org

The goal at Chandoo.org is to make you awesome in Excel. A site where users constantly teach each other new tricks and ideas using comments and forum posts.

Digital Literacy

 

Alison

ALISON’s suite of Digital Literacy and IT Skills courses includes basics, such touch typing and Microsoft Office training; necessities, such as social and digital media training; and more advanced courses, such as website and app development, programming and Cloud computing. These free Digital Literacy and IT skills courses range from foundation-level certificate courses for complete beginners to a fully comprehensive certification programme.

DigitalLearn.org

A collection of self-directed tutorials for end-users to increase their digital literacy.

Computer Maintenance

 

Cleaning Desktop

How to use compressed air to clean your desktop computer.

Computer Safety & Maintenance

Maintaining a computer involves three things: keeping it physically clean, protecting it from malware, and backing up important files.

PC Maintenance

This is for when your computer seems to take forever to boot, or when it hangs, freezes, and otherwise exhibits frustrating behavior. More than anything, it’s just for when your computer seems to have lost its pep.

Technology Planning

 

Technology Guide and Lifecycles

How long hardware and software is useful and operational for your library

Sample Technology Plan

Taking note of what you have, where you have it, and what your plan for the future is.

 

Navigating Websites & Browsers

 

Website Legitimacy

A list of precautions to take when using the internet to avoid scams, fraud, and fake websites.

Web Extensions

Information on web extensions (.com, .gov, .edu) and what they say about the website. A more extensive list can be found here.

Clearing Browser History

Chrome
Video | Images

Firefox
Video | Images

Edge
Video | Images

Safari
Video | Images

Other Resources

 

New York Public Library

The Tech Guide Handouts enable you to download and print a variety of helpful guides.

Idealware

Idealware, a 501(c)(3) nonprofit, provides thoroughly researched, impartial and accessible resources about software to help nonprofits make smart technology decisions.

WebJunction – Pennsylvania

WebJunction offers a free Course Catalog of library specific courses and webinar archives intended for library staff, volunteers and supporters.

Skillsoft!

The State Library offers Skillsoft! in our partnership with WebJunction. Skillsoft offers general technology and business skills courses.

Mastering the Organizational Map

Trustee Workshop with Pat Wagner: Handouts

Using POWER Library. A Practical Application
Overview of POWER Library e-Resources

 

Ask Here PA/POWER Library Online Courses

Are you new to POWER Library? Have you used Ask Here PA and want to know more about it? Or, do you need continuing education credits? POWER Library and Ask Here PA online training — originally available via WebJunction — is now available via the POWER Library Portal. Both courses provide 3 hours of Act 48 and continuing education credits.

Understanding and Promoting Ask Here PA

Designed for librarians and classroom teachers who wish to better understand how Ask Here PA works and be able to successfully promote the service in your library and classroom.

POWER Library: AP Images

For librarians and library aides new to the AP Images e-resource. This course shows you how to use AP Images to access the unparalleled archives of The Associated Press.

Technology Competencies

A technology competencies curriculum created for library staff by the Ephrata Public Library. This site includes training on basic computer hardware and software uses and functions.

Just the Basics

Learn best practices for helping users borrow OverDrive titles on a variety of popular devices.