function could be used to sort rows which effectively means that you can sort – by color in Excel 2003 but it takes a bit more effort. – Sort By Custom List Another sorting capability in is the ability to sort by – Custom List. For example, assume a CPA firm has ten partners, and the Managing partner prefers to be shown at the top of the list, and the remaining Partners based on seniority. In this case, you could create a Custom List in the excel Options dialog box listing the partners in the desired order, and then sort future reports based on that order. Perhaps a better example use of this feature would be to create a non-alphabetic custom list of your chart of accounts, and then sort transactions to produce a general ledger in chart of account order even if your preferred chart of accounts – is not alphabetical. the partner seniority does not match the alphabetic names, nor any Filtering Data - AutoFilter to filter data allows you to view a subset of your data in a range of cells or table. Once you have filtered the data, you can apply additional filters to further refine your data view. When you are done, you can clear a filter to once again redisplay all of the data. To use this tool, start with any list of data and turn on the AutoFilter tool. Then position your cursor in the column you want to filter and use the drop down arrows to apply your filters as shown in the screen below. Once the filters are applied, you will see a subset your data. For example, the screen presented below shows filtered data for only Macon and Savannah properties. As filters are applied, a funnel appears in the drop down arrow button to indicate that a filter has been applied. You can apply filters for multiple columns simultaneously. Key Points Concerning The AutoFilter Command: Contiguous Data The AutoFilter tools works best when you are working with data – that is contiguous. In other words, your data should contain no blank columns, no blank rows, and the columns must all be labeled. Filter by Multiple Columns - You can filter by more than one column.
function could be used to sort rows – which effectively means that you can sort by color in Excel 2003 – but it takes a bit more effort. Sort By Custom List – Another sorting capability in is the ability to sort by Custom List. For example, assume a CPA firm has ten partners, and the Managing partner prefers to be shown at the top of the list, and the remaining Partners based on seniority. In this case, you could create a Custom List in the excel Options dialog box listing the partners in the desired order, and then sort future reports based on that order. Perhaps a better example use of this feature would be to create a non-alphabetic custom list of your chart of accounts, and then sort transactions to produce a general ledger in chart of account order – even if your preferred chart of accounts is not alphabetical. the partner seniority does not match the alphabetic names, nor any Filtering Data - AutoFilter to filter data allows you to view a subset of your data in a range of cells or table. Once you have filtered the data, you can apply additional filters to further refine your data view. When you are done, you can clear a filter to once again redisplay all of the data. To use this tool, start with any list of data and turn on the AutoFilter tool. Then position your cursor in the column you want to filter and use the drop down arrows to apply your filters as shown in the screen below. Once the filters are applied, you will see a subset your data. For example, the screen presented below shows filtered data for only Macon and Savannah properties. As filters are applied, a funnel appears in the drop down arrow button to indicate that a filter has been applied. You can apply filters for multiple columns simultaneously. Key Points Concerning The AutoFilter Command: Contiguous Data – The AutoFilter tools works best when you are working with data that is contiguous. In other words, your data should contain no blank columns, no blank rows, and the columns must all be labeled. Filter by Multiple Columns - You can filter by more than one column.
2009%20Excel%20Functions%20Macros%20and%20Data%20Commands%20Manual.docx