In this article we are going to look at Excel’s Goal Seek command. This command is actually quite easy to use, and it is very popular because of its ability to look backwards from a given result. A common example used to illustrate this command is finding the amount a person can borrow, at a [...]
This is another in a series of Excel’s Conditional Formatting How-To's. The pervious post looked at the Highlight Cell Rules option. (For Details See: Excel Conditional Formatting Highlight Cell Rules). In this article we are going to look at another option namely: Color Scales. Using Color Scales is a popular formatting technique that lends itself [...]
Excel’s Conditional Formatting command allows for a simple and quick method to format a range or a table of cells based on the value of the data contained in those cells. This allows us to actually see certain features of the data. Over the next few Posts we are going to look at examples to [...]
We posted instructions on finding the Command Prompt in Windows 7 in a past Post, and because we still find it useful, the following is an update on finding it in Windows 10. The reason that it is useful, is that, in many cases, while instructing people, the phrase “just open a Windows Command Prompt [...]
Excel's AnalysisToolPak offer a variety of routines for analyzing statistical, scientific and engineering data. In this articular we are going to look at how to use the correlation tool in the Analysis ToolPak. Enable the Analysis ToolPak: Although already installed with Excel, the Analysis ToolPak will need to be enabled through the Options menus. For [...]
What is a Data Structure? Part 1 An Explanation Using Tables in Excel 2010 Whether you are just going to look at your data and draw conclusions visually, or you are going to writing a computer program to manipulate it, even a very simple structure can help. When analyzing data, it is useful to decide [...]
Using Excel 2010 we are going to look at how to replace blank cells with zeros. Selecting the cells manually is, of course one option, but if the spread sheet is large then the procedure would be rather time consuming. For this exercise we will use a couple of short-cuts. Tools used for this exercise: [...]
In this example we are going to convert Id numbers into Text format and we will look at how to removing any resulting warning messages. Tools used for this exercise: Using the “Number as text” format Removing the warning message on the Options command on the File Tab. […]
Using Excel 2010 we are going to look at how to separate full names (last name followed by first name) into separate columns. Once that is done we are going to convert the data to table format and sort on the last name. Tools used for this exercise: The “Text to Columns” command Converting to [...]
It seems that in many cases, while instructing people, the phrase “just open a Windows Command Prompt and type in …” is usually interrupted with the comment “ok, how do I do that”. Also, in the user manuals and document we generate, there are occasions that a command prompt may be needed, and this note [...]
