1 / 31

Work Smarter. Not Harder.

Work Smarter. Not Harder. Anna J. Catterson, PhD Instructional Designer. Scenarios…. Work Smarter. Not Harder. Greetings!. General Concepts. Word, Excel Setting Properties that include tags on all of your files Templates Collaborative Software Open Office and Google Docs.

mjones
Download Presentation

Work Smarter. Not Harder.

An Image/Link below is provided (as is) to download presentation Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript

  1. Work Smarter. Not Harder. Anna J. Catterson, PhD Instructional Designer

  2. Scenarios… Work Smarter. Not Harder.

  3. Greetings!

  4. General Concepts • Word, Excel • Setting Properties that include tags on all of your files • Templates • Collaborative Software • Open Office and Google Docs

  5. Setting Properties – DO THIS!

  6. Saving Files Tags, Titles & NO Spaces!

  7. Using Microsoft Office Word, Excel, PowerPoint and Outlook Templates! http://www.Microsoft.com

  8. Using Microsoft Office Word, Excel, PowerPoint and Outlook Templates! http://www.Microsoft.com

  9. Collaborative Software – FREE! http://www.google.com/docs

  10. Collaborative Software – FREE! http://www.google.com/docs

  11. MS WORD • Options • Proofing (Grade Level) • Customize Ribbon – Developer Toolbar • Quick Access Toolbar • Add-Ins (PDF) • Using the Developer toolbar to create custom forms • Restrict Formatting • Using Styles • Create a style for one report that you use repeatedly • Create styles for everyday use which includes your college font and color • Shortcut Handout

  12. Word – Grade Level

  13. Readability Statistics

  14. Developer Toolbar - Forms NO MORE UNDERLINED FORMS…please.

  15. Developer Toolbar - Forms

  16. Developer Toolbar – Word Forms

  17. Developer Toolbar – Word Forms

  18. Developer Toolbar – Forms

  19. Quick Access Toolbar

  20. Styles

  21. Create a New Style

  22. Example

  23. Tabs - Word • ………………………………….(21)

  24. MS Excel • Excel as a Calculator • Importing Data from the Data Menu (Text, Web, Access or other sources) • Using the Developer Toolbar to create forms in Excel • Setting Properties on the file • Using the Review ribbon to protect sheet and workbook • Quickly create a formula and use fill down tools • Shortcut handout

  25. Excel as a Calculator!

  26. Importing Data – Any Data. • Don’t start over. • Don’t start over. • Do Import from ANY and ALL sources.

  27. Pivot Tables

  28. Formulas

  29. A. Catterson • acattdesigns.blogspot.com • acatterson@gmail.com • Twitter: @annacatterson

More Related