OIT and A-LEC Help Students Excel with Excel.

Almost two dozen students attended last night’s Excel@Excel hands-on-workshop at SMU’s Altshuler Learning Enhancement Center. The OIT-lead workshop was part of the A-LEC’s practical learning strategy sessions offered throughout the term. A-LEC has partnered with OIT to facilitate four of the 25 sessions available to both undergraduate and graduate students.

Excel@Excel Training in the A-LECYesterday’s workshop covered the basics of Excel and an introduction to formulas. OIT will offer a second Excel workshop for students on February 25th that will explore more in-depth formulas and functions. While last night’s and the February 25th session are both a student-only training, IT Training regularly offers workshops for all members of the campus community.  For more information about upcoming training opportunities, visit our IT Training workshop schedule.

“I’m excited that we have such great training opportunities for all of our campus,” stated Laurene Klassen, the Manager of IT Training, “but, let’s not forget the challenges that some people have to attend our workshops. I always try to encourage others to check out Lynda.com. So many people aren’t yet aware of the great online resources we have and I’m working hard to get the word out. Our Lynda.com license strengthens our training department by offering the courses we can’t regularly offer. Now, we have the tools to assist others to increase their learning by leaps and bounds.”

 

Photo Credit: Rebecca Umobong

4 easy steps to keep the leading zero in Excel!

When working on spreadsheets you might have a need to have a column that has leading zeros. For example, let’s use an ID number, if I was to input the beginning of my id “0010” Excel would automatically remove the first two zeros.  Here’s how to keep the leading zero in Excel:

  1. Right-click on the column you want the leading zero, and select Format Cells.
  2. Select Custom from the category list.
  3. In the Type field, enter how many digits you need. The SMU ID is 8 digits which we will use in our example below.  (Note: You do not need to add quotes to the string.)

Format Cells

4. Click OK. The column will now utilize the format you created!

ID number