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 →
One of the most powerful Excel function tools is the INDEX/MATCH() combination. It can be set to find specific character strings and deliver the cell contents at the intersection of the row and column string matches. This is the third … Continue reading →
When cleaning data files in Excel, one never moves away from manually pushing data around. Manually entering data by hand, sorting, and/or dragging and dropping in a new location; they all take time. But for small amounts of data, a … Continue reading →
The last few months have provided opportunity to flex my spreadsheet skillset. Excel code and technique seemed to erupt through the keyboard. In the last few months, diverse datasets have included: 2024 household food expenditures 2024 household power consumption and … 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 →
Excel sheets happen, but only if one knows the hidden menus upon which to click. One of the most useful Excel tricks is copying spreadsheets. Copying and moving a sheet doesn’t show up a lot in the spreadsheet tricks that … Continue reading →
Last week Biomass Rules posted about comparing 4-year loans to 7-loans. The Wall Street Journal published an article that discussed negative equity from partially paid car loans. There are multiple factors to consider with more than one correct solution. The … Continue reading →
The American Farm Bureau Federation does an excellent job with the annual Thanksgiving Meal Survey, and they have for nearly 40 years. They have the infrastructure and the expertise to make it work every year. All of their prices are … Continue reading →
Biomass Rules Blog students who were working ahead on last week’s crude oil and corn price comparison likely hit an impasse when downloading the monthly corn price data from USDA. The USDA, National Ag Statistics Service (NASS), Quick Stats monthly … Continue reading →
