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.
Working with time When working with time in Excel, we need to ensure that we format cells correctly. This is extremely important as Excel does not display hours over 24 (1 day), seconds greater than 60, or minutes greater than 60. Hours are always fractions of a day in decimal presentation, whereas dates are whole […]
Returning the date of retirement Let’s work out the exact date our employees will retire using the EDATE function. Our employees reach retirement at 65. Follow the next steps: Now that we know how to calculate the actual date of retirement, there may be instances where we need to how many years until the employee
Returning the date of retirement Read More »
Converting the month name to a month number To convert the month name to a month number, proceed as follows: Figure 11.12 – Converting the month name to the month number Working out the future date from the days specified The WORKDAY function returns the date for a specified number of working days entered from
Converting the month name to a month number Read More »
Date-Time Functions and Enhancing PivotTable Dashboards In this chapter, we will explore date functions and look at how to work with time. Here, we concentrate on DATEDIF(), YEARFRAC(), EDATE(), WORKDAY(), and many more functions to be more productive in the workplace. In addition, a large part of this chapter will explore a host of PivotTable
Date-Time Functions and Enhancing PivotTable Dashboards Read More »
Using the COUNTIFS statistical function In our previous edition book, Learn Microsoft Office 2019, we learned all about the COUNTIF function. Let’s look at an example to recap this function, and explore the COUNTIFS function at the same time. Recapping the COUNTIF function In the next topic, we will expand on prior knowledge and discover
Using the COUNTIFS statistical function Read More »
Using DGET to return a single value Figure 10.26 – Formulating the DGET database function Figure 10.27 – Creating a Product validation rule Let’s look at a few more examples of database functions. Constructing DAVERAGE We will now work out the average gross margin: Figure 10.28 – Formula construction for the average gross margin
Using DGET to return a single value Read More »
Using the DATEDIF function DATEDIF is a function that works out the age of the employee to display the year, month, and day in the cell. When working with the DATEDIF function, we will need to type the function into the cell to construct it from scratch. The DATEDIF function is not resident in the
Using the DATEDIF function Read More »
Date-Time Functions and Enhancing PivotTable Dashboards In this chapter, we will explore date functions and look at how to work with time. Here, we concentrate on DATEDIF(), YEARFRAC(), EDATE(), WORKDAY(), and many more functions to be more productive in the workplace. In addition, a large part of this chapter will explore a host of
Date-Time Functions and Enhancing PivotTable Dashboards Read More »
Using the COUNTIFS statistical function In our previous edition book, Learn Microsoft Office 2019, we learned all about the COUNTIF function. Let’s look at an example to recap this function, and explore the COUNTIFS function at the same time. Recapping the COUNTIF function In the next topic, we will expand on prior knowledge and discover
Using the COUNTIFS statistical function Read More »
Constructing DAVERAGE We will now work out the average gross margin: Figure 10.28 – Formula construction for the average gross margin above 50% See whether you can work out the maximum total cost for Division 2, the total quantity sold for Division 1, and the minimum quantity sold for Division 3, using the appropriate function
Constructing DAVERAGE Read More »
