Melbourne Regional Chamber - Event Information


Event Name:Online Excel Training Module 4: Financial Functions, Data Tables, and Amortization Schedules
Event Type(s):Members' Events (submit your event)
Description:Course Objectives:
  • Assign a name to a cell and refer to the cell in a formula using the assigned name
  • Determine the monthly payment of a loan using the financial function PMT
  • Understand the financial functions PV (present value) and FV (future value)
  • Create a data table to analyze data in a worksheet
  • Create an amortization schedule
  • Control the color and thickness of outlines and borders
  • Add a pointer to a data table
  • Analyze worksheet data by changing values
  • Use range names and print sections of a worksheet
  • Set print options
  • Protect and unprotect cells in a worksheet
  • Hide and unhide worksheets and workbooks
  • Use the formula checking features of Excel
 
All topics are taught in the order of the modules in the optional textbook, Microsoft Office 365 & Excel 2016: Comprehensive, (Shelly Cashman) ISBN:9781305870710. Textbook can be purchased from various online retailers.
 
Cost:
• Non-ABWA Member: $40/session
• ABWA Member: $25/session

Payments are non-refundable.  Each 2-hour workshop session includes email and phone support for 30 days.
 
Register now at www.abwaoceanside.com
 
Event Date:1/30/2021
Event Time:1:00 PM - 3:00 PM Eastern
Location:Online
Melbourne, FL 32901

Click here for Google Maps
click here for Mapquest Map
Contact Person:Andrea Ellis
(phone: 832 756-3701)
Details:Course Objectives:
  • Assign a name to a cell and refer to the cell in a formula using the assigned name
  • Determine the monthly payment of a loan using the financial function PMT
  • Understand the financial functions PV (present value) and FV (future value)
  • Create a data table to analyze data in a worksheet
  • Create an amortization schedule
  • Control the color and thickness of outlines and borders
  • Add a pointer to a data table
  • Analyze worksheet data by changing values
  • Use range names and print sections of a worksheet
  • Set print options
  • Protect and unprotect cells in a worksheet
  • Hide and unhide worksheets and workbooks
  • Use the formula checking features of Excel
 
All topics are taught in the order of the modules in the optional textbook, Microsoft Office 365 & Excel 2016: Comprehensive, (Shelly Cashman) ISBN:9781305870710. Textbook can be purchased from various online retailers.
 
Cost:
• Non-ABWA Member: $40/session
• ABWA Member: $25/session

Payments are non-refundable.  Each 2-hour workshop session includes email and phone support for 30 days.
 
Register now at www.abwaoceanside.com
Links:http://httpp://www.abwaoceanside.com
Outlook/vCalendar/Google:Click on the icon next to the date(s) to add to your calendar:
1/30/2021
Email Reminder:click here to setup an email reminder for this event