Learning Outcomes:

• Download and rename an Excel template

• Enter formulas in the correct location 

• VLOOKUP, IF, PMT, MAX, SUM Formulas

• Know the difference between absolute and relative formulas and when to use them

• Paste while maintaining destination formatting

• Use fill and select correctly

• Create header and footer with correct pagination

• Format all dollar amounts with correct decimal places

• Modify key amounts or formulas to see how it all changes to experience how it changes the entire spreadsheet

• Freeze panes

•  Use Visual Basic Editor and Macros to create a programmable Command Button (Hello World)

• Save and link the .xlm file

• Convert Excel to PDF and embed

• Convert Excel to Google sheets, make any necessary corrections, insert below the PDF