Dividing Text in Excel

Application: Microsoft Excel 2007 & 2010


Have you ever needed to separate last name and first names in an excel spreadsheet? There are frequently times when spreadsheet data needs to be divided into more granular information in order to better sort, filter, alphabetize, or use in a mail merge independently.
Spreadsheets can be updated with Excel’s Text to Column command that can divide the data into separate columns.


Divide data in one column
*These steps apply to data where a space is used to divide. For data that is divided by commas or other, please see the article listed below.
1. Insert a column(s) where the divided data will be placed.
2. On the Data ribbon, select Text to Columns.
3. The Text to Columns Wizard will appear. In Step 1, select Delimited.
4. Click Next. In Step 2, select Space. Be sure to uncheck all other options.
5. Click Next. In Step 3, select Text.
6. Click Finish.

             

        becomes

For more information about this feature, please visit the Microsoft Office article.

Web 2.0 Tool of the Week: Second Life

Second Life is a 3-D virtual world entirely built and owned by its Residents. Since opening to the public in 2003, it has grown explosively and today is used by universities, businesses and individuals from around the globe.


An Invitation to See Second Life in Action
On April 12-13, TWU will host the Annual Student Creative Arts and Research Symposium. TWU uses Second Life during the symposium to allow students to present a virtual poster from off campus. As in real-life, presenters attend one session of the symposium by logging into Second Life from a computer and having their avatar present during a session. Students present their research to a global audience in addition to the visitors on the TWU campus.
A real-life viewing of Second Life will be available in ACT 225 and is open to the public. Student research will be presented at the following times in world:


Tuesday, April 12
12:00-12:50 p.m.
6-7:20 p.m.


Wednesday April 13
9-10:20 a.m.
12:15-1:00 p.m.
6-7:20 p.m.


In addition to a guided tour in ACT 225, visitors are welcome to try Second Life hands on in ACT 603 or from the convenience of your home. We invite you to join us in this celebration of student research!

Tip of the Week: Adding to My Links

Application: SharePoint
SharePoint has its own bookmarking option to allow for direct navigation to frequently used sites. Both SharePoint and other internet sites can be bookmarked. This list of links or bookmarks can be accessed anywhere through SharePoint.

How to add a link or bookmark in SharePoint
1. Go to Share.twu.edu. (From on campus)
2. Navigate to a specific page. For example, click on Instructional Support Services, then select Denton, then select Training.
3. In the upper right corner of the page, click on My Links.
4. Select Add to My Links.
5. A dialog box appears. Make any optional changes needed such as the name of the link, who can view the links, which group to add the link to or create a new group of links.
6. Click OK.

Tip of the Week: Managing Multiple Schedules

Applications: Outlook & SharePoint
Scheduling a meeting with multiple people or managing multiple schedules for various projects can be challenging. Offices use calendars to schedule meetings, vacations, phone coverage, appointments and more. To manage multiple schedules, there are several technology tools available.

Scheduling MeetingsMicrosoft Outlook calendars offer schedule availability options. Each faculty and staff member can designate times as busy, free, tentative, or out of the office. To schedule a meeting in Outlook:

1. Click on the calendar tab in the navigation pane
2. Select the date for the meeting
3. Right-click to open the dialog box and choose an option such as New Appointment, New All Day Event, New Meeting Request, etc.
4. A new dialog box will open. Select options for title, location, length of meeting, reminders, importance, etc.

When inviting others to a meeting with a meeting request, they are given the option to accept, decline, or mark tentative. The meeting request then keeps track of who has responded and how.

Office Calendars
When working with a group of people, SharePoint calendars can be used. The flexibility of SharePoint allows multiple calendars to be built in any site. A different calendar can be used for each project or person. SharePoint calendars can be connected to Outlook for ease of adding and modifying events. SharePoint also has options to determine levels of access to view, edit, or delete events.

Tip of the Week: Dropbox

Web 2.0 Tools Dropbox

Many people work from multiple locations or computers. Some need to access the same file from any location. Files uploaded to Dropbox can be accessed from different computers (Windows, Mac, and Linux), smartphones, or the Dropbox website.

What are the advantages?
• As files are saved in a Dropbox folder, the file is updated from every access point (multiple computers, smartphone)
• Entire folders or individual files can be shared with others
• Files are backed up on the Dropbox server
• Basic account is free with up to 2GB
• File history is kept for 30 days so earlier versions can be restored
• Unlimited undo option
• Files of any type can be stored
• Encryption for both storage and transfer of files
• When using Dropbox to collaborate with others, everyone can see changes when file is saved

Tip of the Week: Using My Site in SharePoint

Application: SharePoint

Each TWU faculty and staff has a My Site space in SharePoint. This is an internal website that can be used to store documents, keep a calendar, project tasks and more. SharePoint is available from on or off campus, making it a flexible way to store and manage information. There are two parts of My Site: My Home and My Profile.

Using My Home in SharePoint
• Personal place to store documents, calendars, surveys, tasks, and lists
• Permissions can be set by item to determine who can view or edit
• Many items can be linked to your Outlook account to view and edit through Outlook

Using My Profile in SharePoint
• Professional public profile page
• Fields to offer information about professional affiliations, skills, contact info, reporting hierarchy
• Option to display a picture

Tip of the Week: Public Folders

Applications: Microsoft Outlook

Public folders are special Outlook accounts that allow a group of people to share email. Public folders can have subfolders as well, for various departmental or project needs.

How are TWU offices using Public Folders?
Departmental email point of contact
Many TWU departments have email enabled public folders so that their department has a generic department point of contact, such as departmentname@twu.edu. These account names can be used in department literature so that several departmental people can process incoming requests.
Departmental central voicemail & fax
Many TWU departments use a public folder for their main line voicemail messages as well as faxes. This can be a time and cost savings to the department.

Tip of the Week: Charts & Tables

Web 2.0 Tools Chartle and Tabelizer

Charts and tables are ways to show data. Many tools are available to create charts and tables for uses in reports, websites, or shared through email and online sources. Several Web 2.0 tools are available to create charts or tables and give HTML code for using the charts on websites.
What are the differences?
• Chartle allows many types of charts to be created, color coded, and shared. Charts can be featured in the Chartle gallery, emailed, or shared on social networking sites such as Facebook or Twitter, among others. With each chart, the HTML code is offered to embed the chart in a website.

• Tabelizer creates a HTML table from spreadsheet data. After the information is entered into the program, options are available to adjust the font size and style as well as the header color. The final product appears on the screen along with the HTML code for use in websites.