Excel proposes different ways to sort data. You may sort your data in alphabetical order, according to the background or text color of the data, etc.
In some cases, you may want to sort your data in non-standard ways. For example, if your data consists of month names, you usually want it to be ordered by month numbers rather than alphabetically.

Some headings or titles (such as table titles or figure captions) in the document are too long or have a format, making it difficult to include them in a Table of Contents, Table of Figures, or similar lists. Word offers functionality Table of Contents Entry that keeps text readable in a Table of Contents, Table of Figures, etc.

When you prepare the presentation, you add some hints, the presentation plan, or even full text of your speech into slides of the PowerPoint presentation. Later you will be able to use these notes during the presentation (see how to view your notes in the presentation mode.)

When you create a book or other specific type of a Microsoft Word document, you may need to start each new part of your paper on an odd page. This rule is a mandatory requirement of some publishers, even if it creates an empty page between two sections of the document:

If you create a chart or diagram in Excel with shapes, you might need to update the shape text automatically depending on the value in a particular cell.

The Desktop Alert is an alert window that pops up when you receive a new email, a meeting request, or a task request to the Outlook default Inbox.

For some reason can be informative to create several shapes with one background picture and move some of them apart. Moving shapes is easy, but how to keep the background image flowing through them all?

When working with multiple tables and large amounts of data, when designing or analyzing charts or diagrams, you may need to view two or more parts of the worksheet simultaneously.

When you prepare a PowerPoint presentation, you can add some information from an external source file. For example, many presentations contain some data from an Excel spreadsheet or Excel charts.

For some charts or diagrams, you need to create a regular polygon – equiangular (all angles are equal) or equilateral (all sides have the same length). E.g., equilateral triangle, regular square, etc.