Tuesday, February 4, 2014

Tips & Tricks By Devon Taylor

Good Morning Everyone,

I hope that you all had a wonderful long weekend!  This week I've got a tutorial for setting up notification rules in Google Sheets, a Mac OS X Mission Control overview and a great list of Excel tips.  If you have any questions, don't hesitate to ask!

SU Tips and Tricks

Using Mission Control on your Mac is a great way to add a little organization to your workflow. Mission control allows you to add multiple desktops to your Mac that you can switch back and forth from effortlessly.  This is a great way to keep your active programs organized and can also save you time from switching back and forth between them!  For a complete overview of this handy Mac tool, click the link!
This is a great list of Excel tips and tricks from ExcelJet.  Some examples include conditional formatting, filtering lists, concatenation and many more! If you want to learn about these and others, check out the link. 
Curious about Drive?  This list will get you well on your way to mastery!
Notification Rules for Google Drive Spreadsheets
While the new activity stream works to let you know when something has changed in your Drive, you have to actually be in Drive to get any benefit.  That is where notification rules come in. You can set up a rule in your spreadsheet that will notify you immediately of any changes to your sheet.  This works for forms (ie... someone submits a response) or for regular spreadsheets as well!  Check out the link to see how to set up a notification! 

Where I'll Be This Week
Wednesday - Cork Street -
12:00 - 2:00 - Conference Room
Thursday - Wilkins Building -
11:00 - 1:00 - Conference Room
Halpin-Harrison Hall
2:30 - 4:30 - Room 140
Friday - HPB -
11 - 1 - In Front of the Library

No comments:

Post a Comment