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 71: Apply Custom Sort to Data Items On occasion, you may need to apply a custom sort to the data items in your PivotTable. For instance, if you work for a company in California, your organization may want the West region to come before the North and South. In these types of situations, neither […]
Macro 71: Apply Custom Sort to Data Items Read More »
Macro 70: Sort All Fields in Alphabetical Order If you frequently add data to your PivotTables, you may notice that new data doesn’t automatically fall into the sort order of the existing pivot data. Instead, it gets tacked to the bottom of the existing data. This means that your drop-down lists show all new data
Macro 70: Sort All Fields in Alphabetical Order Read More »
Macro 69: Apply Number Formatting for All Data Items A PivotTable does not inherently store number formatting in its pivot cache. Formatting takes up memory; so in order to be as lean as possible, the pivot cache only contains data. Unfortunately, this results in the need to apply number formatting to every field you add
Macro 69: Apply Number Formatting for All Data Items Read More »
Macro 68: Set All Data Items to Sum When creating a PivotTable, Excel, by default, summarizes your data by either counting or summing the items. The logic Excel uses to decide whether to sum or count the fields you add to your PivotTable is fairly simple. If all of the cells in a column contain
Macro 68: Set All Data Items to Sum Read More »
Macro 67: Adjust All Pivot Data Field Titles When you create a PivotTable, Excel tries to help you out by prefacing each data field header with Sum of, Count of, or whichever operation you use. Often, this is not conducive to your reporting needs. You want clean titles that match your data source as closely
Macro 67: Adjust All Pivot Data Field Titles Read More »
Macro 65: Make All PivotTables Use the Same Pivot Cache If you work with PivotTables enough, you will undoubtedly find the need to analyze the same data- set in multiple ways. In most cases, this process requires you to create separate PivotTables from the same data source. The problem is that each time you create
Macro 65: Make All PivotTables Use the Same Pivot Cache Read More »
Macro 64: Create a PivotTable Inventory Summary When your workbook contains multiple PivotTables, it’s often helpful to have an inventory summary (similar to the one shown here in Figure 6-1) that outlines basic details about the PivotTables. With this type of summary, you can quickly see important information like the location of each PivotTable, the
Macro 64: Create a PivotTable Inventory Summary Read More »
Macro 63: Refresh All PivotTables Workbook It’s not uncommon to have multiple PivotTables in the same workbook. Many times, these PivotTables link to data that changes, requiring a refresh of the PivotTables. If you find that you need to refresh your PivotTables en masse, you can use this macro to refresh all PivotTables on demand.
Macro 63: Refresh All PivotTables Workbook Read More »
Macro 62: Create a Backwards- Compatible PivotTable If you are still using Excel 2003, you may know about the compatibility headaches that come with PivotTables between Excel 2003 and later versions. As you can imagine, the extraordinary increases in PivotTable limitations lead to some serious compatibility questions. For instance, later versions of Excel PivotTables can
Macro 62: Create a Backwards- Compatible PivotTable Read More »
