In February my wife and I were planning a trip to New York City. I stumbled upon an interesting data-set that MOMA had shared with data.world. Continue reading
free data from Data.world MOMA artists
Posts Tagged → hyperlink
Video 00081 Count and find different types of Excel errors
Have you ever inherited a messy Excel file?
It can be REALLY painful! Over the years I have used various techniques to audit Excel files.
This post shows you how to distinguish between different error types, count them and find them!
Video 00035 Solution_Dynamic array HYPERLINK
Create a dynamic hyperlink using an array formula!
This means that you can jump to a location in your data depending on conditions in the values.
This is one of my favorite ways to use an array formula! Continue reading
Video 00030 Create a HYPERLINK in Microsoft Excel
A hyperlink is an easy way to jump from one location to another location. The destination could be to the same workbook, an external workbook or a website.
There are two ways to create a hyperlink in Microsoft Excel: Continue reading