Civil Engineering Projects
Exploring database functions
There are twelve database functions in Excel that cover most of the clusters of functions. These functions have been ...
Investigating the LET function
The LET function is used to simplify formulas. It is a method to get Excel to compute the same ...
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 ...
VLOOKUP AND MATCH
The VLOOKUPMATCH worksheet consists of a Vet Service Report table listing services provided by each salesperson in cells ...
Building on VLOOKUP
Before we discover new LOOKUP functions in Office 2021, we will build on our existing VLOOKUP skills cultured from our ...
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 ...
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 ...
Exploring New and Useful Workflow Functions
Microsoft Excel 2021 houses some valuable new functions. During this part of the book, you will recap ...
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 ...
Using the CONCAT function
Follow these steps:
Continue with the workbook from the previous section; that is, SSGJoin.xlsx.
We will use the ...
Sorting out empty rows
In the workbook named BlankCells.xlsx, we have several blank rows in the dataset. To remove all the blank rows from the ...
Using the UNIQUE function
The UNIQUE function is a new function for the latest version of Excel. It is a dynamic function that updates data ...
