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

Unrealized Gain and Loss

For the analysis of the investment portfolio, it is helpful to see the unrealized gain or loss. These amounts show how many you will receive or lose if you realize all available stocks right now. Sure, there are some fees for the operations that can decrease gain or increase loss, but, at least, you want to see the least approximate amounts:

How to view current stocks prices and other quotes in Excel

There are countless reasons why you might need to have stock prices in your Excel spreadsheet. In the past, you had to copy and paste from Yahoo Finance or another financial service, but at the moment, Microsoft offers a new way to add and update some stock information such as stock prices, changes of price, etc.

The Area chart for Investments

Many financial and non-financial companies like Yahoo provide investments portfolio tracking services but do not offer the ability to change the appearance of the charts. Microsoft Excel gives you full flexibility by providing different types of customizable charts. E.g., there are a few variations of Area chart for tracking the value and costs of your portfolio.

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.