Use measurement rulers on a worksheet - Microsoft Support
Excel provides a horizontal and vertical ruler in the Page Layout view, and you can use these rulers to measure the width and height of items in a worksheet.
Show or hide the ribbon in Office - Microsoft Support
Customize the ribbon in Office. Show the ribbon when hidden, and set options to shows tabs and commands, just tabs, or automatically hide the ribbon for the maximum document space.
Language Accessory Pack for Microsoft 365 - Microsoft Support
Check spelling and grammar in a different language. Translate text into a different language. Learn how to download, install, and configure Language Accessory Packs for Microsoft 365 to add additional display, help, and proofing tools to Microsoft 365.
Copy the window or screen contents - Microsoft Support
When you're using a Microsoft 365 program with Windows, there are two ways to copy the contents of what you see on your screen (commonly referred to as a "screenshot" or "screen capture"). You can use the Snipping Tool or the PRINT SCREEN key.
Automate tasks with the Macro Recorder - Microsoft Support
When you record a macro, the macro recorder records all the steps in Visual Basic for Applications (VBA) code. These steps can include typing text or numbers, clicking cells or commands on the ribbon or on menus, formatting cells, rows, or columns, or even importing data from an external source, say, Microsoft Access.
Wrap text in a cell - Microsoft Support
Microsoft Excel can wrap text so it appears on multiple lines in a cell. You can format the cell so the text wraps automatically, or enter a manual line break. Wrap text automatically. In a worksheet, select the cells that you want to format. On the Home tab, in the Alignment group, select Wrap Text.
VLOOKUP function - Microsoft Support
Use VLOOKUP when you need to find things in a table or a range by row. For example, look up a price of an automotive part by the part number, or find an employee name based on their employee ID. In its simplest form, the VLOOKUP function says:
Excel data types: Stocks and geography - Microsoft Support
You can get stock and geographic data in Excel. It's as easy as typing text into a cell, and converting it to the Stocks data type, or the Geography data type. These two data types are considered linked data types because they have a connection to an online data source.
Load the Analysis ToolPak in Excel - Microsoft Support
Perform statistical and engineering analysis with the Analysis ToolPak. The Analysis ToolPak is a Microsoft Office Excel add-in program that is available when you install Microsoft Office or Excel.
Create, apply, or delete a custom view - Microsoft Support
Apply a custom view. Go to View > Workbook Views > Custom Views. In the Views box, click the name of the view that you want to apply, and then click Show. Note: If your view was created on another worksheet, then that worksheet will be automatically displayed.
Add a trend or moving average line to a chart - Microsoft Support
Formatting a trendline is a statistical way to measure data: Set a value in the Forward and Backward fields to project your data into the future. Add a moving average line. You can format your trendline to a moving average line. Click anywhere in the chart.