Tutorial: Import Data into Excel, and Create a Data Model
Note: Notice the checkbox at the bottom of the window that allows you to Add this data to the Data Model, shown in the following screen.A Data Model is created automatically when you import or work with two or more tables simultaneously. A Data Model integrates the tables, enabling extensive analysis using PivotTables, Power Pivot, and Power View.
Applies To: Excel for Microsoft 365, Excel 2021, Excel 2019, Excel 2016
Add or remove a digital signature for Microsoft 365 files
Invisible digital signatures in Word, Excel, or PowerPoint. An invisible digital signature, like a visible digital signature line, assures the authenticity, integrity, and origin of a document.
Applies To: Excel for Microsoft 365, Word for Microsoft 365, PowerPoint for Microsoft 365, Excel 2021, Word 2021, PowerPoint 2021, Excel 2019, Word 2019, PowerPoint 2019, Excel 2016, Word 2016, PowerPoint 2016
Import Gmail to Outlook - Microsoft Support
Step 1: Prepare Gmail for connecting to Outlook. Before you connect your Gmail account and Outlook, you need to prepare your Gmail account: turn on 2-step verification for Gmail and then create an app password that Outlook/Microsoft 365 will use with your Gmail address to make the connection.. Step 2: Add your Gmail account to Outlook
Applies To: Outlook 2016, Outlook 2013, Outlook Web App for Office 365, Outlook on the web, Outlook on the web for Exchange Server 2016, Outlook Web App
Get started with eye control in Windows - Microsoft Support
Set up an eye tracking device. This guide helps you to set up and calibrate your eye tracking device for use with Windows eye control. We have tested it with the Tobii Eye Tracker 4C device; your experience with other devices might vary.
Create, view, and edit contacts and contact lists in Outlook
Use the People page to create, view, and edit contacts, contact lists, and groups. Create new contacts from scratch, or add someone as a contact from their profile card.
Applies To: Microsoft 365 admin, Outlook.com, New Outlook for Windows, Outlook on the web for Exchange Server 2016
Switch from working offline to online - Microsoft Support
Learn how to switch Outlook from working offline to online with your mail server on Microsoft Support.
Applies To: Outlook for Microsoft 365, Outlook 2021, Outlook 2019, Outlook 2016, New Outlook for Windows
Change your profile picture in Microsoft Teams
Select your profile picture at the top right of Teams. When your account manager opens, select your profile picture again.
Applies To: Microsoft Teams
Change notification settings in Windows - Microsoft Support
To change notification settings for individual senders, under Get notifications from these senders, turn a notification sender either on or off—or select a sender's name and then turn on or turn off notification banners, lock screen privacy, turn notification sounds on or off, and set the priority of notifications.
Join a meeting in Microsoft Teams - Microsoft Support
To learn more, check out the Join a Teams meeting video. Join by link. All you need to join a Teams meeting is a link. Select Join the meeting now in your meeting invite to be taken to a page where you can choose to either join on the web or download the desktop app.. If you already have the Teams app, the meeting will open there automatically.
Applies To: Microsoft Teams
Create professional slide layouts with Designer - Microsoft Support
This is a subscriber-only, Microsoft 365 feature. Find your version. Design ideas for one photo Applies to: PowerPoint for Microsoft 365 Current Channel: Version 1511 or later Semi-Annual Enterprise Channel: Version 1602 or later Multiple photos, color extraction, and facial recognition
Applies To: PowerPoint for Microsoft 365, PowerPoint for Microsoft 365 for Mac, PowerPoint for the web, PowerPoint 2021, PowerPoint 2019, PowerPoint 2016, PowerPoint for iPad, PowerPoint for Android tablets, PowerPoint Mobile