Our upgrades to Office 2007 should be arriving on our desktops either tomorrow or Monday.
To heighten the anticipation, here’s a cool new feature I just discovered in Excel 2007.
Now you can split a column into two columns, so it’s possible to, say, take a column that has first and last names and split the column into TWO columns, with first names in one and last names in the other.
Bring up the Data ribbon, select your column (it needs a blank column to the right of it), and click on “Text to Columns.” This takes the process that is used for converting .CSV or .TXT files to Excel files and applies it to your selection. You can set what characteristics cause the text to split (eg., comma, certain number of characters) and when you click Finish you’ll get the text split into two columns.
Pretty cool!
In case you didn’t catch it in the Butler News Digest today, we can now access BUfiles from off campus! It’s using a program called BUconnect:
“BUconnect is a service that allows the Butler community to access
BUfiles and other Butler services from anywhere in the world. “
To get started, visit http://www.butler.edu/ir/?pg=7268
For more information on how it all works and how to set it up (it’s VERY easy), visit http://www.butler.edu/ir/cmsExternalDocuments/WebConnect.pdf
One question that gets asked rather frequently is about whether a certain program is installed on the library computers. I’m happy to say that BOTH libraries are on I.R.’s official list of “Departmental Labs” and have all the installed programs listed on the I.R. “Lab Locations” website: http://www.butler.edu/labs/?pg=2538
I have also included this information (with a link to that same “Lab Locations” page) in the FAQ list on our website.
Now that we have a secure place for posting things like passwords, here are the new logons for libpub and libalum:
libpub | libpub@)09
libalum | libalum@)09
(those are both “2009” but with the first two digits holding the shift key)
Also, this is a reminder that anyone visiting the library with their own wireless laptop can now get on the “BU Guest Wireless” network without a logon.
Oh frabjous day!! We now have general open Wi-Fi in Irwin Library. The same type of guest access that has been available at Starbucks is now available in Irwin.
If a guest brings a wireless laptop into Irwin, they can click “View Available Wireless Networks” and should automatically see “BU Guest Wireless.” This network requires no username or password and does provide access to the Internet. It does NOT provide access to BUfiles or the databases; instead it asks for EZproxy logon info, just like it does for people off campus. People using the “BU Guest Wireless” network CAN print, but they have to add the printer to their computer. Instructions are at the Reference Desk, but will only be given out upon request.
This will not change most of what goes on in IL119 because database access is usually necessary.
We will still leave the backup instructions (the old way to log on guests) in the binder at the Reference Desk for the time being.
Thanks.
Scott
Comments Off on A New Excel Trick 
Themocracy