How to view current stock prices and other quotes in Excel

There are countless reasons why you might need actual stock information, such as stock prices and changes, in your Excel spreadsheet. Previously, you had to copy and paste from Yahoo Finance or another financial service.

How to calculate formulas in a Word document

In some Word documents you need to use formulas, such as summing, subtracting, multiplying, or dividing certain values:

How to use paragraph borders and shading

You can use paragraph borders, but removing these borders isn't easy for somebody. This tip is how to insert and remove paragraph borders and shading.

Functions and formulas that you can use in a Word document

Word provides some simple formulas and functions without need to embed Excel tables. It is easy to insert and use formulas:

How to use AutoCorrect substitutions for fast typing of Greek alphabet and mathematical symbols

Typing mathematical symbols like Greek alphabet or symbols "≤", "≥", "≠", "∞" etc. takes a lot of time. To speed up typing, you can create aliases and expand them through AutoCorrect feature or create shortcuts for frequently used symbols.

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:

Equations in PowerPoint

To create an effective presentation that contains equations, you need to use a special mathematical style. This style involves using special characters and syntax, a special type of line breaks, delimiters, and requirements for superscripts and subscripts.

How to sum cells by criteria

Use SUMIF if you need to sum values for a particular person or another criterion.

How to keep a table in one page of a Word document

A lot of documents Word contain tables. If you have a small table, you may want to keep it on one page even if Word tries to split it between pages.

How to automatically duplicate information in a Word document

A lot of Word documents contain repeated information especially legal documents such as contracts, agreements, invoices, etc. They all contain details of one or two parties that should be repeated two or more times. You can easily create a document with all necessary information in one place and add some special fields for duplicated information: