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.

Chart templates

Companies often strive to unify their reports using predefined rules regarding choosing font types, color styles and other formatting modes. The unified look is introduced using Templates, and when we want to create charts, we will use chart templates. In addition to appearance, standard charts also introduce standard data ranges in axes, which contributes to the accuracy of the report.

Creating a poll

How often do you create a poll? How much time does it take to enter and process the responses? Do you think that you can work faster? While you’re conducting a survey do you sometimes wish to be mobile? If you have these issues to the attention then it will certainly be interesting text that follows. Excel is a great software for creating and processing of survey results. Whereas, with the release of new versions, you can also keep the polls “in the cloud”, the process of surveying has never been easier …

How to use macros

Macros represent short programs that the user mostly does not write, but are automatically generated by Excel. Their role is to automate frequently used procedures, and more ambitious users can use them to develop applications with the powerful Visual Basic for Applications (VBA) programming language. In this way there are almost no things that can’t be done in Excel, so it becomes a development platform.

Importing a table from the Internet

Importing a table from the Internet is a useful Excel option that came at the wrong time. Sometimes, when web designers created pages using the TABLE structure, the tabular data was in the tables (where they should be). Today, the approach to making web sites has changed, so DIV tags are used to display tabular data, which for some reason can not be recognized by Excel. Hence this option has limited application capability.