1. Learn to recognize when a CHOOSE or SWITCH statement might be beneficial.
2. Consider all necessary conditions to use each function.
3. Determine, based on your needs, which function is right for the job.
4. Create a clear list of inputs and possible associated outputs that the functions must consider.
5. Input the formula into your Excel sheet.
6. Run the function and review the output data.
7. Alter the formula if necessary to create the desired output.