Howdee! I had a lot of requests after my recent article on converting a JSON string to Excel, asking if it was possible to convert Excel to JSON. Fortunately, it is not only possible, but you can use the same library we previously covered to...
Howdee! One of my favorite data analysis tools is the offset Excel function. It provides a tremendous amount of flexibility to automate ranges and formula inputs. It can be used to adjust inputs based on counts, dates, & amounts. Imagine a sum formula that automatically...
Howdee! It’s becoming increasingly more common for data to be generated in a JSON format as opposed to XML. XML was widely used for years, but recently JSON has started to become the preferred method of data exchange. Many REST APIs have the option to...
Howdee! The Excel vlookup function is one of the most common job requirements listed for any position that will require the applicant to use Microsoft Excel frequently. However, many folks aren’t utilizing the vlookup function to its maximum. There are several uses of the Excel...
Howdee! The ability to hide columns in Excel (or rows) is not a topic that’s ground-breaking news by any means. It’s probably something you do on a regular basis. However, have you ever found yourself creating multiple views of the same report depending on the...
Howdee! Excel is a great tool for performing data analysis. However, sometimes getting the data we need into Excel can be cumbersome and take a lot of time when going through other systems. You’re also at the mercy of how a disparate system exports data,...
Howdee! There will be occasions, when working with Microsoft Excel, when you want to control the data that can be entered in a certain cell. A great way to accomplish this is creating a dropdown in Excel that the end user can select values from....
Howdee! There may be occasions where you need to perform an action a set number of times when writing code. This is generally called “looping”. The Excel VBA for loop is one of the most useful tools an Excel developer can learn. Being able to...
Howdee folks! VLOOKUP is a great Excel function, but sometimes you need a little more flexibility than it provides. That’s where nesting the MATCH formula inside the INDEX (also known as the index match excel function) formula can shine. It also has the added benefit...
Howdee! Do you ever find yourself wishing “if only there were a function in Excel like this, I could do that”? Then this write-up is for you. Creating a custom excel function can help reduce the reliance on having multiple calculated columns or, what I...
 |
Tickets |