Projects that involve both the construction or renovation of a structure or an alteration of part of the environment are considered part of civil engineering.
5 major civil engineering projects:
Water engineering.
Construction and management engineering.
Structural engineering.
Geotechnical engineering.
Transport engineering.
Macro 61: Show Filtered Columns in the Status Bar When you have a large table with many columns that are AutoFiltered, it is sometimes hard to tell which columns are filtered and which aren’t. Of course, you could scroll through the columns, peer- ing at each AutoFilter drop-down list for the telltale icon indicating the […]
Macro 61: Show Filtered Columns in the Status Bar Read More »
Macro 60: Create a New Sheet for Each Item in an AutoFilter One of the most common tasks an Excel user is confronted with is separating a data set into separate sheets. For instance, if you have a set of data that has rows for the east, west, south, and north regions of the U.S.,
Macro 60: Create a New Sheet for Each Item in an AutoFilter Read More »
Macro 59: Copy Filtered Rows to a New Workbook Often, when you’re working with a set of data that is AutoFiltered, you want to extract the filtered rows to a new workbook. Of course, you can manually copy the filtered rows, open a new workbook, paste the rows, and then format the newly pasted data
Macro 59: Copy Filtered Rows to a New Workbook Read More »
Macro 56: Highlight Duplicates in a Range of Data Ever wanted to expose the duplicate values in a range? The macro in this section does just that. There are many manual ways to find and highlight duplicates — ways involving formulas, conditional for- matting, sorting, and so on. However, all these manual methods take setup
Macro 56: Highlight Duplicates in a Range of Data Read More »
Macro 55: Clean Up Non-Printing Characters Sometimes you have non-printing characters in your data such as line feeds, carriage returns, and non-breaking spaces. These characters often need to be removed before you can use the data for serious analysis. Now, anyone who has worked with Excel for more than a month knows about the Find
Macro 55: Clean Up Non-Printing Characters Read More »
Macro 54: Create a Super Data Cleanup Macro As we mentioned at the beginning of this Part, you can combine the macros we have covered thus far into a super data cleanup macro. This allows you to clean and standardize your data in one fell swoop, saving loads of time and headaches. How it works
Macro 54: Create a Super Data Cleanup Macro Read More »
Macro 53: Append Text to the Left or Right of Your Cells Every so often, you may come upon a situation where you need to attach data to the beginning or end of the cells in a range. For instance, you may need to add an area code to a set of phone num- bers.
Macro 53: Append Text to the Left or Right of Your Cells Read More »
Macro 52: Replace Blanks Cells with a Value In some analyses, blank cells can cause of all kinds of trouble. They can cause sorting issues, they can prevent proper auto filling, they can cause your pivot tables to apply the Count function instead of the Sum function, and so on. Blanks aren’t always bad, but
Macro 52: Replace Blanks Cells with a Value Read More »
