Fisher exact test is used to analyze categorical data when the sample size is small. The video shows how to perform Fisher exact test calculations with Excel.