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 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.
Although Excel is the best software to work with tables, we often create them in other software. Also, tables are commonly used for data exchange, when they are exported as tables in a text file as “Comma Separated Values”. In this file, each row of the table is a separate line in the text, and the values that are in the columns are separated by commas (hence the name). In the text that follows, we will show how to import text from one such file …
The Goal Seek option allows us to easily find a value that meets the set goal. However, this is an option of modest possibilities. To find the optimal calculated solution, by setting the target value and additional parameters, use the Excel Add-in named Solver. It is a complex tool, with many possibilities, which comes up to the target by applying one of the methods of Operational Research.
Goal Seek is one of the What-If tools used to calculate how much to change an argument of a formula, or argument that indirectly affects to it, in order to get a certain result. This is a simple option that can be used, for example, to calculate the sales price of the item that is needed to reach the desired sales level. Learn about the Goal Seek option in the text that follows …