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.
Exploring database functions There are twelve database functions in Excel that cover most of the clusters of functions. These functions have been in the Excel library for many years, and are often forgotten about or not known, as there are so many other functions we can use today. Database functions are a substitute for IFS […]
Exploring database functions Read More »
Investigating the LET function The LET function is used to simplify formulas. It is a method to get Excel to compute the same expression used within a formula by naming it, leading to more efficient processing, and making the formula easier to understand as it is less complex in construction. Let’s look at the
Investigating the LET function Read More »
Exploring XMATCH The XMATCH function will return the relative position of an item within a range or an array. We will firstly look at a basic XMATCH construction to return a result and then look at an example that includes XMATCH and INDEX together. Constructing XMATCH (syntax) The syntax for XMATCH is similar to
VLOOKUP AND MATCH The VLOOKUPMATCH worksheet consists of a Vet Service Report table listing services provided by each salesperson in cells A6:F13. Instead of taking the time to run along rows, columns, and salespersons, we would like to choose the service provided for a particular salesperson and return the value for that service. In the
Building on VLOOKUP Before we discover new LOOKUP functions in Office 2021, we will build on our existing VLOOKUP skills cultured from our previous edition book, Learn Microsoft Office 2019. It is important to understand how different functions work together or to find fewer complex methods to generate the desired output. Combining IFERROR AND VLOOKUP
Building on VLOOKUP Read More »
Building IFS functions The IFS function was first introduced in Office 2016, so it is not a new function. It is so much easier to construct and evaluate multiple IF conditions instead of using the old clunky nested IF formula. The IFS syntax is extremely simple: =IFS(logical_test1,value_if_ true1,[logical_test2,value_if_true2], and so on up to 127 conditions.
Building IFS functions Read More »
Evaluating array formulas We can evaluate part of an array by selecting the part of the array formula and then pressing F9 on the keyboard to show values. This is a great way of checking whether the array is using the correct cells: Figure 10.6 – Selecting the part of the array to evaluate Figure
Evaluating array formulas Read More »
Exploring New and Useful Workflow Functions Microsoft Excel 2021 houses some valuable new functions. During this part of the book, you will recap a number of important concepts and investigate some new functions. In the previous book, Learn Microsoft Offi e 2019, we concentrated on the differences between a formula and a function, learned about
Exploring New and Useful Workflow Functions Read More »
Separating data The Text to Columns feature in Excel is a wonderful tool to separate data from a single cell into multiple columns. Let’s take a look: Figure 9.61 – Convert Text to Columns Wizard Figure 9.62 – Select Comma, then Next > Summary You have learned an abundance of skills throughout this chapter. Now,
Using the CONCAT function Follow these steps: Figure 9.59 – The CONCAT formula’s construction Now that you have mastered the & and CONCAT methods, let’s look at the TEXTJOIN function. Constructing the TEXTJOIN function The TEXTJOIN function is more efficient due to the following reasons: Figure 9.60 – The TEXTJOIN syntax’s construction With that, we
Using the CONCAT function Read More »
