ES Computer Training Workshops, continuing education, sessions, accredited courses for construction, finance, insurance, business.
6/013.jpg6/014.jpg6/007.jpg6/019.jpg

Our highly effective computer training courses, will help save you time and money, plus you will earn CFP* and Life License Credits.

Microsoft Excel for Finance - 3 Part Instructor-led Webinars (Basics, Data Analysis and Advanced Formulas)

Overview

This seminar is delivered in 3 three hours instructor-led webinars covering the following topics:

Topics

  • Basics
    • Learn simple Excel tricks to quickly apply calculations to large data sets
    • Include customized graphics for presenting complex data
    • Navigate through spreadsheets smoothly and efficiently with keyboard shortcuts
    • Share data between workbooks by learning to link them together
    • Formatting & Style -present data in a professional manner
    • Protect and secure your data
  • Data Analysis
    • Review different Excel functions for sorting data .
    • Understand filters to narrow down the data in your worksheet and hide parts of it from view.
    • Learn to build a pivot table for analyzing data and creating reportsli>
    • Utilize different Excel formulas for easier data analysis.
  • Advanced Formulas
    • Learn Excel functions that are widely used in Finance. This includes
      • Basic functions (ie. SUM, AVG, Common Errors, and more)
      • Logical functions (ie. IF, AND, OR, and more)
      • Lookup functions (ie. Vlookup, index match, and more)
      • Financial functions (ie. Net Present Value, Future Value, Rate of Return, and more)
      • Date functions
    • Calculate and compare different values.li>
    • What-if analysis tools to determine a range of possible outcomes

    Space is limited to : 6 students, sign up today to gain valuable insight into one of the most helpful tools a financial professional can use in today’s market.

    Cost of this course is $660 + applicable taxes and course runs from 1:00 p.m. to 4:00 p.m. Eastern Time



    Schedule

    Remote Workshop
    Jun 10th, 2020
    Jun 17th, 2020
    Jun 25th, 2020
    Instructor-Led Webinar
    Online
    Register
    ES Computer Training Workshops, continuing education, sessions, accredited courses for construction, finance, insurance, business.

    © 2020 ES Computer Training, a division of ESCTT Inc. All Rights Reserved.