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

How to highlight a data point

One of the essential parts of any work with data is presenting results. You can use many different charts, diagrams in Microsoft Excel or PowerPoint.

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:

Outlook

How to backup Outlook PST file

If Outlook does not open your data file, or you can not find some items in your inbox, contacts or calendar, then your PST is apparently corrupted. At this moment, thought about backup comes to your mind, but it is too late to muse about a backup. You need to backup your Outlook data in advance. Otherwise, you will need a repair tool.

How to show the voting results

For some Outlook messages, it can be useful to add Voting to collect your colleagues' or friends' votes (see How to add and use voting button in 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.

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 share the custom dictionary in Word

When you work with some specific task or project, will be great to create a custom dictionary to save exceptional words such as project or task names, terms, abbreviations, names of participates, etc.

How to create a new custom dictionary in Word

When you work with documents, that contain specific words (character sequences), or if you need to switch from one project or task to another, you can want to create a custom dictionary for some tasks, projects, or only for personal use.

How to remove a word from the custom dictionary

When you work with the Word document, you can add some words to the custom dictionary to avoid spelling errors. It is natural to add a word to the dictionary by mistake. So, you can want to remove some word from the dictionary.