Excel Workshop: Working with Real-Time DataSize: 280 MB | Duration: 1h 18m | Video: AVC...
Using conditional statements and text functions like LEFT, MID, RIGHT, and CONCATENATE, you\'ll learn to standardize data sets from the NCDC and create new dimensions. Then find out how to use VLOOKUP to join the data, and use COUNTIF statements to analyze trends. Once the historical data is in place,...