This video walks students through the use of IF statements -- one of the most powerful tools you have for manipulating data, especially if you don't have the same number of observations for each state (for example, using county-level data). Almost any problem you have can be solved by the use of an IF statement, or a series of IF statements that help you aggregate or filter your data. Learn it now and let Excel do the hard work for you!