Tutorial: Import Data into Excel, and Create a Data Model
These tutorials build and refine an Excel workbook from scratch, build a data model, then create amazing interactive reports using Power View. The tutorials are designed to demonstrate Microsoft Business Intelligence features and capabilities in Excel, PivotTables, Power Pivot, and Power View. In these tutorials you learn how to import and ...
Create, load, or edit a query in Excel (Power Query)
Create, load, or edit a query in Excel (Power Query) Applies To. Power Query offers several ways to create and load Power queries into your workbook. You can also set default query load settings in the Query Options window. Tip To tell if data in a worksheet is shaped by Power Query, select a cell of data, and if the Query context ribbon tab ...
Use Microsoft Query to retrieve external data
You can use Microsoft Query to retrieve data from external sources. By using Microsoft Query to retrieve data from your corporate databases and files, you don't have to retype the data that you want to analyze in Excel.
Merge columns (Power Query) - Microsoft Support
With Power Query, you can merge two or more columns in your query. You can merge columns to replace them with a merged column, or create a new merged column alongside the columns that are merged. You can merge columns of Text data type only.
Outline (group) data in a worksheet - Microsoft Support
You can create an outline of rows (as shown in the example below), an outline of columns, or an outline of both rows and columns. 1. To display rows for a level, select the appropriate outline symbols. Level 1 contains the total sales for all detail rows. Level 2 contains total sales for each month in each region.
INDIRECT function - Microsoft Support
INDIRECT (ref_text, [a1]) The INDIRECT function syntax has the following arguments: Ref_text Required. A reference to a cell that contains an A1-style reference, an R1C1-style reference, a name defined as a reference, or a reference to a cell as a text string.
UNIQUE function - Microsoft Support
Learn about the UNIQUE function, which returns a list of unique values in a list or range. UNIQUE is in a class of functions called dynamic arrays.
Keyboard shortcuts in Microsoft 365
Here you'll find links to most keyboard shortcut articles for Microsoft 365 apps. Windows macOS Office for iOS Office for Android Web. Keyboard shortcuts for Outlook. Keyboard shortcuts in Word. Keyboard shortcuts in Excel. Use keyboard shortcuts to create PowerPoint presentations.
CONCATENATE function - Microsoft Support
Learn how to concatenate text strings in Excel using the CONCATENATE function. Our step-by-step guide makes it easy to join two or more text strings into one.
Insert data from picture - Microsoft Support
With the Data from Picture feature, you can insert data from a screen clipping on your clipboard, an image file from your computer, or from your iPhone camera. Capture your data from an image. There are three methods: Avoid images that depict data from an angle - the perspective should be head-on and focused.
Activate Office - Microsoft Support
Activate an Office purchase or offer that's included on a new Windows device. Activate Office from Microsoft Workplace Discount Program. Activate a brand new Office product key. …