Bill MacKenty

HOWTO: turn a normal name into a username with excel

How do I take a list of first names and last names and turn it into a username? The answer is here:

HOWTO_turn_a_normal_name_into_a_username_with_Excel.pdf

Google: Managing google alerts

Creating_and_Managing_Google_Alerts.pdf

Office: how to annotate a Word document

how_to_annotate.pdf

Office: how to password protect an office document

How_to_protect_your_office_documents.pdf

Excel gradebook templates

This is an excel gradebook template I just finished.  I grabbed the basic layout (and some formulas) from here, and then added some cool features:

1) there are 5 different categories of assignments
2) each assignment can be weighted
3) the gradebook dynamically calculates the score depending on the category (which is cool, imho).

PLEASE tell me if you find any bugs and/or problems.

Thanks!

Windows HOWTO: printing in powerpoint

This small PDF will help users see how to print powerpoint slides in that neat “notes” view. 

Here’s a handy movie to watch if you’d like another perspective

Windows HOWTO: Powerpoint advanced

This pdf covers:

Inserting clip art into your presentation
Inserting pictures and other graphics files into Powerpoint
Slide Transitions
Inserting Videos
Animations (basic)

Here are some movies to help you better understand this:

Inserting clip art: part 1
Inserting clip art: part 2
Inserting pictures
Adding transitions
Custom animations

Windows HOWTO: inserting clipart in word

This PDF is a simple guide for inserting clip art and pictures into Word. It is targeted for novice users.

This is a short movie explaining the same idea

Windows HOWTO: Introduction to powerpoint

This small PDF is a simple guide for getting started with Powerpoint. It is targeted for novice users with little to no experience using Windows.

Here’s a movie illustrating the same idea

OS X HOWTO: introduction to Word

This short guide will help new users understand Microsoft Word.  This HOWTO is targetted towards new and novice users.