Welcome to project management certification, PMP, Program Management, Agile, Business Analysis, Professional Scheduling and other related training

Business Analysis Training, Excel(R) Series, in Troy-MI, Washington-DC, Bellevue-Seattle-WA or Live Online - 2 hour Training Segments

Business Analysis Training, Excel(R) Series, in Troy-MI, Washington-DC, Bellevue-Seattle-WA or Live Online - 2 hour Training Segments
Item# BUSAN-01-11
$175.00, 2  classes for  $315.00, 3  classes for  $429.00, 4  classes for  $500.00
2018-2019 Business Analysis Training Using Excel onsite in Troy,-MI, Washington-DC, Bellevue-Seattle-WA or by Live Video Conference Online. There are 10 focus topics in this menu. To purchase a class, click on the down arrow, scroll down to the class and click again, and repeat until you have purchased all of the classes you want. Call Nereda Haque, PMP for more details at 360-584-8614. Business Analysis Training is available onsite in Washington-DC, Troy-MI, Bellevue-WA or via Live Video Conference (LVC ET or LVC PT). ET means Eastern Time and PT means Pacific Time. Pacific Time is 3 hours behind Eastern Time. All classes are 5 PM to 7:00 PM unless otherwise stated. The price that you pay will depend on the number of classes that you purchase. To purchase any of these classes, click on the down arrow, scroll down to the class you want and click again, and so on until you have purchased all of the classes you want: 

Description

Business Analysis Training - Excel Series

PDUs for PMP®, ACP, PgMP: 2 PDUS per class This Business Analysis – Excel Series of Hand-On Classes are designed for busy managers, project managers, business analysts who needs to have command on using Excel to perform their management, business analysis and financial know-how. Each section is scheduled for 1 to 2 hour session, depending on length of the topics. These hands-on classes will build your proficiency in Excel and analysis techniques for general management and project management.

When: For date and times please see the above menu.

Locations or Methods of Learning:

(1)SmartPath LLC Onsite in Washington, DC: 1050 Connecticut Ave NW, 10th FLR, Suite 1000, Washington, DC 20036. Metro is in the building and across the street in the CVS. Cross Street is "L" Street. Central Parking is in the building between K and L Streets on the right. DC Parking and Redline Metro

(2)SmartPath LLC Onsite in Bellevue, WA: 2018 156th Ave NE, Bellevue WA 90007 - Parking is free to the right of the Stop sign as you drive up the hill or in front of the building.

(3) Via Live Video Conference using your computer.

Class Choices are numbered 1 to 11. Other options may be added later on:

Business Analysis Class Titles and Outlines for Class Content and Practice


1. Business Analysis Using Excel – Examining a Business Case
• Developing a Business Case
• Developing the Excel Model

2. Business Analysis Using Excel – Creating a Sensitivity Analysis
• Reviewing the Business Case
• Managing Scenarios
• Measuring Profit
• Varying Discount Rate Input
• Using the Goal Seek Tool

3. Business Analysis Using Excel – Measuring Quality
• Monitoring Quality through Statistical Process Control
• Performing Acceptance Sampling
• Using Worksheet Functions for Quality Control
• Sampling Units from a Nonfinite Population

4. Business Analysis Using Excel – Forecasting and Projections
• Baseline
• Moving Average Forecast
• Forecasting with Regression Functions
• Forecasting with Smoothing Functions

5. Business Analysis Using Excel – Making Investment Decisions
• Using Standard Deviation
• Understanding Confidence Intervals
• Using Regression Analysis in Decision Making

6. Business Analysis Using Excel – Examining a Decision Criteria
• Understanding Payback Periods
• Calculating Future Value, Present Value
• Net Present Value, Optimizing Costs

7. Business Analysis Using Excel – Importing Business Data
• Creating and Using ODBC Queries
• Working with Data Ranges
• Creating and Using Web Queries
• Using Parameterized Web Queries

8. Business Analysis Using Excel – Exporting Business Data*
• Using VBA to update an External Database
• Editing the Records Values
• Using with Blocks
• Adding new records to the Record set
• Choosing to use ADO

9. Business Analysis Using Excel – Analyzing Contribution Margins
• Calculating the Contributing Margin
• Using Unit Contribution
• Finding the Break-Even Point
• Making Assumptions in Contribution Analysis

10. Business Analysis Using Excel – Ratio Analysis
• Interpreting Industry Averages and Trends
• Comparing Ratios within Industries
• Analyzing Profitability Ratios
• Analyzing Leveraging Ratios
• Analyzing Liquidity Ratios
• Analyzing Activity Ratios

11. Business Analysis Using Excel – Valuing Inventories
• Understanding Perpetual and Periodic Inventory Systems
• Valuing Inventories, Comparing the 4 Valuation Methods
• Handling Purchase Discounts, Calculating Turns Ratio

If your organization requests this training, you will be provided PDU information based on the triangle.

* We did not include Exporting Data in our Proprietary School Class submission so this subject will not be offered in Michigan at this time for our two hour special training