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 create an axis with subcategories

Excel offers a lot of different tricks to create great informative charts and diagrams. A lot of the useful adjustments related to the axis. E.g., you can hide an axis, use primary and secondary axis, change the presentation of data on the axis, etc.

How to create a step chart in Excel

There are a lot of different pre-defined charts in Excel, but for some types of data, pre-defined charts such as area chart or line chart can look fine but are incorrect.

Different rounding effects in Excel

When you work with digits, it’s crucial how you round them. It doesn't depend on what exactly you are rounding - decimals, thousands, or millions. You can see very different amounts after summing the figures, rounded in different ways:

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 create an organizational chart with two or more connection lines

Microsoft Word (like Microsoft Excel and Microsoft PowerPoint) proposes tools to create and update organizational charts, but only for the hierarchical organizations (a hierarchical organization is an organizational structure where every entity in the organization, except the root, is a subordinate to a single other entity).

How to reassign a shape in the organizational chart

Sometimes you need to reassign some positions in the organizational chart from one place to another. Word isn’t a really convenient application for organizational charts as Excel, but you have some possibilities to do that.

How to convert SmartArt to the shapes in Word

Many useful features in Word (like in Excel and other Microsoft Office applications) disappear from version to version, from patch to patch... The function Convert to Shapes also disappeared.