Need to find an event on your calendar but don’t know when it occurred? Whether you’re using Outlook or Outlook Web App, you can quickly search your calendar, or other people’s calendars, to find a particular event.
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:
Right click on the column you want the leading zero, select Format Cells
Select Custom from the category list
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.)
4. Click OK. The column will now utilize the format you created!
Stay organized and collaborate with teammates using OneNote in Office 365 on all your devices. Your notes are saved automatically as you make them—just like a paper notebook. They go with you everywhere too and, unlike paper notebooks, you don’t have to worry about losing them.
Share your OneNote notebooks with others, so that everyone can edit and share notes in the same place. Your notes are synced to OneDrive for Business, giving everyone access to them from wherever they are.
Tech Day is free for SMU Faculty, Staff and Students. Topics range from Adobe to LinkedIn with subject matter experts from various departments at SMU as well as special guest speakers from Adobe and Apple. As there are a limited number of seats, all sessions will be on a first come first served basis. We look forward to seeing you there!
In case you haven’t heard, OneDrive is now available for all SMU faculty, staff, and students! What does that mean? OneDrive for Business is a Microsoft online service that provides resources for file storage, collaboration, and communication. Students and Employees receive 1 TB of space. All files that you store in OneDrive are private initially. However, you can easily change the permissions of the files to share them with other individuals (both at SMU and externally). The single-item file size upload limit is 10GB. You can also access and synchronize files easily on multiple devices.
Enter your SMU email address using the @smu.edu format (email@example.com).
You will automatically be redirected to the SMU Office365 login page.
Enter your SMU email address using the @smu.edu format and your mySMU password.
Click Sign In.
Click OneDrive from the top menu bar. The first time you click on OneDrive, you may see a message that indicates your account is being activated. That process takes a few minutes to complete.
You can use the OneDrive service from the browser window. Once you have initially launched one drive, it should also be a default save option without your Microsoft Office applications. You can also download the OneDrive Sync application onto your computer. This will automatically backup files saved to a specified location to your OneDrive account.
I was just composing an email to a number of people I will be writing on a regular basis. Rather than reinserting each individual or wasting time searching for that last sent item and forwarding to all, I decided to create an Outlook group. It takes a few seconds to set up, and if you communicate on a regular basis with a particular group of people, this trick can save you a lot of time.
To begin, navigate to your Outlook contacts (People). From the Home tab, select New Contact Group. Select Add Members and choose the appropriate Address List. Next, name your group and click Save and Close.
When you are ready to write your group, select the To…button, under the address book select Contacts. Next, go to the name of your group, double-click and click OK.
Your group will display in your email and is available for you to use whenever you need it!
You can easily edit or delete a group by going to your contacts and searching for the group. Once you find the group, right click on the name and select Edit or Delete.
To follow along with last week’s post we wanted to give you a few tips on using screenshots in the Microsoft Suite.
From the Insert tab (available in all of the Office products), select the Screenshoticon. Microsoft gives you two options you can use to insert an image. Click on the drop down arrow and either select Available Window, which gives you the option to insert another window into your document like in the example below:
Or, you can insert a Screen Clipping, which allows you to select the specific item you want to insert. First, click on the window you want to grab the screenshot from to make the window active. Next, go back to the Office product you want to insert the screenshot into. Select the Screenshot icon and select Screen Clipping, the window that you were previously on will gray out.
The cursor will change to a cross +. Left click and select the area you want to insert. Here, I selected just the clip I wanted.
That’s our quick tip of the day. Happy screen clipping!