1. Learn How to Analyze Data Using Excel

Learn How to Analyze Data Using Excel

$99.00
Event ID: 2151563
Recording: Unable to attend? A recording will be available after the presentation.
Date: Recorded on 1/10/2020
Duration: Scheduled for 75 minutes plus question and answer period.
Presenter: Tom Fragale, Microsoft Certified Trainer
Credits: 1.5 NASBA (Management Services)

Data Analysis Tools for Bankers

Learn how to analyze data using Excel.
Save time and reach meaningful conclusions.

If you are like most bankers and financial professionals, you use Excel regularly to tackle large volumes of data. You may be doing more data entry and manual calculations than necessary.

For example, Excel has powerful functions that enable you to look up information in separate spreadsheets, subtotal, and summarize data from thousands of records, and calculate loan amortization tables. By taking advantage of these and many additional features, you can save time, manage more data, and make better decisions.

WHAT YOU'LL LEARN

Excel Guru Tom Fragale will explain advanced Excel capabilities clearly and show you how to apply them to your daily data analysis tasks. This webinar will cover the following functions and tools in depth:

Functions

  • IF
  • AND
  • OR
  • Nested IF
  • VLOOKUP
  • HLOOKUP
  • PMT Loan amortization

Tools

  • Sort
  • Filter
  • Subtotals
  • Pivot tables
  • Conditional formatting

BankersWeb.com Quality Commitment

BankersWeb, a division of CareerLearning, wants you to be satisfied with your webinar purchase. If this webinar does not meet your expectations, please email us at [email protected].

TOP