Office

How to change decimal symbol and digit grouping symbol in Windows 10

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.

How to create an equilateral triangle, a regular square, and other regular polygons

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.

How to copy your AutoCorrect Exceptions from one PC to another

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

Excel

Progressively create a Gantt chart in Excel

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.

How to show quiz results in an Excel chart

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:

How to create an automatically extended or dynamic drop-down list

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.

Outlook

How to automatically send a copy for outgoing messages

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.

How to import Contacts from a CSV file into Outlook

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).

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.

PowerPoint

How to change the size of slides in Microsoft PowerPoint

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.

Open hyperlink without holding Ctrl in PowerPoint

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.

Create a ghost image effect in PowerPoint

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:

Word

How to create a multi-source citation

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:

Insert a vertical bar with integration limits into the equation

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.

How to create a numbering AA, AB, AC... instead of AA, BB, CC... in Word

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.: