Remove Duplicates in Excel

Explanation of Excel Cursors

Understanding the Excel Cursors will save you a lot of time and frustration

The Select Cursor will highlight cells and is the most common cursor you see

The Move Cursor will move the highlighted cells to another location. It is a quick version of cut and paste

The Auto Fill Cursor will copy formulas and repeat series such as dates and days

Excel Input Restriction

Are people entering in the incorrect data in your spreadsheets?

Make sure the data is valid by using Data Validation.

Go to Data Toolbar-> Data Validation and restrict what can be entered

Power Point 2016 Screen Recordings

Perfect for demonstrations, you can now include screen recordings in your PowerPoint presentations with just a few clicks. Just set up whatever you'd like to record on your screen, then go to Insert > Screen recording, and you'll be able to select a portion of your screen to record, capture what you need, and insert it directly into your presentation in one seamless process.

Smart Lookup

Smart lookup lets you fact-check and research a phrase with results appearing in a sidebar.

Highlight a phrase, click on Review -> Smart Lookup to see results in the sidebar

Outlook attachments made easy

In Outlook 2016 you can easily attach documents you most recently worked on to your emails from the Insert tab.

When Inserting an attachment, select one of your recently saved files

Collaborating on Word Documents

When you and your colleagues want to collaborate on a document, use real time co-authoring to see everyone’s changes as they happen.

First you save the document to OneDrive or SharePoint Online, so others can work in it.

Next, you invite people to edit it with you. When they open and work on the document in Word 2016 or Word Online, you'll see each other’s changes as soon as they're made.

Six new chart types in Excel 2016

Get creative and display information in a new way. The new chart types in Excel 2016 are;