We are offering a Microsoft Excel Financials Seminar. The class will cover financial modeling in Excel,  Financial functions, Statistical functions, Data Analysis and many other topics are included. Our small classes allow everyone more time to interact with the instructor, learn faster, and more effectively.

This is a great course for someone in the finance industry looking to improve their Excel skills or learn the skills for a job that requires the use of Excel Financial Functions. This course will turn any Expert Excel user into an Excel Financials Guru.

Benefits to this course:

• Small class

• 100% hands on training. Every student gets their own computer to follow along

• Topics include: Modeling Concepts, Financial Functions, Analysis, Statistical Functions, Dashboards, Charts & Tables.

• Convenient location in Midtown Manhattan. 2 blocks from Penn Station.

• Expert instructor with more than 10 years of financial experience using and teaching Excel

 

The seminar will include a text book and a certificate at the end, showing that you attended the class.

Beware of other companies offering training with no hands on exercises. People learn by doing the actual exercises, not by watching someone else do it!

Seminar Cost: $999

Sale Price: $499 until May 25,  2012

 

Topics covered:

Lesson 1: General modeling concepts

• Modeling Exponential Growth

• The Power Curve

• Using Correlations to Summarize Relationships

• Introduction to Multiple Regression

• Using Moving Averages to Understand Time Series

• An Introduction to Random Variables

• Modeling Machine Life and Duration of a Project

Lesson 2: Financial Functions / Data Analysis in Excel

• Comprehensive Overview of Financial Functions -Best practices for using NPV, XNPV, IRR, and XIRR, Projecting from historical data using GROWTH, MEDIAN, INDEX, OFFSET, INDIRECT, MATCH

• Adding trend lines to charted data and forecasting from the associated equations

•  Dynamic V-Lookup

• Test outputs as a function of changing inputs

• Preserve and display the original baseline data and the new scenarios in a Scenario Manager Report

• Perform "what-if" analysis across changes in two variables simultaneously

• Display the output in a 2D array

• Capturing, deploying and displaying testing outcomes using Excel

• Identifying targeted and optimal outcomes using Excel's Goal Seek and Solver tools

Lesson 3: Statistical Functions

• Understanding Descriptive Statistics, Moving Average Data Smoothing, and Exponential Data Smoothing using the Data Analysis ToolPakToolpak (DATP)

• Use the RANDBETWEEN function to simulate constrained random data values for data smoothing exercises

• Examine uses of DATP functions as Histogram

• Using analysis of variance (ANOVA) with 1 and 2 Way Factor w/replication and w/o replication, to test other ToolPak skills for Statistical significance

Lesson 4: Dashboards / Interactive Charts and Pivot Tables

• Additional methods such as Spin Boxes for ensuring that output formulas are properly linked to input variables

• Building Navigation Buttons for Your Model

• Adding and Configuring Controls

• Using List Button and Check-Box Controls and create Custom Forms

• Using Option and Combo Box Controls

• Separating Data, Analysis, and Presentation

• Effectively Using Paste Special Command

• Summarizing Data with Database Statistical Functions

• Advance Pivot Tables Reports including Power Pivots and Slicer

• Waterfall Charts

• Effectively using the keyboard in MS Excel

• Advance Conditional Formatting

• Advance Data Validation

Lesson 5: Picture Links / Camera Snapshots

• Introduction to Picture Links and Camera Snapshots in Excel