Free Technology Tutorials

The video in this post is a follow-up to the last video I published here about creating a members only WordPress blog. In that video I briefly demonstated a WordPress plugin that allows you to upload a csv file of and create tens of thousands users in a matter of minutes. In this video, I demonstrate how to create that csv file of users with MS Excel. The video is a bit long…I’m sure given a lot of planning and thought I could have demonstrated this in under 10 minutes, but since I can now upload videos of unlimited length to YouTube, and since I no longer have the time to spend hours on creating these, my videos will tend to be a bit longer these days. The upside is, in this video, you should not only learn a thing or two about WordPress, but you may pick up a few Excel tips that could come in handy in several different applications–I demonstrate the use of the “text to columns”, “concatenate”, and “past values only” functions in Excel that are extremely useful. Anyway, enjoy.

In the following video, I demonstrate how to turn an average, total, or any other value into a letter grade, based on your grading scale, in your MS Excel gradebook. This is only one of many applications of these very powerful Boolean functions in Excel.