When you work with numbers and amounts in Microsoft Word or Microsoft Excel, you can have some issues with decimal symbol or digit grouping symbol. Both symbols can be changed in the settings of the Windows system.

For some charts, diagrams and presentations, 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.

If you want to copy your AutoCorrect exceptions from one PC to another, do the following:

A Gantt chart is one of the most popular tools in project management. It illustrates project schedules by showing activities, like tasks and events, against time.

When you analyze quiz answers, you need to see the numbers and the difference between all negative and positive answers. This is not easy, if you have more than 3 possible answers - positive, neutral and negative. However, you can create a chart that shows the whole picture:

When you work with data in Excel, often you need to add more and more of new data. However, it takes some time to update formulas, charts, tables, when you add new data. Excel proposes functions that can help to customize your data and avoid routine updating. This tip is about creating an automatically extended (also known as dynamically updated or just dynamic) drop-down lists.

For some e-mail boxes can be very helpful to create a rule that automatically sends a copy of outgoing messages to somebody else. For example, [email protected] or [email protected] mail boxes can send all messages to a supervisor.

Outlook proposes easy and fast way to import contacts from the CSV file to your Outlook. It can be prepared in Excel or saved in another Outlook instance (see How to export Outlook Contacts to a CSV file).

You may want to save Outlook contacts for future use. For example, to move them to another PC, or add them to another email client. Fortunately, you can save all contacts to the file in CSV format.

When you prepare your presentation, you should adapt it to the device which will be used for projecting it. Some devices or even laptops can have different sizes, so you can need to change the sizes of your presentation.

In contrast to other Microsoft Office applications such as Word, Outlook and Excel, in PowerPoint doesn’t have the option that changes how to open hyperlinks, by clicking with pressing or holding Ctrl or without Ctrl.

A ghost image effect is really wonderful and memorable. This effect is extremely popular now in Photoshop and other graphical applications. But even in PowerPoint you can create a ghost-like see-trough image in a few easy steps:

When you work with article, thesis, report and other documents, you may need to create a multi-source citation instead of simply joining several citations:

For some standards it is necessary to add to the equation the vertical bar with integration limits. Microsoft Word doesn’t propose the simple way how to add it.

Unfortunately, Word doesn’t propose the option to change the pre-defined numeration AA, BB, CC... to the AA, AB, AC... as it required for different cases. This tip proposes step by step guide how to create the necessary numeration AA, AB, AC, etc.: