Group or ungroup data in a PivotTable - Microsoft Support
Grouping data in a PivotTable can help you show a subset of data to analyze. For example, you may want to group an unwieldy list date and time fields in the PivotTable into quarters and months.
Split panes to lock rows or columns in separate worksheet areas
Select the column to the right of the column where you want to place the split, and use the Split command. You can also split on both a row and a column. by selecting the cell below and to the right of where you want the split—then click Split.
Split a column of text (Power Query) - Microsoft Support
You can split a column with a text data type into two or more columns by using a common delimiter character. For example, a Name column that contains values written as <LastName>, <FirstName> can be split into two columns using the comma (,) character.
Convert your SmartArt graphic into shapes - Microsoft Support
After you split your SmartArt graphic into individual shapes, you cannot convert the shapes back to a SmartArt graphic. Click the SmartArt graphic that you want to break apart. Under SmartArt Tools , on the Design tab, in the Reset group, click Convert , and then click Convert to Shapes .
Cut out part of a picture - Microsoft Support
For an image in a Office file, you can remove parts of the picture that you don't want to include. As described below, you start with automatic background removal. Then, you manually indicate the areas of the picture that you want to keep and remove.
Use slicers to filter data - Microsoft Support
Use slicers to filter data. Slicers provide buttons that you can click to filter tables, or PivotTables. In addition to quick filtering, slicers also indicate the current filtering state, which makes it easy to understand what exactly is currently displayed. Windows macOS Web.
Create a flow chart with SmartArt - Microsoft Support
Create a flow chart with SmartArt. Applies To. A flow chart shows sequential steps in a task or process. There are many different SmartArt layouts that you can use to illustrate the steps in a process, including layouts that can contain pictures. This article explains how to create a flow chart that contains pictures.
Split a cell - Microsoft Support
Split the content from one cell into two or more cells. Note: Excel for the web doesn't have the Text to Columns Wizard. Instead, you can Split text into different columns with functions. Select the cell or cells whose contents you want to split.
Unpivot columns (Power Query) - Microsoft Support
In Power Query, you can transform selected columns into attribute-value pairs where columns become rows. You use Power Query's Query Editor to unpivot columns.
Crop a picture to fit in a shape - Microsoft Support
Crop an image to a shape. When you crop a picture to a certain shape, it'll change size to match that shape while keeping its proportions the same. Add an image to your Microsoft 365 file, like a PowerPoint presentation or Word document, by selecting Insert from the ribbon > Picture.
Accessibility best practices with Excel spreadsheets
Merged or split cells can make navigating Excel tables with assistive technologies very difficult, if not impossible. Always keep your tables straightforward and simple. To ensure that tables don't contain split cells, merged cells, or nested tables, use the Accessibility Checker.