Let's put on our math hats and learn how to create formulas and functions in Excel the right way, the first time. Learn tips and tricks with tons of shortcuts for using the SUM, AVERAGE, COUNT and many other functions. Discover how to use the PMT function for calculating monthly payments based on the interest rate, length of the loan, and loan amount. Text functions in Excel are easy and productive for combining columns using CONCAT and splitting out data using the LEFT and RIGHT functions. Conclude with VLOOKUP and HLOOKUP for comparing financial worksheets and automatically updating them.