Apply shading to alternate rows or columns in a worksheet
网页There are two ways to apply shading to alternate rows or columns —you can apply the shading by using a simple conditional formatting formula, or, you can apply a predefined Excel table style to your data. Technique 1: Apply shading to alternate rows or columns by using conditional formatting.
Dynamic array formulas and spilled array behavior - Microsoft …
网页Excel formulas that return a set of values, also known as an array, return these values to neighboring cells. This behavior is called spilling. Formulas that can return arrays of variable size are called dynamic array formulas.
Analyze Data in Excel - Microsoft Support
网页Analyze Data in Excel empowers you to understand your data through natural language queries that allow you to ask questions about your data without having to write complicated formulas. In addition, Analyze Data provides high-level visual summaries, trends, and …
Look up values with VLOOKUP, INDEX, or MATCH - Microsoft …
网页Use the table_array argument in a VLOOKUP function. Use VLOOKUP, HLOOKUP, and other functions like INDEX and MATCH to search for and find data based on values you enter. This article gives you a quick VLOOKUP refresher, then links to more.
Create, load, or edit a query in Excel (Power Query) - Microsoft …
网页Create a blank query. You may want to just start from scratch. There are two ways to do this. Select Data > Get Data > From Other Sources > Blank Query.
UNIQUE function - Microsoft Support
网页The UNIQUE function returns a list of unique values in a list or range. Return unique values from a list of values. Return unique names from a list of names. An array can be thought of as a row or column of values, or a combination of rows and columns of values.
INDIRECT function - Microsoft Support
网页Description. Returns the reference specified by a text string. References are immediately evaluated to display their contents. Use INDIRECT when you want to change the reference to a cell within a formula without changing the formula itself. Syntax. INDIRECT (ref_text, [a1]) The INDIRECT function syntax has the following arguments:
Filter by using advanced criteria - Microsoft Support
网页Filter by using advanced criteria. If the data you want to filter requires complex criteria (such as Type = "Produce" OR Salesperson = "Davolio"), you can use the Advanced Filter dialog box. To open the Advanced Filter dialog box, click Data > Advanced.
Create a drop-down list - Microsoft Support
网页Lock or unlock specific areas of a protected worksheet. You can insert a drop-down list of valid entries (also called a drop-down menu or drop-down box) in Excel to make data entry easier, or to limit entries to certain items that you define.
SORTBY function - Microsoft Support
网页The SORTBY function sorts the contents of a range or array based on the values in a corresponding range or array. In this example, we're sorting a list of people's names by their age, in ascending order.
Tutorial: Import Data into Excel, and Create a Data Model
网页In this tutorial, you start with a blank Excel workbook. The sections in this tutorial are the following: Import data from a database. Import data from a spreadsheet. Import data using copy and paste. Create a relationship between imported data. Checkpoint and Quiz. At the end of this tutorial is a quiz you can take to test your learning.