ArcUser Magazine (often has interesting "how-to" articles and notes about all ESRI software - copies can be found on Sutton Lab library shelf or online
See especially the set of tutorials entitled Terrain Modeling with ArcView GIS - this is a comprehensive set of tutorials explaining how to download, process, and use a variety of USGS data products.
GeoCommunity has several useful sites:
"Several Rules for Happy ArcView Use" (from Harvard University's Graduate School of Design, Fundamentals of Geographic Information Systems - Paul Cote, Instructor)
Stuff for ArcView Users (Mark Cederholm, Pierssen Publishing)
The Unofficial Arc/Info and ArcView Symbol Page (lines, fills, symbols, etc.)
ArcView Tips and Information (from the School of Geosciences, University of Wollongong, Australia - includes information on extensions, world files, cartographic design, and databases)