This final lesson on shaping data in Excel is brought to you by the St. Louis Federal Reserve Bank, Federal Reserve Economic Data (FRED) website. Reviewing the YouTube videos created for this data-shaping exercise, the 4 videos span 45 total … Continue reading →
A traditional way of shaping data in Excel is by using the VLOOKUP() function. After identifying the item to look up and the array in which to search for it, a range is identified where the new information can be … Continue reading →
A year contains half a million minutes. The residential solar panel data arrived in five-minute increments, or about 20 percent of the annual minute universe. Adding in the utility generated data, the two data sources delivered about 130,000 data points. … Continue reading →
