Change the shape fill, outline, or effects of chart elements
You can instantly change the look of chart elements (such as the chart area, the plot area, data markers, titles in charts, gridlines, axes, tick marks, trendlines, error bars, or the walls and floor in 3-D charts) by applying a predefined shape style.
Insert Picture in-cell in Excel - Microsoft Support
There are several options to insert pictures in to a cell: Note: For inserting pictures in cells, Excel supports the following picture file types: JPG/JPEG, PNG, BMP, ICO, WEBP, TIF/TIFF, GIF (not animated). On the Insert tab select Illustrations. Select Pictures, then Place in Cell. Select This Device for inserting a picture from your device.
Which SmartArt graphic layouts have unlimited shapes?
You can both add and delete shapes in most SmartArt graphics, and you can also change the positions of the various shapes, so you should choose a layout that provides the best visual representation of your data. The following tables show some of …
Create a Pareto chart - Microsoft Support
Pareto charts highlight the biggest factors in a data set, and are considered one of the seven basic tools of quality control as it's easy to see the most common problems or issues. Select your data. Typically, you select a column containing text (categories) and one of numbers.
XLOOKUP function - Microsoft Support
Use the XLOOKUP function to find things in a table or range by row. For example, look up the price of an automotive part by the part number, or find an employee name based on their employee ID.
Add or remove a sheet background - Microsoft Support
To improve readability, you can hide cell gridlines and apply solid color shading to cells that contain data. A sheet background is saved with the worksheet data when you save the workbook. To use a solid color as a sheet background, you can apply cell shading to …
Video: Cut, copy, and paste - Microsoft Support
With the cut, paste, and copy commands as well as Clipboard, Office lets you move text, graphics, and more in a file or across the apps. Note: Paste only uses your most recently copied or cut …
Improve accessibility with the Accessibility Checker
Before you send an Outlook email message or share a Word document, Excelspreadsheet, PowerPoint presentation, or OneNote notebook, run the Accessibility Checker to make your content easier for people to read and edit.
Access your Account Privacy Settings - Microsoft Support
To access your privacy settings in the new Outlook for Windows: On the View tab, select View settings and choose General. Select Privacy and data then choose Privacy settings. This opens the Account Privacy settings dialog box where you can select your privacy options. This applies to Office version 1904 or newer.
File formats that are supported in Excel - Microsoft Support
To open a file that was created in another file format, either in an earlier version of Excel or in another program, click File > Open. If you open an Excel 97-2003 workbook, it automatically opens in Compatibility Mode. To take advantage of the new features of Excel 2010, you can save the workbook to an Excel 2010 file format.
Check spelling and grammar in Office - Microsoft Support
Most Office programs automatically check for potential spelling and grammatical errors as you type, so you don't need to do anything to show errors while you work. Automatic spelling and grammar checking is not available in Access, Excel, or Project. You can manually start a spell check by pressing F7.