Search results
Results From The WOW.Com Content Network
Use a SmartArt graphic to create an organization chart in Excel, Outlook, PowerPoint, or Word to show the reporting relationships in an organization, such as department managers and non-management employees.
The INDEX function returns a value or the reference to a value from within a table or range. There are two ways to use the INDEX function: If you want to return the value of a specified cell or array of cells, see Array form. If you want to return a reference to specified cells, see Reference form.
Create a memory-efficient Data Model using Excel and the Power Pivot add-in. In Excel, you can create data models containing millions of rows, and then perform powerful data analysis against these models. Data models can be created with or without the Power Pivot add-in to support any number of PivotTables, charts, and Power View visualizations ...
What you can customize: You can personalize your ribbon to arrange tabs and commands in the order you want them, hide or unhide your ribbon, and hide those commands you use less often. Also, you can export or import a customized ribbon.
Rename a file in an online app. Select the file name at the top of the page. Enter a new name. Changes are saved automatically in the Office Online apps.
In the menu that appears you can rename the file, select a new location to move it to, or see the version history for the file. If the file isn't a Microsoft Office file, or if you're not a Microsoft 365 subscriber, then the easiest way to rename or move a file is to use File Explorer in Windows.
Print a workbook to a file. Select File, and then select Print, or press Ctrl+P. Under Printer, select Print to File. Select Print. In the Save Print Output As dialog box, enter a file name and then select OK. The file will be saved in your Documents folder.
The TRANSPOSE function must be entered as an array formula in a range that has the same number of rows and columns, respectively, as the source range has columns and rows. Use TRANSPOSE to shift the vertical and horizontal orientation of an array or range on a worksheet.