Options for opening documents

Anyone who has elementary computer literacy can open a document, whether it’s Excel or some other file. Excel 2013 brought several novelties that, even in doing this simple operation, make daily work easier. These are options for creating shortcuts to the most frequently used documents in the menu and opening a copy of an existing document. More detailed, in the text that follows …

Formatting in service of reporting

In several previous posts I wrote about the formatting of the contents of the cell. In addition to the standard ways of displaying its content, users can also define custom views. User-defined formats can be greatly used to enrich the appearance of the report. Using them, we achieve effects similar to the conditional formatting technique, and we can easily copy them or use them to create formatting styles.

Custom formats

When formatting the content of a cell, one of the items that we can set up is the way the content of the cell is displayed. Since the options for creating such formats are in the Number tab of the Format Cells dialog box, the settings to be addressed are often called “formatting the number”. Although the content of a cell does not have to be a number. It can also be text, date, time or other information. Have you ever wondered: how to create custom formats?

Converting table into image

Switching the Excel spreadsheet to another application like, for example, PowerPoint can be an inconvenient job. If it hates you to deal with details, there is a very simple way to do this, that is to convert the final table into an image, and then copy the image to the desired destination. This can be done using the Paste Special option, as well as using the Camera tool, and the following text will explain how to make the most of this option.

Document templates

Excel has been here for more than 20 years. Although it can not be said that in its world “there is nothing new in the sky,” numerous problems that have been encountered by the rich Excel community, since its inception, have long been solved, and solutions can be downloaded from the Internet in the form of templates. In this text, we will say a word-two on how to find the right template for generating a document that solves the problem.