Microsoft Tips & Tricks

If you use the Microsoft Office suite, you’ll want to join us for tips and tricks in these popular programs:

► Office 365

► OneDrive

► Word

► Excel

► PowerPoint

Get Office 365 For Free

Did you know you can get Office 365 for Education for free? You get access to Word, Excel, Powerpoint, OneNote, and Microsoft Teams.

To take advantage of the offer, go to the website:

http://office.com/teachers

Get access to free professional learning opportunities, as well as earn digital badges and certificates to enhance your skills. More links to tutorials available at the bottom of this page.

Looking for free Microsoft Tools to Engage Your Students?

Check this list out!

Office 365 Environment

Microsoft Office 365 is a subscription service that provides users with the basic productivity applications necessary to get work done in the modern enterprise.

Productivity applications include, but are not limited to, a word processor, a spreadsheet, an email client, a calendar, and a presentation application. In today's session, we'll focus on a few to get started.

Spotlight

Read the two-part TechNotes blog entry, Steps to a Tech-Powered Classroom with Office 365. Want to know how to blend technology into teaching and learning with Microsoft Office 365? Then take these five steps now to get ready for learning!

Windows Tips & Tricks

Tips & Tricks

  1. Switch between open programs: Use Alt-Tab combination to move forward (or Shift-Alt-Tab to move backwards) between open programs
  2. Lock Your Screen: Always do this when away from your machine. Press Windows-L to lock your screen
  3. Secret Text Menu: Right-click on the Windows icon in the bottom-left corner
  4. Setup "GodMode:" Create a New Folder then rename it GodMode.{ED7BA470-8E54-465E-825C-99712043E01C} to get a list of quick settings to adjust your Windows 10 machine
  5. Customize Tiles: Right-click on tiles to get more features
  6. Shake Screen Clear: Lots of open windows? Right-click your most important window then shake it to get rid of other open windows

Unauthorized Software Tips

  • ATube.me: Free open source software for grabbing YouTube videos, saving them to your fav video format or MP3 audio format
  • Firefox Quantum browser: Keep your internet worlds apart; isolate those cookies to stop Facebook and Google snooping on where you go online
  • PicPick: Screenshots made easy. Use PixResizer to size pics/images for placement on web pages.
  • 7zip: Easy to use compression program with AES-256 encryption built-in to pack up files/folders. Also try Secure Space Encryptor (SSE).

Cheats Sheets

Spotlight

Read the TechNotes blog entry, Power Tips for Windows Users. Think you know everything about the Windows operating system? Check out these power tips for Windows and see how much time you can save. Also, read Windows 10 Tips & Tricks.

My Favorite Tips for MS Office Tools

There's no shortage of awesome MS Office resources, such as the Office Shortcuts reference guide shown right. In today's webinar, I'll share some of my favorite tips that I use often.

What are some that you use on a regular basis? Screencast them then share the link or just describe them here.

Share Your tips & tricks

Spotlight

Read the TechNotes blog entry, Expand Classroom Possibilities with Microsoft. See how updates to your favorite Microsoft classroom tools, including Teams, OneNote, Class Notebook, and Immersive Reader, can expand learning. Note: This blog entry was featured by Microsoft OneNote team. Click image right to see tweet.

Explore Microsoft Flow

It works in a similar way to If This Then That (IFTTT). Flow is focused on Office 365 and Microsoft tools. You can find tools to automate the flow of information for Office 365, OneDrive, and more.

Spotlight

Read the TechNotes blog entry, Five OneDrive Tips You Can't Live Without. Looking for ways to increase your productivity and save time? These five tips for OneDrive, a free resource, can help. Also, read Using OneDrive to Back Up Your iOS or Android device

Tips & Tricks

  1. Keyboard Shortcuts (See complete list)
    • Press Ctrl-M to Create a 2nd OneNote window
    • Right click on section/page to Move/Copy it
    • Press Ctrl-T to create a new section
    • Use Shift key plus click-n-drag to combine frames on a OneNote page
  2. Create a table of contents for pages by highlighting multiple pages, then right-click to "Copy the link to page" then paste into desired Table of Contents page. Links work on web in OneNote Online, too!
  3. Embed content (e.g. YouTube, Vimeo, MS Forms) into a OneNote page

Cheat Sheets

Do you like the animated OneNote GIFs shown above? There are more available! Get Nico Paphitis' Entire Collection of Animated GIFs for OneNote. Be sure to drop him a tweet like this one...copy-n-paste it now into Twitter:

Hi, @paphitisn! Thanks for all the OneNote animated GIFs! @mguhlin shared them with me! #onenote #tcea #microsoftedu

Sketchnotes are “…rich visual notes created from a mix of handwriting, drawings, hand-drawn typography, shapes, and visual elements like arrows, boxes, and lines,” says Mike Rohde, author of The Sketchnote Handbook.

Another fun idea includes sketchnoting the six-word memoir using a tool like Microsoft OneNote. See some more ideas about sketchnoting to assist student’s development of their memoirs.

Spotlight

Read the TechNotes blog entry, Get Organized with OneNote. Need help organizing the vast mounds of paperwork generated by your campus? Try using OneNote and the chore becomes a breeze. See MORE OneNote

Want To Be a Power Excel and Sway User? Add Interactive Content!

Create data in an Excel chart and you can get the "embed code" for that place it in the Embed Card. Find out more.

Tips & Tricks

  1. Conditional Formatting
  2. Add up column of data (Alt-=)
  3. Display formulas (CRTL-’ )
  4. Concatenate cell data with a formula such as: =(D1&" "&D2)
  5. Use Ctrl-H to find and replace in multiple cells at a time
  6. Jump up or down on a sheet. Press Ctrl up/down arrow

Cheat Sheets

Spotlight

Read the TechNotes blog entry, Engaging Learners with Microsoft Forms. Dump those old paper rubrics and flip the learning! Empower yourself and your students to use Microsoft Forms for the quick evaluation of academic work. This makes grading easy and simplifies the process for students.

Spotlight

Read the TechNotes blog entries, No More Death by Powerpoint and Free Templates for Powerpoint. Create engaging presentations that look beautiful. And, don't be afraid to read other blog entries featuring Powerpoint, including Powerpoint Translator Makes Captioning Possible

Tips & Tricks

  1. Selecting Separate Bodies of Text (hold Ctrl key down)
  2. Mail Merge
  3. Customize Toolbar
  4. Turn Track Changes on/off
  5. Highlighted Text to Link (Ctrl-K)
  6. Press Shift-5 to Return to Where you were working previously
  7. Special Characters

Cheat Sheets

Microsoft Sway

We'll introduce you to Microsoft Sway so that you can create and share interactive reports, presentations, assignments, projects, and more.

What is Sway?

  • Sway is a presentation program that allows users to combine text and media to create a presentable captivating presentations
  • Sway also allows for collaborative document creation! Multiple users can connect and build together
  • Sways are stored on Microsoft's servers and are tied to the user's Microsoft account

Spotlight

Read the TechNotes blog entry, Podcasting with Microsoft Sway. Podcasting is an amazing way for students to showcase their learning. Use Microsoft Sway and you have a final product that is beautiful and easy to do.

Other Tips & Tricks