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.
Creating and Attaching Item Content This chapter will take you through Outlook 2021 enhancements, where we will explore and configure objects such as mail, contacts, tasks, notes, and journals. You will set some advanced options and language options in the interface and learn how to manipulate item tags and arrange the content pane. In addition, […]
Creating and Attaching Item Content Read More »
Exploring statistical functions In Chapter 9, New Features, Filters, and Cleaning Data, of this book, we learned about using the COUNTIFS statistical function. A list of statistical functions can be found in the Excel library. Click the Formulas tab, then click on More Functions | Statistical to see all types available, as illustrated in the
Exploring statistical functions Read More »
Converting measurements with CONVERT The CONVERT function is brilliant when needing to convert numbers to a different measurement system—for instance, pounds (lb) into kilograms (kg) or feet (ft) into meters (m). This function is great to know as it applies to many aspects of life. The CONVERT function only has three arguments, as presented here:
Converting measurements with CONVERT Read More »
Rounding with MROUND In the previous-edition of this book, we introduced the ROUND, ROUNDUP, and ROUNDDOWN functions. When we use the increase and decrease decimal icons in Excel, we are formatting a cosmetic change to values by rounding them. This does not change the underlying raw data value in the cell. To apply rounding to
Rounding with MROUND Read More »
Useful Statistical and Mathematical Functions Office 2021 includes a range of mathematical and statistical functions, some of which are considered important foundational skills to build more complex formulas. We will build on prior skills to work with Math & Trig and Statistical functions using Excel 2021 and introduce some additional functions to the mix. We
Useful Statistical and Mathematical Functions Read More »
Moving PivotTable reports If you would like to move the PivotTable next to your data and not display the report on a separate worksheet, follow these steps: Figure 11.56 – Move PivotTable Finally, we will learn how to use the GETPIVOTDATA function. This function is constructed to grab data (reference data) from a PivotTable cell.
Moving PivotTable reports Read More »
Changing the design theme Eff cts options using the relevant buttons to the right of the Themes button. Figure 11.50 – Themes drop-down list The dashboard is now complete and ready for other members of your company to interact with it. Let’s see how we can share dashboards with others. Sharing your dashboard with others
Changing the design theme Read More »
Creating dashboards Dashboards are a visual way to represent data from worksheets in a dynamic format. In this topic, we will look at a few ways to make your data interactive. We’ll proceed as follows: Figure 11.42 – PivotTable report result Figure 11.43 – Complete SSG dashboard Figure 11.44 – Gridlines and Headings options We
Creating dashboards Read More »
Adding time Figure 11.29 – TIME worksheet displaying incorrect SUM value Figure 11.30 – Constructing a custom format to display time Figure 11.31 – Total time displayed using the [h]: mm;@ format Figure 11.32 – Adding hours to time Figure 11.33 – Overtime You should now have the skills to confidently work with time in
Using Paste Special to convert hours into time Here is a quick and easy method to convert hours into time on the worksheet. Proceed as follows: Figure 11.24 – Paste Special… Here are a few time functions to boost your knowledge: Table 11.2 – Time functions in Excel We will look at a few time
Using Paste Special to convert hours into time Read More »
