Convert workbooks to HTML format

The default file format for files created in Excel for Microsoft 365 is the .xlsx format. You can easily save a workbook, spreadsheet, or even selected area in various formats such as .xls, PDF, HTML, etc. See also how to save workbook in .xls format or PDF format.

How to create a Jigsaw puzzle with the falling-out piece

Here you will see how to combine different Jigsaw puzzle drawing techniques to create a photo-realistic puzzle with the fallen-out piece. By adding the falling-out pieces one by one, you can illustrate the dissolution process.

Position pictures, text boxes, shapes on the page

Word offers many useful features for working with various objects, such as images, photographs, text boxes, shapes, WordArt objects. All visual objects, excluding tables and equations, are figures in Microsoft Word. One of the most challenging steps in formatting objects is placing them with the text content. The Layout dialog box controls the positioning of figures.

Adding commands to the Quick Access Toolbar

Suppose you'd like to add a couple more commands to the Quick Access toolbar. Also, say you're a big fan of AutoSum. You can add the AutoSum button to the Quick Access toolbar, so you can quickly create and use AutoSum entries.

Adding commands to the Quick Access Toolbar

Suppose you'd like to add a couple more commands to the Quick Access toolbar. Also, say you're a big fan of AutoText, which lets you assign long strings of text to a couple keystrokes. You can add the AutoText button to the Quick Access Toolbar, so you can quickly create and use AutoText to collect frequently used commands.

Easily organize shapes in Excel

Every time you add, move, or resize shapes, it's not easy to align them by default. Excel proposes features for arranging and aligning shapes:

Excel Formula auditing tools

When working with formulas in Excel, it is often necessary to find where a mistake was made. Excel provides very useful tools:

How to view current stock prices and other quotes in Excel

There are countless reasons why you might need actual stock information, such as stock prices and changes, in your Excel spreadsheet. Previously, you had to copy and paste from Yahoo Finance or another financial service.

How to view currency exchange rates in Excel

When working with different currencies in an Excel spreadsheet, it is often necessary to use or compare exchange rates. Excel for Microsoft 365 offers a new Currencies Data Type. Like the Stock Data Type, the Currencies Data Type lets you get up-to-date exchange rates worldwide. It returns various exchange details that can be included in a spreadsheet.

How to view geography information in Excel

Excel for Microsoft 365 offers a useful feature for using statistical information about geographic regions. Unfortunately, not all the information provided is up to date, such as population figures or tax rates. However, some data, such as region codes, is useful. You can easily use this information in an Excel spreadsheet: