Use the Format Painter - Microsoft Support
With format painter, you can copy all of the formatting from one object and apply it to another one—think of it as copying and pasting for formatting. Select the text or graphic that has the formatting that you want to copy. On the Home tab, select Format Painter in the Clipboard group.
Video: Create and change WordArt - Microsoft Support
When you want text to really stand out on a page, use WordArt to add outlines, shading, and other effects to your words.
Insert WordArt - Microsoft Support
Insert WordArt. WordArt is a quick way to make text stand out with special effects. You begin by picking a WordArt style from the WordArt gallery on the Insert tab, and then customize the text as you wish. Important: In Word and Outlook, you must first anchor multiple objects before selecting them. Select one object.
Split data into multiple columns - Microsoft Support
Sometimes, data is consolidated into one column, such as first name and last name. But you might want separate columns for each. So, you can split the Sales Rep first name and last name into two columns. Select the "Sales Rep" column, and …
Microsoft 365 Quick Starts - Microsoft Support
Training: Get started quickly on all of your favorite Microsoft 365 apps with our popular Quick Start guides.
Merge queries (Power Query) - Microsoft Support
A merge query creates a new query from two existing queries. One query result contains all columns from a primary table, with one column serving as a single column containing a navigation link to a related table.
Change formula recalculation, iteration, or precision in Excel
Precision is a measure of the degree of accuracy for a calculation. Excel stores and calculates with 15 significant digits of precision. However, you can change the precision of calculations so that Excel uses the displayed value instead of the stored value when it recalculates formulas.
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.
Tutorial: Import Data into Excel, and Create a Data Model
In these tutorials you learn how to import and explore data in Excel, build and refine a data model using Power Pivot, and create interactive reports with Power View that you can publish, protect, and share. The tutorials in this series are the following: Import Data …
Rename an Excel table - Microsoft Support
Go to Table Tools > Design > Properties > Table Name. On a Mac, go to the Table tab > Table Name. Highlight the table name and enter a new name. Tips: All of your tables will be shown in the Address bar, which appears to the left of the Formula bar.
Accessibility best practices with Excel spreadsheets
This topic gives you step-by-step instructions and best practices for making your Excel spreadsheets accessible and unlock your content to everyone, including people with disabilities. You learn, for example, how to work with the Accessibility Checker to tackle accessibility issues while you're creating your spreadsheet.