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
Using product keys with Office - Microsoft Support
If you see a Let's get started screen with options to try, buy, or activate Office, this means that Office is installed on your new PC as a 1-month trial of Microsoft 365 Family. You won't receive a product key from your PC manufacturer unless you paid for an Office product key card. Instead, you can start a trial of Microsoft 365 Family, or buy Office.
Applies To: Excel for Microsoft 365, Word for Microsoft 365, Outlook for Microsoft 365, PowerPoint for Microsoft 365, Access for Microsoft 365, OneNote for Microsoft 365, Publisher for Microsoft 365, Visio Plan 2, Excel 2021, Word 2021, Outlook 2021, PowerPoint 2021, Access 2021, Project Standard 2021, Publisher 2021, Visio Professional 2021, Visio Standard 2021, Office 2021, OneNote 2021, Excel 2019, Word 2019, Outlook 2019, PowerPoint 2019, Access 2019, Project Standard 2019, Publisher 2019, Visio Professional 2019, Visio Standard 2019, Office 2019, Excel 2016, Word 2016, Outlook 2016, PowerPoint 2016, OneNote 2016, Project Professional 2016, Project Standard 2016, Publisher 2016, Visio Professional 2016, Microsoft 365 for home, InfoPath 2013
Change page orientation to landscape or portrait - Microsoft Support
Choose either portrait (vertical) or landscape (horizontal) orientation for all or part of your document.
Applies To: Word for Microsoft 365, Word for the web, Word 2021, Word 2019, Word 2016
XLOOKUP function - Microsoft Support
Use the XLOOKUP function when you need to find things in a table or a range by row. For example, look up the price of an automotive part by the part number, or find an employee name based on their employee ID. With XLOOKUP, you can look in one column for a search term, and return a result from the same row in another column, regardless of which side the return column is on.
Applies To: Excel for Microsoft 365, Excel for Microsoft 365 for Mac, Excel for the web, Excel 2021, Excel 2021 for Mac, Excel 2019, Excel 2016, Excel for iPad, Excel for iPhone, Excel for Android tablets, Excel for Android phones
How to set your time and time zone - Microsoft Support
In Date & time, you can choose to let Windows 10 set your time and time zone automatically, or you can set them manually.. To set your time and time zone in Windows 10, go to Start > Settings > Time & language > Date & time.. Open Date & time settings
Find and open File Explorer - Microsoft Support
File Explorer in Windows 11 helps you get the files you need quickly and easily. To check it out in Windows 11, select it on the taskbar or the Start menu, or press the Windows logo key + E on your keyboard.. How to use File Explorer:
Add a list box or combo box to a worksheet in Excel
To set this property. Do this. Fill color. Click BackColor > the down arrow > Pallet, and then pick a color.. Font type, style or size. Click Font > the... button and pick font type, size, or style.. Font color. Click ForeColor > the down arrow > Pallet, and then pick a color.. Link a cell to display selected list value. Click LinkedCell. Link Combo Box to a list
Applies To: Excel for Microsoft 365, Excel 2021, Excel 2019, Excel 2016
Sort data in a range or table - Microsoft Support
To specify the next cell color, font color, or icon to sort by, click Add Level, and then repeat steps three through five.. Make sure that you select the same column in the Then by box and that you make the same selection under Order.. Keep repeating for each additional cell color, font color, or icon that you want included in the sort.
Applies To: Excel for Microsoft 365, Excel for the web, Excel 2021, Excel 2019, Excel 2016
Contact - Microsoft Support
Contact Microsoft Support. What's new. Surface Pro; Surface Laptop; Surface Laptop Studio 2
Open the Camera in Windows - Microsoft Support
How to open the Camera app in Windows. To open up your webcam or camera, select the Start button, then select All apps, and then select Camera in the list of apps. If you have multiple cameras, you can switch between them by selecting Change Camera at the top right once the Camera app is opened.. Open Camera