A quick introduction to Mongoose Coding.
This video showcases a simple macro that queries data directly from a public website to present in Excel. This methodology can be used to gather financial data, technical specifications, unit conversions, etc., or to leverage some online services, as well. This couples nicely with more involved data management or document population systems.
This video provides a case study on two macros with universal uses. The first case study automatically fills out several templates and saves them into new folders. The second consolidates and summarizes information from three different sources.
This video showcases unique ways to visualize data in Excel. Here, we overlay a geographical plot of stores over a map of the United States. Excel has a surfeit of powerful features that can be used to display and process information of all sorts.
Showcases a forecasting tool that leverages VBA code as well as native features within Excel to create an intuitive forecasting tool. For this client, having the right tools for the job enables him to make the right decisions for his consulting business.