In addition to our flagship "Master" series, ROI-Team offers our workbooks
as standalone learning tools. Assemble your own course and learn to be a financially literate Master of Modeling. Determine what you need to learn
(our FREE Self Assessment is available to help), then select
modules for the cart and buy when ready. Click on any title for more information, or click here to download a FREE slide show outlining all course modules.
- Business Modeling Methodology
Provides hands-on Excel training in structuring a simple model, and in creating interrelated spaces for data, parameters, detailed results, and summary results presentation. Offers a proven approach for creating bullet-proof models of any size and complexity.
NOTE: This module is included in the "Master of Financial Analysis"
and Master of Visual Basic" courses.
- Excel Modeling
Provides hands-on Excel training in the use of all the underutilized controls resident in Excel’s Forms Toolbar. These features can make Excel highly interactive, and help underscore presentation conclusions.
NOTE: This module is included in the "Master of Financial Analysis"
and Master of Visual Basic" courses.
- Excel VBA Modeling
Provides hands-on Excel training in structuring more complex models, and offers a significant improvement over simple Excel operations in data management, computations, and appearance.
NOTE: This module is included in the
Master of Visual Basic" course.
- Advanced Excel VBA
For analysts who need to go beyond the VBA basics to create models for multiple users or with more complex operations. The techniques illustrated are limited to those most useful to business analysts - this is not a Visual Basic course for programmers.
NOTE: This module is included in the
Master of Visual Basic" course.
- Excel Modeling Solutions
Walks through the Excel and VBA set up of solutions to some complex but common analytic calculation problems. Builds on concepts illustrated in the VBA Modeling module.
NOTE: This module is included in the
Master of Visual Basic" course.
- ROI Modeling with Excel
Provides a thorough walk-through of a complex ROI tool. All of its code and interactions are explained so that students gain confidence in their modeling skills and can modify this tool or create their own. This tool is also offered as a standalone business tool.
NOTE: This module is included in the
Master of Visual Basic" course.
- Insource / Outsource Modeling with Excel
Provides practice in construction and integration of a complex and versatile insourcing / outsourcing tool. This tool is also offered as a standalone business tool.
- New Product Modeling with Excel
Demonstrates how to consider all the revenue and cost implications of each new product so it can be integrated into the product line. This tool is also offered as a standalone business tool.
- Excel Data Analysis Tools
Introduces techniques for extracting data and analyzing it with Excel Pivot Tables and Pivot Charts. Access is also introduced conceptually, but is not used in the course.
NOTE: This module is included in the
Master of Financial Analysis" course.
- Excel Templates for Accounting and Finance
Provides a toolkit of useful templates and explains each thoroughly.
NOTE: This module is included in the "Master of Financial Analysis"
and Master of Visual Basic" courses.
- Control Toolbox in Excel
Provides an introduction and hands-on training in the use of Active-X Controls within the Excel environment. This module will be easier for students who have been introduced to VBA, through module 3, for example.
NOTE: This module is included in the "Master of Financial Analysis"
and Master of Visual Basic" courses.
We have several powerful, useful tools in our Library, to demonstrate Excel's firepower. Check them out - they're FREE.
|
|