Useful Excel functions for accountants include advanced conditional formatting, HLOOKUP, VLOOKUP, pivot tables, Macros, graphs, and chart elements. Accountants use Excel to create reports, analyze data, and establish strong financial strategies.