<p>This course will be an overview of:</p> <ul> <li>Ten critical functions for accountants to know including:</li> </ul> <p>&nbsp; &nbsp; &nbsp; VLOOKUP<br /> &nbsp; &nbsp; &nbsp; XLOOKUP<br /> &nbsp; &nbsp; &nbsp; XMATCH<br /> &nbsp; &nbsp; &nbsp; INDEX<br /> &nbsp; &nbsp; &nbsp; IF<br /> &nbsp; &nbsp; &nbsp; IFS<br /> &nbsp; &nbsp; &nbsp; COUNTIF<br /> &nbsp; &nbsp; &nbsp; SUMIF<br /> &nbsp; &nbsp; &nbsp; SUMPRODUCT<br /> &nbsp; &nbsp; &nbsp; GETPIVOTDATA</p> <ul> <li>Usage of formatting and conditional formatting in conjunction with these critical functions</li> </ul>