How to Select Hidden or Invisible Rows Excel

Software

There is a feature in Excel that allows you to hide and unhide rows or columns without affecting its formulation in any way. This feature would be helpful for you when you want to hide come information from a user. You could hide a row by choosing Format, then Row, then Hide. Or, you could select the row you want to hide, right click on it, and select Hide.Let’s try an example. In a new Worksheet...Read More

Posted: 18 May 2012

Tags: How to Select Hidden or Invisible Rows Excel How Select Hidden Invisible Rows Excel Select Hidden Rows Excel Choose Invisible Rows Excel

Excel Tutorial - Using Data Validation Lists To Control Data Entry

Software

By control input data in your Excel worksheets, you can verify the integrity of your data, this is particularly useful if you want to perform an accurate analysis of your data at a later date. There are a number of ways to guide or limit users to the way entering data.1 - Provide a custom list - this is great if you have a long list of options for the user to select, it is easier to maintain.2 - Type...Read More

Posted: 13 May 2012

Tags: Excel Tutorial Using Data Validation Lists To Control Data Entry Excel Tutorial Using Data Validation Lists Control Entry

Control data entry lists Excel tutorial - using Data Validation

Software

By control input data in your Excel worksheets, you can verify the integrity of your data, this is particularly useful if you want to perform an accurate analysis of your data at a later date. There are a number of ways to guide or limit users to the way entering data.1 - Provide a custom list - this is great if you have a long list of options for the user to select, it is easier to maintain.2 - Type...Read More

Posted: 11 May 2012

Tags: Control data entry lists Excel tutorial using Data Validation Control data entry lists Excel tutorial using Data Validation

Microsoft Excel: Advice tips and practices

Software

Microsoft Excel is one such program that is used by each person at some point in his life. It is a program that uses binary digits and a lot of esoteric secrets. Here are some useful Microsoft Excel tips and tricks:Delete blank lines: If there is a set of data separated by blank rows or cells, these should be deleted. The standard procedure is to select the column, press F5, click Special, and then...Read More

Posted: 11 May 2012

Tags: Microsoft Excel Advice tips and practices Microsoft Excel Advice tips and practices

MS Excel tips - count how many numbers in your Excel list are above average

Software

The function COUNTIF in Excel counts the number of cells in a range of cells that meet a given criteria. The range is the range of cells you want to count cells and the criteria are the criteriain in the form of a number, expression, the reference cell or text that defines which cells in the selected range will be taken into account.For example, the criteria could be the next 13, "14", B2, "> =...Read More

Posted: 03 May 2012

Tags: MS Excel tips count how many numbers in your Excel list are above average Excel tips count how many numbers your list are above average