Theme elements in Excel

Every Microsoft document uses a Theme - a combination of coordinated colors, fonts, and effects that visually convey a certain tone. Using Themes is an easy way to specify the colors, fonts, and a variety of graphic effects in the document. You can apply a Theme or any of the Theme elements: Colors, Fonts, Effects.

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 draw flowchart and swimlane flow chart in Excel

A flowchart or flow chart typically shows the steps of a task, process, or workflow connected by connecting arrows (also known as connectors or flowlines) that illustrate the order of steps or the direction of the process. Flowcharts are widely used in different industries to document, study, plan, improve, and explain complex processes with simple and logical diagrams.

Free Budget Templates for Excel

A budget is a plan to help decide how to spend your money. Creating this spending plan helps you determine in advance whether you have enough money for what you need or what you want. Microsoft Excel offers highly customizable budgeting spreadsheet templates for different needs: personal or family monthly budget templates, family holiday shopping budget worksheet templates, wedding and other personal event planning templates, business trip and vacation budget spreadsheet templates, etc.

How to work with multiple items in MS Office

When you work with a document, several documents or a presentation, it will be useful to have at hand several objects at once such as text blocks (from Internet, other document or e-mail), charts or graphics and even some pictures.

Fill and outline options in Microsoft

Microsoft applications such as PowerPoint, Word, and Excel use the same approach to set up and fill with colors, gradients, pictures, textures, and patterns for various graphic objects and text. Microsoft uses the theme color of each element as a placeholder rather than a fixed color. Thus, it is easy to change colors by switching to a different color theme - a set of colors assigned to preset positions.

How to change comma to decimal point and vice versa in Excel

Because of different standards of different countries and cultures, there is a lot of situations when you need to change commas to dots, decimal points or dots, decimal points to commas in an Excel spreadsheet:

How to change cells format easily

When working with data and formulas in Excel, one of the important points is the format of the cells. Data can be presented in completely different ways.

How to insert automatic numbers, captions, and cutlines for photos in Word

Unlike most images, pictures, and charts captions, photo captions (also often called cutlines) have multiple lines of text. Many publications share the title of the photo (caption) and a more detailed description (cutline). The terms Captions and Cutlines are often used interchangeably, particularly in magazines.

How to lock objects from moving and resizing in PowerPoint

PowerPoint has a handy feature that allows you to freeze an object on a slide. By locking objects from moving, you will not worry about hitting the wrong object when aligning, grouping, or resizing the rest of the slide elements. Locking will also allow you to more easily work with the object's content without fear of automatically resizing or displacing the object when you edit its content.