Matthew R. Jenks

 
Home
About Me
Resume
Worksheets
Contact Me

Worksheets

One of the skills that I can bring to a company or organization is a solid proficiency in using the Excel program. Soon I will be adding examples of my capabilities to this page, which include knowledge of the use and customization of these basic Excel templates below, followed by a list of basic skills I have in the Excel program.

Excel Templates

  • Balance Sheets

  • Expense Statements
  • Expense Budgets
  • Analysis Worksheets
  • Financial Planning Worksheets
  • Loan Amortization
  • Sales Invoice

Basic Excel Skills Checklist

  • Entering and editing labels, values, and formulas

  • Finding and replacing formulas
  • Moving and copying data
  • Inserting and deleting ranges
  • Using relative and absolute references in formulas
  • Using SUM, AVERAGE, MIN, and MAX
  • Previewing and printing worksheets
  • Controlling Page Setup, including headers and footers
  • Creating charts based on worksheet data
  • Changing chart types
  • Formatting chart elements
  • Printing charts
  • Saving worksheets as Web pages
  • Using the AutoRepublish feature
  • Inserting and editing hyperlinks