Tips for Using Excel in Office 365

Let your data tell a story

With Office 365 you can easily tell the story of your data. Perform complex tasks quickly, visualize your data to understand it better, and share your workbooks for better results.

Analyze your data instantly

Discover and compare different ways to represent your data visually then apply formatting, sparklines, charts, and tables with a single click.

Learn more

Get a better picture of your data

Let Excel recommended the charts that best illustrate your data’s patterns. Quickly preview your chart and graph options, then pick the ones that present your insights most clearly.

Learn more

Let Excel work for you

Save time as Excel learns your pattern and auto-completes remaining data. No formulas or macros required.

Learn more

For more information on Office 365 at SMU, please visit our webpage http://www.smu.edu/BusinessFinance/OIT/Services/o365.

O365 for SMU Students

A better way to work for SMU students

With Office 365, you can read, write, collaborate, and present ideas—from virtually anywhere with consistent, clean, and fast experiences.

Simplify sharing

Your files are saved online, so you can send everyone a link to the file where updates can be made together, at the same time.

Learn more

Zoom in with PowerPoint

Direct your audience’s attention right to your point in your PowerPoint presentation. Zoom in on a diagram, chart, or graphic with a couple of clicks, and zoom out just as smoothly.

Learn more

A PDF time-saver you’ll love

Open a PDF in Word on your desktop, and you can edit content as if you created it in Word.

Learn more

OneDrive for Faculty, Staff, & Students

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 unlimited 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.

Sounds great! How do I access my OneDrive?

Visit http://office365.smu.edu and click Login.
Enter your SMU email address using the @smu.edu format (user@smu.edu).
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.

Student Email Migration

Here are a few things you need to know about the student email migration to Microsoft Exchange:

After migration, you will have 50 GB of storage in your email mailbox.
Your email address will not change.
All of your content will be moved from your current mailbox.
You will still have access to the full SMU Address Book.
You will keep your email even beyond graduation!
The POP protocol will no longer work after the account migration. If you have configured gmail to pull in your SMU email account, this feature will no longer work via POP after the migration.
If you have delegated permissions to your account or shared account folders with another individual, those permissions will break until that individual’s mailbox is also moved.

Migration Steps

Step 1: Identify Large Emails/Attachments
Step 2: Review of the Migration Process
Step 3: Access Your New Mailbox after Migration
Step 4: Reconfigure Email Clients after Migration

Step 1: Identify Large Emails/Attachments

Any attachments or emails larger than 25 MB will cause the migration of your account to fail. If this occurs, we will contact you to remove the message and reschedule the migration of the account. If you believe you have a message that exceeds this size limit, please download the attachments onto your computer and then delete the message from your account.

Step 2: Review of the Migration Process

You will receive an email notifying you of your assigned day for migration. Within 24 hours of that assigned day, a process will begin to copy your current mailbox contents to your new Office 365 mailbox. You will still have full access to your current email through webmail.smu.edu or any configured email clients.

Between 7am and 8am on your assigned day, the final synchronization will occur. If you are logged into webmail or any email clients at that time, you will simply receive an error. At that point, you will need to begin accessing your email through Office 365. Interruption to your email access should be less than 5 minutes.

Step 3: Access Your New Mailbox after Migration

To access your new mailbox after migration:

Go to office.smu.edu
Click Login
Enter your @smu.edu email address as the username
You will be redirected to another login page
Enter your account password
You can now access your mail by clicking the Outlook link in the menu bar. You can switch between other Office 365 services licensed for your account (such as OneDrive) by using that main menu bar as well.

Step 4: Reconfigure Email Clients after Migration

If you have configured your email account on a mobile device or email client, you may need to delete and recreate your device’s email account. For detailed instructions visit http://www.smu.edu/BusinessFinance/OIT/Projects/Office365.

The general information required for the account setup is listed below:

Account Type: Exchange/Corporate
Email: your email address using the @smu.edu format (mustang@smu.edu)
Server: outlook.office365.com
Domain: leave this field blank
Username: your email address using the @smu.edu format (mustang@smu.edu)
Password: your SMU password

For more information, please visit http://www.smu.edu/BusinessFinance/OIT/Projects/Office365.

Free Office 365 for SMU Students

Everyone at SMU is united behind a single goal – help prepare our students to become the best they can be. Now, there are exciting news that aim to go a long way to achieve that goal, we are providing Office 365 to every one of our students for free. This automatically updatable, subscription-based software ensures our students always have the latest version of Word, Excel, PowerPoint, OneNote, and more for as long as they’re a student here and the program continues. According to an IDC study, students with Microsoft Office skills are better prepared for work in the professional world and we are pleased to help our students on their road to success.

• Install on up to 5 compatible PCs and Macs, plus 5 tablets (including iPad!)

• Use with OneDrive for automatic device syncing

• Gain valuable skills on the world’s most popular productivity software

• Use the same programs as the faculty to ensure full file fidelity

This offer is available to all students at SMU. To get your free Office 365, visit Office.com/GetOffice365 and follow the download instructions. If you have any trouble, view our service page or contact the IT Help Desk for assistance.