Embed a Live Excel Spreadsheet into a Microsoft Sway Presentation

If you’re using Microsoft’s Sway and you want to insert an Excel spreadsheet, there’s just a couple easy steps to do it.

Title of Sway
The title of your Sway

Create a new Sway and give it a title. I’ve called this one Embedding an Excel Spreadsheet.

Media group
Choose the media group

Next, click the plus sign to add more content. Choose the Media group then click the Embed option.

Embed
Choose the embed option

Video explanation

https://www.youtube.com/watch?v=Z0nuf-DyimA”

Create new Excel workbook
Create a new Excel workbook
Upload Excel workbook
Upload an existing Excel workbook

Sway is now waiting for the embed code. You need to get the code from Excel after you’ve uploaded it to OneDrive (or created it online to begin with). So, assuming you’ve uploaded your Excel flle, we’re going to step forward from that point. If you haven’t done that, you need to open up OneDrive and upload it.

Embed option in Excel
Embed option in Excel online

In the online Excel workbook, go to Share and embed and the code is ready at the bottom of the next window. You will be presented with a screen to select different parts of your spreadsheet, leave it at the default for now. Copy the embed code from your clipboard and go back to your Microsoft Sway. Go to the box waiting for your input, and paste the code.

Embed card with code
Sway card with embed code

You’ve embedded that Microsoft document. This is live. If you were to update this in Excel, this document that’s showing here would be updated. You can also interact with this document to a certain extent with the icon lower right hand corner. You can download it or print it.

Sway with embedded document
Sway with embedded document

Embed a Live Word Document into a Microsoft Sway Presentation

If you’re using Microsoft’s Sway and you want to insert a Word document, there’s just a couple easy steps to do it.

Title of Sway
The title of your Sway

Create a new Sway and give it a title. I’ve called this one Embedding a Word Document.

Media group
Choose the media group

Next, click the plus sign to add more content. Choose the Media group then click the Embed option.

Embed
Choose the embed option

Video explanation

https://www.youtube.com/watch?v=9Cnb9eqSvnA”

Create new Word document
Create a new Word Document
Upload Word document
Upload an existing Word document

Sway is now waiting for the embed code. You need to get the code from your Word document after you’ve uploaded it to OneDrive (or created it online to begin with). So, assuming you’ve uploaded your Word document, we’re going to step forward from that point. If you haven’t done that, you need to open up OneDrive and upload it.

Embed option in Word
Embed option in Word online

In the online Word document, go to Share and embed and the code is down here waiting for you. It’s all highlighted. Copy the embed code from your clipboard and go back to your Microsoft Sway. Go to the box waiting for your input, and paste the code.

Embed card with code
Sway card with embed code

You’ve embedded that Microsoft document. This is live. If you were to update this in Word, this document that’s showing here would be updated. You can also interact with this document to a certain extent with the icon lower right hand corner. You can download it or print it.

Sway with embedded document
Sway with embedded document

Google Sheets – Compare two lists for matches or differences

If you’re using Google Sheets and you have two separate columns of data in which you’re looking for matches, there’s a pretty easy way to highlight the matched items. You can also do it the other way around and highlight items that don’t match. You’re typically doing this because your lists are long and you can’t do it visually. However, for this example the lists are purposely small so it’s easy to see.

Two columns with matches highlighted
Matches between two columns are highlighted

Conditional Formatting

We’re going to do it through Conditional Formatting. Go to your menu, then to Format, and select Conditional formatting. The Conditional formatting menu options will pop up on the right-hand side and there’s everything you need right here.

Conditional formatting menu option
Menu option for conditional formatting
Rules for conditional formatting
Rules for conditional formatting

First, apply the conditional formatting to the range which, in this shared spreadsheet (which is also embedded near the end of this page), is C1 to C10. Note that the range is different in the video but the process is the same. You can select the range with your mouse or type it in as C1:C10.

At first, the range should be highlighted because it is set to highlight if it’s not empty. Change this to a custom formula, which is at the bottom. Click on Custom formula is and then it gives you a box that’s waiting for the formula.

Custom formula
Custom formula

You are going to be typing in a formula just like you’re typing into a spreadsheet cell. One of the differences though is now Google Sheets is not going to help you. Once you start typing the function, no helper text will pop up to explain the function. If you want help, type the formula into a cell in the spreadsheet and it’ll help you build it. Then, you can paste it into the custom formula box.

Video explanation

MATCH formula

You want to use a function called MATCH. MATCH is going to look at each cell in the range and check to see if it exists in the other range that you specify. The first parameter that you want, it’s going to do this one cell at a time, is C1. Now type a comma and Sheets will be looking for the range that you want to try to look up C1 in to see if it’s a duplicate. You don’t want this range to shift down every time it evaluates a cell on the right., so use dollar signs before the row numbers to fix the range as such A$1:A$7.

Next, your spreadsheet wants to know if this is going to be an exact match. Enter a 0 (zero) for yes so if it finds exactly Yellow. Now close it off with the parentheses. Your code should look like this:

=MATCH(C1,A$1:A$7,0)

The box that contains this function should have changed from red to blue meaning that the function is now a valid function. It should be working after the box turns blue. You can see it highlighted the color red in green because red is on the list on the left but it didn’t highlight orange because orange isn’t in that list. If you click done, you’ve highlighted everything that exists in the other list.

=ISNA(MATCH(C1,A$1:A$7,0))

If you want to do this the opposite way, and highlight the items in this list that aren’t in the list on the left, wrap your formula in the function called ISNA. The ISNA function is saying – look, if the MATCH function doesn’t work, highlight it. Not if it does work. After the ISNA, put a parenthesis and then go to the very end and close it with the parenthesis.

View of Sheet with ISNA applied

Conclusion

After following this tutorial, you should be able to highlight matches or differences between two columns. If you have any questions, feel free to leave a comment below.

Follow image below for the live Google Sheet with this data

docs share icon

Google Sheets – Show Formulas

If you’re using Google sheets and you have a lot of cells that have data in them, you may be trying to figure out which ones have formulas and which ones don’t. But, you don’t want to have to take the time to go into every single cell and look in the formula bar to see if it’s a value or formula.

formula bar with formula in it
Formula bar

Two solutions

There are two easy ways to show the formulas and they both accomplish the same thing. One is from the menus and one is a shortcut.

Video explanation

Menus

To do this from the menus, you go to View and choose Show formulas. That will immediately make all the cells that have formulas just show you the formula so you can know what’s going on. Keep in mind, while you have this option on, it’s not going to show you the values. When you’re done and you know where the formulas are, just go hide them again and then your spreadsheet is ready to go.

menu option for show formulas
Using the menus

Shortcut

The other way you show formulas in a cell is just by holding down the control key and pressing the ‘ key which is right to the left of the 1 key.

showing formulas
Formulas showing

That’s all you really need to know. That’s the quick and easy way to show formulas and to get them to go away again.

Microsoft To-Do – Using the My Day feature

Purpose

Microsoft To-Do is a task management app that works on your phone, tablet, and computer. The app centers on a simple to-do list, much like the one in Outlook, but adds a few new twists to it. It can be used with Outlook, as the tasks will mostly synchronize, or on its own as a stand alone.

Tasks in Outlook
Tasks in Outlook

Basic Use

Video explanation

My Day

The big innovation with To Do is the My Day function. At the beginning of each day, you open up My Day and it’s blank. The thought is you may have all of these tasks that are nicely categorized and they’re dated, but YOU choose what you do that day.

My Day
My Day

Click on the smart suggestion light bulb and it’s going to suggest things that you do today based on what you have in these lists and what the due dates are. I decided that clean my room is due today but there’s no way I’m doing that.

Light bulb
Click on the light bulb
Smart Suggestions
Smart Suggestions

Now choose what you want to do with your day from scratch. This will give you a fresh list totally under your control. You can left-click and you can reorder by holding down your left mouse key or your finger if you’re on mobile and dragging it down. If you get it done, mark it as completed. If you decide you’re not going to do it, remove it from My Day by moving it to another list. If you decide you don’t want to do something on your My Day list at all, just delete it.

Conclusion

To Do’s power lies in its comfortable resting spot in the Office 365 environment which gives it integration with Outlook. The My Day function sets it apart from Outlook and makes it a worthy candidate for your organization app of choice.