This Google Spreadsheets help page explains and illustrates the breakthrough I needed to get publishable info., for example blog handles and URLs, from more comprehensive and therefore unpublishable spreadsheets (including students full names, student numbers...).
Live illustrations, step-by-step instructions, and video demonstration - Final products perhaps aren't as glamorous as Pageflakes or the like, but you certainly can make-do without another account/sign-in if you already do Google.