Office 365

Office 365 (79)

 

Flash Fill is one of those features in Excel that is easy to ignore or turn off, but it actually does have some very valid use cases that could make life easier! Flash Fill can be tremendously helpful when working on repetitive tasks that would be tricky to implement with formulas. Below are a few examples to demonstrate how this feature can be used. It’s pretty smart! If you’re doing any sort of repetitive task in Excel, I recommend giving it a try.

 

 

 

 

Credit to https://www.excel-easy.com/examples/flash-fill.html for the Flash Fill example ideas!

Read More
Tagged under

 

There’s nothing worse than accidentally sending an email before you’ve finished it (or forgetting an attachment, or sending to the wrong recipient..)! Did you know Microsoft Outlook allows you to attempt to recall a sent message?

 

There is a catch–per the related support article,

-The recipient must use Outlook

-The recipient must be logged on to the mail service provider

-The recipient must not be using Cached Exchange Mode/working offline

-The original message cannot be moved from the Inbox (so if the recipient has rules that would move your message, you’re out of luck)

-The original message cannot be opened and/or marked as read

To attempt to Recall a message, navigate to the Sent folder in Outlook. Open the email in question and select the “other actions” button in the Move section of the menu. Select “Recall This Message”:

Select an option and I suggest leaving the “Tell me if..” checkbox checked so you’ll know if the Recall worked:

Example of a failed recall status message:

 

Read More
Tagged under

 

We’ve all been there. In the midst of editing a Spreadsheet or Word document, you realize you’re in too deep with changes, and everything’s broken, and the formatting is messed up, and and…! If you saved your document to OneDrive, have no fear. It is really easy to recover old Excel, Word and other document versions with the help of OneDrive.

 

From Excel and Word, for example, you can access old document versions directly from the program by selecting the file name at the top, then See All Versions under Version History:

This displays the Activities for that document, including other versions. To open a different version, just click on the corresponding activity:

When you access OneDrive online, you can easily view or restore old document versions by right-clicking any file and selecting “Version History”:

This opens a new tab showing the Version History:

Read More
Tagged under

 

If your organization uses Exchange and Outlook, consider enabling MailTips! It’s quite handy and can be a big help.
The MailTips bar (a yellow bar across the top of your email draft) is contextual and can pop up in different situations, including:
-If you select “Reply All” by accident
-If you type “please find attached” or something similar and don’t actually attach anything
-Responding to someone with an Out-Of-Office message up in Outlook

 

So, to enable MailTips, open Outlook.
Select File, then Options:

Select Mail, then scroll down to the MailTips section and click “MailTips Options”:

You will see a pop up with full a list of conditions that trigger MailTips. Below, you’ll see options for displaying MailTips–I recommend the first option, “Display Automatically when MailTips apply”:

 

That’s it! It’s saved me from embarrassment more than once, I hope you find it useful.

Read More
Tagged under

 

If you’re an Outlook and OneNote user, this tip might be handy! You can link any text in OneNote to a task in Outlook…that you can manage from OneNote! It’s fantastic if you do most of your organizing in OneNote.

 

So, open up OneNote and select the text you wish to turn into a task. It can have a “To Do” (or any other) tag.
A small formatting window should pop up, or you can right-click to make it appear:

Select the Red Flag, then one of the below options depending on the due date:

If you check in Outlook, under your “To-Do List” or “Tasks”, you will see the task you created in OneNote:

Changes sync immediately, no matter where you update the task from. If you mark as complete in one program, it will be updated in the other as well.

Read More
Tagged under

 

Did you know you can personalize your space on portal.office.com? You can specify your start page, change the theme, and access other application settings from one place.

 

Sign in to Portal.Office.com

Click on the Gear near your name to display the Settings menu:

 

You can expand Theme to select a personal theme–some of them are motion-enabled, so that’s fun! Don’t forget to “Save” in the Theme section:

More practically, you can also set your Start Page from an option list (I wish Dynamics was on this list!):

You can also update notification settings (so it doesn’t chime in the browser every time you get an email!) and change your password from this Settings menu as well.

Read More
Tagged under

 

On the topic of the Office 365 Home Page, I wanted to bring to everyone’s attention a sneaky little feature on portal.office.com that is hiding in plain sight.  If you’re working on a project and keep accessing the same documents, or would like to quickly reference any document at all (including OneNote Notebooks!), it’s easy to “Pin” them.

In the Documents section, there is a “Recent” Tab (shows by default), and a “Pinned” tab, along with “Shared with me” and “Discover”.
WELL, any document that shows up in the “Recent” tab can be pinned to the “Pinned” tab with a few clicks:

-Find any file you wish to save in the “Recent” tab. Hover over the file, and on the right, to display the “. . .” menu, then select “Pin to this list”:

The file will appear in the “Pinned” tab. When you’re ready to remove it from the Pinned list repeat the same steps, but “Unpin from this list” instead:

-You CAN Pin shared documents as long as they appear in the “Recent” tab first.

Read More
Tagged under

 

If you haven’t worked with this relatively new program from Microsoft before, I encourage you to check it out. Sway is like a super-modernized Powerpoint–it’s really good at displaying information in a clean way, but there is so much more room for customization than Powerpoint, which is pretty linear in design.

You can display information Vertically, Horizontally, or like a Slideshow. You can also specify right-to-left layouts as needed.

You can add multimedia directly from Services like OneDrive, Twitter, YouTube, Flickr (and more), or upload files from your device.

Here are two Sway links so you can actually check out a real “presentation”:

How to Sway
Universe Cheat Sheet

This is a great blog post going over Sway basics:
https://tracyvanderschyff.com/2017/09/09/sway-101-resources/

Microsoft’s “Getting Started with Sway”:
https://support.office.com/en-us/article/getting-started-with-sway-2076c468-63f4-4a89-ae5f-424796714a8a

Finally, https://sway.com

If you copy a Sway link and paste it into OneNote, the Sway presentation will embed automatically, so you can give it a try with the How to Sway example above:

So, next time you have a presentation or report to work on, consider trying Sway!

Read More
Tagged under

 

If you are still logging in to Portal.Office.com using a “.onmicrosoft.com” domain, it may be time to update this with your organization’s domain.   You may also see this recommendation pop up on the Office 365 Portal Admin Home page:

It’s easy–ESPECIALLY if your domain is with GoDaddy–and free!

You should either have access to your organization’s domain information yourself, or warn your webmaster ahead of time so they watch out for the verification code/email (which expires 60 minutes after being sent). DNS Settings must also be updated manually if you do not use GoDaddy–another reason to warn your webmaster/DNS manager! Please note that you must be a Global Administrator to do this.

From the Office 365 Admin Center, go to Setup–>Domains:

You will see a list of domains and their status. To add a new Domain, click “Add Domain”:

Enter your domain name (this should be the same as your regular company email):

Next, verify the domain by sending a verification email to the webmaster OR by having them add a TXT record into Neustar. NOTE: If you use GoDaddy, you can just select that option and sign in from this screen! If you don’t see that as an option, your Domain is not hosted with GoDaddy.:

Proceed to the next screen. It will ask how you want to use your Domain with Office 365. Select your required options and specify if this is for on-prem mailboxes or not, then proceed to the next screen.

You will need to add the specified DNS records to your DNS in a separate window or tab.

After waiting about 15 minutes for the DNS to update,  go back to your Office 365 Domain Set-up page, and select “done, go check”.

 

That’s it! You can now sign in with your actual email, instead of the “.onmicrosoft.com” domain.

Read More
Tagged under

 

One of my favorite new [to me] discoveries in Microsoft Teams is the Planner. The Planner was clearly designed with collaboration in mind, giving you the ability to assign owners to different tasks. However, It works JUST as well as a personal or non-collaborative planner, and I’ve actually started to use it heavily for my own work. I love it! If you’re interested in giving it a spin, keep on reading.

Before diving in, just a quick side note about using the Planner for yourself…I actually created a private team, gave it my own name, and am using that as my own personal “headquarters” in Teams. I can keep notes, files, and I have a nice Planner tab that I’m loving to keep track of my tasks.  So Teams can be great for non-collaborative organization, too!

To add a new Planner tab to any team, select the + next to your other tabs:

Select Planner:

Give the tab a name (you can always change this later):

Voila!

A few things to point out:

  1. Different lists are referred to as “Buckets”. To add a new Bucket, just click right on the “Add new bucket” text and type away.
  2. You can filter by keyword, assignee, Due Date, and Label:
  3. You can Group By Bucket, Assigned to, Due Date, etc:
  4. The actual tasks might look really simple (too simple), but after you create a task, you can click on the task and more details pop up:

     

    You can do so much more from the details screen!
    a. You can update the progress and start/due dates
    b. Add collaborators (including non-team members)
    c. Add a description
    d. Give it a label
    e. Add sub-tasks! I love this. If the “task card” is looking too simple, you can add the description and sub-tasks (checklist items) to the card by clicking the “Show on card” checkbox
    f. Add attachments! Unfortunately right now they must either be added via URL or SharePoint. I’m hoping they’ll add a local upload option as well.
    g. Add comments (this is a great way to ask questions or update the status for yourself or collaborators)
    h. See activity & comments

  5. It’s easy to show completed tasks, though they are hidden by default
  6. You can also access the planner from the Office 365 Portal! (Apps–>More)

 

The Planner has been incredibly helpful to me and I highly encourage you to give it a try, whether you use it for yourself or collaboratively.

Read More
Tagged under
Top
We use cookies to improve our website. By continuing to use this website, you are giving consent to cookies being used. More details…