Home Page‎ > ‎

Computer Stuff

Here are random videos about Computer Hardware and Software that Don't Fit Anywhere Else.  My videos on GIS Programs are HERE and my videos on the R Statistics Software are HERE with my econometrics videos.

Also: Want to know the best FREE software out there? Check out TANSTAFL.burkeyacademy.com.  It is just a brief listing of some of my good finds of free programs and tools.

Excel Tips and Tricks
Excel Match FunctionIn response to a reddit statistics question: How can you find numbers that repeat in different columns?  Here is my solution. *File:MatchFunction.xlsx
Excel vlookup A quick introduction to exact and range vlookups in Microsoft Excel. *FILE*
Excel HIstograms: Labeling the Bins Properly The easy way is to put the bin ranges in the center of each bar.  A viewer asks: Can you put the limits at each end of the bar?  Yes: but it is difficult.  Let me show you how, the easiest way.
Excel locate scatterplot points An easy way to create an ID to label scatterplot points and find them.
Excel locate scatterplot points: EXTREME EDITION I created an Excel Spreadsheet with over 1,000 checkboxes, to allow you to highlight points in a scatterplot... or do whatever else you'd like to do with them. File Download
Two Scatterplots on One Graph Here we add two series in one scatter plot, and make separate trendlines for them.

Computer Tricks and Other Research Tools:
 Portable Apps!Lots of free apps that run on a Pen drive (USB Stick)? The coolest tools you haven't heard about!  www.portableapps.com
Computer Build One (Playlist of 17 Videos) A playlist on how to build your own PC from Scratch (17 videos).  We use an Intel Core i5 3570K, Asus P8Z77-V LK Motherboard, Antec 300 Illusion Case, Corasair CX430 Power Supply, 16GB G.Skill 12800 DDR3 Ram, and a Seagate 1TB SATA 6 Boot Drive.
Computer Build Two (Playlist of 6 Videos) A Playlist on building a second  similar computer, with some additional twists.  In this one we go faster and don't explain the basics, but focus on the new parts, such as a Samsung 840 series SSD Drive, huge aftermarket heatsink for the processor (Cooler Master Hyper 212 Plus), Corsair Vengeance 2*8GB for 16 GB RAM, and a modular power supply.
Gini Coefficients I calculated Gini Coefficients for the 2000 census, and people have been asking me for the 2010 census updates. This video explains why there won't be any, but where to get passable substitutes.      *FILE*   My old page about Gini Coefficients
Two BRIEF introductory videos about making "screencasting" videos like my instructional videos, using CamStudio (FREE!)  Video 1 is the basic "idea" and Video 2 is the "How To".
Inkscape for Diagrams How I use Inkscape for drawing diagrams. Inkscape Link
Make a sillhouette with GIMPUsing GIMP (free photo editing software) "Intelligent Scissors"  to cut out a picture of my head.  Then I do two things: 1) Make a silhouette 2) Save a cutout of my head with a transparent background to paste into another picture. Gimp Link
Lotus iNotes to GMail Got the iNotes blues? Want to use Outlook, Firebird, or some other program on your phone to check your emails?  In this video I show you how to forward all incoming emails from Lotus Domino/iNotes to Gmail, set up Gmail to send from your work email address, and allow Outlook to connect to Gmail with POP or IMAP protocols.
Add Forge Mod to MinecraftLike to play Minecraft? I have a server I have set up, and here I show you how to add the Forge Mod that give lots of additional fun crafts to build.
Basic Web Page EditingAn overview of what a basic web page is, and how to open one in Kompozer (free web page editor).