Learn

Civil Engineering Projects

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 66: Hide All Subtotals in a PivotTable

Macro 66: Hide All Subtotals in a PivotTable When you create a PivotTable, Excel includes subtotals by default. This inevitably leads to a PivotTable report that inundates the eyes with all kinds of numbers, making it difficult to analyze. Figure 6-2 demonstrates this. Figure 6-2: Subtotals can sometimes hinder analysis. Manually removing Subtotals is easy

Macro 66: Hide All Subtotals in a PivotTable Read More »

Macro 64: Create a PivotTable Inventory Summary

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 62: Create a Backwards- Compatible PivotTable

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 »

Share knowledge