When advanced formulas, formatting, etc are needed, Excel has as many options as a programming language. I have created many things with full understanding of functions like VLOOKUP, IF statements, and error catching.