Below is a list of our upcoming free training workshops. Scroll down to get this week?s software tip!
Wednesday, September 10
Windows Vista Essential Skills, 10 ? 11:30 a.m., Cook 3
Blackboard: Stop “Uploading” Content, Just Drag and Drop! 1 ? 3 p.m., Cook 3
Thursday, September 11
PowerPoint 2007 – New Features, 2 ? 4 p.m., Cook 3
Blackboard Fundamentals, 1 ? 3 p.m., Cook 19B
Friday, September 12
Excel 2007 – Advanced Calculations, 9 ? 11 a.m., Cook 3
Monday, September 15
Office 2007 – Overview/Road Show, 11 ? noon, Cook 3
Virtual Workspace Essentials, 2 ? 3:30 p.m., Cook 3
Tuesday, September 16
Photoshop Elements I – Hands-on Tour, 9 ? 11 a.m., Cook 3
Blackboard Grade Center, 1 ? 2 p.m., Cook 3
Wednesday, September 17
Blackboard: Stop “Uploading” Content, Just Drag and Drop! 9 ? 11 a.m., Cook 3
Excel 2007 Basics for PeopleSoft Financials Users, 2 ? 3 p.m., Cook 3
Thursday, September 18
PowerPoint 2007: Adding Transitions and Animation Effects, 2 ? 4 p.m., Cook 3
Friday, September 19
Emerging Technologies – A YouTube and MP3 Professor: Reaching Today’s Online Student, noon ? 1 p.m., Cook 404B
I Found It in the Library…Of All Places! noon ? 1 p.m., Cook 3
I Found It in the Library…Of All Places! 1:30 ? 2:30 p.m., Cook 3
Monday, September 22
Office 2007 – Overview/Road Show, 9 ? 10 a.m., Cook 3
Tuesday, September 23
SharePoint Designer: Creating a Web Site, 10 ? noon, Cook 3
To register for workshops and view additional course information, go to {http://www.towson.edu/otstraining}. The site also contains self-help documents and movie tutorials as workshop alternatives.
SOFTWARE TIP OF THE WEEK
Excel 2003/2007 – Handling leading zeros in number codes
You may sometimes enter numbers in Excel that have leading zeros. For example you may enter social security numbers or zip codes that require a leading zero. Unfortunately, Excel removes the leading zero when you may want it to remain in the spreadsheet. Below are steps to force the leading zero to remain visible in the spreadsheet.
1. Highlight the row, column or cells that you wish to format with leading zeros and right click. The Format Cells dialog box will appear.
2. Click on the Number tab.
3. Click on Custom under Category.
4. On the right, click under Type.
5. Type the desired custom format as defined below:
? For Social Security Numbers, type this custom format: 000?000?0000
? For ZIP codes, type this custom format: 00000
6. Click on OK.
To sign up for free technology workshops or view additional materials related to software training, visit OTS Training online at {http://www.towson.edu/otstraining}. You can also contact us directly regarding any software training related issues at {training@towson.edu} or 410-704-4070.
