Howdee Excel Ninjas! My article on using VBA to import JSON into Excel has been one of my most popular. As a follow up to this I wanted to demonstrate how to Parse JSON using VSTO (Visual Studio Tools for Office) add-in to help perform...
Filtering data in Excel is one of the most common practices for accountants, analysts, executives, and everyone in-between. Using Excel’s built-in Filter tool is a necessary skill for almost anyone in an office environment, but sometimes the user interface and efficiency of the filter can...
Howdee! For the second part of my Excel pivot table series, I want to cover pivot table calculated fields. Calculated fields are super handy ways to customize your data in a pivot table. For example, if you have sales by state in a pivot table,...
Howdee! Going back to Excel’s early days, one of its primary uses has always been the aggregation of data. Being able to sum and count data on the fly in a spreadsheet was a revolutionary change to the workplace. Many years later, those formulas are...
Howdee! If you’ve ever written any VBA code, you’ve likely had to edit strings in Excel VBA. It can be challenging and more than a little frustrating, especially if you’re not familiar with the tools available to you within the framework. Have you ever had...
Howdee! Data visualization is one of the biggest terms being thrown around right now. From companies like Domo, to Tableau, to Microsoft’s Power BI, data visualization is the hot item right now. To those of us that have been working in Excel for years, this...
Howdee! For many years now, being an Excel expert has been almost synonymous with being an expert in writing VBA code. While VBA is a wonderful tool, in 2017 it is a bit dated in my opinion. So, today I want to introduce a new...
Howdee! A common requirement when developing in Excel is the need to have code run while a user interacts with a report. That is to say, the user does not need to explicitly trigger your subroutine. Therefore, today I want to cover how to run...
Howdee! A big part of some analyst’s job is usually collecting data via templates and aggregating that data into reports for leaders to review. This presents a problem. Many times, the way users want to enter data, is not favorable for aggregating reports or inserting...
Howdee! Querying data over the web becomes more common every day. Almost every cloud based program has the ability to serve up its data through some sort of API. Sometimes, the data can be extracted to Excel through some sort of reporting interface within the...
|
Tickets |