16.08W Microsoft Excel for Credit Unions

Organizational Resource Development

Summary

Microsoft Excel is one of the most important analytical tools in the financial industry.  Nearly every credit union staff member can benefit from a basic knowledge of this program and its powerful capabilities.  In this course, participants will explore Microsoft Excel and its credit union applications.

Audience

This course is designed for an credit union employee who needs to compile, manipulate, or analyze financial data.

Objectives

By the completion of this course, participants will be able to:

  • Define key Excel terminology
  • List best practices for structuring data
  • List recommendations for maintaining spreadsheet integrity
  • Perform basic Excel calculations
  • Apply basic Excel formatting
  • Create basic Excel formulas
  • Incorporate multiple conditions within Excel formulas

Topics

  • Excel terminology
  • Data structuring best practices
  • Recommendations for maintaining spreadsheet integrity
  • Data types
  • Data formatting
  • Custom formats
  • Data sorting
  • Data grouping
  • Subtotals
  • Calculated fields
  • Tables and named ranges
  • Simple formulas
    • Sum
    • Average
    • Count
  • The "if" function
  • Incorporating multiple conditions within formulas
  • Visual representations of data

 

Course Offerings Schedule

Microsoft Excel for Credit Unions