In this blog post, we explore the secret Excel buttons that are hidden in plain sight (yes on the Home tab), yet many people do not know them.
There are 6 buttons I would like to mention. They have been ordered both by how useful they are, and almost my view on how aware people are of them.
This list does not even include Conditional Formatting, Clear Cells or the Copy as Picture tool which could all have easily made the cut.
Create a five star rating system in Excel using Conditional Formatting. This can be a useful way of visualising ratings like you see on eBay and Amazon.
To be an Excel pro you must master these Paste Special tricks.
Copy and paste is one of the most common tasks a computer user performs daily. Paste Special in Excel allows you to specify which elements of the copied item get pasted. It also allows you to perform operations on values and other cool stuff.
This blog post explores 10 Excel Paste Special tricks that an Excel pro needs to know.
[Read more…] about 10 Excel Paste Special Tricks to Make you a ProIn this blog post, we look at how to highlight the cells that contain a specific word. We will also ensure that the word in the cell matches the case of the word being looked for.
For this example, we have a list of the Ballon d’or winners of all time. Column B contains 3 letters in uppercase (after the name) which identify the country that the player represented at the time of winning the award.
In cell E1 I have entered the 3 digits for a country. I would like to automatically change the colour of all the cells that contain the country written in E1.
There is a good chance that the 3 digits identifying a country could also occur in a players name. For example, the letters for France – FRA do occur in the name Franz Beckenbauer.
To prevent this happening, we will match the case of the word we are searching for, as it is always written in upper case.
[Read more…] about Highlight the Cells that Contain a Specific Word (and it Matches Case)This blog post will take you through the steps to create a searchable drop down list in Excel – just like Google search.
This is a great Excel trick for working with large drop down lists.
In this tutorial we will use a list of 87 names that as we type into the drop down list, it searches the names, and the list shortens to show only those names containing that string of characters.
There are a few formulas to write to get this searchable drop down list in Excel created. Everything is shown and provided in this tutorial. If you prefer a video. Check out the video tutorial below.
