Insert icons in Microsoft 365
You can insert icons into Microsoft 365 documents. You can rotate, color, and resize them with no loss of image quality. These icons are free to use and there's no royalty or copyright to worry …
View, manage, and install add-ins for Excel, PowerPoint, and Word ...
View, manage, and install add-ins for Excel, PowerPoint, and Word. When you enable an add-in, it adds custom commands and new features to Microsoft 365 programs that help increase your productivity. Because add-ins can be used by attackers to do harm to your computer, you can use add-in security settings to help protect yourself.
Manage data source settings and permissions (Power Query) - Microsoft …
When you need to view or manage an external data source, it pays to know the right dialog box for your needs: Use the Recent Sources dialog box to display frequently used data sources that you have already imported and as a convenient list for making changes to the connection information of each data source.
Show or hide the ribbon in Office - Microsoft Support
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.
Customize the Quick Access Toolbar - Microsoft Support
You can move the Quick Access Toolbar from one of the two possible locations, and you can add buttons that represent commands to the Quick Access Toolbar. Notes: You cannot increase the size of the buttons representing the commands by an option in Microsoft Office.
Download free, pre-built templates - Microsoft Support
You can download free, pre-built document templates with useful and creative themes from Office when you click File > New in your Office app. Templates can include calendars, business cards, letters, cards, brochures, newsletters, resumes, cover …
Keyboard shortcuts in Microsoft 365
Many users find that using Microsoft 365 apps with keyboard shortcuts on an external keyboard helps them work more efficiently. For users with mobility or vision disabilities, keyboard shortcuts can be easier than using the touchscreen, and are an essential alternative to using a mouse.
Automate tasks with the Macro Recorder - Microsoft Support
To automate a repetitive task, you can record a macro with the Macro Recorder in Microsoft Excel. Imagine you have dates in random formats and you want to apply a single format to all of them. A macro can do that for you. You can record a macro applying the format you want, and then replay the macro whenever needed.
Excel functions that return ranges or arrays - Microsoft Support
Below is a list of functions that could return multi-cell ranges or arrays in what we refer to as pre-dynamic array Excel. If these functions were used in workbooks predating dynamic arrays, and returned a multi-cell range or array to the grid (or a function that did not expect them), then silent implicit intersection would have occurred.
Crop a picture to fit in a shape - Microsoft Support
This article applies to steps you can use to crop images in different Microsoft 365 applications. You can use the same steps in PowerPoint, Word, Outlook, or Excel. When you crop a picture to a certain shape, it'll change size to match that shape while keeping its proportions the same.
Define and solve a problem by using Solver - Microsoft Support
Solver is a Microsoft Excel add-in program you can use for what-if analysis. Use Solver to find an optimal (maximum or minimum) value for a formula in one cell — called the objective cell — subject to constraints, or limits, on the values of other formula cells on a worksheet.