Civil Engineering Projects
Removing spaces or hidden characters
There are several ways to remove spaces from workbook data once it's been imported. We can use the TRIM and ...
Removing duplicate data
To locate duplicates in a worksheet, follow these steps:
First, open the workbook named Duplicates.xlsx. Always make ...
Importing, cleaning, joining, and separating data
When we import data from different sources, cell data may contain extra spaces or invisible ...
Setting up a conditional formatting rule
Now that we have the rule in place, we would like to ensure that every time a user selects an item from ...
Conditional formatting functions
Conditional formatting is a format, such as a cell shading or font color, that's automatically applied to cells ...
Extracting using wildcard characters
Wildcard operators are useful for extracting data according to a partial match within a cell. For instance, ...
Using operators to refine filters
We can further broaden our filters using comparison operators. Previously in this book, we concentrated on the ...
Filtering using Advanced Filter
In the previous edition of this book, we learned how to set up and manage sorts and filters.
Filtering data in Excel ...
Updating Excel on the web
The following table highlights some of the new and/or updated features in Excel for the web. As it is extremely ...
Generating maps
In the previous edition of this book, we explored the ins and outs of chart creation and formatting. Let's add to this by ...
Adding the Camera tool
Another quick tip would be to add the Camera tool to the QAT so that you can take a snapshot of worksheet data, ...
New Features, Filters, and Cleaning Data
In the previous edition of this book, we concentrated on all the basic skills concerning data ...
